Financial Modeling Crash Course

Lesson 1 • Core Formula Toolkit

Covers the essential formulas used in nearly every financial model. Builds formula fluency needed for all later chapters.

Lesson 2 • What Financial Models Actually Do

Defines financial models, their business purpose, and common use cases. Anchors all subsequent technical work in real decision-making contexts.

Lesson 3 • Error-Proofing and Auditing Techniques

Teaches systematic methods to detect and prevent formula errors. Produces models that others can verify with confidence.

Lesson 4 • Model Architecture and Layout

Introduces the separation of inputs, calculations, and outputs. Creates a scalable structure that supports auditing and collaboration.

Lesson 1 • Income Statement Mechanics

Models revenue, cost of goods sold, operating expenses, and net income line by line. Establishes the top of the integration waterfall.

Lesson 2 • Linking the Three Statements

Connects all three statements so that a single assumption change flows through automatically. Tests integration integrity with stress inputs.

Lesson 3 • Assumption Documentation

Structures a dedicated assumptions tab with sources and rationale. Ensures models are transparent and defensible to reviewers.

Lesson 4 • Cash Flow Statement Methods

Derives operating, investing, and financing cash flows from the income statement and balance sheet. Completes the three-statement linkage.

Lesson 1 • Bottom-Up Revenue Forecasting

Builds revenue from unit-level assumptions aggregated upward. Produces forecasts that can be validated against operational data.

Lesson 2 • Cost Structure Analysis

Classifies costs as fixed, variable, or semi-variable and models each accordingly. Enables accurate margin forecasting across volume scenarios.

Lesson 3 • Headcount and Payroll Modelling

Builds a detailed headcount schedule linked to the income statement. Captures the largest cost driver in most service businesses.

Lesson 4 • Gross Margin and EBITDA Bridging

Reconciles revenue and cost forecasts into margin metrics. Provides the analytical bridge used in management and investor reporting.

Lesson 1 • Working Capital Forecasting Methods

Projects working capital using days-based and percentage-of-revenue approaches. Selects the method appropriate to data availability and business type.

Lesson 2 • Liquidity and Cash Runway Analysis

Forecasts minimum cash balances and identifies periods of potential shortfall. Supports decisions on credit facilities and equity raises.

Lesson 3 • Working Capital Components

Defines accounts receivable, inventory, and accounts payable as cash flow drivers. Connects operational metrics to balance sheet movements.

Lesson 4 • Free Cash Flow Derivation

Calculates unlevered and levered free cash flow from operating and investing activities. Produces the cash flow metric used in valuation.

Lesson 1 • Building the Debt Schedule

Constructs a period-by-period debt schedule with opening balance, draws, repayments, and interest. Feeds directly into the three-statement model.

Lesson 2 • Weighted Average Cost of Capital

Calculates WACC from cost of equity, cost of debt, and capital structure weights. Produces the discount rate used in DCF valuation.

Lesson 3 • Debt Instrument Fundamentals

Surveys term loans, revolvers, bonds, and mezzanine debt by structure and cost. Provides the vocabulary needed to model any debt stack.

Lesson 4 • Leverage Ratios and Credit Metrics

Computes net leverage, interest coverage, and debt service coverage ratios. Enables covenant compliance testing and credit risk assessment.

Lesson 1 • Terminal Value Estimation

Calculates terminal value using the Gordon Growth Model and exit multiple methods. Quantifies the sensitivity of total value to terminal assumptions.

Lesson 2 • DCF Sensitivity and Scenario Tables

Builds two-variable data tables to show how value changes with WACC and growth rate. Communicates valuation uncertainty to non-technical audiences.

Lesson 3 • DCF Framework and Logic

Explains the time value of money and why future cash flows are discounted. Positions DCF as the intrinsic value anchor for all other methods.

Lesson 4 • Discount Rate Application

Applies WACC to discount projected cash flows and terminal value to present value. Bridges the capital structure chapter into the valuation output.

Lesson 1 • Comparable Company Analysis Setup

Selects and screens a peer group based on business model, size, and geography. Establishes the foundation for a defensible trading comps analysis.

Lesson 2 • Spreading and Normalising Financials

Standardises reported financials by removing one-time items and adjusting for comparability. Ensures multiples reflect ongoing business performance.

Lesson 3 • Triangulating Valuation Outputs

Combines DCF, trading comps, and precedent transaction ranges into a single football field. Produces a defensible valuation conclusion.

Lesson 4 • Precedent Transaction Analysis

Applies acquisition multiples from comparable deals to estimate control value. Captures the premium paid above trading value in M&A contexts.

Lesson 1 • Monte Carlo Simulation Basics

Introduces probabilistic modelling using random input distributions. Produces a value distribution rather than a single-point estimate.

Lesson 2 • Dynamic Dashboard Construction

Builds an executive summary tab with charts, KPIs, and scenario toggles. Translates model complexity into a single-page decision tool.

Lesson 3 • Scenario and Sensitivity Framework

Distinguishes scenario analysis from sensitivity analysis and when to use each. Structures the model to toggle between cases without breaking links.

Lesson 4 • Model Quality and Review Checklist

Applies a structured pre-delivery review covering logic, formatting, and documentation. Ensures the model meets professional standards before sharing.