Terminal Value Calculator Template
Executive Summary
Key Takeaways
- ✓ The template calculates terminal value using both the perpetuity growth method and the exit multiple method side by side, not just one.
- ✓ A built-in cross-check cell back-solves the implied exit multiple from the perpetuity method (and the implied growth rate from the exit multiple method), so the two can be compared directly.
- ✓ The terminal-year cash flow input should be normalized before it feeds either calculation, removing the effect of any one-off item in the final explicit forecast year.
- ✓ The template includes a dedicated cell calculating terminal value's share of total enterprise value, since this concentration is a key disclosure point in any DCF.
Purpose¶
This template sets out how to calculate DCF terminal value using both standard methods side by side, following the guidance in Terminal Value: Perpetuity Growth vs. Exit Multiple, with a built-in cross-check between them.
Template Structure¶
Section 1 — Shared Inputs
| Input | Value | Notes |
|---|---|---|
| Terminal-year free cash flow (normalized) | [input] | One-off items removed |
| Terminal-year EBITDA (normalized) | [input] | Used for the exit multiple method and the cross-check |
| Discount rate (WACC or cost of equity) | [linked from WACC Calculator Template] | — |
Section 2 — Perpetuity Growth Method
| Input | Value | Notes |
|---|---|---|
| Perpetuity growth rate (g) | [input] | Must be strictly below the discount rate; benchmark against long-run GDP/inflation |
| Terminal Value (Perpetuity Method) | = FCF × (1 + g) / (WACC - g) |
— |
Section 3 — Exit Multiple Method
| Input | Value | Notes |
|---|---|---|
| Exit multiple (EV/EBITDA) | [input] | Sourced from current comparable trading or transaction data, with source and date |
| Terminal Value (Exit Multiple Method) | = Terminal Year EBITDA × Exit Multiple |
— |
Section 4 — Cross-Check
| Calculation | Formula | Interpretation |
|---|---|---|
| Implied exit multiple (from perpetuity method) | = Terminal Value (Perpetuity) / Terminal Year EBITDA |
Compare against observed trading multiples for comparable companies |
| Implied growth rate (from exit multiple method) | Solve for g in the perpetuity formula using Terminal Value (Exit Multiple) | Compare against long-run GDP/inflation expectations |
Section 5 — Terminal Value Share of Total Value
| Calculation | Formula |
|---|---|
| Terminal value share of enterprise value | = PV(Terminal Value) / Total Enterprise Value |
How to Use This Template¶
Populate the shared inputs first, ensuring the terminal-year cash flow and EBITDA figures are normalized. Calculate both terminal value methods independently, then use the cross-check section to compare the implied multiple and implied growth rate against external benchmarks. A material divergence between the two methods — an implied exit multiple far outside the observed comparable range, or an implied growth rate above what the economy can sustain — should prompt a review of the underlying assumptions before the terminal value is finalized.
Common Pitfalls¶
Using the raw, unnormalized final-year cash flow. If the final explicit forecast year included a one-off item, both terminal value methods will be built on a distorted base.
Skipping the cross-check. Calculating only one method, with no comparison against the other, forfeits the single most useful sanity check available for terminal value.
Omitting the terminal value share calculation. Without Section 5, the disclosure does not show how concentrated total value is in the terminal assumption — a completeness gap flagged in the DCF Model Audit Checklist.
Continue Reading¶
Related Pillars¶
Related Technical Guides¶
Related Glossary¶
Related Checklists¶
Related Resources¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
Why does this template calculate terminal value two ways?
Because each method carries different assumption risk — the perpetuity growth method depends heavily on the assumed long-run growth rate, while the exit multiple method depends on current market pricing persisting to the terminal date. Calculating both and cross-checking one against the other surfaces an unreasonable assumption that either method alone might not reveal.
What does the cross-check cell actually calculate?
It back-solves the exit multiple implied by the perpetuity growth method's terminal value (dividing that terminal value by terminal-year EBITDA), and separately back-solves the perpetuity growth rate implied by the exit multiple method's terminal value, so both can be compared against observed market benchmarks.
Should the terminal-year cash flow be the same figure used in both methods?
Yes, and it should be the normalized (not raw) terminal-year cash flow, with any one-off item removed, consistent with the guidance in the Terminal Value technical guide.
Does this template calculate WACC or the growth rate assumption itself?
No. This template calculates terminal value from WACC and growth rate (or exit multiple) inputs that must be sourced separately — see the WACC Calculator Template for the discount rate build, and the Perpetuity Growth Rate glossary page for growth rate benchmarking guidance.
Related Articles
Terminal Value
Terminal value (TV) is the estimated value, at the end of a financial model's explicit forecast period, of all cash flows that the asset or business is expected to generate beyond that period. In a discounted cash flow (DCF) analysis, the terminal value represents the present value of the perpetuity of cash flows from the terminal period onwards, discounted back to the valuation date. Terminal value is the single largest component of total enterprise value in most DCF analyses. It is typically significant because a business or asset's cash flow-generating life extends far beyond a practical explicit forecast period of 5 to 10 years.
Perpetuity Growth Rate
The perpetuity growth rate (also called the terminal growth rate or Gordon growth rate) is the assumed constant rate at which a business's free cash flow is expected to grow indefinitely beyond the explicit forecast period. It is the key assumption in the Gordon Growth Model method of calculating terminal value, and it must be strictly less than the discount rate for the perpetuity formula to produce a finite, meaningful value. Because no business can outgrow the broader economy forever, the perpetuity growth rate is conventionally capped at or near the long-run expected growth rate of GDP or inflation in the business's operating geography.
Terminal Value: Perpetuity Growth vs. Exit Multiple
Terminal value, representing the cash flows a business is expected to generate beyond the explicit forecast period, is calculated using one of two standard methods: the perpetuity growth (Gordon Growth) method, which assumes cash flow grows at a constant rate forever, or the exit multiple method, which applies an observed market multiple to a terminal-year financial metric. Because terminal value frequently represents 60 to 80% or more of total DCF value, the choice of method and the resulting cross-check between the two is one of the most consequential technical steps in the entire valuation.
WACC Calculator Template
This template sets out how a WACC calculation should be structured as a standalone, auditable block within a financial model: a labelled input section for the risk-free rate, beta, equity risk premium, and cost of debt, a separate capital structure weighting section, and a final blended WACC cell that references every input rather than embedding any value directly. It is a structural template, not a source of specific rate assumptions, which must be sourced and justified for each specific valuation.