Calculator

DCF calculator

A discounted cash flow model turns a stream of projected free cash flows into one present value. The answer depends entirely on the inputs: it is the value these assumptions imply, not a fact about the company. The sensitivity table shows how far it moves when two of them change.

Inputs

Fills free cash flow, shares, net cash and price from DeltaScreener's latest data (needs JavaScript). Everything else is your assumption.
Operating cash flow minus capital expenditure.
0 for a single stage.
Your required annual return.
Growth after the forecast, forever. Must be below the discount rate.
Cash minus debt. Negative for net debt.
Only used to show the gap to the model value.

Result

Model value per share under these inputs$51.03
Equity value$25.52B
Terminal value share of total58.2%

Present value of 10 years of cash flow: $9.82B. Present value of the terminal value: $13.69B. Plus net cash of $2.00B, divided by 500.00M shares.

Sensitivity: model value per share

Model value per share for other discount rates and terminal growth rates
Terminal growth ↓ / Discount rate →7.00%8.00%9.00%10.00%11.00%
1.50%$64.29$54.38$47.15$41.64$37.32
2.00%$68.36$57.02$48.95$42.92$38.26
2.50%$73.33$60.14$51.03$44.38$39.31
3.00%$79.54$63.88$53.46$46.04$40.49
3.50%$87.53$68.45$56.33$47.95$41.83

Projected free cash flow

Projected free cash flow and present values
YearFCFDiscount factorPresent value
1$1.10B0.9174$1.01B
2$1.21B0.8417$1.02B
3$1.33B0.7722$1.03B
4$1.46B0.7084$1.04B
5$1.61B0.6499$1.05B
6$1.69B0.5963$1.01B
7$1.78B0.5470$971M
8$1.86B0.5019$936M
9$1.96B0.4604$901M
10$2.06B0.4224$868M
Terminal$32.41B0.4224$13.69B

Worked example

Free cash flow $100M, growing 10% a year for 2 years, discount rate 10%, terminal growth 2%, 10M shares, net cash $50M.

Year 1: FCF $110M, discounted ÷ 1.10 = $100M. Year 2: FCF $121M, discounted ÷ 1.21 = $100M. Sum: $200M.

Terminal value at the end of year 2: 121 × 1.02 ÷ (0.10 − 0.02) = $1,542.75M; discounted ÷ 1.21 = $1,275M.

Enterprise value $200M + $1,275M = $1,475M; plus $50M net cash = $1,525M equity; ÷ 10M shares = $152.50 model value per share under these inputs. Note that 86% of it comes from the terminal value.

How it is calculated

FCF(t) = FCF(t−1) × (1 + g1) for t ≤ n1, × (1 + g2) for n1 < t ≤ n1 + n2 PV(FCF) = Σ FCF(t) ÷ (1 + r)^t t = 1 … N, N = n1 + n2 TV = FCF(N) × (1 + gT) ÷ (r − gT) Gordon growth, requires r > gT PV(TV) = TV ÷ (1 + r)^N Equity = PV(FCF) + PV(TV) + net cash Value per share = Equity ÷ shares outstanding

Cash flows are discounted as if received at the end of each year. If the discount rate is not above the terminal growth rate the terminal value has no finite answer, and the calculator says so instead of printing a number; the same applies cell by cell in the sensitivity table.

Load from a ticker fills four inputs from DeltaScreener's stored data: trailing free cash flow, net cash as total cash minus total debt, the last price, and shares outstanding derived as market cap ÷ price. These come from the same providers as the rest of the site (see the methodology) and can lag the latest filing. Growth stages, discount rate and terminal growth are never pre-filled: they are the assumptions the model is about. Some issuers (ADRs in particular) report cash flow in a currency other than the share price's, which makes the per-share figure meaningless; check the reporting currency on the company's financials page (/stock/<ticker>/financials) first.

Other calculators

Questions about the data behind these tools: see the help centre and the data methodology.

Data for information only, not investment advice. Figures may be delayed or inaccurate; verify against company filings. See our disclaimer.