Module 5: Terminal Value, Present Value, and Sensitivity Analysis
Learning objectives and prerequisites
By the end of this lesson, you should be able to build a dated DCF and a sustainable terminal period. Prerequisite knowledge: Operating UFCF and discount rates. Work from assumptions to equations, explain the acquisition consequence, and record the evidence needed to rely on the answer.
Units: $000 unless a section explicitly states otherwise.
Learning objectives: Calculate two terminal-value approaches, discount dated cash flows, and interpret sensitivity rather than relying on a single valuation. Study time: 2 hours.
Terminal value requires a sustainable business
An explicit five-year forecast captures the transition to a stable business. Terminal value captures subsequent operating cash flows. It is not a premium added because the seller expects one. Before calculating it, normalize margins, replacement spending, taxes, working capital, and growth. A year with deferred maintenance or temporarily reduced staffing is a poor terminal starting point.
The perpetuity-growth method is:
Terminal UFCF = Year 5 normalized UFCF × (1 + g)
Terminal value at Year 5 = Terminal UFCF / (r - g)
Enterprise value = sum[UFCF_t / (1 + r)^t] + TV_5 / (1 + r)^5
Here r is the discount rate and g is perpetual growth. The equation requires r > g. A constant-growth formula assumes the growth rate can be financed by the reinvestment already reflected in terminal cash flow. Long-run growth cannot exceed economic capacity indefinitely.
The exit-multiple method applies a selected EV/EBITDA multiple to terminal EBITDA. It imports a market-pricing assumption. Keep the metric and period consistent: an EV/LTM EBITDA multiple belongs with a trailing metric at the modeled exit date. Do not average two methods mechanically; identify why they agree or differ.
Worked DCF
Assume annual year-end UFCF of 465, 490, 515, 540, and 565. Use r = 20% and g = 2%. All figures are illustrative.
| Year | UFCF | Discount factor | Present value |
|---|---|---|---|
| 1 | 465 | 0.8333 | 387.5 |
| 2 | 490 | 0.6944 | 340.3 |
| 3 | 515 | 0.5787 | 298.0 |
| 4 | 540 | 0.4823 | 260.4 |
| 5 | 565 | 0.4019 | 227.1 |
Terminal UFCF is 576.3; terminal value is 3,201.7; its present value is approximately 1,286.7. Explicit-period PV is approximately 1,513.3, giving EV of 2,800.0. Roughly 46% comes from terminal value. Rounding individual rows can change the final total slightly; calculate using full precision.
If terminal EBITDA is 950, the perpetuity implies a terminal EV/EBITDA multiple of about 3.37x. A 4.0x exit multiple instead gives terminal value 3,800 and total EV around 3,040.4. Ask what cash conversion, growth, or market conditions explain that difference.
Spreadsheet timing
For evenly spaced annual periods, Excel's NPV function discounts its first listed cash flow one period. Add a time-zero cash flow separately. For actual irregular dates use XNPV with consistent dates. A midyear convention can approximate cash received through the year, but apply it consistently and describe how terminal cash flows are timed. Do not silently combine midyear operating cash flows with an arbitrary terminal exponent.
Build a table crossing discount rates of 18%, 20%, and 22% with growth rates of 0%, 1%, and 2%. Then run an operating downside independently. A rate sensitivity alone will not show lost customers or a large equipment replacement.
Practice and answer key
A stable business generates next year's UFCF of 300. At r = 20% and g = 2%, what is terminal value at the preceding year-end? What if g becomes 0% and next-year cash remains 300?
Solution moved to the separate instructor key.
Deliverable: A DCF with timing labels, terminal-value percentage, implied exit multiple, and two-dimensional sensitivity table.
Rebuild the first terminal year
The common shortcut Year 5 UFCF × (1 + g) works only if Year 5 cash is already a sustainable base with compatible reinvestment. If explicit revenue grows 4% and perpetual revenue grows 2%, incremental working capital generally changes. The Harbor capstone deliberately forecasts a separate Year 6 to expose that distinction.
At the end of Year 5, Harbor revenue is about 6,083.2645 and NWC is 547.4938. Year 6 revenue at 2% growth is 6,204.9298, and NWC at 9% is 558.4437. Investment is only 10.9499. EBIT remains 14% of sales, giving NOPAT 651.5176. With D&A 124.0986 and CapEx 148.9183, UFCF is 615.7480. Use that cash in the perpetual formula rather than blindly growing Year 5 UFCF at 2%.
Understand the terminal-value fraction
A large terminal-value share means the model relies substantially on cash beyond the explicit forecast. That is normal for a continuing business but increases the importance of sustainable economics. It is not corrected by arbitrarily lengthening the explicit period while retaining equally unsupported assumptions.
At discount rate r and perpetual growth g, the denominator r − g shrinks as growth approaches the required return. A model can therefore explode numerically even when an economic premise is implausible. Add a hard check that r exceeds g and flag implausibly high terminal multiples. Never replace a negative terminal value with zero simply to hide invalid inputs.
Exit multiples are a different terminal argument
An exit multiple assumes a future buyer will pay a specified ratio for terminal earnings. It is not independent evidence if the multiple was chosen to reproduce the perpetuity result. Calculate the implied ratio from the perpetual model and explain differences in growth, reinvestment and cash conversion before averaging methods.
For a liquidation or declining business, a growing perpetuity may be inappropriate. A finite runoff, asset realizations and closure costs can be more meaningful. The analyst should select a framework consistent with the business rather than assume every acquired company exists in its current form forever.
Separate sensitivities from operating scenarios
A rate-growth grid holds operating assumptions fixed while varying valuation parameters. A customer-loss case changes revenue, margins and possibly collections. Both are useful, but only the second tests the actual mechanics of operational deterioration. Combining them can create a severe downside, provided the analyst explains overlapping expected-loss treatment.
Excel's two-input data tables are convenient but not essential. A formula-based grid can compute each terminal value directly from its row rate and column growth, using absolute references for operating forecasts and mixed references for headers. Such a grid is easier to inspect across spreadsheet applications. Check a corner cell manually before relying on its color formatting.
Treat timing as an economic assumption
An annual NPV formula usually assumes the first listed receipt comes one full period after valuation. Time-zero acquisition equity belongs outside that future cash-flow range or at exponent zero. A midyear approximation can be sensible for evenly collected operations, but not necessarily for a seasonal business with late collections. Actual dated XNPV/XIRR analysis is appropriate where irregular timing matters.
The lab should show year-end factors, cash PVs, terminal value at Year 5 and its separate discount factor. A terminal value discounted once too many can understate value materially; omitting discounting overstates it. A reviewer should see the timing in row labels rather than infer it from formulas.
Spreadsheet construction and audit lab
Create explicit dates and annual discount exponents. Forecast a separate first terminal year, including reinvestment at its own growth rate. Calculate terminal value at the final explicit date and discount it once.
Use named row labels and explicit units. Blue-font inputs should contain assumptions or source data; black-font formulas should calculate results from those inputs. Reproduce the worked example first, then change one economically important assumption and predict the direction of the result before recalculating. Save a base case and a dated challenge case rather than silently replacing assumptions. A zero arithmetic check does not establish an executable deal.
Learning summary and further reading
Build a dated DCF and a sustainable terminal period. The acquisition decision depends on the bridge between source evidence, modeled cash and the claim being valued. Explain what the model includes, what it omits, and which outstanding evidence could reverse your conclusion. Consult the source and alignment references for attributed public reading; fictional case assumptions are not market observations or legal approvals.
Previous module · Next module · Sources and CFI alignment
Independent assessment
Complete the student assignment before consulting the separate instructor key. The chapter's worked examples teach the method; the assignment uses independent inputs.