← All financial models

Alphabet (GOOGL) Financial Model

📊 Download Model

Three-statement Excel model · 23 quarters and 5 fiscal years of history · 9 quarters and 5 fiscal years of projections

current ✓ C13 recon ✓ C14 trace ✓ C15 terminals

About the GOOGL model

This three-statement Excel model covers Alphabet Inc. (GOOGL): its income statement, balance sheet and cash flow statement. It holds 23 quarters and 5 fiscal years of history and 9 quarters and 5 fiscal years of projections.

Projected revenue is built from KPI drivers: YoY growth % × filed revenue line (Search & other / YouTube ads / Network / Subscriptions, platforms & devices / Cloud / Other Bets); the six leaf lines sum to Total Revenues as filed, across 6 segments.

Beyond the income statement, the workbook has these sections: KPI Drivers, Balance Sheet, Cash Flow Statement and Segment KPIs (annual, reference only).

Model thesis: Cloud decelerates +103% 3Q26A to +22% FY30E on a $561B backlog; FY27 capex $300B keeps free cash flow negative through 2Q28E; equity marks are zero in every projected period, so projected EPS is operating EPS

On November 10, 2026, the model passed checks C13 (every subtotal reconciles to the reported figure at $0), C14 (every projected revenue cell traces to a KPI driver row) and C15 (each driver ends in a rate, a count or a historical anchor, never a typed-in projected dollar level). It was last updated November 10, 2026.

History
23 quarters and 5 fiscal years
Projections
9 quarters and 5 fiscal years
KPI
YoY growth % × filed revenue line (Search & other / YouTube ads / Network / Subscriptions, platforms & devices / Cloud / Other Bets); the six leaf lines sum to Total Revenues as filed
Segments
6
Units
Dollars in millions, except per share amounts
Verified
Updated
File
Excel workbook (.xlsx), 192 KB
Access
Free account required: 3 different models a month at no charge, then $9 a month.

Income statement preview

Columns FY23–FY25 are actual results and FY26E–FY28E are our estimates. Figures were recalculated in Excel on November 10, 2026. Dollars in millions, except per share amounts.

Income statement preview for GOOGL. Dollars in millions, except per share amounts. Actual fiscal years followed by our estimates.
Income Statement
ActualEstimate
FY23FY24FY25FY26EFY27EFY28E
Google Search & other$175,033$198,084$224,532$256,085$278,874$301,132
YouTube ads31,51036,14740,36744,49648,39552,321
Google Network31,31230,35929,79229,55729,29628,857
Google Advertising$237,855$264,590$294,691$330,137$356,566$382,310
Google Subscriptions, Platforms, and Devices34,68840,34048,03054,65760,94267,326
Google Services$272,543$304,930$342,721$384,794$417,508$449,636
Google Cloud33,08843,22958,705111,010184,619254,004
Other Bets1,5271,6481,5371,5651,7211,928
Hedging Gains (Losses)236211(127)12000
Total Revenues$307,394$350,018$402,836$497,488$603,849$705,567
Less: Cost of Revenues(133,332)(146,306)(162,535)(196,684)(248,707)(293,551)
Gross Profit$174,062$203,712$240,301$300,805$355,141$412,017
Less: Research and Development($45,427)($49,326)($61,087)($78,887)($96,896)($111,810)
Less: Sales and Marketing(27,917)(27,808)(28,693)(34,909)(42,148)(48,538)
Less: General and Administrative(16,425)(14,188)(21,482)(23,621)(28,246)(33,002)
Total Operating Expenses($89,769)($91,322)($111,262)($137,416)($167,291)($193,350)
Total Costs and Expenses($223,101)($237,628)($273,797)($334,100)($415,998)($486,901)
Income from Operations$84,293$112,390$129,039$163,388$187,851$218,667
Interest Income3,8654,4824,3376,4537,4907,548
Interest Expense(308)(268)(736)(4,217)(8,313)(11,799)
Foreign Currency Exchange Gain (Loss), net(1,238)(409)(382)700
Gain (Loss) on Debt Securities, net(1,215)(1,043)540(526)00
Gain (Loss) on Equity Securities, net3923,71424,080127,28200
Income (Loss) from Equity Method Investments, net(628)(188)281(118)00
Other5561,1371,667(968)00
Other Income (Expense), net$1,424$7,425$29,787$127,914($823)($4,250)
Income Before Income Taxes$85,717$119,815$158,826$291,302$187,028$214,416
Less: Provision for Income Taxes($11,922)($19,697)($26,656)($54,554)($31,795)($36,451)
Net Income$73,795$100,118$132,170$236,748$155,233$177,965
Less: Preferred Stock Dividends$0$0$0($682)($1,192)($1,192)
Net Income Available to Common Stockholders$73,795$100,118$132,170$236,066$154,041$176,773
Ratios & Assumptions
YoY Total Revenues Growth8.7%13.9%15.1%23.5%21.4%16.8%
Gross Margin56.6%58.2%59.7%60.5%58.8%58.4%
Incremental Gross Margin71.0%69.6%69.3%63.9%51.1%55.9%
Operating Margin27.4%32.1%32.0%32.8%31.1%31.0%
Net Margin24.0%28.6%32.8%47.6%25.7%25.2%

The full workbook adds 23 historical and 9 projected quarters, plus KPI Drivers · Balance Sheet · Cash Flow Statement · Segment KPIs (annual, reference only) — every subtotal a live formula, every projection traced to a driver.

Download the full GOOGL model (xlsx)3 free models a month with an account, then $9 a month

Alphabet research

Aardvark Labs Capital Research has published 8 reports on Alphabet (GOOGL). The latest is the Q3 2026 Earnings Recap, published October 29, 2026, rated Outperform.

Cloud Doubles to $30.7B While Search Slows to 12%: The Sell-Off Prices the Cash Burn, Not the Franchise

All GOOGL research →

Methodology

Every projected revenue cell traces to a KPI/driver row (C14). Terminal driver cells are rates, counts, or historical anchors — never typed-in projected dollar levels (C15). Every subtotal-vs-reported reconciliation row ties to $0 (C13). Each model is written per-ticker against its actual schema — no cloning, no level-input shortcuts.