Amazon Financial Model
Marketplaces Company Financials Example (Free Excel Download)
Amazon is a multinational technology and retail conglomerate that operates the world's largest e-commerce marketplace and the leading cloud computing platform.
professionals from Deloitte
Used by professionals from
About this model
This model projects Amazon's future free cash flow and sum-of-the-parts equity valuation to determine whether the massive ongoing capital expenditure in artificial intelligence infrastructure will generate sufficient AWS and advertising growth to justify the current share price.
Amazon is a multinational technology and retail conglomerate that operates the world's largest e-commerce marketplace and the leading cloud computing platform. The company monetises its vast customer base through retail sales, third-party seller fees, subscription services like Amazon Prime, and a rapidly growing digital advertising business.
- Business segments: North America (approximately 59% of revenue), International (approximately 23% of revenue), and Amazon Web Services or AWS (approximately 18% of revenue).
- Key geographies: The United States, Germany, the United Kingdom, and Japan are the largest individual markets, though AWS operates globally.
- Business model type: A hybrid ecosystem comprising an asset-heavy retail and logistics network, a high-margin transaction tollbooth (third-party seller services), a subscription model (Prime), and a capital-intensive utility-like technology platform (AWS).
- Competitive position: Number one market share in US e-commerce and global cloud infrastructure (IaaS/PaaS), competing directly with Microsoft Azure and Google Cloud in technology, and Walmart, Target, and emerging discount platforms like Temu in retail.
- Recent major events: A massive acceleration in capital expenditure during 2024 and 2025 to build out generative AI infrastructure, alongside a major cost restructuring in the retail fulfilment network that shifted operations from a national to a regional model in the US.
The downloadable Amazon 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 & AssumptionsAmazon financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $469.82B | $513.98B | $574.78B | $637.96B | $716.92B |
| Gross profit | $197.48B | $225.15B | $270.05B | $311.67B | $360.51B |
| Operating income | $24.88B | $12.25B | $36.85B | $68.59B | $79.97B |
| Net income | $33.36B | -$2.72B | $30.43B | $59.25B | $77.67B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Amazon
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Amazon reports revenue across three segments (North America, International, AWS) but breaks down net sales into seven specific groups. The model must project revenue based on these seven groups.
Online Stores
- Revenue driver formula: Active Customer Accounts x Average Order Value x Order Frequency
- Historical growth rate: 4% to 8% CAGR
- Key growth levers and headwinds: Headwinds from consumer trading down to discount competitors; levers include faster delivery speeds driving higher conversion.
- Pricing dynamics: Highly competitive and algorithmic spot pricing.
- Revenue recognition notes: Recognised upon delivery to the customer.
- Seasonality: Q4 is the strongest by a wide margin due to the holiday shopping season.
Physical Stores
- Revenue driver formula: Store Count x Sales per Square Foot
- Historical growth rate: 4% to 6% CAGR
- Key growth levers and headwinds: Primarily driven by Whole Foods Market foot traffic and basket size.
- Pricing dynamics: Premium grocery pricing.
- Revenue recognition notes: Recognised at the point of sale.
- Seasonality: Relatively stable throughout the year.
Third-Party Seller Services
- Revenue driver formula: Third-Party Gross Merchandise Value x Take Rate (Commissions + Fulfilment Fees)
- Historical growth rate: 11% to 15% CAGR
- Key growth levers and headwinds: Increasing penetration of Fulfilment by Amazon (FBA) and rising fee structures.
- Pricing dynamics: Contractual fee schedules set by Amazon.
- Revenue recognition notes: Recognised over time as services are rendered.
- Seasonality: Peaks in Q4 alongside retail volumes.
Subscription Services
- Revenue driver formula: Prime Members x Annual Subscription Fee
- Historical growth rate: 10% to 14% CAGR
- Key growth levers and headwinds: Price increases and international penetration, offset by saturation in the US market.
- Pricing dynamics: Contractual and sticky, with occasional step-function price hikes.
- Revenue recognition notes: Deferred and amortised straight-line over the subscription period.
- Seasonality: Steady, with slight bumps around Prime Day in Q3.
Advertising Services
- Revenue driver formula: Ad Impressions x Cost Per Click or Cost Per Mille (CPM)
- Historical growth rate: 20% to 25% CAGR
- Key growth levers and headwinds: Introduction of Prime Video ads and sponsored product placements.
- Pricing dynamics: Auction-based pricing driven by seller competition.
- Revenue recognition notes: Recognised as clicks or impressions are delivered.
- Seasonality: Highly correlated with Q4 retail traffic.
Amazon Web Services (AWS)
- Revenue driver formula: Compute/Storage Usage x Blended Rate per Unit
- Historical growth rate: 15% to 20% CAGR (accelerated to 20% in 2025)
- Key growth levers and headwinds: Generative AI workloads and foundation model training driving massive compute demand, offset by enterprise cost optimisation.
- Pricing dynamics: Usage-based spot pricing and long-term contractual commitments.
- Revenue recognition notes: Billed in arrears for usage or deferred for upfront commitments.
- Seasonality: Generally linear, with slight Q4 enterprise budget flushes.
Other
- Revenue driver formula: Miscellaneous licensing and co-branded credit card agreements.
- Historical growth rate: Highly variable.
Cost Structure
Variable Costs / COGS
- Line-by-line breakdown: Amazon reports "Cost of Sales" which includes the purchase price of consumer products, inbound and outbound shipping costs, and packaging supplies.
- Gross margin range: Not explicitly reported in a traditional format, but implied gross margins have expanded from roughly 43% to over 48% as high-margin services (AWS, Advertising) outpace retail product sales.
- Key input costs and commodity exposures: Fuel prices for logistics, cardboard/packaging costs, and wholesale product costs.
- How COGS scales with revenue: Scales linearly with Online Stores revenue but exhibits massive operating leverage against Advertising and AWS revenue.
Operating Expenses
- Fulfilment: Costs to operate fulfilment centres, physical stores, and customer service. Includes warehouse payroll and logistics infrastructure depreciation.
- Technology and Content: Amazon's equivalent of R&D. Covers AWS server depreciation, software developer headcount, and content licensing for Prime Video. Typically runs at 12% to 15% of total revenue.
- Sales and Marketing: Advertising costs to promote Amazon, AWS marketing, and payroll for sales teams. Typically 5% to 7% of revenue.
- General and Administrative: Corporate overhead, legal, and human resources. Typically 1% to 2% of revenue.
- Stock-Based Compensation: Highly material. Embedded within the operating expense lines above, running at approximately 3% to 4% of total revenue.
- Restructuring / one-time charges: Occasional severance and physical store impairment charges (e.g. $2.4 billion in Q4 2025 for tax disputes, severance, and impairments).
Margin Profile
- Operating margin: Consolidated operating margins range from 3% to 10%, expanding recently due to AWS and Advertising growth.
- Segment-level margins:
- North America: 4% to 6%
- International: 0% to 2%
- AWS: 30% to 38% (a massive profit engine subsidising retail operations).
Balance Sheet Structure
- Total assets: Approximately $500 billion to $550 billion.
- Key asset categories: Property and Equipment (PP&E) is the largest line item, representing data centres, fulfilment centres, and transportation equipment.
- Goodwill & intangibles: Relatively small as a percentage of total assets (historically under 5%), reflecting a preference for organic growth over transformational M&A.
- Working capital profile:
- Days Sales Outstanding (DSO): 15 to 25 days (mostly AWS and Advertising receivables).
- Days Inventory Outstanding (DIO): 35 to 45 days.
- Days Payable Outstanding (DPO): 90 to 105 days.
- Net working capital: Structurally negative. Amazon collects cash from consumers immediately but pays suppliers months later, creating a massive float that funds operations.
- PP&E: Heavily weighted towards AWS servers (useful lives of 4 to 6 years) and logistics equipment.
- Right-of-use assets: Highly material due to leased warehouse space globally.
Capital Expenditure & Investment
- Capex as % of revenue: Historically 8% to 12%, but surged to approximately 15% to 18% in 2025.
- Maintenance capex vs. growth capex: The vast majority is growth capex directed at AI infrastructure (Trainium and Inferentia chips) and data centre expansion.
- Major capex programmes underway: A stated plan to invest heavily in generative AI, with capital expenditures exceeding $100 billion annually.
- Capitalised software: Material, but dwarfed by physical hardware investments.
- M&A pattern: Bolt-on acquirer (e.g. Zoox, One Medical, MGM Studios).
Debt & Capital Structure
- Total debt: Approximately $60 billion to $80 billion in long-term debt, plus substantial lease liabilities.
- Debt/EBITDA ratio: Consistently below 1.5x, reflecting a highly conservative balance sheet.
- Credit rating: AA- (S&P) / A1 (Moody's).
- Key debt instruments: Senior unsecured notes. The company occasionally taps the bond market to fund infrastructure (e.g. a $15 billion issuance in late 2025).
- Maturity profile: Well-laddered with an average maturity exceeding 5 years.
- Interest rate profile: Predominantly fixed-rate debt.
- Covenants: Standard investment-grade covenants with massive headroom.
- Share repurchase programme: Authorised but rarely used at scale. The company prefers to reinvest cash into AWS and logistics.
- Dividend policy: Amazon does not pay a dividend.
Cash Flow Characteristics
- Operating cash flow conversion: Extremely strong. OCF routinely exceeds Net Income by 1.5x to 2.0x due to massive depreciation add-backs and stock-based compensation.
- Free cash flow margin: Highly volatile. FCF margins compressed significantly in 2025 (dropping to roughly 1.5% of revenue) due to the $50 billion year-over-year increase in AI-related capital expenditures.
- Major non-cash items: Depreciation and amortisation, stock-based compensation, and deferred income taxes.
- Working capital cash flow impact: A consistent source of cash as the business scales, owing to the negative working capital cycle.
- Capex intensity: The defining feature of Amazon's current cash flow profile. The company reinvests almost all operating cash flow into infrastructure.
Sheet Structure
- Assumptions: Contains all hardcoded drivers, historical growth rates, margin assumptions, and macroeconomic inputs.
- Revenue_Build: Projects the seven net sales groups (Online stores, Physical stores, Third-party seller services, Subscription services, Advertising services, AWS, Other) using volume and pricing drivers.
- Segment_Income: Allocates the consolidated revenue into the three reporting segments (North America, International, AWS) and applies segment-level operating margin assumptions to calculate segment operating income.
- Income_Statement: Consolidated P&L mirroring the 10-K format, driven by the revenue build and cost structure assumptions.
- Balance_Sheet: Standard asset, liability, and equity schedules. Must include detailed working capital schedules to capture the negative NWC dynamic.
- Cash_Flow: Indirect method cash flow statement. Must explicitly calculate Amazon's preferred metric of Free Cash Flow (OCF less equipment finance leases and principal repayments of all other finance leases).
- Debt_and_Leases: Tracks senior notes, finance leases, and operating leases, calculating interest expense and principal repayments.
- PP&E_and_Capex: A detailed waterfall of capital expenditures, capitalised software, and depreciation, split between AWS infrastructure and retail logistics.
- DCF_and_SOTP: A sum-of-the-parts valuation valuing AWS on an EV/EBITDA basis and the retail/advertising business on a separate multiple, cross-checked against a consolidated Discounted Cash Flow analysis.
Key Financial Relationships
- `Online Stores Revenue = Prior Year Online Stores Revenue x (1 + Online Stores Growth Rate)`
- `Third-Party Seller Services Revenue = Implied 3P GMV x Blended Take Rate`
- `AWS Revenue = Prior Year AWS Revenue x (1 + AWS Growth Rate)`
- `Total Net Sales = Sum of the 7 Revenue Groups`
- `North America Segment Revenue = Total Net Sales x NA Allocation Percentage`
- `AWS Segment Operating Income = AWS Segment Revenue x AWS Operating Margin`
- `Consolidated Operating Income = NA Operating Income + International Operating Income + AWS Operating Income`
- `Cost of Sales = Online Stores Revenue x Cost of Sales Margin`
- `Technology and Content Expense = Total Net Sales x Tech & Content % of Revenue`
- `Accounts Payable = (Cost of Sales / 365) x Days Payable Outstanding`
- `Depreciation Expense = Beginning PP&E x Blended Depreciation Rate`
- `Free Cash Flow = Operating Cash Flow - Purchases of Property and Equipment - Principal Repayments of Finance Leases`
Cross-Sheet Dependencies
- The Assumptions sheet feeds all forward-looking calculations across the model.
- The Revenue_Build sheet feeds total net sales into the Income_Statement and segment allocations into the Segment_Income sheet.
- The Segment_Income sheet calculates consolidated operating income, which must perfectly match the operating income calculated on the Income_Statement.
- The Income_Statement generates Net Income, which flows to the top of the Cash_Flow statement and into Retained Earnings on the Balance_Sheet.
- The PP&E_and_Capex sheet calculates depreciation, which flows to the Income_Statement (embedded in operating expenses) and is added back on the Cash_Flow statement.
- A circularity exists between the Debt_and_Leases sheet (interest expense), the Income_Statement (net income), the Cash_Flow statement (cash balance), and the Balance_Sheet (debt balances). This requires a standard circuit breaker toggle.
Sign Convention
- Revenue and asset balances are entered as positive numbers.
- Expenses on the Income Statement are entered as positive numbers and subtracted in subtotals.
- Contra-assets (like accumulated depreciation) are entered as positive numbers and subtracted from gross assets.
- On the Cash Flow statement, cash inflows are positive and cash outflows (including capital expenditures) are negative.
- The builder must ensure that formulas subtracting expenses from revenue use the minus sign if expenses are positive.
Things Most Likely to Go Wrong
- Misunderstanding Free Cash Flow: Amazon defines FCF differently than standard textbooks. The model must deduct principal repayments of finance leases alongside standard property and equipment purchases.
- Segment vs Group Revenue Mismatch: The model must reconcile the seven net sales groups to the three reporting segments. Failure to map these correctly will break the operating income build.
- Underestimating Capex: Extrapolating historical capex-to-revenue ratios will drastically understate future cash outflows. The model must reflect the massive step-up in AI infrastructure spending seen in 2024 and 2025.
- Ignoring Stock-Based Compensation: SBC is a massive non-cash expense. Excluding it from valuation metrics artificially inflates profitability. The model must track SBC and dilute the share count accordingly.
- Working Capital Reversals: Because Amazon operates with negative working capital, a sudden deceleration in revenue growth will cause working capital to become a massive use of cash. The model must dynamically link working capital to revenue growth.
- Foreign Exchange Impacts: International segment revenue is highly sensitive to currency fluctuations. The model should ideally forecast on a constant-currency basis and apply an FX overlay.
- AWS Useful Life Changes: Amazon frequently changes the estimated useful life of its servers (e.g. extending from 4 to 5 years). This creates sudden, non-operational boosts to operating income that the model must normalise.
- Lease Accounting Complexity: Operating and finance leases make up a huge portion of the balance sheet. The model must accurately roll forward right-of-use assets and lease liabilities.
Validation Checks
- "Consolidated Operating Income from the Income Statement must exactly equal the sum of Segment Operating Income."
- "Free Cash Flow must equal Operating Cash Flow minus Capex minus Finance Lease Principal Repayments."
- "AWS Operating Margin should remain within the 30% to 40% historical band; flag if outside this range."
- "Days Payable Outstanding should remain above 90 days to reflect Amazon's supplier leverage."
- "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
- "Capital Expenditure as a percentage of revenue should be flagged if it drops below 12% during the AI buildout phase."
- "Effective tax rate should remain between 12% and 18%."
- "Total Net Sales must exactly equal the sum of the seven revenue groups."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Online Stores Revenue Growth | 6.0 | % | Blended rate reflecting mature e-commerce penetration and discount competition [1]. |
| Third-Party Seller Services Growth | 12.0 | % | Continued shift toward 3P marketplace and rising fulfilment fee capture [1]. |
| Advertising Services Growth | 22.0 | % | Strong momentum from Prime Video ads and sponsored product placements [1]. |
| AWS Revenue Growth | 20.0 | % | Based on actual 2025 growth rates driven by generative AI workloads [1]. |
| North America Operating Margin | 5.5 | % | Reflects regional fulfilment network efficiencies achieved in recent years [1]. |
| International Operating Margin | 1.0 | % | Gradual path to profitability in emerging markets [1]. |
| AWS Operating Margin | 36.0 | % | Consistent with recent quarters following server useful life extensions and cost controls [1]. |
| Capex as % of Revenue | 17.5 | % | Reflects the $128 billion implied capex run-rate for AI infrastructure in 2025 [1]. |
| Days Sales Outstanding (DSO) | 20 | Days | Calculated from historical receivables and total revenue. |
| Days Payable Outstanding (DPO) | 95 | Days | Reflects immense negotiating power with retail suppliers. |
| Effective Tax Rate | 15.0 | % | Historical average GAAP effective tax rate. |
| Diluted Shares Outstanding | 10,830 | Millions | Based on 2025 net income and reported diluted EPS [1]. |
| WACC / Discount Rate | 9.5 | % | Standard cost of capital for a mega-cap technology firm. |
| Terminal Growth Rate | 3.0 | % | Long-term GDP growth plus slight premium for cloud penetration. |
Data Sources & Benchmarks
- Filings: SEC EDGAR database for Amazon's Form 10-K and 10-Q filings; Amazon Investor Relations website for quarterly earnings slides and press releases.
- Key Peers: Microsoft (MSFT) and Alphabet (GOOGL) for AWS and Advertising benchmarking; Walmart (WMT) and Target (TGT) for North America retail benchmarking.
- Industry Data: Gartner and Synergy Research Group for cloud infrastructure market share; eMarketer for digital advertising market growth.
- Consensus Estimates: FactSet or Bloomberg for forward-looking analyst estimates on AWS growth and consolidated capital expenditures.
Sources
Do more with the Amazon model
Frequently asked
What is Amazon's core business model and how does it generate revenue?+
Amazon operates a hybrid ecosystem combining an asset-heavy retail and logistics network, a high-margin transaction tollbooth, a subscription model, and a capital-intensive technology platform. The company monetizes its vast customer base through retail sales, third-party seller fees, subscription services like Amazon Prime, and a rapidly growing digital advertising business, alongside its leading AWS cloud platform.
How does Amazon's cloud computing segment, AWS, contribute to its overall revenue?+
Amazon Web Services (AWS) is the leading cloud computing platform globally, representing approximately 18% of Amazon's total revenue. It operates as a capital-intensive, utility-like technology platform that competes directly with Microsoft Azure and Google Cloud. The company is heavily investing in AI infrastructure to drive further AWS growth.
What are Amazon's primary capital expenditure priorities, and how do they impact its financial model?+
Amazon's capital expenditures are primarily growth capex, heavily directed towards AI infrastructure, including Trainium and Inferentia chips, and data center expansion. Capex as a percentage of revenue is projected to surge to approximately 15% to 18% in 2025, with stated plans to invest over $100 billion annually in generative AI.
What are the key revenue growth drivers for Amazon's Online Stores segment?+
Revenue for Amazon's Online Stores segment is primarily driven by active customer accounts, average order value, and order frequency. Key growth levers include faster delivery speeds, which can drive higher conversion, though the segment faces headwinds from consumers trading down to discount competitors.
What is the purpose of the Amazon financial model, particularly concerning its valuation?+
The Amazon financial model projects the company's future free cash flow and a sum-of-the-parts equity valuation. Its main purpose is to determine whether the massive ongoing capital expenditure in artificial intelligence infrastructure will generate sufficient AWS and advertising growth to justify the current share price.
Is there an Excel financial model available for Amazon, and what is its forecast horizon?+
Yes, an Excel financial model for Amazon (AMZN) is available for download. This model provides detailed financial projections with a forecast horizon spanning from fiscal year 2026 through fiscal year 2030.
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 Marketplaces Company Financial Models
Browse another company in the same sector.
Copart
Copart is the global leader in online salvage vehicle auctions, connecting sellers (primarily auto insurance companies) with buyers (dismantlers, rebuilders, used car dealers, and exporters) through its proprietary online platform.
CoStar Group
CoStar Group is a leading global provider of online real estate marketplaces, information, analytics, and 3D digital twin technology for the commercial and residential property markets.
Carvana
Carvana operates an e-commerce platform for buying and selling used cars, offering a fully digital transaction experience, financing, and vehicle delivery or pickup via its automated vending machines.
DoorDash
DoorDash operates a local commerce platform that connects consumers with merchants and independent contractors (Dashers).
eBay
eBay operates a global e-commerce marketplace connecting millions of buyers and sellers, focusing on non-new, refurbished, and enthusiast categories such as collectibles, motors parts and accessories, luxury goods, and fashion.
Uber
Uber Technologies, Inc.
Explore more Consumer financial model templates.
