Three-statement Excel model · 22 quarters and 5 fiscal years of history · 10 quarters and 5 fiscal years of projections
About the COIN model
This three-statement Excel model covers Coinbase Global, Inc. (COIN): its income statement, balance sheet and cash flow statement. It holds 22 quarters and 5 fiscal years of history and 10 quarters and 5 fiscal years of projections.
Projected revenue is built from KPI drivers: QoQ-growth transaction lines (volume discontinued 2Q26) + QoQ-growth S&S components, across 9 segments.
Beyond the income statement, the workbook has these sections: KPI Drivers, Balance Sheet and Cash Flow Statement.
Model thesis: Transaction-revenue cycle trough (FY26E revenue -32%) + stablecoin/staking S&S compounding; buybacks fund the wait
On October 19, 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 October 19, 2026.
Income statement preview
Columns 2023–2025 are actual results and 2026E–2028E are our estimates. Figures were recalculated in Excel on October 19, 2026. Dollars in millions, except per share.
| Income Statement | ||||||
|---|---|---|---|---|---|---|
| Actual | Estimate | |||||
| 2023 | 2024 | 2025 | 2026E | 2027E | 2028E | |
| Consumer transaction revenue, net | $1,334.0 | $3,430.3 | $3,322.8 | $1,787.5 | $2,359.8 | $2,925.3 |
| Institutional transaction revenue, net | 90.2 | 345.6 | 479.7 | 422.9 | 545.4 | 700.3 |
| Other transaction revenue, net (2023+) | 95.5 | 210.2 | 252.9 | 186.1 | 211.6 | 245.5 |
| Total Transaction Revenue | $1,519.7 | $3,986.1 | $4,055.4 | $2,396.5 | $3,116.9 | $3,871.1 |
| Stablecoin revenue (2023+ presentation) | $694.2 | $910.5 | $1,348.8 | $1,193.6 | $1,296.9 | $1,441.8 |
| Blockchain rewards | 330.9 | 705.8 | 677.4 | 342.1 | 374.8 | 433.8 |
| Custodial fee revenue | 69.5 | 0.0 | 0.0 | 0.0 | ||
| Earn campaign revenue (2021 only; folded 2022) | 0.0 | 0.0 | 0.0 | |||
| Interest income | 0.0 | 0.0 | 0.0 | |||
| Interest and finance fee income (2023+) | 186.7 | 265.8 | 247.0 | 263.5 | 281.9 | 309.6 |
| Other subscription and services revenue | 125.6 | 425.1 | 554.8 | 437.1 | 501.0 | 579.9 |
| Total Subscription & Services Revenue | $1,406.9 | $2,307.1 | $2,828.0 | $2,236.3 | $2,454.7 | $2,765.1 |
| Net Revenue | $2,926.5 | $6,293.2 | $6,883.4 | $4,632.9 | $5,571.6 | $6,636.2 |
| Crypto asset sales revenue (2021-2022) | $0.0 | $0.0 | $0.0 | |||
| Corporate interest and other income | 181.8 | 270.8 | 297.9 | 267.0 | 248.2 | 247.6 |
| Total Other Revenue | $181.8 | $270.8 | $297.9 | $267.0 | $248.2 | $247.6 |
| Total Revenue | $3,108.4 | $6,564.0 | $7,181.3 | $4,899.9 | $5,819.8 | $6,883.8 |
| Less: Transaction expense | ($420.7) | ($897.7) | ($1,020.2) | ($710.1) | ($843.9) | ($998.2) |
| Less: Technology and development | (1,324.5) | (1,468.3) | (1,670.6) | (1,923.4) | (2,002.5) | (2,149.8) |
| Less: Sales and marketing | (332.3) | (654.4) | (1,058.6) | (1,071.1) | (1,283.8) | (1,424.4) |
| Less: General and administrative | (1,074.3) | (1,300.3) | (1,619.6) | (1,432.9) | (1,501.5) | (1,595.9) |
| Less: Losses (gains) on crypto held for operations (2024+) | 0.0 | 71.7 | (20.7) | (66.9) | 0.0 | 0.0 |
| Less: Crypto asset impairment, net (2023 presentation) | 34.7 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| Less: Restructuring | (142.6) | 0.0 | 0.0 | (52.4) | 0.0 | 0.0 |
| Less: Other operating expense, net | (10.3) | (7.9) | (356.1) | (24.9) | 0.0 | 0.0 |
| Total Operating Expenses | ($3,270.0) | ($4,256.9) | ($5,745.9) | ($5,281.7) | ($5,631.6) | ($6,168.2) |
| Operating Income (Loss) | ($161.7) | $2,307.2 | $1,435.4 | ($381.8) | $188.2 | $715.6 |
| EBITDA (OpInc + D&A) | ($22.0) | $2,434.7 | $1,623.9 | ($122.5) | $429.3 | $946.1 |
| Interest expense | ($82.8) | ($80.6) | ($85.4) | ($90.1) | ($90.1) | ($90.1) |
| Gains (losses) on crypto held for investment (2024+) | 0.0 | 687.1 | (528.9) | (691.9) | 0.0 | 0.0 |
| Other income (expense), net | 167.6 | 29.1 | 700.9 | 11.7 | 0.0 | 0.0 |
| Income (Loss) Before Income Taxes | ($76.8) | $2,942.6 | $1,522.1 | ($1,152.1) | $98.1 | $625.5 |
| Less: Provision for (Benefit from) Income Taxes | 171.7 | (363.6) | (261.7) | 164.9 | (19.6) | (125.1) |
| Net Income (Loss) | $94.9 | $2,579.1 | $1,260.3 | ($987.2) | $78.5 | $500.4 |
| NI Attributable to Common — Basic (numerator) | $94.8 | $2,577.8 | $1,260.3 | ($987.2) | $78.5 | $500.4 |
| NI Attributable to Common — Diluted (numerator) | 94.8 | 2,591.2 | 1,277.3 | (987.2) | 78.5 | 500.4 |
| Weighted Avg Shares — Basic (M) | 235.8 | 247.4 | 260.1 | 263.8 | 263.4 | 263.4 |
| Weighted Avg Shares — Diluted (M) | 254.4 | 273.4 | 287.2 | 263.8 | 263.4 | 263.4 |
| EPS — Basic | $0.40 | $10.42 | $4.85 | ($3.74) | $0.30 | $1.90 |
| EPS — Diluted | $0.37 | $9.48 | $4.45 | ($3.74) | $0.30 | $1.90 |
| Ratios & Assumptions | ||||||
| Operating Margin | (5.2%) | 35.1% | 20.0% | (7.8%) | 3.2% | 10.4% |
| Net Margin | 3.1% | 39.3% | 17.6% | (20.1%) | 1.3% | 7.3% |
| Effective Tax Rate [DRIVER] | 223.5% | 12.4% | 17.2% | 14.3% | 20.0% | 20.0% |
The full workbook adds 22 historical and 10 projected quarters, plus KPI Drivers · Balance Sheet · Cash Flow Statement — every subtotal a live formula, every projection traced to a driver.
Coinbase Global research
Aardvark Labs Capital Research has published 8 reports on Coinbase Global (COIN). The latest is the Q3 2026 Earnings Recap, published October 30, 2026, rated Outperform.
Revenue Held Flat While Market Volume Fell 10%, and the Hack-Day Sell-Off Hands Us the Entry: Upgrading to Outperform
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.