📉Pro

Financial Modeling & Analysis

Master financial modeling from three-statement models and DCF valuation to LBO, merger, and real estate models — with scenario analysis and presentation techniques.

7 modules 35 lessons ~9h AI voice coach
Start Learning — Pro

7-day free Pro trial included

Course Outline

1

Financial Modeling Foundations

5 lessons

Learn the principles, design standards, and best practices that underpin every professional financial model.

What is Financial Modeling?
Model Design Principles
Color Coding Standards
Linking Financial Statements
Error Checking
2

Three-Statement Model

5 lessons

Build a complete three-statement financial model — connecting income statement, balance sheet, and cash flow statement.

Income Statement Model
Balance Sheet Model
Cash Flow Statement Model
Connecting the Three Statements
Balancing the Model: The Cash Plug
3

DCF Model

5 lessons

Build a complete DCF valuation model from revenue build to equity bridge.

Revenue Build
Operating Model
Free Cash Flow Projection
WACC Model
Terminal Value & Equity Bridge
4

LBO Model

5 lessons

Build a leveraged buyout model from sources and uses through debt schedules, cash flow sweeps, and returns analysis.

Sources & Uses Table
Debt Schedule
Cash Flow Sweep
Returns Waterfall
LBO Sensitivity Analysis
5

Merger Model

5 lessons

Build a merger model to analyze accretion/dilution, synergies, and purchase price allocation.

Accretion / Dilution Analysis
Pro Forma Income Statement
Synergy Modeling
Purchase Price Allocation
Merger Model Outputs
6

Real Estate Financial Modeling

5 lessons

Build real estate financial models for property cash flow analysis, development pro formas, and investment returns.

Property Cash Flow Model
Cap Rates & NOI
Development Pro Forma
Debt Service Coverage Ratio (DSCR)
IRR & Equity Multiple
7

Scenario & Sensitivity Analysis

5 lessons

Master advanced analytical techniques — sensitivity tables, scenario analysis, Monte Carlo simulation, and presenting results.

Building Sensitivity Tables
Scenario Analysis
Monte Carlo Simulation
Tornado Charts
Presenting Model Results