Financial Modeling, DCF & Valuation Case Prep with CA Keshav Bansal

Preparing for a technical case study round or struggling to bridge textbook valuation theory with real-world financial models? Having built integrated DCF models for North American institutional mandates, executed 409A/Black-Scholes valuations for US biotech/pharma firms, and completed the FMVA from The Wall Street School, I will walk you through how analysts actually value companies.

What we will cover:

1. 3-Statement & DCF Mechanics: Building revenue drivers, working capital schedules, WACC, and terminal value without circularity errors.

• Relative Valuation: Practical application of Trading Comps.
• Writing an Investment Memo: How to translate your Excel model into a compelling buy-side stock pitch or IC thesis.

Practically used Excel functions will be discussed and shared during the session. Isn't this exciting?