Terminal Value: The Part of a DCF That Does Most of the Work

A hypothetical company’s model has five forecast columns, one per year, and then a sixth cell off to the right labeled TV. The five columns hold the careful work. The sixth cell holds one line of arithmetic. That one cell usually decides the answer.

Working the formula on a hypothetical model

Say year five of the forecast ends with free cash flow of $150,000,000. You assume the business grows 3% a year forever after that, and you discount at 9%. The formula grows year five’s cash flow by one year, then divides by the gap between the discount rate and the growth rate.

Three quarters of the value comes from years nobody forecast. That is normal for a DCF.

The forecast years are the part you can argue about line by line, with a filing open next to the model, while the terminal value rests on two assumptions that cannot be checked against anything a company has reported: how fast the business grows after the forecast ends, and what return you demand for holding it. The DCF lesson in the valuation course builds the forecast columns step by step.

One point of growth

Change the growth rate from 3% to 4% and leave everything else alone. Cash flow in year six becomes 150,000,000 x 1.04 = 156,000,000. The rate gap narrows to 0.05.

One percentage point added about $354,000,000 to the total. The operating forecast did not change at all.

That sensitivity comes from the denominator. As growth creeps toward the discount rate, the gap shrinks and the answer climbs fast, which is why a model that looks conservative on margins can still be aggressive in its last cell.

How it shows up in a valuation model

Most spreadsheet models put the terminal value in its own row below the forecast, with the growth rate and the discount rate as input cells nearby, although some models use an exit multiple in its place and apply a price-to-cash-flow or enterprise-value multiple to the final year’s figure. Either way, look for the discounted terminal value as a share of the total. Many models print it. If yours does not, divide one by the other yourself.

A sensitivity table is the other thing to look for: a grid with growth rates across the top and discount rates down the side. Read the corners. If the value per share doubles between one corner and the other, the model is telling you how little it knows.

What people get wrong

The most common mistake is treating the growth input as a forecast for the next few years. It applies forever. A company growing 15% today can still deserve 3% in the terminal value, because the formula describes the business long after the current run has faded.

Growth must stay below the discount rate. At equal rates the formula divides by zero. Above it, the answer goes negative, which no one should accept from a spreadsheet.

People also forget to discount the terminal value back to today. The $2,575,000,000 figure sits at the end of year five. Adding it to present values without dividing by 1.538624 overstates the total by roughly $900,000,000 in the example, and the error hides easily because the undiscounted number looks plausible.

The terminal value also inherits year five’s flaws. If that year has unusually low capital spending or a one-time working capital release, the whole perpetuity carries it.

Related terms

Running the formula backward is often more useful: start from the market price and solve for the growth rate it implies, which is the case made in run a reverse DCF before you build the forward one. Earnings yield gives a quick cross-check. With growth set to zero, the formula collapses to cash flow divided by the discount rate, so a stock priced that way has a yield equal to the return you demanded. More valuation terms sit in the investing hub.