Valuation

Interactive tools for DCF modeling, relative valuation, and scenario analysis. Build the complete valuation toolkit from Chapter 3-10 frameworks.

7 Tools Interactive
8 Chapters Source
15 Exercises BUILD
BOOK CHAPTERS COVERED
Ch 3
Time Value
Ch 4
NPV & IRR
Ch 5
Capital Budgeting
Ch 6
Risk & Return
Ch 7
CAPM
Ch 8
Cost of Capital
Ch 9
DCF Valuation
Ch 10
Multiples

Interactive Tools

DCF Model Builder

Build three-statement DCF models with automatic free cash flow derivation and terminal value calculation.

  • FCF from EBIT or EBITDA
  • Gordon growth & exit multiple
  • Sensitivity tables

Comparable Analysis

Screen and adjust trading and transaction multiples with automatic normalization.

  • Multiple selector (P/E, EV/EBITDA, etc.)
  • Control premium adjustment
  • Outlier handling

Cost of Capital Calculator

WACC estimation with proper treatment of taxes, target structure, and risk adjustments.

  • Cost of equity (CAPM, buildup)
  • Cost of debt (YTM, spreads)
  • Target vs. current structure

Scenario Manager

Create and compare base, bull, bear, and custom scenarios with probability weighting.

  • Scenario tree builder
  • Probability-weighted value
  • Tornado charts

Terminal Value Analyzer

Dedicated terminal value sensitivity analysis with multiple methodology comparison.

  • Gordon vs. exit multiple
  • TV as % of value
  • Cross-check validation

Beta Estimator

Estimate and unlever betas from market data with adjustable parameters.

  • Regression vs. industry
  • Unlevering formulas
  • Blume adjustment

Valuation Summary

Combine DCF, comparables, and precedents into a unified valuation summary with ranges.

  • Football field chart
  • Weighted average
  • Export to PDF

BUILD Exercises

BUILD 1
Three-Statement DCF Model
Build a complete DCF from income statement projections to equity value
FOUNDATIONAL
BUILD 2
Terminal Value Sensitivity Matrix
Create WACC × Growth sensitivity table with conditional formatting
INTERMEDIATE
BUILD 3
Trading Comparable Analysis
Screen, select, and apply multiples to derive implied value range
INTERMEDIATE
BUILD 4
WACC Calculator with Iterations
Handle circular reference between WACC and enterprise value
ADVANCED
BUILD 5
Scenario-Weighted Valuation
Build probability-weighted DCF with Monte Carlo extension
ADVANCED

Start Building

Access the Valuation module and build production-grade models with guided exercises.

Access Module