Terminal Value in Excel: Gordon Growth vs Exit Multiple (2026)

July 12, 2026 · VeloraAI Team
Financial Modeling Formulas Excel

In most sell-side DCF models, 60% to 80% of enterprise value sits inside a single cell: terminal value. That cell is also the one analysts audit last, defend weakest, and get wrong most often. A 0.5% shift in the perpetual growth rate can move an implied share price by 15%, yet terminal value is routinely typed in as a hard-coded formula and never sensitized. This guide shows how to build terminal value in Excel using both the Gordon Growth (perpetuity growth) method and the Exit Multiple method, cross-check them against each other, and stress-test the assumptions that actually matter.

You will get the exact formulas, the discounting mechanics, a comparison table for choosing between methods, and the sanity checks that separate a defensible valuation from a number you can't defend in a fairness opinion.

What Is Terminal Value in a DCF Model?

Terminal value (TV) is the estimated value of a business at the end of the explicit forecast period, capturing all cash flows that occur beyond your model's horizon. Because forecasting free cash flow line-by-line past year 5 or 10 becomes speculative, analysts collapse everything after that into a single lump-sum value and discount it back to today.

Terminal value typically dominates a DCF because it captures cash flows extending into perpetuity, while the explicit period only covers 5–10 years. On a mature company with a 10-year forecast and a 9% WACC, roughly two-thirds of enterprise value routinely comes from the terminal year and beyond — which is why getting this calculation right is the single most consequential step in a DCF model built in Excel.

There are two standard methods:

  1. Gordon Growth Model (also called the perpetuity growth method): assumes free cash flow grows at a constant rate forever.
  2. Exit Multiple Method: applies a market-based multiple (usually EV/EBITDA) to the final year's metric.

Best practice is to calculate both, cross-check them, and present a range rather than a point estimate.

ℹ️ Note: Terminal value belongs in year N of the forecast (the last explicit year), not year N+1. It must then be discounted back to today using the same WACC and period convention as your explicit-period cash flows.

How Do You Calculate Terminal Value Using the Gordon Growth Model?

The Gordon Growth formula for terminal value is: TV = FCF × (1 + g) / (WACC − g), where FCF is the final-year free cash flow, g is the perpetual growth rate, and WACC is the weighted average cost of capital. This value sits in the last explicit year of your DCF and must be discounted back to present value.

The Formula in Excel

Assume your model has these labeled cells:

  • FCF_Yn: Free cash flow in the final forecast year (year N)
  • g: Perpetual growth rate (e.g., 2.5%)
  • WACC: Discount rate (e.g., 9.0%)

The core Excel formula is:

=FCF_Yn * (1 + g) / (WACC - g)

Written with cell references instead of named ranges:

=H10 * (1 + $C$4) / ($C$3 - $C$4)

Where H10 is year-10 FCF, $C$3 is WACC, and $C$4 is the perpetual growth rate.

Choosing the Perpetual Growth Rate

The single most abused assumption in DCF modeling is the perpetual growth rate g. Two hard constraints:

  1. g must be less than WACC. Mathematically, if g ≥ WACC the denominator turns negative or zero and the formula breaks. Practically, no business can grow faster than its cost of capital forever.
  2. g must be less than long-term GDP growth. No company can outgrow the economy in perpetuity — or it eventually becomes larger than the economy itself. For developed-market DCFs, use 2.0% to 3.0% as a defensible band. Anything above 3% needs an explicit justification tied to inflation expectations.

⚠️ Warning: Using g = 5% because "the company is growing fast today" is the single most common analyst error. Perpetual growth reflects steady-state, not near-term momentum. If you can't defend g < long-term GDP growth, the number is not defensible in a valuation memo.

Handling FCF vs. FCF(1+g) in the Numerator

Some textbooks write TV = FCF_N / (WACC − g), using year-N FCF directly. Others use FCF_N × (1 + g), representing year N+1 cash flow. Both are defensible, but they yield materially different answers. Use the year N+1 (i.e., FCF × (1+g)) convention consistently — it matches the perpetuity formula's assumption that the first cash flow occurs one period after valuation.

How Do You Calculate Terminal Value Using the Exit Multiple Method?

The Exit Multiple method estimates terminal value by applying a market-derived multiple to a terminal-year operating metric — most commonly TV = EBITDA_N × EV/EBITDA multiple. It grounds the terminal value in observable market pricing rather than an abstract perpetuity assumption and is preferred in banking practice for M&A and LBO contexts.

The Formula in Excel

Assume:

  • EBITDA_Yn: Terminal year EBITDA
  • Exit_Multiple: The chosen EV/EBITDA multiple (e.g., 8.5x)

The formula is:

=EBITDA_Yn * Exit_Multiple

Or with cell references:

=H14 * $C$6

You can also anchor the multiple to a peer-set median directly in Excel:

=H14 * MEDIAN(Peers_EV_EBITDA_Range)

Choosing the Exit Multiple

Best practice is to use the current trading multiple of the peer group (from a comparable company analysis in Excel), adjusted for where you expect the target's operating profile to be in year N. If the target will look more like a mature, slower-growing peer at exit, apply the mature-peer multiple, not today's high-growth multiple.

Approach When to Use Data Source
Current peer median Mature companies with stable comp sets Bloomberg, CapIQ current EV/EBITDA
5-year historical average Cyclical industries Historical trading multiples
Target's own historical mean Public companies with long trading history Company-specific multiples
Precedent M&A multiples Change-of-control valuations Recent deal comps

💡 Pro Tip: Do not use a forward multiple (e.g., EV/NTM EBITDA) applied to already-forward EBITDA — that double-counts growth. If your peer multiple is on next-twelve-months EBITDA, apply it to year N EBITDA, not year N+1.

Discounting Terminal Value Back to Present Value

Both methods return terminal value as of the end of the final forecast year — not today. You must discount TV back to time zero using the same WACC and same period convention (mid-year or end-of-year) as your explicit cash flows.

End-of-Year Convention

If your explicit cash flows are discounted at end-of-year, discount TV over N full years:

=TV / (1 + WACC)^N

For a 10-year forecast:

=H20 / (1 + $C$3)^10

Mid-Year Convention

Under the mid-year convention, cash flows are assumed to arrive at the midpoint of each year. TV is still received at end of year N, so it discounts over N − 0.5 years:

=TV / (1 + WACC)^(N - 0.5)

⚠️ Warning: A very common bug is discounting explicit-period FCFs mid-year but discounting TV end-of-year. This creates a period mismatch. Either use mid-year throughout or end-of-year throughout — never mix.

Which Method Should You Use? Gordon Growth vs Exit Multiple

Both methods should be calculated in every DCF. Use Gordon Growth as your primary if the company is mature, stable, and asset-light. Use Exit Multiple when comparable peers exist and the target is likely to be sold rather than held forever. Then cross-check: if the two methods disagree by more than 15%, one of your assumptions is off.

Dimension Gordon Growth Exit Multiple
Best for Mature, stable-growth companies Cyclical, M&A, or LBO targets
Anchors to Long-term macro assumptions Observable market pricing
Key input Perpetual growth rate (g) EV/EBITDA (or EV/EBIT) multiple
Sensitivity risk High — small changes in g swing value 15%+ Medium — multiple is more stable
Common critique Growth rate is arbitrary Assumes today's multiples persist
Sanity check Back into implied exit multiple Back into implied perpetual growth

The Two-Way Cross-Check

The most powerful analyst move: after you build both methods, back-solve the implied assumption of each.

Implied exit multiple from Gordon Growth:

=TV_Gordon / EBITDA_Yn

Implied perpetual growth rate from Exit Multiple:

=WACC - (EBITDA_Yn * (1 + g_placeholder) / TV_Multiple)

Or use Excel's Goal Seek: set the Gordon Growth TV equal to the Exit Multiple TV by changing g. If the implied g is 5%, your exit multiple is too rich. If the implied exit multiple is 12x on a company where peers trade at 7x, your g is too aggressive.

graph TD
    A[Final Year FCF & EBITDA] --> B[Gordon Growth Method]
    A --> C[Exit Multiple Method]
    B --> D[TV = FCF × 1+g / WACC-g]
    C --> E[TV = EBITDA × EV/EBITDA]
    D --> F[Discount to PV]
    E --> F
    F --> G[Cross-Check: Implied Multiple vs Implied Growth]
    G --> H{Within 15%?}
    H -->|Yes| I[Present as Valuation Range]
    H -->|No| J[Revisit Assumptions]
    J --> A

What Percentage of DCF Value Should Terminal Value Be?

There is no strict rule, but 50% to 80% of total enterprise value from terminal value is normal for a 5–10 year forecast. Above 85%, your explicit period is too short — extend it or reconsider your growth assumptions. Below 40% and you may be under-valuing long-term cash flows or over-discounting them.

Calculate this ratio explicitly in your Excel model:

=PV_of_TV / (PV_of_TV + SUM(PV_of_Explicit_FCFs))

What This Ratio Tells You

  • TV > 85% of EV: Explicit period likely too short. Extend to 10 years, or you're valuing the terminal assumption more than the business itself.
  • TV between 60% and 80%: Typical range for mature businesses with 5–10 year forecasts.
  • TV < 40%: Either explicit period is unusually long, growth rate is very low, or WACC is very high. Verify your inputs.

Example: A software company with $400M year-10 FCF, 3% perpetual growth, and 10% WACC has TV = $400M × 1.03 / (0.10 − 0.03) = $5,886M. Discounted at 10% over 10 years, PV(TV) = $5,886 / 1.10^10 = $2,269M. If PV of the 10-year explicit FCFs is $900M, terminal value contributes $2,269 / ($2,269 + $900) = 71.6% of enterprise value. That's within range and defensible.

Sensitivity Analysis on Terminal Value

Because TV drives the majority of DCF value, running a two-variable sensitivity table on terminal-value inputs is not optional — it is the difference between a valuation you can defend and one you can't.

Building the Sensitivity Table in Excel

Set up a two-way data table with WACC on one axis and perpetual growth rate (or exit multiple) on the other. The output cell is implied share price or enterprise value.

  1. In the top-left cell of your table, reference your DCF output cell: =$D$50 (assumes D50 holds implied share price).
  2. Populate the top row with WACC values: 7.0%, 8.0%, 9.0%, 10.0%, 11.0%.
  3. Populate the left column with growth rates: 1.5%, 2.0%, 2.5%, 3.0%, 3.5%.
  4. Select the entire table including the reference cell and headers.
  5. Go to Data → What-If Analysis → Data Table.
  6. Row input cell: WACC assumption. Column input cell: g assumption.

Excel will populate every intersection.

Reading the Output

If a 100 bps move in WACC (say 9% to 10%) swings your share price by more than 20%, the model is over-sensitive to WACC and you should double-check your capital structure and beta assumptions. If a 50 bps move in g swings share price by more than 15%, your explicit forecast is too short — extend it and let more value settle into the explicit period.

💡 Pro Tip: Format the sensitivity table with conditional formatting (Red-Yellow-Green color scale) so the range of plausible outcomes is visually obvious. When a client asks "what if growth is 2% instead of 3%?", you should be able to point to a cell, not recalculate.

Common Terminal Value Mistakes That Break Valuations

These are the recurring errors from real deal-side model reviews:

1. Using Nominal Growth Above Long-Term Inflation

Setting g = 4% or higher in a low-inflation environment implies the business will eventually consume the entire economy. Cap g at long-term GDP growth (typically 2%–3% for developed markets, 4%–5% for select emerging markets).

2. Forgetting to Discount TV Back to PV

The Gordon Growth formula returns TV as of end of year N, not today. Failing to divide by (1 + WACC)^N overstates enterprise value by orders of magnitude.

3. Mismatched Cash Flow Definitions

The FCF used in TV must match the FCF used in the explicit period. If you use unlevered FCF (FCFF) in years 1–10 and lever-adjusted FCF in the terminal formula, you're comparing apples to oranges. Stick to FCFF discounted at WACC for enterprise value, or FCFE discounted at cost of equity for equity value — but never mix.

4. Terminal-Year FCF Reflects Peak, Not Steady-State

If your terminal year FCF is inflated by an unsustainable margin, one-time working capital release, or unusually low capex, the perpetuity extrapolates that anomaly forever. Normalize the terminal year so that D&A ≈ capex, working capital changes are modest, and margins reflect long-run averages.

⚠️ Warning: A frequently-cited example: terminal year capex is 3% of revenue but D&A is 6% of revenue. The perpetuity assumes this gap continues forever, which is impossible — eventually the asset base gets depleted. Normalize capex = D&A in steady state.

5. Circular Growth-in-Two-Places Errors

If your explicit period ends with revenue growing at 8% in year 10, and you apply g = 3% in the terminal formula, there's an implicit discontinuity — cash flow growth drops 5 percentage points overnight. Either extend your explicit period until growth naturally decelerates to g, or add a "fade" period (years 11–15) between explicit and perpetuity.

Advanced: Using the H-Model for Fading Growth

The H-Model is a middle ground between Gordon Growth and a full explicit fade period. It assumes growth linearly declines from an initial rate ga to a terminal rate gn over a period of H years.

The formula:

=FCF_Yn * (1 + gn) / (WACC - gn) + FCF_Yn * H * (ga - gn) / (WACC - gn)

Where:

  • ga = initial higher growth rate
  • gn = terminal steady-state growth rate
  • H = half of the transition period (e.g., if fade is 10 years, H = 5)

This handles the discontinuity problem elegantly and is standard in equity research for growth companies transitioning to maturity.

Frequently Asked Questions

What is a good perpetual growth rate for a DCF?

For developed-market companies, a defensible range is 2.0% to 3.0%, roughly tracking long-term inflation and real GDP growth. Anything above 3% needs explicit justification, and no g should ever exceed long-term nominal GDP growth (~4%–5%). Emerging market DCFs may support 3.5%–5.0% depending on the country's macro outlook.

Should terminal value be higher than the sum of forecast period cash flows?

Almost always, yes. Terminal value typically represents 60%–80% of total enterprise value in a 5–10 year DCF. This is not a flaw — it reflects that the vast majority of a business's value comes from cash flows beyond your forecast horizon. If TV is less than 40% of EV, either your explicit period is unusually long or your terminal assumptions are unusually conservative.

Can terminal value be negative in a DCF?

Mathematically yes, if perpetual FCF is negative, but this makes no economic sense — a business with permanently negative cash flows is worth zero (equity) or scrap value. If your model produces negative TV, either normalize the terminal-year FCF (fix unsustainable losses) or acknowledge the business has no going-concern value and use liquidation value instead.

Is Gordon Growth or Exit Multiple more accurate for terminal value?

Neither is inherently more accurate — both are approximations of unobservable future cash flows. Gordon Growth is theoretically cleaner because it discounts actual cash flows; Exit Multiple is more practical because it anchors to observable market prices. Best practice is to calculate both, present the range, and highlight where they disagree. In banking pitch books, Exit Multiple is more common; in equity research, Gordon Growth dominates.

How do you calculate terminal value for a company with declining cash flows?

If cash flows are permanently declining, use a negative perpetual growth rate (e.g., g = −2%) in the Gordon Growth formula. The math still works because WACC > g. For businesses in secular decline (print media, coal), this often produces terminal values only 2x–4x terminal FCF, which is realistic. For temporary declines followed by stabilization, model the recovery explicitly and use standard perpetuity from the stabilized year.

Closing: Terminal Value Is Where DCFs Live or Die

Terminal value is the single largest driver of DCF-based valuations and the assumption most likely to be attacked in due diligence, an investment committee, or a fairness opinion review. Building both Gordon Growth and Exit Multiple in every model, cross-checking their implied assumptions, and running two-way sensitivity tables on the inputs takes 20 minutes and eliminates 80% of the errors that show up in real-world model audits.

Tools like VeloraAI can auto-generate terminal value cross-checks, flag when g exceeds long-term GDP growth, and detect the FCF/discount-rate mismatches that traditional Excel audits miss — but the discipline of building a defensible TV starts with the analyst. Add both methods to your DCF template today, and the next time someone asks "why is your terminal value $2.3 billion?", you'll have a two-page answer instead of a shrug.