A financial model is only as valuable as the judgment behind it. Building a spreadsheet that produces numbers is one skill. Knowing which numbers to trust, how assumptions drive outcomes, and how to defend a valuation under scrutiny is another. This program develops both.
DCF, Comps, and Scenarios is an intermediate-to-advanced program designed for aspiring and practicing financial analysts, investment professionals, and business strategists who are ready to build, stress-test, and communicate professional-grade financial models. Across 14 focused courses, you will master the core methodologies that drive corporate finance: Discounted Cash Flow valuation, comparable company and precedent transaction analysis, scenario and sensitivity modeling, sales forecasting, project finance, capital structure analysis, zero-based budgeting, and Monte Carlo simulation.
You will work with Excel throughout, applying real-world techniques to case studies drawn from companies including NVIDIA, Microsoft, Amazon, WeWork, and Carillion. Every course combines expert instruction with hands-on labs and practical projects that produce defensible, analyst-ready outputs.
By the end of the program, you will be equipped to build robust financial models from scratch, evaluate investment decisions with rigor, and communicate your findings clearly to stakeholders and leadership.
Übungsprojekt
You will complete hands-on projects that mirror the financial analysis work done in professional roles. You'ill build a full DCF model in Excel incorporating WACC & terminal value calculations, perform a comparable company analysis using EV/EBITDA & P/E multiples, & normalize M&A transaction data for control premiums & synergies. You will construct a 20-year project finance model with sculpted debt schedules & equity waterfalls, build & analyze cash flow waterfalls to assess project solvency, & perform budget variance analysis to diagnose cost issues & stress-test financing scenarios. You'll also use Excel's Scenario Manager to model base, best-case, & worst-case financial outcomes, build one-way data tables to identify NPV breakeven points, run a Monte Carlo simulation to generate probabilistic EBITDA forecasts, & create sales forecasts using CAGR & Excel's GROWTH function. Each project is grounded in real company scenarios & designed to produce presentation-ready analysis.
