About Course

This hands-on, Excel-focused course teaches finance professionals and students to build complete three-statement financial models and perform DCF and relative valuations. You’ll learn to create detailed financial schedules, apply scenario and sensitivity analysis, and assess forecast risks. The course also trains you to present complex financial data clearly through dashboards and interactive Excel models.

What Will You Learn?

  • Build complete three-statement financial models (Income Statement, Balance Sheet, Cash Flow).
  • Perform DCF and relative valuation techniques for companies and transactions.
  • Create detailed financial schedules for revenue, costs, working capital, depreciation, taxes, debt, and equity.
  • Apply scenario and sensitivity analysis to evaluate forecast risks.
  • Present complex financial data clearly using dashboards and interactive Excel models.

Course Content

Module 0: Intro & Fundamentals

  • Module 0: Intro & Fundamentals
  • Module 1: Conceptual Foundations
  • Module 2: Core Schedules & Model Mechanics
  • Module 3: Three-Statement Roll-Out
  • Module 4: Forecasting & Valuation
  • Module 5: Scenarios & Sensitivity
  • Module 6: Advanced Topics
  • Module 7: Capstone Project

Student Ratings & Reviews

No Review Yet
No Review Yet