Snowflake Inc.: DCF model
A discounted-cash-flow model filled in from Snowflake Inc.'s filings as reported. Change any assumption; the values follow at once.
A tool for your own analysis, not investment advice. It does arithmetic on the figures the company filed and on assumptions you choose; it does not forecast, and the result is only as good as those assumptions. Every formula is on the methodology page.
Market price USD 330.27 on Oct 30, 2026: Closing price the SEC publishes with its fails-to-deliver data (SNOW).
Assumptions: Base case
Change any figure; the values follow at once.
Revenue and margins
From the filings10-K filed Mar 20, 2026
The years between change on a straight line.
From the filingsThe first year starts at Revenue growth a year from FY2022 to FY2025 (3 years), held within -10% to 25%: 31.38% a year; the years after are your assumption.
The years between change on a straight line.
From the filingsAverage operating margin, FY2023–FY2025: -36.60%; the years ahead are your assumption.
Tax and reinvestment
Your assumptionThe effective rate cannot be worked out (losses or no tax line): 25% to start with.
From the filingsAverage share of revenue, FY2023–FY2025
From the filingsAverage share of revenue, FY2023–FY2025
Your figureAverage operating working capital (current assets less cash and short-term investments, less current liabilities other than debt) as a share of revenue, FY2023–FY2025
Discount rate
Your assumption1.0 to start with
Your assumption5% to start with
Your assumptionNot on file: the risk-free rate plus 1.5 points.
From the filingsDebt over debt plus market value on Oct 30, 2026
After the last year
Your assumption2.5% to start with.
From value to shares (every case)
Balance sheet of Q2FY2026, Jul 31, 2026 · 10-Q filed Sep 4, 2026
From the filings
From the filings
From the filings
From the filings
Your assumption
From the filingsdiluted, weighted average, Q2FY2026 · 10-Q filed Sep 4, 2026
The three cases
Base case: value per share
Discount rate 9.92%; long-run growth 2.50%. Values as at the end of FY2025.
| Present value of the 5 projected years | −USD 7.9 B |
|---|---|
| Present value after the last year | −USD 24.5 B |
| Enterprise value (the whole business) | −USD 32.4 B |
| Less debt | USD 0 |
| Plus cash and short-term investments | USD 2.3 B |
| Equity value (the shareholders') | −USD 30.0 B |
| Divided by shares (millions) | 349.3 |
| Value per share | USD -85.99 |
Value per share
USD -85.99
Below zero: with these figures the debt is worth more than the business.
Price USD 330.27 on Oct 30, 2026
Base case: year by year
Millions of USD. The FY2025 column is as reported; the years after are projected. Tax, capital spending and working capital are signed as they add to (+) or take from (−) free cash flow.
| USD millions | FY2025reported | FY2026projected | FY2027projected | FY2028projected | FY2029projected | FY2030projected |
|---|---|---|---|---|---|---|
| Revenue | 4,684 | 5,855 | 6,990 | 7,951 | 8,597 | 8,812 |
| Growth | 29.2% | 25.0% | 19.4% | 13.8% | 8.1% | 2.5% |
| Operating income (EBIT) | −1,435 | −2,143 | −2,558 | −2,910 | −3,147 | −3,225 |
| Operating margin | -30.6% | -36.6% | -36.6% | -36.6% | -36.6% | -36.6% |
| Tax on operating income | −0 | −0 | −0 | −0 | −0 | |
| Depreciation and amortisation | 220 | 273 | 326 | 371 | 401 | 412 |
| Capital spending | −102 | −92 | −110 | −125 | −135 | −138 |
| Change in working capital | 585 | 567 | 481 | 323 | 107 | |
| Free cash flow to the firm | −677 | −1,376 | −1,774 | −2,183 | −2,557 | −2,845 |
| Discount factor | 0.9098 | 0.8276 | 0.7530 | 0.6850 | 0.6232 | |
| Present value | −1,252 | −1,468 | −1,644 | −1,751 | −1,773 |
Base case: sensitivity
How the value per share moves when one pair of figures changes and the rest stay as they are.
Discount rate and long-run growth
Value per share in USD; your figures in the outlined middle; green at or above the market price, red below it.
| Discount rate ↓ · Long-run growth → | 1.5% | 2.0% | 2.5% | 3.0% | 3.5% |
|---|---|---|---|---|---|
| 7.92% | -105.19 | -113.09 | -122.45 | -133.71 | -147.51 |
| 8.92% | -89.21 | -94.85 | -101.36 | -108.97 | -117.99 |
| 9.92% | -77.06 | -81.24 | -85.99 | -91.42 | -97.7 |
| 10.92% | -67.5 | -70.7 | -74.29 | -78.32 | -82.9 |
| 11.92% | -59.8 | -62.31 | -65.09 | -68.18 | -71.64 |
Revenue growth and operating margin
Value per share in USD; your figures in the outlined middle; green at or above the market price, red below it.
| Growth, every year ↓ · Margin, every year → | −4 pt | −2 pt | ±0 pt | +2 pt | +4 pt |
|---|---|---|---|---|---|
| −4 pt | -87.09 | -81.99 | -76.89 | -71.79 | -66.69 |
| −2 pt | -92.4 | -86.88 | -81.36 | -75.83 | -70.31 |
| ±0 pt | -97.94 | -91.96 | -85.99 | -80.01 | -74.04 |
| +2 pt | -103.7 | -97.24 | -90.78 | -84.32 | -77.86 |
| +4 pt | -109.69 | -102.72 | -95.74 | -88.77 | -81.79 |
Where the figures come from
The statements as reported, in millions of USD; hover a figure for its filing.
| USD millions | FY2025to Jan 31, 2026 | FY2024to Jan 31, 2025 | FY2023to Jan 31, 2024 | FY2022to Jan 31, 2023 | FY2021to Jan 31, 2022 | FY2020to Jan 31, 2021 |
|---|---|---|---|---|---|---|
| Revenue | 4,684 | 3,626 | 2,806 | 2,066 | 1,219 | 592 |
| Growth | 29.2% | 29.2% | 35.9% | 69.4% | 106.0% | — |
| Operating income | −1,435 | −1,456 | −1,095 | −842 | −715 | −544 |
| Operating margin | -30.6% | -40.2% | -39.0% | -40.8% | -58.6% | -91.9% |
| Effective tax rate | — | — | — | — | — | — |
| D&A, % of revenue | 4.7% | 5.0% | 4.3% | 3.1% | 1.8% | 1.7% |
| Capital spending, % of revenue | 2.2% | 1.3% | 1.3% | 1.2% | 1.3% | 5.9% |
| Working capital, % of revenue | -57.8% | -57.1% | -54.8% | -49.2% | -53.4% | -67.0% |
| Free cash flow to the firm | −677 | −789 | −488 | −438 | −456 | — |
| Filing | 10-K | 10-K | 10-K | 10-K | 10-K | 10-K |
- No debt is tagged on the balance sheet of Q2FY2026: debt starts at zero.
- From the filings: revenue, margins, tax rate, depreciation, capital spending and working capital (fiscal years above), debt, cash, leases and minority interests (balance sheet of Q2FY2026), and the share count (Q2FY2026).
- Market data: US Treasury daily par yield curve, 10-year (Nov 20, 2026); Market price USD 330.27 on Oct 30, 2026: Closing price the SEC publishes with its fails-to-deliver data (SNOW).
- Your assumptions: the growth path and margins ahead, beta, the equity risk premium, long-run growth or the exit multiple, and the weights of the cases. How each figure is worked out: methodology.