Track A: Financial Modelling
What you will be able to do
- Structure a professional model
- Forecast the three statements
- Value a company with a DCF
- Test scenarios and sensitivities
18 lessons and projects. Short, practical steps in a spreadsheet, with real Excel for the features a browser cannot run.
Outline
Module 1: Model foundations
- Model structure: inputs, calculations, outputs
- Timelines and period flags
- Building the assumptions sheet
Module 2: Forecasting the three statements
- Revenue forecast
- Cost forecast
- Working capital
- Fixed assets and depreciation schedule
- Debt schedule and interest
- Income statement
- Balance sheet
- Cash flow statement (indirect)
- Balancing the model and error checks
Module 3: Valuation
- Free cash flow
- WACC
- DCF with terminal value
- Sensitivity table: WACC and growth
- Base, best and worst scenario switch
Capstone: 3-statement model and DCF valuation
Completing it earns a certificate of completion. It is not an accreditation or a professional qualification.
Start free