Apple Inc. (AAPL) 10-K Financial Statements & Excel Model (.xlsx)
Access audited annual financial statements for Apple Inc. directly from SEC EDGAR. Review multi-year US-GAAP performance across Products and Services reportable segments, forensic working capital cycle analysis, and download the institutional financial model in Excel (.xlsx) with pre-linked formulas.
Download Apple (AAPL) 10-K Financial Model
Complete multi-sheet workbook: Summary, Income Statement, Balance Sheet, Cash Flow, Capital Return Schedule, and 5-Year DCF
1. Audited 3-Year Multi-Period Financial Performance (US-GAAP)
Reported multi-period figures from Apple's official SEC Form 10-K filing:
| Line Item (US-GAAP Taxonomy) | FY2022 | FY2023 | FY2024 (Latest) | YoY Variance |
|---|---|---|---|---|
| Total Net Sales | $394,328M | $383,285M | $391,035M | +2.0% |
| Cost of Sales | $223,546M | $214,137M | $210,352M | -1.8% |
| Gross Margin | $170,782M | $169,148M | $180,683M | +6.8% |
| Gross Margin % | 43.3% | 44.1% | 46.2% | +210 bps |
| Research & Development (R&D) | $26,251M | $29,915M | $31,370M | +4.9% |
| Selling, General & Administrative (SG&A) | $25,094M | $24,932M | $26,093M | +4.7% |
| Operating Income | $119,437M | $114,301M | $123,220M | +7.8% |
| Operating Margin % | 30.3% | 29.8% | 31.5% | +170 bps |
| Net Income (GAAP) | $99,803M | $96,995M | $93,736M | -3.4% |
| Diluted EPS ($) | $6.11 | $6.13 | $6.08 | -0.8% |
| Cash Flow from Operations (CFO) | $122,151M | $110,543M | $118,254M | +7.0% |
| Capital Expenditures (CapEx) | ($10,708M) | ($10,959M) | ($9,454M) | -13.8% |
| Free Cash Flow (FCF) | $111,443M | $99,584M | $108,800M | +9.3% |
2. ASC 280 Products vs. Services Revenue & Gross Margin Schedule
Apple's profitability expansion is fundamentally anchored by the structural mix shift toward higher-margin digital Services:
| Segment / Product Line | FY2022 ($M) | FY2023 ($M) | FY2024 ($M) | % of Total Sales | Segment Gross Margin |
|---|---|---|---|---|---|
| iPhone | $205,489M | $200,583M | $201,183M | 51.4% | 37.1% (Products) |
| Services (App Store, Cloud, Pay, Music) | $78,129M | $85,200M | $96,169M | 24.6% | 74.2% (Services) |
| Wearables, Home & Accessories | $41,241M | $39,845M | $37,005M | 9.5% | 37.1% (Products) |
| Mac | $40,177M | $29,357M | $29,984M | 7.7% | 37.1% (Products) |
| iPad | $29,292M | $28,300M | $26,694M | 6.8% | 37.1% (Products) |
| Total Consolidated Net Sales | $394,328M | $383,285M | $391,035M | 100.0% | 46.2% Blended |
3. Working Capital Efficiency & Capital Allocation Forensics
Apple's capital return program remains the largest in corporate history, returning over $95B annually through share repurchases and dividends. Operating cash flow conversion exceeds 125% of net income, supported by rapid Services margin expansion:
Apple operates with negative working capital, receiving cash from customers weeks before paying component suppliers.
Beneish M-Score of -2.75 is well below the -1.78 threshold, confirming high financial reporting integrity and low accrual risk.
Over $95 billion retired in FY2024, continuing Apple's decade-long share count shrinkage toward a net cash neutral balance sheet.
Frequently Asked Questions (Apple 10-K & Valuation)
How do Apple's Services gross margins compare to Products gross margins?
Apple's Services segment gross margin reached 74.2%, compared to 37.1% for physical Hardware Products (iPhone, Mac, iPad, and Wearables). High-margin recurring revenue streams from the App Store, iCloud, Apple Pay, AppleCare, and digital subscriptions have expanded Apple's consolidated gross margin from 43.3% in FY2022 to 46.2% in FY2024.
What is the scale and strategy behind Apple's share repurchase program?
Apple operates the largest capital return program in corporate history, returning over $95 billion annually through share repurchases and dividends. Apple has repurchased over $650 billion in common stock over the past decade, purposefully targeting a "net cash neutral" balance sheet while reducing diluted share count and expanding Earnings Per Share (EPS).
Why does Apple have a negative Cash Conversion Cycle?
Apple operates with a negative Cash Conversion Cycle of approximately -54 days. Due to immense scale and purchasing leverage, Apple collects cash from consumer device sales and carrier partners weeks before it pays contract manufacturing and component suppliers (Days Payable Outstanding around 110 days), effectively financing working capital via supplier credit.
How can I download Apple's audited SEC Form 10-K financial statements in Excel?
You can download the audited multi-sheet Apple Form 10-K financial model directly from this page using the "Download AAPL .XLSX" button. The workbook includes audited 3-year historical Income Statements, Balance Sheets, Cash Flow Statements, ASC 280 Products vs. Services breakdowns, and a pre-linked 5-year DCF model generated client-side with zero macro security warnings.
Run Interactive Valuations for AAPL
Open the CALIO Terminal to adjust WACC, test sensitivity scenarios, and benchmark Apple directly against Microsoft, Alphabet, and Meta.