# Apple (AAPL) Financial Model

Free Excel 3-statement financial model and company analysis for Apple.

- Canonical: https://finamodel.com/companies/apple
- Industry: Hardware
- Downloadable model: Yes
- Excel download: https://finamodel.com/company-models/AAPL.xlsx

## Model Purpose

This model provides a comprehensive equity valuation and capital return forecast to help an equity research analyst determine Apple's intrinsic value and assess the EPS accretion from its massive share repurchase programme.

## Company Overview

Apple Inc. designs, manufactures, and markets smartphones, personal computers, tablets, wearables, and accessories, alongside a highly profitable and growing suite of related services.
The business is divided into five reported product categories: iPhone (approximately 51% of revenue), Mac (7%), iPad (6%), Wearables, Home and Accessories (10%), and Services (26%).
Key geographies include the Americas (42%), Europe (25%), Greater China (17%), Japan (6%), and Rest of Asia Pacific (10%).
Apple operates a premium hardware ecosystem model that acts as a platform to drive recurring, high-margin subscription and transaction-based services revenue.
The company holds a dominant competitive position in the premium smartphone and tablet markets globally, competing primarily with Samsung, Alphabet (Google), and Microsoft.
Recent major events include the launch of Apple Intelligence (its generative AI suite), the introduction of the Vision Pro spatial computing headset, and ongoing regulatory scrutiny regarding App Store policies in the European Union and the United States.

## Revenue Deep Dive



### iPhone

- Segment name: iPhone
- Revenue driver formula: Installed Base x Replacement Cycle Rate x Average Selling Price (ASP)
- Historical growth rate: -2% to 5% (highly cyclical based on major form-factor upgrades)
- Key growth levers and headwinds: 5G adoption, AI-driven supercycles, lengthening replacement cycles, and macroeconomic pressure in China.
- Pricing dynamics: Premium pricing strategy with clear tiering (Standard, Pro, Pro Max).
- Revenue recognition notes: Recognised upon transfer of control (usually delivery), with a small portion deferred for future software upgrades.
- Seasonality: Highly seasonal. Q1 (ending December) is the holiday quarter and typically accounts for 30-35% of annual iPhone revenue.

### Mac

- Segment name: Mac
- Revenue driver formula: Unit Sales x ASP
- Historical growth rate: -10% to 15% (volatile post-pandemic)
- Key growth levers and headwinds: Apple Silicon upgrade cycles, enterprise adoption, and PC market cyclicality.
- Pricing dynamics: Premium pricing, highly dependent on customisation (RAM, storage).
- Revenue recognition notes: Upfront upon delivery.
- Seasonality: Strongest in Q4 (September) due to back-to-school sales and Q1 (December) for holidays.

### iPad

- Segment name: iPad
- Revenue driver formula: Unit Sales x ASP
- Historical growth rate: -15% to 10%
- Key growth levers and headwinds: Cannibalisation from larger iPhones and lighter Macs, educational deployments.
- Pricing dynamics: Wide range from entry-level to high-end iPad Pro.
- Revenue recognition notes: Upfront upon delivery.
- Seasonality: Peaks in Q1 (holiday) and Q4 (back-to-school).

### Wearables, Home and Accessories

- Segment name: Wearables, Home and Accessories
- Revenue driver formula: Unit Sales x ASP
- Historical growth rate: -5% to 10%
- Key growth levers and headwinds: Apple Watch health features, AirPods upgrade cycles, Vision Pro adoption.
- Pricing dynamics: Accessory pricing with high margins.
- Revenue recognition notes: Upfront upon delivery.
- Seasonality: Extremely heavy Q1 (holiday) weighting due to gift-giving.

### Services

- Segment name: Services
- Revenue driver formula: Active Installed Base x Average Revenue Per User (ARPU)
- Historical growth rate: 9% to 14% CAGR
- Key growth levers and headwinds: App Store billings, Apple Music/TV+ subscriptions, Google search licensing revenue (Traffic Acquisition Costs), and regulatory risks to App Store fees.
- Pricing dynamics: Subscription-based and transaction-based (15-30% take rate on App Store).
- Revenue recognition notes: Recognised over time as services are delivered.
- Seasonality: Less seasonal than hardware, providing a steady sequential growth pattern.

## Cost Structure



### Variable Costs / COGS

- Products COGS includes component costs (displays, memory, processors), contract manufacturing labour, freight, logistics, and warranty expenses.
- Services COGS includes traffic acquisition costs, licensing fees for content (Apple TV+, Apple Music), and data centre operations.
- Gross margin range: Total company 43% to 46%. Products gross margin ranges from 35% to 37%. Services gross margin ranges from 71% to 74%.
- Key input costs and commodity exposures: NAND/DRAM memory pricing, display panels, and logistics costs.
- COGS scales linearly with hardware volume, but Services COGS exhibits massive operating leverage.

### Operating Expenses

- R&D: Typically 7% to 8% of revenue. Apple does not capitalise software development costs materially; almost all R&D is expensed as incurred. It covers silicon development, AI research, and new product categories.
- SG&A: Typically 6% to 7% of revenue. Includes marketing, advertising, retail store operations, and corporate functions. Highly headcount-driven.
- Depreciation & Amortisation: Approximately 2% to 3% of revenue, primarily related to tooling equipment at supplier facilities and data centre infrastructure.
- Stock-Based Compensation: Approximately 2.5% to 3% of revenue.
- Restructuring / one-time charges: Very rare and typically immaterial.

### Margin Profile

- Gross margin: 43% to 46% (expanding due to Services mix shift).
- EBITDA margin: 32% to 34%.
- Operating margin: 30% to 31%.
- Net margin: 24% to 26%.
- Margin trend: Expanding steadily over the last five years entirely due to the mix shift towards the 70%+ margin Services segment.

## Balance Sheet Structure

- Total assets: Approximately $330 billion to $350 billion.
- Key asset categories: Cash, cash equivalents, and marketable securities (often exceeding $150 billion), accounts receivable, vendor non-trade receivables, and property, plant and equipment.
- Goodwill & intangibles as % of total assets: Less than 2% (Apple rarely makes large acquisitions).
- Working capital profile:
  - Days Sales Outstanding (DSO): 20 to 25 days.
  - Days Inventory Outstanding (DIO): 7 to 10 days (incredibly lean supply chain).
  - Days Payable Outstanding (DPO): 90 to 110 days.
  - Net working capital as % of revenue: Consistently negative.
  - Apple operates with structurally negative working capital, meaning its suppliers fund its growth.
- PP&E: Consists of corporate facilities, retail stores, data centres, and manufacturing tooling located at third-party facilities.
- Right-of-use assets / operating leases: Approximately $10 billion to $12 billion, primarily for retail stores.

## Capital Expenditure & Investment

- Capex as % of revenue: 2% to 3% (historically $10 billion to $12 billion annually).
- Maintenance capex vs. growth capex: Approximately 40% maintenance (retail refresh, corporate IT) and 60% growth (data centres for AI, new product tooling).
- Major capex programmes underway or planned: Expansion of proprietary data centres to support Apple Intelligence and iCloud growth.
- Capitalised software / development costs: Immaterial.
- M&A pattern: Bolt-on acquirer. Apple buys small technology teams and IP rather than large ongoing businesses.
- Typical acquisition multiple paid: Not disclosed, usually small absolute dollar amounts.

## Debt & Capital Structure

- Total debt: Approximately $100 billion to $110 billion (term debt and commercial paper).
- Debt/EBITDA ratio: Approximately 0.8x to 1.0x.
- Credit rating: AA+ (S&P) / Aaa (Moody's).
- Key debt instruments: Unsecured senior notes and commercial paper.
- Maturity profile: Well-laddered with average maturity exceeding 5 years.
- Interest rate profile: Predominantly fixed rate bonds.
- Covenants: Standard investment-grade covenants; no restrictive financial maintenance covenants.
- Share repurchase programme: Extremely active. Apple repurchases $80 billion to $90 billion of its own stock annually, driving significant EPS accretion.
- Dividend policy: Payout ratio of approximately 14% to 16%, with a dividend yield around 0.5%. The dividend grows at roughly 4% to 5% annually.

## Cash Flow Characteristics

- Operating cash flow conversion: OCF / Net Income is typically 1.1x to 1.2x.
- Free cash flow margin: 25% to 28% of revenue.
- Major non-cash items that bridge net income to OCF: Depreciation, amortisation, and stock-based compensation.
- Working capital cash flow impact: Significant source of cash during Q1 (holiday quarter) due to massive spikes in accounts payable, which reverse in Q2.
- Capex intensity: Very low (asset-light manufacturing model).
- Cash tax rate vs. GAAP effective tax rate: Closely aligned, typically around 15% to 16%.

## Sheet Structure

1. **Cover**: Company name, ticker, model purpose, and contact information.
2. **Assumptions**: All hardcoded inputs, growth rates, margin assumptions, and capital return targets.
3. **Scenarios**: Base, Bull, and Bear case toggles linked to the Assumptions sheet.
4. **Revenue_Build**: Detailed unit and ASP forecasts for iPhone, Mac, iPad, and Wearables, plus ARPU and installed base forecasts for Services.
5. **Income_Statement**: Consolidated P&L from revenue down to EPS, including share count forecasting.
6. **Balance_Sheet**: Assets, liabilities, and shareholders' equity.
7. **Cash_Flow**: Operating, investing, and financing cash flows.
8. **Working_Capital**: Schedules for accounts receivable, inventory, vendor non-trade receivables, and accounts payable.
9. **Debt_Schedule**: Debt tranches, interest expense calculations, and debt maturities.
10. **Capital_Returns**: Detailed schedule of share repurchases, average buyback price, dividend payments, and resulting basic/diluted share count.
11. **DCF**: Unlevered free cash flow calculation, WACC, terminal value, and implied share price.

## Key Financial Relationships

1. "iPhone Revenue = iPhone Units Sold x iPhone ASP"
2. "Services Revenue = Total Active Installed Base x Services ARPU"
3. "Total Products Revenue = iPhone Revenue + Mac Revenue + iPad Revenue + Wearables Revenue"
4. "Products COGS = Total Products Revenue x (1 - Products Gross Margin %)"
5. "Services COGS = Services Revenue x (1 - Services Gross Margin %)"
6. "Total Gross Profit = (Total Products Revenue - Products COGS) + (Services Revenue - Services COGS)"
7. "Blended Gross Margin = Total Gross Profit / Total Net Sales"
8. "Accounts Payable = (Total COGS / 365) x Days Payable Outstanding"
9. "Inventory = (Products COGS / 365) x Days Inventory Outstanding"
10. "Share Repurchase Cash Outflow = Target Net Cash Position Adjustment + Free Cash Flow - Dividends Paid"
11. "Shares Repurchased = Share Repurchase Cash Outflow / Average Share Price During Period"
12. "Ending Diluted Shares = Beginning Diluted Shares - Shares Repurchased + SBC Dilution"

## Cross-Sheet Dependencies

- The **Revenue_Build** sheet feeds the top line of the **Income_Statement**.
- Segment gross margins from the **Assumptions** sheet feed the COGS lines on the **Income_Statement**.
- Net Income from the **Income_Statement** feeds the top of the **Cash_Flow** statement and Retained Earnings on the **Balance_Sheet**.
- The **Working_Capital** sheet calculates changes in operating assets and liabilities, which feed the **Cash_Flow** statement.
- The **Capital_Returns** sheet determines the cash used for buybacks and dividends, feeding the financing section of the **Cash_Flow** statement.
- The **Capital_Returns** sheet also calculates the new share count, which feeds back to the **Income_Statement** to calculate EPS.
- Interest income and expense on the **Income_Statement** depend on the cash and debt balances from the **Balance_Sheet** and **Debt_Schedule**, creating a potential circularity that must be managed with a toggle or iterative calculation.

## Sign Convention

- Revenues, assets, and equity balances are entered and displayed as positive numbers.
- Expenses (COGS, R&D, SG&A, Interest, Taxes) are entered as positive numbers but subtracted in subtotal formulas on the Income Statement.
- Liabilities are entered as positive numbers.
- On the Cash Flow statement, cash inflows are positive and cash outflows (capex, dividends, share repurchases, debt repayment) are negative.

## Things Most Likely to Go Wrong

- Failing to capture the extreme Q1 (December quarter) seasonality, which skews working capital and cash flow generation.
- Underestimating the impact of the Services mix shift on consolidated gross margins; as Services grow faster than Products, overall gross margin mathematically expands.
- Modelling share repurchases as a static dollar amount rather than a plug to achieve management's stated "net cash neutral" goal over time.
- Miscalculating EPS by using ending share count instead of the weighted average share count for the period.
- Overestimating inventory balances; Apple holds very little inventory, relying instead on vendor non-trade receivables and massive accounts payable.
- Ignoring the impact of foreign exchange; Apple generates over 50% of revenue outside the US, making reported revenue highly sensitive to a strong US Dollar.
- Assuming linear growth in iPhone units; the replacement cycle is lumpy and driven by major form-factor or network (5G/AI) upgrades.
- Treating all R&D as capitalisable; Apple expenses almost all R&D, so operating cash flow is not artificially inflated by capitalised software costs.

## Validation Checks

- Blended Gross Margin must be between 43% and 47%; flag if outside this band.
- Services Gross Margin should remain above 70%; flag if it drops below this threshold.
- Net Working Capital must be negative; flag if the model forecasts positive net working capital.
- Capex as a percentage of revenue should remain between 2% and 4%.
- OCF / Net Income conversion must remain above 1.0x.
- The Balance Sheet must balance perfectly in every forecasted period (Total Assets = Total Liabilities + Shareholders' Equity).
- Effective tax rate should be between 14% and 17%.
- Dividend payout ratio should not exceed 20% of Net Income.

## Key Assumptions (Default Values)

| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| iPhone Revenue Growth | 2.5 | % | Modest growth driven by AI upgrade cycle and ASP increases. |
| Mac Revenue Growth | 3.0 | % | Stabilisation post-pandemic PC slump. |
| iPad Revenue Growth | 1.0 | % | Mature product category with lengthening replacement cycles. |
| Wearables Revenue Growth | 4.0 | % | Continued Apple Watch adoption and new AirPods cycles. |
| Services Revenue Growth | 11.0 | % | Continued expansion of installed base monetisation and subscriptions. |
| Products Gross Margin | 36.5 | % | Historical average, reflecting premium pricing offset by component costs. |
| Services Gross Margin | 73.5 | % | High margin profile of App Store and licensing revenues. |
| R&D as % of Revenue | 7.5 | % | Consistent with recent historical investment in silicon and AI. |
| SG&A as % of Revenue | 6.5 | % | Highly stable operating expense ratio. |
| Days Sales Outstanding (DSO) | 22 | Days | Based on historical receivables collection efficiency. |
| Days Inventory Outstanding (DIO) | 9 | Days | Reflects Apple's extremely lean, just-in-time supply chain. |
| Days Payable Outstanding (DPO) | 100 | Days | Reflects immense supplier bargaining power. |
| Capex as % of Revenue | 2.8 | % | Slight elevation for AI data centre infrastructure buildout. |
| Effective Tax Rate | 15.5 | % | Blended rate based on US and international tax provisions. |
| Annual Share Repurchases | 85,000 | $ Millions | Aligns with management's goal to reach a net cash neutral position. |
| Dividend Growth Rate | 4.0 | % | Consistent with historical annual dividend increases. |
| WACC | 8.5 | % | Reflects low beta, premium market position, and low cost of debt. |
| Terminal Growth Rate | 2.5 | % | Long-term GDP growth proxy for a mature mega-cap company. |

## Data Sources & Benchmarks

- SEC EDGAR: Apple Inc. 10-K and 10-Q filings.
- Apple Investor Relations: Quarterly earnings supplements and data summaries.
- Key peers for benchmarking: Microsoft (MSFT), Alphabet (GOOGL), Samsung Electronics.
- Industry data sources: IDC and Gartner for global smartphone and PC shipment market share data.
- Consensus estimates source: Bloomberg or FactSet for near-term revenue and EPS consensus validation.
- Proprietary data: Sensor Tower or Data.ai for App Store revenue tracking and download trends.

## Sources

- Apple Inc. Form 10-K for the fiscal year ended September 28, 2024.
- Apple Inc. Form 10-Q for the fiscal quarter ended December 28, 2024.
- Apple Investor Relations website (investor.apple.com).
- IDC Quarterly Mobile Phone Tracker reports.

---

## Frequently asked questions

### What does Apple Inc. do?

Apple Inc. designs, manufactures, and markets various electronic devices like smartphones, personal computers, and wearables, alongside a profitable suite of related services. The company's business model leverages a premium hardware ecosystem to drive recurring, high-margin subscription and transaction-based services revenue.

### What are Apple's main revenue sources?

Apple's revenue is primarily driven by its iPhone sales, which account for approximately 51% of its total revenue. Other significant contributors include Services at 26%, and Wearables, Home and Accessories at 10%, with Mac and iPad making up smaller portions.

### What is Apple's capital expenditure strategy?

Apple's capital expenditure (Capex) historically ranges from 2% to 3% of revenue, amounting to $10 billion to $12 billion annually. Approximately 60% of this capex is allocated to growth initiatives, such as expanding data centers for Apple Intelligence and new product tooling.

### How does Apple manage its working capital?

Apple operates with a structurally negative net working capital, meaning its suppliers effectively fund its growth. This is achieved through very lean inventory (7-10 days) and efficient receivables management (20-25 days), combined with extended payment terms to suppliers (90-110 days).

### What is the purpose of the Apple financial model?

The Apple financial model aims to provide a comprehensive equity valuation and forecast capital returns. It helps equity research analysts determine Apple's intrinsic value and assess the EPS accretion resulting from its substantial share repurchase program.

### Can I download an Excel financial model for Apple?

Yes, a comprehensive Excel financial model for Apple Inc. is available for download. This model provides a forecast horizon from FY2026 to FY2030 and includes key assumptions for revenue growth, margins, and capital expenditures.

[Interactive forecast calculator](https://finamodel.com/companies/apple/forecast)