DCF calculator

Enter the latest free cash flow, a growth rate for a number of years, a lower terminal growth rate, a discount rate, net debt and shares. The calculator discounts each year's cash flow to today and gives a value per share, the table behind it, and a grid showing how far the answer moves with the discount and growth rates.

Calculator

Intrinsic value a share
$24.07
on these assumptions
Value of the business
$14,035M
present value of the cash flows
Equity value
$12,035M
after net debt
From after the growth years
39%
of the value of the business
Range in the grid below
$14.72 – $39.74
discount ±2 points, growth ±4

How much the answer moves

Intrinsic value per share by growth rate (rows) and discount rate (columns)
Growth \ discount9%10%11%12%13%
4%$21.34$19.38$17.64$16.09$14.72
6%$25.00$22.68$20.63$18.81$17.18
8%$29.23$26.49$24.07$21.92$20.01
10%$34.12$30.88$28.03$25.50$23.26
12%$39.74$35.93$32.58$29.61$26.98

The center cell is your inputs; along a row the discount rate changes, down a column the growth rate. Here one point more on the discount rate changes the value by −9%, and two points less growth by −14%. Small changes in assumptions move the answer a lot: treat it as a range, not a price.

Year by year (millions)

Projected free cash flow and its present value
YearStageFree cash flowDiscount factorPresent value
1growth 8%$1,0800.9009$973
2growth 8%$1,1660.8116$947
3growth 8%$1,2600.7312$921
4growth 8%$1,3600.6587$896
5growth 8%$1,4690.5935$872
6growth 8%$1,5870.5346$848
7growth 8%$1,7140.4817$825
8growth 8%$1,8510.4339$803
9growth 8%$1,9990.3909$781
10growth 8%$2,1590.3522$760
11terminal 4%$2,2450.3173$712
12terminal 4%$2,3350.2858$667
13terminal 4%$2,4280.2575$625
14terminal 4%$2,5260.2320$586
15terminal 4%$2,6270.2090$549
16terminal 4%$2,7320.1883$514
17terminal 4%$2,8410.1696$482
18terminal 4%$2,9550.1528$452
19terminal 4%$3,0730.1377$423
20terminal 4%$3,1960.1240$396
Total$14,035

How it is calculated

Two stages

Free cash flow grows at your growth rate for the growth years, then at the terminal rate. By default the terminal stage runs for a set number of further years and nothing is counted after that — the same model as the valuation section of the site's stock pages. The alternative is a perpetuity: a terminal value of next year's cash flow ÷ (discount rate − terminal growth), which needs a discount rate above the terminal growth rate and usually gives a higher answer.

From the business to a share

The present values add up to the value of the business. Net debt (debt minus cash) is subtracted to leave the value of the shares, divided by the shares outstanding.

How sensitive it is

Very. One point on the discount rate or two on the growth rate can move the answer by a tenth or more, and much of the value usually comes from the years after the growth stage. The grid shows the range; read the result as a range, not a price.

Filling in from a ticker

A ticker fills in trailing free cash flow, debt minus cash and shares outstanding from the site's fundamentals, in millions — only when the company reports in the currency its shares trade in. Growth and discount rates are always yours to choose.

The formula

FCF_t = FCF_0 × (1 + g)^t for t ≤ N, then × (1 + g_T) a year
PV = Σ FCF_t ÷ (1 + r)^t
perpetuity: TV = FCF_N × (1 + g_T) ÷ (r − g_T), discounted ÷ (1 + r)^N
value per share = (PV − net debt) ÷ shares

The default inputs, worked through

$1,000 million of free cash flow grows 8% a year for 10 years, then 4% a year for 10 more, discounted at 11%. The 20 years are worth $14,035 million today, 39% of it from the last ten. Less $2,000 million of net debt leaves $12,035 million for 500 million shares: $24.07 a share.

Moving the discount rate between 9% and 13% and growth between 4% and 12% gives anything from $14.72 to $39.74 a share.

Questions and answers

What is a discounted cash flow valuation?

Estimating what a business is worth today as the sum of the cash it will produce, each year's amount reduced for how far away it is at the return you require.

What discount rate should I use?

The yearly return you require for the risk. Many analysts use the company's cost of capital, often between 8% and 12% for a large US company. A higher rate gives a lower value.

Why does the answer change so much?

Most of the value lies years ahead, and small changes in growth or the discount rate compound over every one of those years. That is why the grid is shown.

Why is this different from the stock page's estimate?

The stock page uses per-share earnings or free cash flow, 10 years of growth and 10 at 4%, and ignores debt and cash. This calculator works on the whole company and subtracts net debt; with net debt at zero and the same inputs, the two agree.

What if free cash flow is negative?

Then this method gives no value: there is no positive cash flow to discount. Use another approach, or a normal year's figure if the latest one is unusual.

Sources

Updated . Results are arithmetic on the figures you enter, not advice.

Cite this page

Funkfolio, “DCF calculator: intrinsic value per share”. https://funkfolio.com/tools/dcf-calculator