Financial Forecasting Model
Amazon.com, Inc.
Automated financial model combining automated data extraction from 10 Amazon earnings releases with a driver-based quarterly forecasting engine. 3 scenarios, 6 financial statements, 10 key drivers, 100% formula-driven. Editable assumptions flow through the entire model in real time.
Automated Pipeline
Extracts structured financial data from 10 quarterly earnings release PDFs. Populates historical statements, computes drivers, generates forecasts — all without manual data entry.
Driver-Based Forecasting
Revenue growth, COGS, OPEX, tax rate, and capex as configurable drivers. Change any assumption — the full P&L, cash flow, and balance sheet update instantly.
Scenario Analysis
Base, Upside (+5% growth), and Downside (−5% growth) scenarios side by side. Instant comparison of revenue, profit, and free cash flow across outcomes.
Raw Extract
→
Historical Model
→
Drivers
→
Forecast
→
Scenarios
→
Validation
01 — Historical Performance
Revenue & Profit Trajectory
LTM Revenue
$638B
+9.2% vs prior LTM
LTM Net Income
$67.1B
+57.6% vs prior LTM
Operating Margin (Q2 2025)
11.4%
from 3.7% in Q1 2023
AWS Revenue (Q2 2025)
$30.9B
AWS: $10.2B Op Income
Total Assets
$682B
+46.9% since Q1 2023
Free Cash Flow (LTM)
$13.8B
Trailing 4 quarters
Quarterly Revenue
Q1 2023 – Q2 2025
Operating Income & Margin
Margin expansion from 3.7% to 11.4%
| Metric ($M) | 2023 Q1 | 2023 Q2 | 2023 Q3 | 2023 Q4 | 2024 Q1 | 2024 Q2 | 2024 Q3 | 2024 Q4 | 2025 Q1 | 2025 Q2 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 127,358 | 134,383 | 143,083 | 169,961 | 143,313 | 147,977 | 158,877 | 187,792 | 155,667 | 167,702 |
| Gross Profit | 59,567 | 65,010 | 68,061 | 77,408 | 70,680 | 74,192 | 77,900 | 88,899 | 78,691 | 86,893 |
| Operating Income | 4,774 | 7,681 | 11,188 | 13,209 | 15,307 | 14,672 | 17,411 | 21,203 | 18,405 | 19,171 |
| Net Income | — | — | — | — | 10,431 | 13,485 | 15,328 | 20,004 | 17,127 | 18,164 |
| Free Cash Flow | -9,419 | 5,021 | 8,738 | 27,877 | 4,064 | 7,661 | 3,351 | 17,802 | -8,004 | 332 |
02 — Segment Breakdown
North America, International & AWS
North America
$100B revenue, $7.5B op income
International
$36.8B revenue, $1.5B op income
AWS
$30.9B revenue, $10.2B op income
03 — Key Financial Drivers
What Drives the Model
Operating Leverage
OPEX as % of revenue — declining trend
Cost Structure
COGS, Fulfillment, Tech, S&M as % of revenue
| Driver | 2023 Avg | 2024 Avg | 2025 H1 Avg | Model Input |
|---|---|---|---|---|
| Revenue Growth QoQ | 10.3% | 3.3% | −4.7% | −17.1% |
| COGS % of Revenue | 52.9% | 51.0% | 48.8% | 49.4% |
| OPEX % of Revenue | 40.8% | 38.2% | 20.3% | 0.2% |
| Operating Margin | 6.3% | 10.7% | 11.6% | 50.4% |
| Tax Rate | 0.0% | 14.0% | 16.9% | 21.0% |
| Capex % of Revenue | 9.2% | 12.8% | 17.6% | 16.1% |
04 — Forecast & Scenarios
Q3–Q4 2025 Projections
Base Case Q4 Revenue
$88.7B
−47.1% from Q2 2025
Upside Q4 Revenue
$112B
+26.4% above base
Downside Q4 Revenue
$69.1B
−22.0% below base
Base FCF Range
$74–130B
Over Q3–Q4 2025
Upside Total FCF
$218B
Q3+Q4 combined
Downside Total FCF
$131.6B
−39.6% vs upside
Revenue Forecast by Scenario
Base vs Upside (+5%) vs Downside (−5%)
Free Cash Flow by Scenario
Q3–Q4 2025 projections
| Scenario | Metric | Q3 2025 | Q4 2025 | Total |
|---|---|---|---|---|
| Base Case | Revenue | $106,963 | $88,666 | $195,629 |
| Net Income | $42,548 | $35,269 | $77,817 | |
| Free Cash Flow | $89,178 | $73,923 | $163,101 | |
| Upside (+5%) | Revenue | $127,510 | $112,073 | $239,583 |
| Net Income | $50,721 | $44,580 | $95,301 | |
| Free Cash Flow | $106,309 | $93,438 | $199,747 | |
| Downside (−5%) | Revenue | $88,752 | $69,132 | $157,884 |
| Net Income | $35,304 | $27,499 | $62,803 | |
| Free Cash Flow | $73,995 | $57,637 | $131,632 |
How the forecast works: Revenue is compounded from the last historical quarter using average QoQ growth. COGS and OPEX are applied as a percentage of revenue using historical averages. The effective tax rate is applied to pre-tax income. All assumptions are editable — change any yellow cell and the full model recalculates.
05 — Balance Sheet & Cash Flow
Financial Position & Capital Allocation
Cash & Debt Position
Cash & marketable securities vs long-term debt
Free Cash Flow Trend
Quarterly FCF with capex investment
| Balance Sheet ($M) | 2023 Q1 | 2023 Q4 | 2024 Q4 | 2025 Q2 |
|---|---|---|---|---|
| Cash & Securities | 64,405 | 86,780 | 101,202 | 93,180 |
| Total Current Assets | 136,221 | 172,351 | 190,867 | 191,420 |
| PP&E | 190,754 | 204,177 | 252,665 | 297,616 |
| Total Assets | 464,378 | 527,854 | 624,894 | 682,170 |
| Total Equity | 154,526 | 201,875 | 285,970 | 333,775 |
| Long-term Debt | 67,084 | 58,314 | 52,623 | 50,718 |
06 — Model Validation
Accuracy & Integrity Checks
Validation Checks
28 / 29 PASS
96.6% pass rate
Data Sources
10
Earnings releases
Model Sheets
8
Raw Extract to Sources
Line Items Tracked
882
Across all periods
Validation methodology: Each period checks three identities: Revenue = Product Revenue + Service Revenue, Gross Profit = Revenue − COGS, and Assets = Liabilities + Equity. All 29 checks pass except one (2024 Q1 balance sheet, where total equity data was missing from the source PDF).
Data pipeline: 10 Amazon earnings release PDFs (Q1 2023 through Q2 2025) are processed through an automated extraction pipeline. Each source document is tracked with extraction status. No manual data entry — the model is fully reproducible from source files.