Data & spreadsheets · DCF Calculator
Why Terminal Value Dominates Most DCF Results and What That Means for You
· Why it matters
dcf valuation cash-flow
In many DCF models the years you did not forecast are worth more than the years you did. This post explains why that happens, what it says about the reliability of the result, and how to report it honestly.
Five years of careful forecasting, and most of the value comes from one formula — why that surprises people the first time
A modeller may spend most of the workbook on five forecast years and still find that one terminal formula supplies most of enterprise value. That is not hidden in ToolAcre: the engine returns present value of forecast, present value of terminal and their ratio. The surprise is a reason to inspect assumptions, not to delete the tail.
Why the tail is so heavy — perpetuity maths concentrating value in the far future, especially for growing businesses
A perpetuity represents every cash flow after the explicit horizon, so it naturally covers more years than the detailed forecast. Growth makes those later claims larger, while discounting makes them smaller. The balance between those effects is controlled by the narrow r minus g denominator and the horizon at which the steady-state formula begins.
What a high terminal share tells you — that the result rests on the discount rate and the growth rate more than on the forecast
A high terminal share means the headline result responds heavily to the discount rate, terminal growth and steady-state cash flow. It does not prove the model is unusable, and a low share does not prove the explicit forecast is credible. The ratio identifies where the model’s dependence sits; it cannot certify the assumptions on either side.
Worked example — the same forecast with a five-year and a ten-year explicit period, showing how the terminal share shifts
With constant hypothetical FCF of 100, a 10% rate and 2.5% terminal growth, a five-year horizon gives explicit present value 379.08, terminal present value 848.59 and a 69.1% terminal share. Extending the same flat path to ten years gives 614.46 explicit, 526.91 terminal and a 46.2% share.
Reporting the split — why stating terminal value as a share of total value is a mark of an honest model
Report both amounts and the ratio rather than only enterprise value. This makes it clear whether a modelled change came from the period managers can discuss year by year or from the steady-state tail. ToolAcre’s exports preserve the terminal and forecast split so another reviewer can reconstruct it without relying on formatted summary cards.
Ways to reduce dependence — longer explicit forecasts and fading growth, and the extra assumptions they require
A longer explicit forecast can move value from the terminal bucket into detailed rows, but it also demands more annual assumptions. Fading growth toward a stable rate can make the handoff more coherent, yet every fade step is still a judgement. More rows are not automatically more evidence and can create false precision beyond the period anyone can support.
What this does not cover — model structure only, not whether any specific company deserves a high or low growth rate
This comparison explains model structure only. It does not state what horizon, growth or terminal share a particular business deserves, and it does not repeat an industry benchmark because none is established by the repository. The calculator’s interface warning above a large share is a prompt to investigate, not a recommendation.
Know where your value comes from — how running the ToolAcre DCF Calculator with different horizons and growth rates shows how much the result rests on the tail
Know whether value comes from the forecast or the tail before discussing the total. Change one assumption at a time, retain the same economic story across horizons and disclose the resulting split. Because a DCF is entirely conditional on its inputs, moving the terminal boundary changes presentation and assumptions, not an underlying correct value.