Amazon.com, Inc. (AMZN) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Amazon.com, Inc. (AMZN) Bundle
Engineered for accuracy, our (AMZN) DCF Calculator enables you to evaluate Amazon.com, Inc. valuation using real-world financial data and offers complete flexibility to modify all essential parameters for improved projections.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
AY5 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 280,522.0 | 386,064.0 | 469,822.0 | 513,983.0 | 574,785.0 | 690,529.3 | 829,581.0 | 996,633.5 | 1,197,325.3 | 1,438,430.3 |
| Revenue Growth, % | 0 | 37.62 | 21.7 | 9.4 | 11.83 | 20.14 | 20.14 | 20.14 | 20.14 | 20.14 |
| EBITDA | 37,365.0 | 51,005.0 | 74,393.0 | 38,352.0 | 89,402.0 | 90,295.5 | 108,478.3 | 130,322.5 | 156,565.5 | 188,093.1 |
| EBITDA, % | 13.32 | 13.21 | 15.83 | 7.46 | 15.55 | 13.08 | 13.08 | 13.08 | 13.08 | 13.08 |
| Depreciation | 21,789.0 | 25,180.0 | 34,433.0 | 41,921.0 | 48,663.0 | 52,812.9 | 63,447.8 | 76,224.3 | 91,573.6 | 110,013.7 |
| Depreciation, % | 7.77 | 6.52 | 7.33 | 8.16 | 8.47 | 7.65 | 7.65 | 7.65 | 7.65 | 7.65 |
| EBIT | 15,576.0 | 25,825.0 | 39,960.0 | -3,569.0 | 40,739.0 | 37,482.6 | 45,030.4 | 54,098.2 | 64,991.9 | 78,079.4 |
| EBIT, % | 5.55 | 6.69 | 8.51 | -0.69438 | 7.09 | 5.43 | 5.43 | 5.43 | 5.43 | 5.43 |
| Total Cash | 55,021.0 | 84,396.0 | 96,049.0 | 70,026.0 | 86,780.0 | 125,179.3 | 150,386.6 | 180,670.0 | 217,051.4 | 260,759.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 20,816.0 | 24,542.0 | 32,891.0 | 42,360.0 | 52,253.0 | 52,632.9 | 63,231.6 | 75,964.5 | 91,261.5 | 109,638.8 |
| Account Receivables, % | 7.42 | 6.36 | 7 | 8.24 | 9.09 | 7.62 | 7.62 | 7.62 | 7.62 | 7.62 |
| Inventories | 20,497.0 | 23,795.0 | 32,640.0 | 34,405.0 | 33,318.0 | 45,447.8 | 54,599.6 | 65,594.3 | 78,803.0 | 94,671.5 |
| Inventories, % | 7.31 | 6.16 | 6.95 | 6.69 | 5.8 | 6.58 | 6.58 | 6.58 | 6.58 | 6.58 |
| Accounts Payable | 47,183.0 | 72,539.0 | 78,664.0 | 79,600.0 | 84,981.0 | 114,108.8 | 137,086.9 | 164,692.0 | 197,856.0 | 237,698.2 |
| Accounts Payable, % | 16.82 | 18.79 | 16.74 | 15.49 | 14.78 | 16.52 | 16.52 | 16.52 | 16.52 | 16.52 |
| Capital Expenditure | -16,861.0 | -40,140.0 | -61,053.0 | -63,645.0 | -52,729.0 | -70,377.6 | -84,549.5 | -101,575.2 | -122,029.3 | -146,602.3 |
| Capital Expenditure, % | -6.01 | -10.4 | -12.99 | -12.38 | -9.17 | -10.19 | -10.19 | -10.19 | -10.19 | -10.19 |
| Tax Rate, % | 18.99 | 18.99 | 18.99 | 18.99 | 18.99 | 18.99 | 18.99 | 18.99 | 18.99 | 18.99 |
| EBITAT | 12,914.6 | 22,784.1 | 34,946.0 | -1,636.6 | 33,002.7 | 28,895.8 | 34,714.6 | 41,705.1 | 50,103.2 | 60,192.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 23,712.6 | 26,156.1 | -2,743.0 | -33,658.6 | 25,511.7 | 27,949.3 | 16,840.5 | 20,231.7 | 24,305.8 | 29,200.2 |
| WACC, % | 9.52 | 9.54 | 9.53 | 9.43 | 9.52 | 9.51 | 9.51 | 9.51 | 9.51 | 9.51 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 90,415.3 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 30,368 | |||||||||
| Terminal Value | 551,342 | |||||||||
| Present Terminal Value | 350,099 | |||||||||
| Enterprise Value | 440,515 | |||||||||
| Net Debt | 62,224 | |||||||||
| Equity Value | 378,291 | |||||||||
| Diluted Shares Outstanding, MM | 10,492 | |||||||||
| Equity Value Per Share | 36.06 |
What You Will Get
- Real Amazon Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Amazon.com, Inc. (AMZN).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates tailored for Amazon.com, Inc. (AMZN).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Amazon.com, Inc. (AMZN)’s fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and detailed projections specific to Amazon.com, Inc. (AMZN).
- Time-Saving and Accurate: Skip building models from scratch while ensuring precision and flexibility for Amazon.com, Inc. (AMZN).
Key Features
- Real-Life AMZN Data: Pre-filled with Amazon’s historical financials and forward-looking projections.
- Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
- Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes.
- User-Friendly Design: Simple, structured, and designed for professionals and beginners alike.
How It Works
- Download the Template: Gain immediate access to the Excel-based AMZN DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically recalculates Amazon’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation shifts.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial analysis.
Why Choose This Calculator for Amazon.com, Inc. (AMZN)?
- All-in-One Solution: Features DCF, WACC, and a variety of financial ratio analyses tailored for AMZN.
- Flexible Inputs: Modify the highlighted cells to explore different financial scenarios for Amazon.
- In-Depth Analysis: Automatically computes Amazon's intrinsic value and Net Present Value.
- Data-Rich Environment: Comes with historical and projected data for precise analysis.
- Expert-Level Utility: Perfect for financial analysts, investors, and business consultants focused on AMZN.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for portfolio assessment of Amazon.com, Inc. (AMZN).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Amazon.com, Inc. (AMZN).
- Students and Educators: Utilize real-time data to enhance learning and practice in financial modeling.
- Tech Enthusiasts: Gain insights into the valuation methodologies applied to tech giants like Amazon.com, Inc. (AMZN).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Amazon.com, Inc. (AMZN) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Amazon.com, Inc. (AMZN).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.