Alphabet [GOOGL]
Task 3 · investment-memo skill v1.4.0 · 2026-07-27 · spot $326.56
Model: Alphabet_Financial_Model_2026-07-27.xlsx. Every figure below was read back from the live workbook in
Excel; formulas were not trusted because openpyxl writes them without evaluating them.
Read Section 0 first. Alphabet's GAAP earnings are contaminated by mark-to-market on non-marketable equity securities to a degree that breaks conventional valuation. This section is not a caveat; it is a prerequisite.
Q2-2026 other income was a net gain of $98.0bn, "primarily the result of net unrealized gains on our equity securities" (8-K Ex-99.1). GAAP EPS was $9.11, up 294%, on operating income up 30%.
| Quarter | Operating income | GAAP net income | Gap |
|---|---|---|---|
| Q1-2025 | $30,606m | $34,540m | +$3.9bn |
| Q2-2025 | $31,271m | $28,196m | −$3.1bn |
| Q3-2025 | $31,228m | $34,979m | +$3.8bn |
| Q1-2026 | $39,696m | $62,578m | +$22.9bn |
| Q2-2026 | $40,770m | $112,193m | +$71.4bn |
Consequences, stated plainly: 1. Any headline P/E on GOOGL is meaningless. 2. Any earnings-surprise (SUE) or estimate-revision series — which the Factor Scorecard would normally use — inherits the distortion. This is disclosed in Section 4 rather than silently computed. 3. The published consensus of $14.22 (2026) / $14.68 (2027) is on a basis that includes some level of other income and is therefore not cleanly comparable to an operating EPS. The house model reports both, and the comparison in Section 3.2 is explicitly labelled as not like-for-like.
This memo therefore values Alphabet on operating income and unlevered cash flow. EV/EBIT is the primary multiple.
| Value | |
|---|---|
| Beta (regressed, 1-yr daily vs SPY — computed) | 1.42 |
| Risk-free | 4.69% |
| Equity risk premium | 5.0% |
| Cost of equity | 11.8% |
| After-tax cost of debt (4.80% coupon on the 2026 notes, taxed at 16.5%) | 4.01% |
| WACC | 11.6% |
| Terminal growth | 3.5% |
| Terminal value as % of EV | 82.2% |
| Enterprise value | $2,023,980m |
| Less debt $102,305m, less preferred $19,063m, plus cash $55,911m | |
| Equity value | $1,958,523m |
| DCF value per share | $157.95 |
| Upside to spot | −51.6% |
Sensitivity — and this is the point:
| WACC \ g | 2.5% | 3.0% | 3.5% | 4.0% | 4.5% |
|---|---|---|---|---|---|
| 9.0% | $221 | $238 | $258 | $283 | $312 |
| 9.5% | $201 | $216 | $232 | $252 | $276 |
| 10.0% | $184 | $196 | $210 | $226 | $246 |
| 10.5% | $169 | $179 | $191 | $205 | $221 |
| 11.0% | $156 | $165 | $175 | $186 | $200 |
| 11.6% | $144 | $152 | $158 | $170 | $182 |
$144 to $312 — a 2.2x range across defensible parameters. The DCF point estimate is not usable on this name, and pretending otherwise would be the most dishonest thing in this memo. Three compounding reasons: 1. Unlevered FCF is negative in FY2026E (−$40.1bn) and FY2027E (−$21.0bn), so almost all value sits beyond the explicit period. 2. 82.2% terminal-value weight. 3. The regressed beta of 1.42 — genuinely computed, genuinely what the stock has done, and inflated by large idiosyncratic moves including −7.1% on 23 July. A $4tn company with a 1.42 beta is itself a finding, but using it mechanically produces an 11.6% discount rate that few would apply to Alphabet's cash flows.
Reported DCF range: $160–$310, with no point estimate offered. The scenario table and EV/EBIT comps carry the weight.
| FY2023A | FY2024A | FY2025A | FY2026E | FY2027E | FY2029E | FY2032E | |
|---|---|---|---|---|---|---|---|
| Cash from operations | $101,746m | $125,299m | $164,713m | $186,366m | $260,685m | — | — |
| Capex | $32,251m | $52,535m | $91,447m | $200,000m | $255,000m | $285,000m | $298,000m |
| Free cash flow | $69,495m | $72,764m | $73,266m | −$13,634m | $5,685m | $116,230m | $297,375m |
The FY2026E working-capital line is calibrated to the H1-2026 actual CFO of $84,859m and labelled as such in the workbook — without that calibration the model would have produced a CFO ~$40bn above what Alphabet actually reported in the first half.
Alphabet is modelled as free-cash-flow negative for full-year 2026 and barely positive in 2027. H1-2026 actual FCF was $4,261m and Q2-2026 alone was −$5,855m. This is not a forecast; it is an extrapolation of a disclosed trajectory against guided capex.
Seeded on the 10-Q R64 disclosure: in-service technical infrastructure $247,177m, office/other $57,133m, and assets not yet in service $122,814m (from $78,592m at Dec-2025). The not-in-service pool is modelled as transferring into service explicitly.
| FY2025A | FY2026E | FY2027E | FY2029E | FY2032E | |
|---|---|---|---|---|---|
| Depreciation | $26,500m | $52,941m | $77,520m | $144,877m | $257,138m |
| y/y | — | +100% | +46% | — | — |
This is the mechanical reason the Street models 2027 EPS growth at +3.2%. The depreciation wave is in consensus, not missing from it.
| Company | Ticker | Price | Mkt cap ($bn) | EV ($bn) | FY+1 P/E | EV/Sales | EV/EBIT | Rev growth | Op margin |
|---|---|---|---|---|---|---|---|---|---|
| Alphabet | GOOGL | $326.56 | 4,020 | 4,085 | 23.0x | 8.1x | 24.6x | 24.0% | 33.1% |
| Microsoft | MSFT | $389.10 | 2,890 | 2,852 | 23.2x | 8.7x | 18.6x | 17.0% | 46.6% |
| Amazon | AMZN | $231.39 | 2,470 | 2,560 | 28.5x | 3.4x | 29.5x | 11.0% | 11.5% |
| Meta Platforms | META | $593.87 | 1,490 | 1,520 | 17.8x | 7.4x | 18.5x | 18.0% | 40.0% |
| Oracle | ORCL | $119.90 | 340 | 470 | 17.5x | 6.5x | 22.4x | 16.0% | 29.0% |
| NVIDIA | NVDA | $196.51 | 4,780 | 4,740 | 26.0x | 14.0x | 23.3x | 40.0% | 60.0% |
| Peer median (ex-GOOGL) | 23.2x | 7.4x | 22.4x | 17.0% | 34.5% |
Implied values: peer-median EV/EBIT × house FY2027E operating income, bridged to equity = $384.06. Peer-median P/E × house FY2027E operating EPS ($13.97) = $324.03.
Sourcing honesty: GOOGL and MSFT FY+1 P/E use sourced consensus. AMZN/META/ORCL/NVDA multiples are estimates, flagged as such. As with Microsoft, the comp set is the AI-capex cohort re-rating together — any relative conclusion is a sector-regime statement, not a stock-specific one.
| Source | Value | |
|---|---|---|
| Rating | Public aggregators, Jul-2026 | Buy — 61 Buy ratings |
| Consensus price target | ~$430, range $340–$515 (40.7% of mean — genuinely wide) | |
| 2026 EPS | $14.22 (revised up from $11.63 after Q2) | |
| 2027 EPS | $14.68 — +3.2% growth | |
| 2026 capex | Company guidance, raised at Q2 | $195–205bn (from $180–190bn) |
| 2027 capex | FactSet consensus | ~$257bn; management said only "increase significantly" |
| Recent moves | KeyBanc → $445 (Overweight); Wells Fargo → Overweight, $387 |
Alpha Vantage was NOT called (quota exhausted); consensus sourced from public aggregators per
references/consensus-bridge.md.
| House (operating basis) | Street (as published) | Comparison | |
|---|---|---|---|
| 2026E EPS | $11.92 | $14.22 | −16.2% — NOT like-for-like |
| 2027E EPS | $13.97 | $14.68 | −4.9% — NOT like-for-like |
| 2026→2027 EPS growth | +17.2% | +3.2% | Looks like a huge variant. It is an artifact. |
Why this is an artifact and not a variant, spelled out because it would be very easy to sell as one. The house series excludes unrealised equity marks in both years. The Street's 2026 base of $14.22 sits on a year containing $127.6bn of such marks in the first half alone; its 2027 estimate necessarily contains none, because nobody forecasts marks. So consensus growth of +3.2% is measured from an inflated base, and house growth of +17.2% from a clean one. Two different bases, not two different views.
Adjusting crudely for that, the house operating trajectory and the Street's implied operating trajectory are close. There is no demonstrable earnings variant on either 2026 or 2027.
The Street target of ~$430 is 31.7% above spot.
| Component | Street | House | Attribution |
|---|---|---|---|
| 2027E operating EPS | ~$14.0 (implied, adjusted) | $13.97 | ≈0% — no numbers gap |
| Implied 2027 exit multiple at target | ~30.7x | 24.0x (base scenario) | −22% — the entire gap is the multiple |
The gap is 100% multiple and ~0% numbers. The Street is paying ~30x forward operating earnings for a business whose free cash flow is negative this year; this memo's base case pays 24x. Neither is provably right.
The real risk to the house view if the Street is right: Cloud holds above 60% growth with a 36%+ margin,
2027 capex comes in at the low end, free cash flow inflects positive in 2027 rather than 2028, and the market
re-rates the whole capex programme from "cost" to "moat." That path is worth 30–50% from here. Given that Cloud
has now accelerated for two consecutive quarters and expanded margin for six, the bull case is a live
possibility, not a straw man — and this memo has no evidence against it, only an unwillingness to pay 30x
for it before the cash flow turns. That is scepticism, not a variant, and it is labelled as such per
references/trade-construction.md.
| Expiration | Days | ATM implied vol | vs realised |
|---|---|---|---|
| 29-Jul-2026 | 2 | 39.0% | 1.01x |
| 18-Sep-2026 | 53 | 31.6% | 0.81x the 38.8% 3-month realised |
| 15-Jan-2027 | 172 | 34.2% | 0.88x |
Realised: 31.4% (1-year), 38.8% (3-month). Alphabet's implied volatility sits BELOW its trailing realised volatility across the curve — because its catalyst passed on 22 July and the event premium has already collapsed. Skew is close to flat (Sep $325 put 31.2% vs $325 call 31.6%; Jan-27 $300 put 33.4% vs $350 call 33.4%). Options are, unusually, not expensive here. That materially changes the vehicle analysis relative to Microsoft, and it is the one genuinely actionable asymmetry between the two names.
Direction assessed for a long. All inputs computed from Alpaca SIP bars and EDGAR XBRL.
| Signal | Computed value | Read for a LONG | What this factor says |
|---|---|---|---|
| 12-1 momentum | +102.0% | Tailwind | Strong absolute momentum — though it did not clear this cycle's top-8% cutoff of +310.8%. |
| 52-week-high proximity | 81.2% of the $402.38 high | Mild headwind | Off the high, mostly from the 23-July gap. |
| 200-day trend filter | +0.8% above the 200-day | Neutral — and precariously so | The 23-July decline took the stock to the 200-day almost exactly. This is the pivot for Gate 6. |
| Earnings surprise / PEAD | Q2-26 revenue $119.8bn vs ~$116.8bn expected = +2.6% beat; Cloud +82% vs ~63% expected | Tailwind on the fundamental; the stock fell 7.1% | PEAD is inverted here. A beat that produces a 7% decline is the market repricing the cost of the growth, not the growth. Drift logic does not apply cleanly. |
| Estimate-revision direction | 2026 EPS revised UP $11.63 → $14.22; targets raised (KeyBanc $445) | Tailwind — but contaminated | The 2026 revision is substantially driven by equity marks (Section 0), so it is not a clean fundamental-revision signal. Flagged rather than counted. |
| Gross profitability | GP/Assets = 0.404 ($240,301m ÷ $595,281m) | Strong tailwind | Higher than Microsoft's 0.313 and firmly in the top decile of large caps. |
| Accruals | (NI − CFO)/Assets = −0.055 | Tailwind | Clean. Notable given the $29bn of 2025 equity marks in net income — cash flow still exceeded earnings by $32.5bn. |
| Asset growth | +32.2% y/y (and +55% in H1-2026 alone, to $922bn) | Strong headwind | The most negative factor reading on the name. Cooper/Gulen/Schill: high asset growth predicts poor returns, and this is among the largest asset expansions ever recorded at this scale. |
| Piotroski F-score | 6/9 | Neutral | Fails ΔROA (flat 22.2%), Δleverage (LTD/assets up sharply) and Δasset turnover (0.78 → 0.68). All three failures are the capex programme. |
| Short interest | Negligible; ~1.8 days to cover on a stale figure | Neutral | No crowding. |
| Realised vol / beta | 31.4% (1-yr), 38.8% (3-mo); beta 1.42 | — | Moderate-to-high tier for sizing. |
Synthesis — the factors split, and two readings are actively unreliable. Profitability (0.404) and accruals (−0.055) are excellent and momentum (+102%) is positive: on those three, GOOGL looks like a quality-momentum long. Against that, +32.2% asset growth is one of the most negative single factor readings available, and the trend filter is balanced on a knife-edge at +0.8%.
Two readings must be discounted rather than counted: the revision signal is contaminated by equity marks, and PEAD is inverted (a 2.6% revenue beat produced a 7.1% decline). Honesty requires saying that the two expectations-based factors, which would normally be the most decision-relevant, cannot be read on this name right now. That is not a bullish or bearish conclusion; it is a statement that two of the eleven instruments are broken.
references/regime-change-test.md)| Tier | Evidence | Assessment |
|---|---|---|
| 1 — Contractual | Cloud backlog / RPO $519.5bn, from $108.2bn a year earlier (4.8x); backlog cover 5.2 years of the current Cloud run-rate | PRESENT BUT UNDATED. Alphabet discloses no weighted-average duration and no 12-month conversion percentage — both of which Microsoft discloses. A floor you cannot date is a materially weaker floor. |
| 2 — Physical / technical | TPU v7 / Ironwood and Axion silicon; the sale of TPU systems into third-party datacenters, newly recognised in the segment accounting policy (Q2-2026 10-Q, first appearance verified against eight prior filings); Gemini processing 22bn API tokens per minute; $122.8bn of PP&E not yet in service | STRONG. Owning the accelerator, the model and the cloud is a genuine technical position that a competitor cannot replicate quickly. |
| 3 — Structural | Six consecutive quarters of Cloud operating-margin expansion (17.8% → 35.6%); Gemini Enterprise at ~90% of the Fortune 100; Gemini App 950m MAU | Supportive. The margin series is unusually strong evidence. |
| 4 — Narrative | "our differentiated, full stack approach to AI" | Colour. |
Verdict: the regime-change claim PASSES, primarily on Tier 2 rather than Tier 1 — the opposite balance to Microsoft. The technical/physical position is stronger; the contractual evidence is weaker because it is undisclosed, not because it is absent.
Because duration is undisclosed, the model assumes a 20% 12-month conversion rate — anchored on Microsoft's disclosed 25% and adjusted for Alphabet's larger cover — and this is labelled an estimate, not a source, in the workbook. The backlog is modelled at contracted terms through FY2029 and then allowed to decline ($660bn → $650bn → $630bn → $610bn), with no renewal at similar terms assumed.
The sensitivity of this assumption is the honest headline: at a 20% conversion, the backlog covers 98.7% of modelled 2026 Cloud revenue. That figure is almost tautological (5.2x cover × 20% ≈ 100%) and it means the answer to "how contracted is Alphabet's cloud growth?" is driven entirely by a parameter the company does not disclose. That is the finding.
| FY2026E | FY2029E | FY2032E | |
|---|---|---|---|
| Contracted share of Cloud revenue | 98.7% | 64.2% | 57.2% |
| Backlog cover (years of Cloud revenue) | 4.9x | 2.6x | 1.6x |
Declining, as Principle 4 requires.
| Value | Return | Probability | |
|---|---|---|---|
| Bear | $181.01 | −44.6% | 30% |
| Base | $335.20 | +2.6% | 48% |
| Bull | $494.15 | +51.3% | 22% |
The signature is WEAKER than Microsoft's, and the reason is instructive. The bear case is −44.6%, versus Microsoft's −35.2%, on a company with a larger nominal backlog. The backlog does truncate the left tail somewhat — but because its duration is undisclosed, it cannot be relied on to support a specific year, so the bear case is not floored the way Microsoft's is. A $519.5bn backlog with no disclosed duration provides less downside protection than a $627bn backlog with 25% disclosed as converting within twelve months. That is the practical value of disclosure, and it is scored against Alphabet here rather than glossed.
Base rate being overridden: essentially no company above $300bn of revenue has compounded >15% for five years. The model decays total growth from 24.3% (2026E) to 7.3% (2032E) rather than extrapolating. Two overrides are named: Cloud revenue through FY2029 (on the backlog) and the Cloud operating-margin path, which rests on six consecutive observed quarters of sequential expansion — strong evidence for the near years, assumption in the outer ones.
| Method | Value | vs spot $326.56 |
|---|---|---|
| DCF — range only, no point estimate | $160 – $310 | — |
| Peer-median EV/EBIT × FY2027E EBIT | $384.06 | +17.6% |
| Peer-median P/E × FY2027E operating EPS | $324.03 | −0.8% |
| Scenario range (bear–bull) | $181 – $494 | — |
| Probability-weighted value | $323.91 | −0.8% |
| Street consensus target (61 Buy ratings) | ~$430 | +31.7% |
The probability-weighted value is $323.91 against a spot of $326.56 — a 0.8% gap. Scenario-weighted expected return is −0.8% gross, −5.8% after the 4.7% cash hurdle and frictions.
The distribution is extraordinarily wide for a $4tn company — $181 to $494, a 2.7x spread — and that width is itself the most honest output of this analysis. It reflects a genuine, unresolvable-today disagreement about whether $457bn of two-year capital expenditure is a moat or a mistake.