How this instrument works
A discounted cash flow model prices an asset by adding up everything it is expected to pay out, with each future dollar shrunk by how long you have to wait for it. This instrument runs five explicit years of projected cash flow through that shrinking factor, then adds a terminal value — one lump figure standing in for every dollar the asset produces after year five — discounted by that same fifth-year factor. The formula does not derive the cash flows or the terminal value; those come from a forecast you build elsewhere. It only tells you what a specific forecast is worth today at a specific discount rate.
Equity research analysts run this math to justify a price target on a stock; private equity associates run it to decide what to bid for a company before debt gets layered on top; corporate finance teams run it to compare a new factory or software rollout against the return the money could earn elsewhere. In each case the discount rate is the company's or project's weighted average cost of capital (WACC) — the blended return demanded by its lenders and its shareholders — not a rate picked to make the answer come out favorably, at least not defensibly.
The terminal value routinely does most of the work. In a normal five-year model with a reasonable WACC, the terminal value alone can account for sixty to eighty percent of the total NPV, because it stands in for an indefinite future rather than one year of cash flow — which means a DCF's answer usually says more about the assumption baked into that single terminal figure than about the five years of detailed forecasting sitting in front of it. Treat the explicit years as the visible, checkable part of the model and the terminal value as the part that deserves the most scrutiny.
- Enter the projected cash flow for each year in Year 1 cash flow, $ through Year 5 cash flow, $.
- Set Terminal value at end of year 5, $ to what the business or project is worth beyond year 5, however you arrived at that figure.
- Set Discount rate (WACC), % to the rate you want every cash flow and the terminal value discounted at.
- Read Net present value (DCF) — the sum of all five cash flows and the terminal value, each discounted back to today.
Worked example — five years of growth and a $200,000 exit
Project cash flow of $10,000 in year one, rising to $12,000, $14,000, $15,000, and $16,000 by year five, with a $200,000 terminal value assumed at the end of that fifth year, all discounted at a 10% WACC. Each year's cash flow is divided by 1.10 raised to that year's power — 1.10 for year one, 1.10 squared for year two, and on up to 1.10 to the fifth power for year five, which also divides the $16,000 plus the $200,000 terminal value together. Summing all five discounted pieces gives a net present value of $173,890.88.
Of that $173,890.88, the discounted terminal value alone contributes roughly $134,119 — about 77% of the total — even though it represents a single assumption about value beyond year five rather than five years of itemized forecasting. The five explicit years of cash flow, despite being the most closely modeled part of the sheet, add up to less than a quarter of what the business is deemed worth today, which is the pattern to expect from most real DCF models built this way.
Questions
Why does the terminal value matter more than the five years of cash flow?
Because it stands in for every dollar the business or project produces after year five, not just one year's worth. In the worked example above it is roughly 77% of the total NPV, on cash flow that is smaller for years one through five combined — a single assumption about the far future routinely outweighs several years of itemized, checkable forecasting, which is why it deserves more scrutiny than its one line in the sheet suggests.
How is this different from a plain present value calculation?
A plain present-value calculation discounts one future sum back by one factor. This instrument sums five separate cash flows, each discounted by its own year-specific factor, then adds a sixth piece — the terminal value — discounted by the fifth year's factor. The extra structure is what lets it price a stream of unequal payments plus everything beyond the forecast, instead of a single lump sum.
Where does the discount rate (WACC) in this sheet come from?
It is not computed here — you supply it. WACC blends the return a company's shareholders require, often estimated with CAPM, with the after-tax cost of its debt, weighted by how much of each the company actually uses to fund itself. This instrument takes that blended rate as a given input and applies it to every cash flow and the terminal value alike.
How is the terminal value itself usually calculated before I enter it here?
Two methods dominate. The perpetuity-growth method divides year six's expected cash flow by WACC minus an assumed long-run growth rate; the exit-multiple method applies a market multiple, such as enterprise value to EBITDA, to a year-five financial metric. Both produce a single dollar figure for Terminal value at end of year 5, $ — this sheet discounts whichever figure you hand it without checking how it was built.
What's the most common mistake analysts make running a DCF like this?
Spending most of the effort forecasting years one through five to the dollar while treating the discount rate and terminal-value assumption as afterthoughts. Because the terminal value typically dominates the total, and NPV is sensitive to small changes in WACC compounded over five years, a rough WACC or growth guess usually moves the answer more than a careful year-by-year cash flow forecast does.
Does a positive NPV mean the investment is worth making?
Not by itself. A positive figure means the projected cash flows and terminal value, at the WACC you entered, are worth more today than zero — it says nothing about how confident those projections are, what could go wrong operationally, or whether better uses exist for the same capital. This instrument does the discounting arithmetic; the judgment about the forecast and the decision stay with you.
References
- NYU Stern (Damodaran) — discounted cash flow and cost of capital resources
- U.S. SEC Investor.gov — investing basics and valuation glossary
- Federal Reserve — Selected Interest Rates (H.15), Treasury yields
Read this first: This instrument shows arithmetic, not advice. Real offers add fees, taxes and terms that vary by lender and place — verify the figures against your actual paperwork before deciding anything.