Financial Modelling and Valuation Course Online (Live, Hindi + English)
This 8-week live online course teaches you to build a complete three-statement financial model in Excel and value a company using discounted cash flow (DCF) and comparable multiples. You forecast revenue, costs and working capital, link the P&L, balance sheet and cash flow, and run sensitivity analysis. By the end you will have built two full models yourself on historical company data.
- Fee: ₹6,999
- Duration: 8 weeks
- Level: Intermediate
- Mode: Live online
- Language: Hindi and English
What you will be able to do
- Use Excel the way analysts do: structure, formulas, shortcuts and checks
- Build a linked three-statement model from a company's annual reports
- Forecast revenue, margins, capex, debt and working capital
- Value a company with DCF and with trading comparables
- Run sensitivity and scenario analysis and present the result clearly
Detailed syllabus
Module 1: Excel for finance
- Model layout and formatting standards
- Key functions: lookups, INDEX-MATCH, date and logic functions
- Error checks and model hygiene
Module 2: Reading the numbers
- Extracting data from annual reports
- Cleaning and standardising historical financials
- Ratio analysis as a sanity check
Module 3: Three-statement model
- Revenue and cost build-up
- Fixed assets, depreciation and capex schedule
- Debt schedule and interest
- Working capital
- Linking P&L, balance sheet and cash flow
Module 4: Valuation
- Free cash flow and WACC
- Terminal value
- DCF valuation step by step
- Trading comparables: P/E, EV/EBITDA
- Where each method misleads
Module 5: Analysis and presentation
- Sensitivity tables and scenarios
- Charts and a one-page summary
- Common modelling mistakes
Module 6: Capstone
- Build a second model independently on a different company
- Feedback and review
Who this course is for
- Commerce, finance and MBA students
- Aspiring equity research, credit and corporate finance analysts
- Learners who finished our Fundamental Analysis Course
Fees and what is included
| Course fee | ₹6,999 (one-time) |
|---|---|
| Duration | 8 weeks |
| Format | Live online classes with recordings |
| Included | Notes, quizzes, student doubt group, completion certificate from the academy |
| Not included | Tips, signals, trade calls or account handling |
See all prices on the course fees page, meet our trainers, or read the full curriculum.
Financial Modelling & Valuation Course: FAQs
What is financial modelling?
Financial modelling is building a spreadsheet that represents a company's financial performance and forecasts its future, usually as linked income statement, balance sheet and cash flow, to support valuation and decisions.
Do I need to know Excel or accounting first?
Basic Excel and basic accounting help. We revise both in the first two modules. If financial statements are new to you, take the Fundamental Analysis Course first.
Is this the FMVA certification?
No. FMVA is a certification offered by the Corporate Finance Institute. This is our own skills course with a completion certificate from the academy.
Will this help me become an equity research analyst?
It builds the modelling and valuation skills that research roles use. Research analysts in India also need NISM Series XV certification under SEBI rules.
What are the fees for the financial modelling course?
The fee is ₹6,999 for 8 weeks of live online classes, recordings, model templates and feedback on your capstone model.