XYZ DCF calculator
Value Block on your own assumptions. It starts from the growth today's price assumes, with free cash flow, cash and shares from XYZ's SEC filings. Change any of them and see what the shares would be worth.
Revenue growth stands in for a free cash flow record too short or too often negative to measure growth from.
If free cash flow grows as set, buying at $73.31 would earn about 10.2% a year, exactly the 10.2% you asked for.
At that pace, $73.31 becomes about $118.98 in five years, counting the cash the business hands back or keeps.
Show the workings
What the value is made of
- Cash flows, years 1 to 10$19.0B
- Everything after year ten$18.6B
- Cash and short-term investments$6.4B
- All of it, over 0.60bn shares$44.0B
How much the answer moves
Value per share as the return you want and early growth change around your choice.
| Return ↓ · growth → | -6.8% | -1.8% | 3.2% | 8.2% | 13.2% |
|---|---|---|---|---|---|
| 8.2% | $64.68 | $78.71 | $95.71 | $116.13 | $140.49 |
| 9.2% | $56.89 | $68.63 | $82.82 | $99.85 | $120.13 |
| 10.2% | $51.13 | $61.18 | $73.31 | $87.83 | $105.11 |
| 11.2% | $46.69 | $55.45 | $66.00 | $78.61 | $93.58 |
| 12.2% | $43.16 | $50.90 | $60.20 | $71.30 | $84.46 |
Year by year
| Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
|---|---|---|---|---|---|---|---|---|---|---|
| Free cash flow | $2.8B | $2.9B | $2.9B | $3.0B | $3.1B | $3.2B | $3.3B | $3.4B | $3.6B | $3.7B |
| Worth today | $2.5B | $2.4B | $2.2B | $2.1B | $1.9B | $1.8B | $1.7B | $1.6B | $1.5B | $1.4B |
XYZ's figures are from its SEC filings; the price is the last close. The estimate is yours: it is not a price target, and it is not advice.
How this DCF works
- Free cash flow: operating cash flow less capital spending and the stock paid to staff (which dilutes every other shareholder): $2.7B over the last twelve months, after $1.2B of stock pay.
- Ten years of growth: one rate for years 1 to 5 and another for 6 to 10, then a steady rate forever.
- Discounting: each year's cash is worth less today at the discount rate. The starting rate is the 10-year Treasury yield (5.2%) plus 5 points.
- To value per share: add cash and short-term investments ($6.4B) and divide by the shares outstanding. Debt is not taken off again: free cash flow is already after the interest on it.
- What the price assumes: the growth at which this model gives back today's price. The XYZ report scores it against the free cash flow growth the company has delivered, slowed halfway toward the economy's growth, because ten more years at a past pace is rare.