| Day | Focus | Deliverable | |------|-------------------------------|-----------------------------------| | 1 | Three‑statement model from scratch | Balanced model for a retail company | | 2 | DCF + WACC + sensitivity tables | Implied share price range | | 3 | Comps & precedent transactions | Football field valuation chart | | 4 | LBO model (with debt schedules) | IRR and MOIC output | | 5 | Integrated case study (M&A + LBO) | Investment committee memo |
Firms should mandate quarterly model‑audit workshops and a certification exam (e.g., building a three‑statement model + DCF in under 90 minutes) to ensure consistent proficiency. Prepared for internal training use. References: Rosenbaum & Pearl “Investment Banking,” Pignataro “Financial Modeling & Valuation.” Financial Modeling Valuation Wall Street Training
Acquire a $500M EBITDA manufacturing firm. Build an LBO model showing 22% IRR using 6x leverage, 50% exit multiple expansion, and 3% annual EBITDA growth. 6. Common Pitfalls & How to Avoid Them | Pitfall | Consequence | Training Fix | |---------|------------|---------------| | Double‑counting depreciation | Overstates cash flow | Check D&A in both CFI and CFO sections | | Off‑balance‑sheet debt | Understates leverage | Always sweep operating leases into debt | | Fixed tax rate when loss making | Overstates cash taxes | Model NOL carryforwards | | Mismatched dates (e.g., Dec YE vs. Mar YE) | Valuation misalignment | Force all inputs to a common fiscal period | 7. Conclusion Mastery of financial modeling and valuation is the currency of Wall Street. The training described above transforms a candidate from a raw spreadsheet user into a professional who can build robust, defensible models under tight deadlines. Beyond the mechanics, the ultimate goal is to develop judgment: knowing which assumptions matter most, when to simplify, and how to communicate output with clarity and integrity. Build an LBO model showing 22% IRR using
