Corporate Finance & Valuation Lab

Discounted Cash Flow (DCF) Model & Valuation Lab

Model discrete 5-year Unlevered Free Cash Flows (UFCF), discount at WACC, evaluate dual Terminal Value methodologies (Gordon Growth vs. Exit Multiples), bridge Enterprise Value to Equity Value, and stress-test per-share fair values across sensitivity matrices.

DCF Valuation Core
EV = PV(FCF) + PV(TV)
Terminal Value typically accounts for 65%–85% of total enterprise value in long-term DCF forecasts.

Valuation Industry Presets

Select an institutional preset to prefill cash flow trajectory, capital structure, and discount hurdles.

Step 1: Cash Flow Projections & Valuation Parameters

DCF Forecast & Capital Structure Inputs

📈 5-Year Unlevered Free Cash Flow Forecast ($M)

🏛️ Terminal Value Parameters

Standard long-term GDP benchmark is 2.0%–3.5%.

⚖️ Balance Sheet Net Debt & Share Count

Added to Enterprise Value to calculate Equity.
Subtracted from Enterprise Value (funded debt).
Diluted common share count for per-share price.
For Margin of Safety & premium/discount analysis.
Mathematical Formulation
$$\text{PV(FCF)} = \sum_{t=1}^5 \frac{\text{UFCF}_t}{(1 + \text{WACC})^t}$$ $$\text{TV}_{\text{Gordon}} = \frac{\text{FCF}_5 \cdot (1 + g)}{\text{WACC} - g}, \quad \text{TV}_{\text{Multiple}} = \text{EBITDA}_5 \cdot M$$ $$\text{Intrinsic Price} = \frac{\text{EV} + \text{Cash} - \text{Debt}}{\text{Diluted Shares}}$$

Step 2: Valuation Output & Fair Value Bridge

DCF Fair Value Summary

Implied Fair Share Price
$84.15
DCF Intrinsic Value / Share
Enterprise Value (EV)
$2.14B
PV(FCFs) + PV(Terminal)
Net Equity Value
$2.10B
EV + Cash - Debt
Valuation Upside / Spread
+22.8%
vs Current Market Price
PV of Discrete 5Y FCFs
$274.2M
PV of Terminal Value
$1.87B
Terminal Value Share of EV
87.2%
Implied Perpetuity Growth
3.4%
Evaluating model intrinsic fair value...

📅 5-Year Unlevered Free Cash Flow Discounting Schedule

Forecast Period Projected Cash Flow Discount Factor $(1+r)^{-t}$ Present Value (PV) % of Total EV

Step 3: Stress Testing & Matrix Analysis

Valuation Sensitivity Matrices

Examine how changing the WACC discount rate, long-term terminal growth rate, and exit EBITDA multiples impacts implied share price.

📊 Implied Share Price: WACC vs. Perpetuity Growth ($)

Varying the cost of capital vs. terminal long-term GDP growth rate under Gordon Growth.

📊 Implied Share Price: WACC vs. Exit Multiple ($)

Varying WACC vs. Year 5 EV/EBITDA exit multiple under the Multiple Method.

Institutional Valuation Framework

How to Master Discounted Cash Flow Valuation

1. Unlevered Free Cash Flow (UFCF) Mechanics

Unlevered Free Cash Flow represents the cash generated by core operations that is available to all providers of capital (both equity holders and debt holders) after reinvestment in working capital and capital expenditures:

$$\text{UFCF} = \text{EBIT} \times (1 - t) + \text{D\&A} - \Delta\text{NWC} - \text{CapEx}$$

By analyzing unlevered cash flows, you evaluate the enterprise independently of its capital structure financing choices.

2. Terminal Value Pitfalls & Implied Growth Check

Because 65%–85% of a DCF model's value often resides in the terminal value, small variations in the terminal growth rate ($g$) or exit multiple drastically swing the valuation.

Always verify that the implied perpetuity growth rate resulting from your exit multiple does not exceed the long-term sustainable growth rate of the broader economy (typically 2.0%–3.5%). If your exit multiple implies a 6% perpetuity growth rate, the terminal multiple assumption is aggressive.

3. Weighted Average Cost of Capital (WACC)

WACC is the required hurdle rate reflecting the blended cost of debt and equity:

$$\text{WACC} = \left(\frac{E}{V} \times K_e\right) + \left(\frac{D}{V} \times K_d \times (1 - t)\right)$$

Higher interest rates, credit spreads, and market volatility increase WACC, causing future cash flows to be discounted more heavily and compressing fair equity valuations.

4. Margin of Safety & Valuation Distribution

A single DCF point estimate is rarely exact. Benjamin Graham and Warren Buffett recommend demanding a margin of safety (typically 15%–25%) below the intrinsic fair value before committing capital.

Using the dual 5x5 sensitivity tables above allows analysts and investors to identify the exact threshold where an investment transitions from a favorable risk/reward profile into an overvalued posture.

Frequently Asked Questions

DCF Modeling FAQ

A Discounted Cash Flow (DCF) model is an intrinsic valuation methodology that estimates the fair value of a company or investment based on the present value of its projected future cash flows, discounted at the Weighted Average Cost of Capital (WACC).

This simulator supports both the Gordon Growth Perpetuity model (TV = FCF_5 * (1 + g) / (WACC - g)) and the Exit Multiple Method (TV = EBITDA_5 * Multiple), as well as a blended 50/50 average. It also solves for the implied growth rate resulting from your chosen exit multiple.

To transition from Enterprise Value to Equity Value, you add total cash and liquid equivalents and subtract total outstanding debt (Net Debt adjustment). Dividing the resulting Equity Value by fully diluted shares outstanding yields the implied intrinsic share price.

The Margin of Safety is the percentage difference between the calculated intrinsic fair value and the current market trading price: (Intrinsic Value - Market Price) / Intrinsic Value. A positive margin of safety provides a buffer against forecasting errors or economic downturns.

Yes. You can export the complete valuation audit, including discrete 5-year cash flows, discount factors, present values, terminal value reconciliations, and equity bridge items as a CSV spreadsheet with formula injection defense.