Three-statement Excel model · 16 quarters and 5 fiscal years of history · 8 quarters and 5 fiscal years of projections
About the AMD model
This three-statement Excel model covers Advanced Micro Devices, Inc. (AMD): its income statement, balance sheet and cash flow statement. It holds 16 quarters and 5 fiscal years of history and 8 quarters and 5 fiscal years of projections.
Projected revenue is built from KPI drivers: Four segments (Data Center, Client, Gaming, Embedded), each on its own quarter-over-quarter growth rate; revenue is their sum, across 4 segments.
Beyond the income statement, the workbook has these sections: KPI Drivers, Balance Sheet and Cash Flow Statement.
Model thesis: AI accelerators and server CPUs take Data Center to 81% of FY27E revenue: FY26E $52.2B, FY27E $95.1B, gross margin ~54%
On November 14, 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 12, 2026.
Income statement preview
Columns FY2023–FY2025 are actual results and FY26E–FY28E are our estimates. Figures were recalculated in Excel on November 12, 2026. Dollars in millions, except per share.
| Income Statement | ||||||
|---|---|---|---|---|---|---|
| Actual | Estimate | |||||
| FY2023 | FY2024 | FY2025 | FY26E | FY27E | FY28E | |
| Revenue | $22,680 | $25,785 | $34,639 | $52,166 | $95,087 | $133,888 |
| Less: Cost of sales | ($11,278) | ($12,114) | ($16,456) | ($23,226) | ($42,800) | ($59,446) |
| Less: Amortization of acquisition-related intangibles (COGS) | ($942) | ($946) | ($1,031) | ($1,031) | ($966) | ($880) |
| Gross Profit | $10,460 | $12,725 | $17,152 | $27,909 | $51,321 | $73,562 |
| Less: Research and development | ($5,872) | ($6,456) | ($8,091) | ($10,669) | ($14,358) | ($17,138) |
| Less: Marketing, general and administrative | ($2,318) | ($2,735) | ($4,144) | ($5,321) | ($6,662) | ($7,899) |
| Less: Amortization of acquisition-related intangibles (OpEx) | ($1,869) | ($1,448) | ($1,223) | ($1,128) | ($1,062) | ($970) |
| Less: Restructuring charges | $0 | ($186) | $0 | $0 | $0 | $0 |
| Total Operating Expenses | ($10,059) | ($10,825) | ($13,458) | ($17,118) | ($22,082) | ($26,007) |
| Operating Income (Loss) | $401 | $1,900 | $3,694 | $10,792 | $29,239 | $47,555 |
| Less: Interest expense | ($106) | ($92) | ($131) | ($221) | ($340) | ($340) |
| Other income (expense), net | $197 | $181 | $577 | ($50) | $356 | $370 |
| Pre-Tax Income (Continuing) | $492 | $1,989 | $4,140 | $10,521 | $29,255 | $47,585 |
| Less: Income tax provision (benefit) | $346 | ($381) | $103 | ($452) | ($3,520) | ($6,091) |
| Equity income in investee | $16 | $33 | $26 | $22 | $20 | $20 |
| Net Income from Continuing Operations | $854 | $1,641 | $4,269 | $10,090 | $25,755 | $41,514 |
| Income (Loss) from Discontinued Operations, net of tax | $0 | $0 | $66 | $3 | $0 | $0 |
| Net Income | $854 | $1,641 | $4,335 | $10,093 | $25,755 | $41,514 |
| Basic EPS | $0.53 | $1.01 | $2.67 | $6.17 | $15.56 | $24.67 |
| Diluted EPS | $0.53 | $1.00 | $2.65 | $6.08 | $14.78 | $22.20 |
| Ratios & Assumptions | ||||||
| Gross Margin | 46.1% | 49.4% | 49.5% | 53.5% | 54.0% | 54.9% |
| Operating Margin | 1.8% | 7.4% | 10.7% | 20.7% | 30.7% | 35.5% |
| Net Margin | 3.8% | 6.4% | 12.5% | 19.3% | 27.1% | 31.0% |
| Effective Tax Rate | (70.3%) | 19.2% | (2.5%) | 4.3% | 12.0% | 12.8% |
The full workbook adds 16 historical and 8 projected quarters, plus KPI Drivers · Balance Sheet · Cash Flow Statement — every subtotal a live formula, every projection traced to a driver.
Advanced Micro Devices research
Aardvark Labs Capital Research has published 8 reports on Advanced Micro Devices (AMD). The latest is the Q3 2026 Earnings Recap, published November 4, 2026, rated Outperform.
Same Price as August, a Far Bigger 2027: Upgrading AMD 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.