Apple Financial Model
Hardware Company Financials Example (Free Excel Download)
Apple Inc. designs, manufactures, and markets smartphones, personal computers, tablets, wearables, and accessories, alongside a highly profitable and growing suite of related services.
professionals from Deloitte
Used by professionals from
About this model
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.
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.
The downloadable Apple financial model includes SEC-sourced historical financials, forecast assumptions, core operating schedules, and valuation outputs in an Excel workbook built for review and scenario analysis.
A turnkey financial model
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
Historicals & AssumptionsApple financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $365.82B | $394.33B | $383.29B | $391.04B | $416.16B |
| Gross profit | $152.84B | $170.78B | $169.15B | $180.68B | $195.20B |
| Operating income | $108.95B | $119.44B | $114.30B | $123.22B | $133.05B |
| Net income | $94.68B | $99.80B | $97.00B | $93.74B | $112.01B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Apple
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
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
- Cover: Company name, ticker, model purpose, and contact information.
- Assumptions: All hardcoded inputs, growth rates, margin assumptions, and capital return targets.
- Scenarios: Base, Bull, and Bear case toggles linked to the Assumptions sheet.
- Revenue_Build: Detailed unit and ASP forecasts for iPhone, Mac, iPad, and Wearables, plus ARPU and installed base forecasts for Services.
- Income_Statement: Consolidated P&L from revenue down to EPS, including share count forecasting.
- Balance_Sheet: Assets, liabilities, and shareholders' equity.
- Cash_Flow: Operating, investing, and financing cash flows.
- Working_Capital: Schedules for accounts receivable, inventory, vendor non-trade receivables, and accounts payable.
- Debt_Schedule: Debt tranches, interest expense calculations, and debt maturities.
- Capital_Returns: Detailed schedule of share repurchases, average buyback price, dividend payments, and resulting basic/diluted share count.
- DCF: Unlevered free cash flow calculation, WACC, terminal value, and implied share price.
Key Financial Relationships
- "iPhone Revenue = iPhone Units Sold x iPhone ASP"
- "Services Revenue = Total Active Installed Base x Services ARPU"
- "Total Products Revenue = iPhone Revenue + Mac Revenue + iPad Revenue + Wearables Revenue"
- "Products COGS = Total Products Revenue x (1 - Products Gross Margin %)"
- "Services COGS = Services Revenue x (1 - Services Gross Margin %)"
- "Total Gross Profit = (Total Products Revenue - Products COGS) + (Services Revenue - Services COGS)"
- "Blended Gross Margin = Total Gross Profit / Total Net Sales"
- "Accounts Payable = (Total COGS / 365) x Days Payable Outstanding"
- "Inventory = (Products COGS / 365) x Days Inventory Outstanding"
- "Share Repurchase Cash Outflow = Target Net Cash Position Adjustment + Free Cash Flow - Dividends Paid"
- "Shares Repurchased = Share Repurchase Cash Outflow / Average Share Price During Period"
- "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
Do more with the Apple model
Frequently asked
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.
Have more financial modelling questions? Contact us
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Other Hardware Company Financial Models
Browse another company in the same sector.
Arista Networks
Arista Networks provides cloud networking solutions, data centre switches, and routing platforms powered by its proprietary Extensible Operating System (EOS) software.
Ciena
Ciena Corporation is a global leader in networking systems, components, automation software, and services, primarily focused on optical transport and routing/switching solutions.
Cisco
Cisco is a global leader in networking, cybersecurity, collaboration, and observability solutions that power enterprise IT infrastructure, designing and selling technologies increasingly embedded with artificial intelligence.
Dell Technologies
Dell Technologies is a premier provider of IT hardware, software, and service solutions globally.
Garmin
Garmin designs, develops, manufactures, and markets a diverse portfolio of hand-held, wearable, portable, and fixed-mount GPS-enabled products for fitness, outdoor, marine, aviation, and automotive markets.
Hewlett Packard Enterprise
Hewlett Packard Enterprise is a global edge-to-cloud company that provides hardware, software, and financial services to enterprise customers.
HP
HP is a global provider of personal computing and other access devices, imaging and printing products, and related technologies, operating through Personal Systems and Printing segments.
NetApp
NetApp is an intelligent data infrastructure company providing unified data storage, integrated data services, and CloudOps solutions across on-premises environments and major public clouds (AWS, Azure, Google Cloud).
Explore more Tech & Software financial model templates.
