Pro+

DCF + LBO Pro Modeler

This tool is part of the Pro+ Investor Workbench. The free DCF Quick and QoE Analyzer stay open for everyone.

Upgrade to Pro+ to unlock:

  • Full CAPM-based WACC builder (risk-free + beta × ERP + size premium; weighted with cost of debt)
  • LBO sources & uses + debt amortization schedule + cash sweep + exit MOIC / IRR
  • 11×11 two-way sensitivity grids across any pair of inputs
  • 3-scenario (bear / base / bull) side-by-side comparison
  • PDF export & save-to-workbench (CRM-linked)
Upgrade to Pro+ Use the free version
Investor Workbench / Financial Modeling / DCF + LBO Pro · Pro+

DCF + LBO Pro Modeler

The full enterprise build: a 5-year DCF with a complete CAPM-based WACC build, a full LBO structure with sources & uses, debt amortization, and cash sweep, exit MOIC and IRR at multiple exit multiples, and a 5×5 two-way sensitivity grid. Switch between bear / base / bull scenario inputs. Pure client-side math — your model never leaves your device.

Scenario:
Switching saves the current scenario's inputs and loads the new one's.

DCF Inputs

Cost of equity (CAPM)

Cost of debt & weights

Deal structure

Sensitivity Grid Axes

Hold every other input constant. The grid varies the two axes you pick by 5 steps each (±2 around base).

DCF Valuation

5-Year FCF Projection

WACC Build

Build-up

LBO Sources, Uses & Returns

Sources & Uses

Debt Schedule

Returns by Exit Multiple

5×5 Sensitivity Grid

The center cell (orange border) reflects your current base assumptions. Heat-map coloring: green = higher value, red = lower.

Scenario Comparison — Bear / Base / Bull

Edit inputs in each scenario via the pill picker at the top of the page. The compare view always reflects the latest saved state per scenario.

Methodology — math used in this model

DCF — 5-year FCF projection: Year-t revenue = revenue₀ × (1+g)^t; Year-t FCF margin interpolates linearly Start → Year-5. Discount factor = 1 / (1 + WACC)^t (or t − 0.5 if mid-year convention is on). Terminal Value uses Gordon Growth: TV = FCF₅ × (1 + g_term) / (WACC − g_term). EV = ΣPV(FCF) + PV(TV). Equity = EV + Cash − Debt. Per-share = Equity / Shares.

WACC — Cost of equity (CAPM): k_e = rf + β × ERP + size premium. After-tax cost of debt: k_d × (1 − t). WACC = (D/V) × k_d_after-tax + (E/V) × k_e, where D/V is the target debt weight.

LBO — Sources: Sponsor equity + Total debt = Uses: Purchase price (EBITDA × entry multiple) + Transaction fees. Debt schedule: starting balance amortizes by (mandatory amort) + (cash sweep × FCF) each year, subject to FCF availability. Exit Equity = Exit EV − Ending Debt + Ending Cash. MOIC = Exit Equity / Sponsor Equity. IRR solved via Newton bisection on Sponsor Equity × (1+r)^hold = Exit Equity.

Sensitivity grid — 5×5 two-way grid. The x-axis and y-axis are picked from the dropdown; each axis varies ±2 steps around the base value. All other inputs hold constant. Cells where terminal growth ≥ WACC (Gordon Growth breaks) render as "—".

What's intentionally omitted — Stub-period proration for non-calendar fiscal years, working-capital normalization, ASC 842 / IFRS 16 lease treatment, non-operating-asset roll-ins, minority-interest adjustments, and AI-driven critique of model assumptions vs comp benchmarks (queued for a follow-up release).

Educational financial-modeling tool — not investment advice and not a substitute for institutional-grade valuation work. All math runs in your browser; no inputs are sent to a server.