Alphabet Inc.: DCF model
A discounted-cash-flow model filled in from Alphabet 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 283.82 on Oct 30, 2026: Closing price the SEC publishes with its fails-to-deliver data (GOOGL).
Assumptions: Base case
Change any figure; the values follow at once.
Revenue and margins
From the filings10-K filed Feb 5, 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): 12.51% a year; the years after are your assumption.
The years between change on a straight line.
From the filingsAverage operating margin, FY2023–FY2025: 30.52%; the years ahead are your assumption.
Tax and reinvestment
From the filingsIncome tax over income before tax, FY2023–FY2025
Your assumptionNot on file: set equal to capital spending.
From the filingsAverage share of revenue, FY2023–FY2025
From the filingsAverage 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
From the filingsInterest expense of FY2025 over its average debt, held between the risk-free rate and 8 points above it
From the filingsDebt over debt plus market value on Oct 30, 2026
After the last year
Your assumptionImplies 7.6× the last year's EBITDA.
From value to shares (every case)
Balance sheet of Q3FY2026, Sep 30, 2026 · 10-Q filed Oct 29, 2026
From the filings
From the filings
From the filings
From the filings
Your assumption
From the filingsdiluted, weighted average, Q3FY2026 · 10-Q filed Oct 29, 2026
The three cases
Base case: value per share
Discount rate 9.95%; long-run growth 2.50%. Values as at the end of FY2025.
| Present value of the 5 projected years | USD 513.9 B |
|---|---|
| Present value after the last year71% of the business's value | USD 1.27 T |
| Enterprise value (the whole business) | USD 1.79 T |
| Less debt | USD 126.1 B |
| Plus cash and short-term investments | USD 265.1 B |
| Equity value (the shareholders') | USD 1.93 T |
| Divided by shares (millions) | 12,368 |
| Value per share | USD 155.83 |
Value per share
USD 155.83
45.1% below the price
Price USD 283.82 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 | 402,836 | 453,231 | 498,599 | 536,044 | 562,846 | 576,917 |
| Growth | 15.1% | 12.5% | 10.0% | 7.5% | 5.0% | 2.5% |
| Operating income (EBIT) | 129,039 | 138,326 | 152,172 | 163,601 | 171,781 | 176,075 |
| Operating margin | 32.0% | 30.5% | 30.5% | 30.5% | 30.5% | 30.5% |
| Tax on operating income | −22,118 | −24,332 | −26,160 | −27,468 | −28,154 | |
| Depreciation and amortisation | — | 72,834 | 80,125 | 86,142 | 90,449 | 92,711 |
| Capital spending | −91,447 | −72,834 | −80,125 | −86,142 | −90,449 | −92,711 |
| Change in working capital | 2,968 | 2,672 | 2,205 | 1,579 | 829 | |
| Free cash flow to the firm | 17,420 | 119,176 | 130,512 | 139,646 | 145,892 | 148,750 |
| Discount factor | 0.9095 | 0.8273 | 0.7524 | 0.6844 | 0.6224 | |
| Present value | 108,395 | 107,967 | 105,073 | 99,841 | 92,588 |
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.95% | 184 | 196 | 210 | 226 | 246 |
| 8.95% | 161 | 169 | 179 | 190 | 203 |
| 9.95% | 143 | 149 | 156 | 164 | 173 |
| 10.95% | 129 | 133 | 139 | 144 | 151 |
| 11.95% | 117 | 121 | 125 | 129 | 134 |
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 | 117 | 125 | 133 | 141 | 149 |
| −2 pt | 127 | 135 | 144 | 152 | 161 |
| ±0 pt | 137 | 146 | 156 | 165 | 175 |
| +2 pt | 148 | 159 | 169 | 179 | 189 |
| +4 pt | 160 | 172 | 183 | 194 | 205 |
Where the figures come from
The statements as reported, in millions of USD; hover a figure for its filing.
| USD millions | FY2025to Dec 31, 2025 | FY2024to Dec 31, 2024 | FY2023to Dec 31, 2023 | FY2022to Dec 31, 2022 | FY2021to Dec 31, 2021 | FY2020to Dec 31, 2020 |
|---|---|---|---|---|---|---|
| Revenue | 402,836 | 350,018 | 307,394 | 282,836 | 257,637 | 182,527 |
| Growth | 15.1% | 13.9% | 8.7% | 9.8% | 41.2% | — |
| Operating income | 129,039 | 112,390 | 84,293 | 74,842 | 78,714 | 41,224 |
| Operating margin | 32.0% | 32.1% | 27.4% | 26.5% | 30.6% | 22.6% |
| Effective tax rate | 16.8% | 16.4% | 13.9% | 15.9% | 16.2% | 16.2% |
| D&A, % of revenue | — | — | — | — | — | — |
| Capital spending, % of revenue | 22.7% | 15.0% | 10.5% | 11.1% | 9.6% | 12.2% |
| Working capital, % of revenue | -5.4% | -5.7% | -6.6% | -6.5% | -6.1% | -10.0% |
| Free cash flow to the firm | 17,420 | 41,248 | 42,251 | 33,949 | 38,848 | — |
| Filing | 10-K | 10-K | 10-K | 10-K | 10-K | 10-K |
- 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 Q3FY2026), and the share count (Q3FY2026).
- Market data: US Treasury daily par yield curve, 10-year (Nov 13, 2026); Market price USD 283.82 on Oct 30, 2026: Closing price the SEC publishes with its fails-to-deliver data (GOOGL).
- 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.