Three-statement Excel model · 24 quarters and 6 fiscal years of history · 8 quarters and 5 fiscal years of projections
About the AAPL model
This three-statement Excel model covers Apple Inc. (AAPL): its income statement, balance sheet and cash flow statement. It holds 24 quarters and 6 fiscal years of history and 8 quarters and 5 fiscal years of projections.
Projected revenue is built from KPI drivers: YoY growth % × product category (iPhone / Mac / iPad / Wearables / Services); four hardware lines sum to IS Products, across 5 segments.
Beyond the income statement, the workbook has these sections: KPI Drivers, Balance Sheet, Cash Flow Statement and Segment KPIs.
Model thesis: Record revenue, flat-to-lower earnings: the December guide implies ~2% EPS growth on 8.5% revenue growth, memory costs keep rising past December, and FY27E EPS of $8.65 declines from FY26's $8.98 while the stock trades near 40x — Underperform
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.
Income statement preview
Columns FY24–FY26 are actual results and FY27E–FY29E are our estimates. Figures were recalculated in Excel on November 10, 2026. Dollars in millions, except per share amounts.
| Income Statement | ||||||
|---|---|---|---|---|---|---|
| Actual | Estimate | |||||
| FY24 | FY25 | FY26 | FY27E | FY28E | FY29E | |
| Products | $294,866 | $307,003 | $355,533 | $382,392 | $400,748 | $415,193 |
| Services | 96,169 | 109,158 | 123,301 | 133,782 | 143,815 | 153,882 |
| Total Net Sales | $391,035 | $416,161 | $478,834 | $516,173 | $544,564 | $569,075 |
| Less: Cost of Sales - Products | (185,233) | (194,116) | (215,874) | (249,997) | (258,919) | (266,263) |
| Less: Cost of Sales - Services | (25,119) | (26,844) | (29,358) | (32,640) | (34,516) | (36,470) |
| Total Cost of Sales | ($210,352) | ($220,960) | ($245,232) | ($282,638) | ($293,435) | ($302,733) |
| Gross Margin | $180,683 | $195,201 | $233,602 | $233,536 | $251,129 | $266,342 |
| Less: Research and Development | (31,370) | (34,550) | (45,765) | (52,782) | (57,264) | (61,273) |
| Less: Selling, General and Administrative | (26,097) | (27,601) | (29,774) | (30,965) | (32,204) | (33,492) |
| Total Operating Expenses | ($57,467) | ($62,151) | ($75,539) | ($83,746) | ($89,468) | ($94,765) |
| Operating Income | $123,216 | $133,050 | $158,063 | $149,789 | $161,661 | $171,577 |
| Other Income/(Expense), net | $269 | ($321) | $1,174 | $1,017 | $1,089 | $1,138 |
| Income Before Provision for Income Taxes | $123,485 | $132,729 | $159,237 | $150,806 | $162,750 | $172,715 |
| Less: Provision for Income Taxes | ($29,749) | ($20,719) | ($27,062) | ($25,637) | ($27,668) | ($29,362) |
| Net Income | $93,736 | $112,010 | $132,175 | $125,169 | $135,083 | $143,354 |
| Ratios & Assumptions | ||||||
| YoY Total Net Sales Growth | 2.0% | 6.4% | 15.1% | 7.8% | 5.5% | 4.5% |
| Products Gross Margin | 37.2% | 36.8% | 39.3% | 34.6% | 35.4% | 35.9% |
| Services Gross Margin | 73.9% | 75.4% | 76.2% | 75.6% | 76.0% | 76.3% |
| Total Gross Margin | 46.2% | 46.9% | 48.8% | 45.2% | 46.1% | 46.8% |
| Incremental Gross Margin (YoY) | 148.8% | 57.8% | 61.3% | (0.2%) | 62.0% | 62.1% |
The full workbook adds 24 historical and 8 projected quarters, plus KPI Drivers · Balance Sheet · Cash Flow Statement · Segment KPIs — every subtotal a live formula, every projection traced to a driver.
Apple research
Aardvark Labs Capital Research has published 6 reports on Apple (AAPL). The latest is the Q4 FY26 Earnings Recap, published November 4, 2026, rated Underperform.
Record Revenue, Flat Earnings: December's Margin Guide Points FY27 Below FY26 as the Stock Sets a New High; Downgrading to Underperform
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.