DCF, Comps, and Scenarios: Financial Modeling and Valuation

About this course

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.

Course objectives

• develop skills in DCF, comps, and scenario analysis
• gain proficiency in Excel for financial modeling
• apply real-world techniques through case studies