Course Description

As an analyst working in Investment Banking, Corporate Finance, Equity Research or Private Equity, a major part of your work will revolve around financial modelling. Across the buy side and sell side, financial models are widely used:

  • To value target companies for M&A
  • To evaluate entry and exit multiples and IRR returns for private equity investors and
  • To give stock recommendations of buy, sell and hold.

In addition, financial modelling is widely used across the business world for capital budgeting, scenario planning and project finance among others.

As a result, mastering financial modelling is a crucial skill set for all aspiring analysts and professionals. Job interviews to enter any of these fields:

  • Are intense, highly technical in nature and
  • Questions related to financial modeling tend to come up frequently

Keep in mind, that it is financial modelling skills that separate a "star" analyst from the rest of the pack. 

By investing in SIB’s program, you already have a head start. The skills that you will pick up on this course will enable you to hold your own and succeed not just in interviews, but everyday as a professional as well. It offers:

  • 36 professional quality HD videos with a run time of just over 2 hours


We have used our experience over the years with recruiters and SIB alumni, and identified content that has relevance in the practical world. You will:

  • Learn how to get comfortable with a company’s business model
  • Learn to quickly identify relevant information and KPIs
  • Understand circular references and how to address them
  • Apply commonly used modelling best practices and shortcuts
  • Understand drivers used to forecast revenue
  • Learn to forecast the Income Statement
  • Learn to prepare and forecast the Balance Sheet
  • Understand Working Capital items and how to forecast them
  • Create a schedule for Depreciation and Amortization
  • Forecast tangible and intangible assets
  • Get comfortable with Cash flow and forecasting
  • Connect the dots and learn to balance the financial model
  • Understand how the three primary financial statements connect with each other


Our Financial Modeling program offers:

Practical Skills: Since 2007, SIB has been a pioneer in the provision of practical skills. There is no theory will build a financial model for Infosys, the Indian IT major from a clean sheet of Excel. Nothing can be more practical and real than that. 

Relevance: Just think of a top tier firm (JP Morgan, Deutsche Bank,Citi, BofA, HSBC, Nomura etc) in a major financial centre (London, NY, Hong Kong, Dubai, Mumbai etc) across the world? SIB alumni from our full time placement programs are already making their mark there. This is possible only because our content is relevant to industry and hits the nail on the head. By investing in this program, you have access to that same high impact world class content

Professional HD Production: All our content is professionally produced and edited to maximise your learning experience


  • Your access is valid for a period of 3 years from the day you sign up. So you have plenty of time to practice and perfect :)
  • This is an advanced module and in order to get the maximum out of this program, candidates should have a good understanding of Accounting and Financial Statement Analysis. Our programs on Introduction to Accounting and Advanced Accounting will assist you with that


We would recommend that you go through our programs in the following sequence:

Intro to Accounting --> Advanced Accounting--> Valuation- Trading Comps --> Valuation - Transaction Comps --> Valuation - DCF --> Financial Modeling

Ready to build a financial model like a Wall Street Analyst? LETS DIVE IN

About the Instructor

Team SIB

SIB-School of Investment Banking is a unique and one of a kind Investment Banking training institute. What sets us apart is the fact that in addition to providing cutting edge “job oriented” training, we leverage our deep contacts with recruiters to secure world class placement opportunities for candidatesToday SIB alumni are pursuing their career ambitions with major recruiters such as JP Morgan, Goldman Sachs, Citi, Deutsche Bank, Bank of America, HSBC, Nomura, PwC, Ernst & Young, KPMG, Deloitte and Grant Thornton among others across the worldThis is possible only because our content is relevant to industry, contemporary and hits the nail on the headTeam SIB comprises of former bankers at Lehman Brothers, Nomura, Citi and UBS and has a proven track record of delivering industry relevant cutting edge training that transforms livesWith an average placement record of 90% since 2007, we know more than a thing or two about getting your foot in the door!

Course curriculum

  • 1

    Opening Remarks

    • Introduction & Learning Objectives

    • Essential Downloads

  • 2

    Understanding the Business Model

  • 3

    Forecasting Revenue

    • Employee Build Up

    • Software Professionals, Utlisation, Effort Mix

    • Revenue - Laying the ground

    • Revenue - The missing link

    • Forecasting Revenue

  • 4

    Income Statement

    • Linking Revenue

    • Employee Benefit Expense

    • Deferred Consideration, Technical Subcontractors

    • Other Cost Items

    • EBITDA

    • Depreciation & Amortisation (D&A)

    • EBIT, Other Income

    • Profit Before Tax, Taxex, Net Profit

    • Dividends, EPS

  • 5

    Balance Sheet

    • Input Historic Balance Sheet

    • Forecasting the Balance Sheet

  • 6

    Working Capital Schedule

    • Overview

    • Forecasting Current Investments

    • Forecasting Trade Receivables, Other Items

    • Calculating Working Capital, Changes (Cash Impact)

    • Linking to the Balance Sheet

  • 7

    Fixed Assets Schedule

    • Overview & Tangible Assets

    • Computing Depreciation

    • Intangible Assets, Amortisation

    • Capital WIP, Capex

    • Linking to the Balance Sheet

  • 8

    Cash Flow Statement

    • Cash flow from Operations

    • Investing & Financing Cash Flows

    • Net Cash, Cash & Cash Equivalents, Interest Income

  • 9

    Moment of Truth

    • Connecting the Dots

    • Checks & Balances

  • 10

    Closing Remarks

    • Closing Remarks


5 star rating

Solid course on financial modeling

Amanda Russell

Solid course. Very well explained.

Solid course. Very well explained.

Read Less
5 star rating

Aniket Mishra

The course is well structured and explanations are extremely detailed making it easy to follow.

The course is well structured and explanations are extremely detailed making it easy to follow.

Read Less

Pricing options

Explain how different pricing options might be valuable to different segments of your audience.