Home › Financial modelling
You will not learn modelling by watching someone else model.
Most finance courses hand you a finished model and walk you through it. You watch, you nod, you close the laptop, and you cannot rebuild it. Here you build it — from a blank sheet and a published annual report — because that is the thing an employer actually tests.
What you will be able to do at the end
- Build a three-statement model from scratch that links, balances and does not break when you change an assumption.
- Drive it off real revenue and cost assumptions you can defend in an interview, not plugged numbers.
- Value the business three ways — DCF, comparable companies and precedent transactions — and explain why they disagree.
- Build scenario and sensitivity tables that a reviewer can read in ten seconds.
- Structure and error-proof a model so someone else can audit it. This is the part that separates an analyst from a spreadsheet user.
- Walk into an interview with two finished models of Indian listed companies that are yours.
The syllabus
| Module | What is covered | What you produce |
|---|---|---|
| 01 | Excel for modellers — structure, navigation, the twenty functions that matter, formatting conventions, why a modeller never uses the mouse | A formatted, navigable workbook shell |
| 02 | Reading the annual report — where the numbers actually live, notes to accounts, related-party items, what management chooses not to say | A cleaned historical financials sheet |
| 03 | The income statement — revenue build, cost behaviour, operating leverage, normalising one-offs | A driver-based P&L forecast |
| 04 | Working capital and the balance sheet — days-based schedules, the cash sweep, why your model does not balance and how to find it in ninety seconds | A balancing balance sheet |
| 05 | Debt, interest and the circularity problem — the revolver, iterative calculation, and the switch that stops the whole file exploding | A working debt schedule |
| 06 | Depreciation, capex and the fixed asset roll-forward | A complete three-statement model |
| 07 | Discounted cash flow — free cash flow, WACC in the Indian context, terminal value by both methods, and why your answer is a range not a number | A DCF with a football-field output |
| 08 | Relative valuation — choosing a peer set honestly, which multiple for which business, calendarisation, precedent transactions | A comps sheet |
| 09 | Scenario and sensitivity — data tables, scenario switches, presenting a range to someone who has ninety seconds | Scenario dashboard |
| 10 | Model review — auditing someone else’s file, common errors, documentation, and how modelling questions are actually asked in interviews | A reviewed, submission-ready model |
Who this is built for
B.Com, BBA, MBA, Economics, Engineering
You are competing for finance roles against people with the same degree. A model you built yourself is the only thing on your CV that cannot be copied from a template.
In a job, moving into finance
Accounting, audit, sales or engineering into FP&A, equity research, credit or corporate finance. Weekend cohorts, and the case work is drawn from Indian filings.
Qualified, but never built one
You know the accounting cold. What is missing is the modelling discipline — structure, drivers, circularity, and defending a valuation range out loud.
Colleges and companies
Run as a value-added certificate course for your cohort, or as a two-day team workshop. Attendance, assessment and outcome records handed over in submission-ready format.
Fees
Small live cohort, recordings, all case files, model review of your own work, and a certificate on assessment.
Entirely private, scheduled around your job, and built around the industry you are targeting. Includes interview preparation on your own models.
Delivered to your cohort, online or on campus, inside your timetable. Priced to sit in the value-added course fee head.
Built on your own numbers under NDA where you prefer. Delivered at your office or online.
Fees are exclusive of GST. Institutional engagements are quoted in writing against a written scope before any commitment.
How we teach it
- You drive the keyboard. Sessions are working sessions. If you are watching, we are doing it wrong.
- Indian filings, not American textbooks. Ind AS presentation, Indian tax and depreciation treatment, Indian cost of capital.
- Your model gets reviewed. Line by line, in writing, the way a senior would review it.
- Nobody hands you a finished file. You will build it or you will not have it.
Common questions
I am weak in Excel. Is that a problem?
No, provided you say so at the start. Module 01 exists precisely for this, and the free session is partly a diagnostic so we know where to begin.
Do you guarantee a job or a placement?
No, and be careful of anyone who does. We prepare you for the technical part of the interview and we review your models. What we will not do is promise an outcome that depends on a hiring market we do not control.
Is this the same as an investment or trading course?
No. This is a professional skills course in building and valuing companies. It is not about buying or selling securities and it contains no recommendations. Our separate capital markets education page explains that boundary in full.
What do I need?
A laptop with Excel or Google Sheets, a stable connection, and the willingness to be wrong in front of someone for forty hours. That last one matters most.
Or call / WhatsApp +91 94973 24931. Every engagement starts with a real conversation — online or in person — about what you need and whether we are the right people to do it.