A free DCF template that shows how much of the answer is the terminal value
Ten years of discounted cash flow, the terminal value by perpetuity growth and by exit multiple, the multiple and growth each one implies, a sensitivity grid and a market cross-check.
In the worked case, ten years of forecast cash flow are worth $171.5 million. The terminal value adds $196.2 million. The part that takes all the modelling effort is 46.6% of the answer; the one assumption about the long term is 53.4%. This template makes that split visible, and puts the two ways of computing a terminal value side by side so each one disciplines the other.
Get the template
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.
Income_Approach_and_Terminal_Value.xlsx (19 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
Need the full deal structure? The LBO Model, Pro Edition adds four debt tranches, covenants, a management ratchet and 31 checks, with no circular reference and no macros. $99 → · Watch the 60-second preview
The book behind this model
This file is one worked case from The Private Markets Valuation Specialist. The book explains every assumption, every sheet and the decision the numbers support, chapter by chapter.
The Financial Model Library: all 130 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).
LBO Model, Pro Edition: seven-year buyout model with four debt tranches, covenants, a management ratchet, 31 checks, a blank copy and an 18-page guide. $99 → · See what is inside · Watch the 5-minute demo
This free file stays free. Secure checkout by Stripe.
Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →
The two terminal values, confronted
Perpetuity growth
Exit multiple
Assumption
growth 1.8%, discount rate 8.5%
14x final-year cash flow
Terminal value at year 10
$443.5m
$408.7m
Present value
$196.2m
$180.8m
What it implies
an exit multiple of 15.19x
long-term growth of 1.27%
This is the check most models skip. A growth rate of 1.8% sounds modest; it is the same statement as paying 15.2 times cash flow in year ten.
An exit multiple of 14 sounds like a market price; it is the same statement as 1.27% growth forever. If either implied number is one you would not have typed, the input that produced it is wrong.
What is in the file
1. Assumptions
Year-one cash flow, growth in the forecast, the discount rate, long-term growth, the exit multiple, and a comparable multiple for the cross-check.
2. Cash flow and discounting
Ten years, the discount factors, and the present value of the explicit forecast.
3. Terminal value
Both methods, the multiple and growth each one implies, the gap between them, and the terminal value as a share of total value.
4. Sensitivity
The terminal value share across five discount rates and five growth rates. On the base grid it runs from 46.1% to 62.3%.
5. Cross-check
The income answer against a market multiple: $367.7 million against $360 million, 2.1% apart.
6. Checks
Nine controls that test the file and say PASS, EXPLAIN or AS WARNED.
One thing to try first
Set the exit multiple to twelve times on the Assumptions sheet. The check comparing the two methods turns from PASS to EXPLAIN, and the terminal value sheet shows why:
at that multiple the growth rate implied is far below the one typed next to it. That disagreement is the most useful output a DCF can give you.
What it leaves out on purpose: tax, a debt schedule, working capital and the mid-year convention. They matter, but they would make the file about modelling rather than about the terminal value.
Questions people ask about it
What is the Gordon growth terminal value?
The cash flow in the first year after the forecast, divided by the discount rate less the long-term growth rate. It values the business as a growing perpetuity from that point.
Which terminal value method is right?
Neither on its own. Compute both, read what each implies about the other, and investigate a wide gap before using either.
Why does the terminal value dominate?
Because the forecast covers ten years and the terminal value covers everything after. On long-lived assets it is normal for it to carry half the value or more, which is why it deserves more scrutiny than it gets.
Is it free and editable?
Yes. No macros, nothing locked or protected.
The rest of the files
This template is one of the companion files for The Private Markets Valuation Specialist: the full set adds
the market approach and calibration, the equity waterfall and bridge, credit marks across the cycle and the judgment calls workbook. Free, like this one.
LCR and NSFR calculatorLiquidity coverage and net stable funding built line by line, with encumbrance and six defensible readings.
Risk-weighted assets (RWA) calculatorStandardised against internal-model RWA, the mortgage loan split, CET1 ratios and the year the output floor binds.
Credit scorecard modelA points scorecard built from counts: bins, weight of evidence, information value and the leaking variable.
Price waterfall analysisList price to pocket price for one account and a whole company: nine leakages, ranked and added up.
This template comes from The Private Markets Valuation Specialist. The book is on Amazon.
If this book helped — or didn’t — a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The template stays free either way.