← All financial models

Apple (AAPL) Financial Model

📊 Download Model

Three-statement Excel model · 24 quarters and 6 fiscal years of history · 8 quarters and 5 fiscal years of projections

current ✓ C13 recon ✓ C14 trace ✓ C15 terminals

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.

History
24 quarters and 6 fiscal years
Projections
8 quarters and 5 fiscal years
KPI
YoY growth % × product category (iPhone / Mac / iPad / Wearables / Services); four hardware lines sum to IS Products
Segments
5
Units
Dollars in millions, except per share amounts
Verified
Updated
File
Excel workbook (.xlsx), 166 KB
Access
Free account required: 3 different models a month at no charge, then $9 a month.

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 preview for AAPL. Dollars in millions, except per share amounts. Actual fiscal years followed by our estimates.
Income Statement
ActualEstimate
FY24FY25FY26FY27EFY28EFY29E
Products$294,866$307,003$355,533$382,392$400,748$415,193
Services96,169109,158123,301133,782143,815153,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 Growth2.0%6.4%15.1%7.8%5.5%4.5%
Products Gross Margin37.2%36.8%39.3%34.6%35.4%35.9%
Services Gross Margin73.9%75.4%76.2%75.6%76.0%76.3%
Total Gross Margin46.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.

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

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

All AAPL 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.