Data & spreadsheets · DCF Calculator
How Terminal Value Is Discounted Back and Added to the Forecast Period
· How it works
dcf valuation cash-flow
Terminal value is calculated as of the end of the forecast, not today, so it needs its own discounting step. This post shows which exponent to use, why models are often off by one year, and how the pieces add up.
A terminal value pasted into a model without discounting it — why this single mistake can double a valuation
Terminal value can be the largest number on a DCF page, which makes forgetting its second step especially damaging. The perpetuity formula states a value at the forecast horizon, not today. Adding that future lump directly to present-valued forecast rows mixes dates in one total and can inflate the model far more than any rounding difference.
Where terminal value sits on the timeline — why the perpetuity formula gives a value as of the final forecast year, not as of today
At the end of year N, the model has finished its explicit forecast and stands one period before the first perpetuity cash flow. Gordon growth uses year N plus one cash flow in its numerator, but the resulting terminal value is located at the end of year N. Those two labels describe cash-flow timing and valuation timing, not two discount periods.
Choosing the exponent — discounting by (1+r)^N using the final forecast year, and the off-by-one confusion between year N and year N+1 cash flows
Under the engine’s end-of-year convention, terminal value is divided by one plus the discount rate raised to N. Using N plus one discounts it twice for the step from year N to year N plus one, even though the Gordon numerator already represents that next cash flow. The tests assert exponent ten for a ten-year horizon precisely to catch this off-by-one error.
Present value of the explicit forecast — summing the discounted yearly cash flows before the terminal piece is added
The explicit side is calculated separately. Each forecast cash flow is divided by its own factor, starting with exponent one, and those present values are summed. Only after that sum exists is the discounted terminal amount added. The result is enterprise value because the engine’s cash flows are unlevered and belong to all capital providers.
Worked example — a five-year forecast whose terminal value is computed, discounted at the correct exponent and added, with the wrong exponent shown alongside
With five hypothetical year-end cash flows of 100, a 10% rate and 2.5% terminal growth, explicit present value is 379.08. Terminal value at year five is 1,366.67 and its present value is 848.59, producing 1,227.67 in total. Using exponent six gives 771.45 instead, understating the same terminal claim by 77.14.
Reading the split — expressing terminal value as a share of the total and why that share is worth noting
The terminal share in that example is about 69.1% of enterprise value. That ratio is not a pass or fail mark, but it reveals where the model’s weight sits. ToolAcre returns this fraction directly, and its interface calls attention to heavy dependence rather than allowing the terminal amount to disappear inside one headline total.
What this does not cover — mid-year conventions, exit-multiple methods and any judgement about whether a growth assumption is reasonable
This example uses end-of-year timing and perpetuity growth. The shipped tool also supports mid-year exponents and an exit-multiple terminal method; both change the calculation and must be compared on like terms. It does not judge whether 2.5% or any other terminal assumption is reasonable for a real business.
Terminal value is just another cash flow that needs discounting — how the ToolAcre DCF Calculator lets you check the step against your own hand calculation
Treat terminal value as another dated cash flow: locate it first, then discount it to the valuation date. ToolAcre exposes final-year cash flow, next-year cash flow, exponent, factor and present value, so the arithmetic can be reconstructed. That transparency checks mechanics, not the truth of the forecast.