Snowflake stock report · DCF calculator
SNOW DCF calculator
Value Snowflake on your own assumptions. It starts from a steady company, with free cash flow, cash and shares from SNOW's SEC filings. Change any of them and see what the shares would be worth.
On your assumptions
$59.28 a share82% below today's $328.12
If free cash flow grows as set, buying at $328.12 would earn about 3.8% a year, less than the 10.2% you asked for.
At that pace, $328.12 becomes about $395.37 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$9.2B
- Everything after year ten$9.4B
- Cash and short-term investments$2.3B
- All of it, over 0.35bn shares$20.9B
How much the answer moves
Value per share as the return you want and early growth change around your choice.
| Return ↓ · growth → | -5.0% | 0.0% | 5.0% | 10.0% | 15.0% |
|---|---|---|---|---|---|
| 8.2% | $52.48 | $64.27 | $78.51 | $95.58 | $115.90 |
| 9.2% | $45.73 | $55.58 | $67.44 | $81.65 | $98.53 |
| 10.2% | $40.75 | $49.16 | $59.28 | $71.37 | $85.73 |
| 11.2% | $36.91 | $44.22 | $53.01 | $63.49 | $75.92 |
| 12.2% | $33.86 | $40.31 | $48.04 | $57.26 | $68.16 |
Year by year
| Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
|---|---|---|---|---|---|---|---|---|---|---|
| Free cash flow | $1.3B | $1.3B | $1.4B | $1.5B | $1.5B | $1.6B | $1.6B | $1.7B | $1.8B | $1.9B |
| Worth today | $1.1B | $1.1B | $1.0B | $986M | $940M | $887M | $838M | $791M | $746M | $705M |
SNOW'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): $-427M over the last twelve months, after $1.6B 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 ($2.3B) 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 SNOW 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.