What you will learn
This is the practitioner course every aspiring equity analyst, investment banker, and CA-finance professional should run through at least once. You will build a complete three-statement model in Excel — historicals, assumptions, revenue model, schedules, projections, and a DCF valuation — step by step.
The teaching company throughout is an Indian listed business so units, accounting framework, and disclosures are familiar.
Topics covered (18 lessons)
- Introduction to financial modelling
- Excel workbook setup and best practices
- Pulling and cleaning historical data
- Assumptions (Parts 1 & 2)
- Revenue model
- Asset schedule (Parts 1 & 2)
- Debt schedule
- Reserves schedule (Parts 1 & 2)
- Projections
- Cash flow statement build
- Valuation (3 parts): overview, FCFF & FCFE, risk premium & tax shield
- WACC and terminal growth
- Full DCF analysis
Who this is for
- Investment banking and equity research aspirants
- MBA, CFA Level 2 candidates
- Investors who want a quantitative valuation toolkit
Frequently Asked Questions
Do I need Excel skills?
Intermediate Excel is enough — if you know cell references, INDEX/MATCH, and IF, you will manage. Macros are not used.
Will I get an Excel template?
The course teaches you to build the model from scratch, which is the real skill. You will end up with your own complete template.
Is DCF really covered end-to-end?
Yes — Lessons 16–18 walk through FCFF, FCFE, risk premium, tax shield, WACC, terminal growth, and a full DCF on a sample Indian company.
Does it teach LBO or M&A models?
No — it is focused on the three-statement model and DCF valuation. LBO and M&A would be follow-on courses.
Is this prep for an analyst job?
Yes — the model build, valuation rigour, and equity-research thinking match what’s expected on the desk.
Already purchased? Go to course content →
Reviews
There are no reviews yet.