What learning resources help build excel modelling and DCF skills for IB, VC, PE and consulting?
Excel modelling and DCF skills are best built through a combination of free YouTube foundations, paid structured courses, and hands-on model-building, in that order.
Most IIM Calcutta students who land Goldman Sachs, Everstone Capital, or McKinsey roles spend 60-80 hours of deliberate practice before their first technical interview.
Where to Start: Free Resources
YouTube channels are the fastest zero-cost entry point. Analyst Academy covers three-statement modelling and DCF construction in digestible 15-minute segments. Breaking Into Wall Street publishes free sample models that mirror what analysts actually build at Morgan Stanley and Bain Capital. Trump Excel is underrated for mastering keyboard shortcuts and formula efficiency, which matters when interviewers time your model-building speed. Watch, pause, rebuild in parallel.
Paid Courses Worth the Spend
| Course | Approx. Cost | Best For |
|---|---|---|
| Wall Street Prep Premium | ₹15,000-20,000 | IB / PE technical prep |
| CFI FMVA Certification | ₹25,000-30,000 | Structured, credentialed learning |
| Breaking Into Wall Street Core | ₹12,000-16,000 | LBO and DCF depth |
| Macabacus Bundle | ₹8,000-10,000 | Excel speed and formatting |
Recruiters at Sequoia India and Everstone Capital have flagged FMVA credentials positively during VC/PE screening. Wall Street Prep carries more brand weight in pure IB contexts.
Both are legitimate; your choice depends on whether you want a credential or just the skill.
Build From Scratch, Not Templates
This is the step most people skip. Pick a publicly listed Indian company, say Asian Paints or HDFC Bank, download three years of annual reports from BSE/NSE, and build a full three-statement model from scratch.
Project revenues, EBITDA, capex, and free cash flow across a five-year horizon. Then layer a DCF on top using WACC as your discount rate and calculate terminal value under both the Gordon Growth and exit multiple methods.
Once built, compare your implied valuation against equity research reports from Kotak Securities or ICICI Direct. Where your assumptions diverge, ask why. That self-audit loop is where real understanding forms. No course can replicate it.
IIM Calcutta-Specific Opportunities
IIM Calcutta's finance club, FinNiche, runs internal case competitions and model reviews that give you structured feedback before placements. Peer review is genuinely underused here. Having a second-year student or a club senior tear apart your DCF assumptions teaches more than watching another video. The campus also sees recruiters from Kotak Investment Banking, Avendus, and A.T. Kearney who conduct technical rounds with live Excel tasks.
For consulting roles at McKinsey or BCG, the bar is slightly different. You won't build a full DCF in a case interview, but quick scenario modelling, break-even analysis, and back-of-envelope math in Excel all draw from the same foundation.
The skills transfer.
The Honest Reality
This path is not casual. Reaching interview-ready proficiency takes 60-100 hours minimum.
Most candidates underestimate the gap between understanding a model conceptually and building one cleanly under time pressure. Start before your second year begins, not during placement season.
Pro Tip: Build one complete DCF on an Indian listed company every month during your first year at IIM Calcutta, then present it to a FinNiche peer for critique, as this single habit separates candidates who can explain their assumptions from those who merely memorized formulas.