Financial Statements Modeling - Amazon

Overview From 2021 to 2023, Amazon.com, Inc. transitioned from a period of rapid expansion and pandemic-driven demand toward a more disciplined and profitable operating model. The company continued to scale its e-commerce, cloud computing, advertising, and subscription businesses while improving efficiency across its operations. Amazon Web Services (AWS) remained a major contributor to profitability, while the company's retail business continued to generate the majority of revenue. Amazon also maintained significant investment in fulfillment infrastructure, technology, and data centers, resulting in substantial capital expenditures and depreciation. Financially, Amazon provides a useful example of a large, growing technology company with significant operating investments and complex cash flows. The model captures the relationship between profitability, working capital, capital expenditures, depreciation, debt, stock-based compensation, and cash generation. For analysts building a 3-statement model, Amazon is a useful example of a large technology company with: Strong revenue growth supported by multiple business lines Significant investment in infrastructure and technology High capital expenditures and corresponding depreciation Substantial operating cash flow generated from a large-scale business Complex relationships between operating performance, working capital, and cash balances This exercise uses 2021–2023 historical financials and projects 2024–2028. It teaches how to build an integrated 3-statement model, forecast operating performance and working capital, construct supporting schedules, and connect operating and financing assumptions to the balance sheet and cash flow statement. Learning Goals Build an integrated 3-statement financial model using 2021–2023 historical data and 2024–2028 projections. Forecast key revenue drivers, margins, and operating costs to derive profitability metrics. Create and link supporting schedules for D&A, interest income & expense, PP&E, debt, and retained earnings. Model working capital changes and translate them into operating cash flows. Model capital expenditures and depreciation to connect the PP&E schedule across the three financial statements. Reconcile cash balances so that ending cash from the Cash Flow Statement matches the Balance Sheet. Key Concepts Revenue & Gross Margin: Using growth rates and margins to project top-line performance. Cost of Revenue (COGS) and Operating Expenses: Forecasting cost of sales, R&D, and SG&A as a percentage of revenue. Gross Profit, EBITDA, EBIT, EBT, and Net Income: Understanding how operating and non-operating items flow through the Income Statement. Working Capital Dynamics: Projecting accounts receivable, inventory, accounts payable, and other operating liabilities and translating their changes into cash flow. Non-Cash Adjustments: Incorporating depreciation, amortization, and stock-based compensation into cash flow modeling. Investing Activities: Modeling capital expenditures, PP&E additions, and other long-term asset changes. Financing Activities: Capturing debt repayments, revolver activity, and share repurchases. Retained Earnings and Stockholders’ Equity: Linking net income, dividends, stock-based compensation, and share repurchases to equity balances. Balance Sheet Identity: Ensuring assets equal liabilities plus equity after all projections.

Practice Financial Statements Modeling - Amazon with interactive Excel modeling exercises in our Financial Statement Modeling module.

This hands-on modeling exercise helps you master Financial Statements Modeling - Amazon through real-world Excel practice and financial modeling techniques.