All Courses
Financial Modelling/Foundation/50 hours, self-paced + live cohort
Financial Modelling (FMVA Track)
A complete, build-as-you-go financial modelling and valuation course. You will construct a fully linked 3-statement model, run every major valuation method used on the job (DCF, relative, precedent transactions, APV), and finish with the reporting and career skills that turn a model into a job offer.
Curriculum
01
Foundations of Modelling & Valuation
- Intro to financial modelling
- Intro to valuation (3 methods)
- Common size statements
- Ratio analysis
- DuPont analysis
02
Cost of Capital
- Cost of debt calculation (3 methods)
- Beta calculation (3 methods)
- WACC calculation
03
Forecasting & the 3-Statement Model
- Intro to forecasting
- Forecasting sales, opex, capex, and other balance sheet items
- Building the forecasted, fully linked 3-statement model
04
DCF Valuation
- DCF Method 1: pre-workings and full model
- DCF Method 2: pre-workings and full model
- Sensitivity analysis
05
Relative & Precedent Valuation
- Selection of peer comparables
- Relative valuation: pre-workings and full model
- Precedent transaction analysis: pre-workings and full model
- Football field analysis
06
APV & Advanced Valuation
- Intro to APV
- APV pre-workings
- APV full valuation
07
Reporting & Breaking In
- One-page company profile
- Writing commentary and comparing results with analyst opinions
- Breaking into equity research, investment banking, FP&A, and Big 4 deal advisory
What you'll walk away with
- Build a fully linked 3-statement model: income statement, balance sheet, cash flow
- Run DCF valuation using two full methodologies, with sensitivity analysis
- Run relative valuation, precedent transaction analysis, and APV valuation
- Calculate WACC, cost of debt, and beta using multiple methods
- Write analyst commentary and a one-page company profile
Who this is for
- University and ACCA/CFA students
- Aspiring analysts targeting IB, PE, or FP&A
- Professionals who model in Excel but want rigor