Overview
This Amazon Case Study - Advanced Business Valuation Model is built to value AMZN's businesses and determine its target share price from the bottom up by following these steps:
  1. Calculate Amazon's Total Addressable Market (TAM) for each business segment, and determine the market share in each
  2. Use Amazon's actual financial statements (annual report, 10-K, 10-Q, etc) to build a historical 3-statement model
  3. Set up all the assumptions and drivers required to build out the DCF model
  4. Create a 10-year forecast for Amazon's business, including the three financial statements, supporting schedules, and free cash flow to the firm (FCFF)
  5. Look at Amazon-specific line items such as segmented revenue, stock-based compensation, and capital leases
  6. Perform advanced comparable company analysis (Comps) using Capital IQ and PitchBook Data
  7. Perform a Sum-Of-The-Parts (SOTP) valuation of Amazon
  8. Generate multiple operating scenarios to explore a range of outcomes and values for the business
  9. Compute AMZN's intrinsic value and IRR under each scenario
  10. Perform sensitivity analysis on key assumptions and assess the overall impact of the transaction
What this AMZN model includes:
  • Raw data and historical analysis
  • Market size and TAM
  • Scenarios
  • DCF assumptions
  • Comps data
  • WACC analysis
  • Quarterly data and LTM data
  • Summary dashboard
This model is very useful for advanced financial modelers who are looking to perform financial modeling and valuation using real-world company like Amazon which has a more complex business structure and operates in different business segments.
Share
Reviews Add a review
Avatar
Christopher Kelley

This valuation model for Amazon is so detailed! Amazing work

More From Corporate Finance Institute®

Browse our top rated business templates. See All
Synthetic Call Chart Option Profit/Loss Graph Maker
347
189
This free Option Profit/Loss Graph Maker allows the user to combine up to ten different types of options as well…
Directional Trading Strategies Template Directional Trading Strategies Template
216
0
The directional trading strategies template allow users to determine the profit when buying options. This template focuses on directional strategies…
HELOC Calculator Template Home Equity Line of Credit (HELOC) Calculator
185
80
This home equity line of credit (HELOC) calculator can calculate the maximum amount of loan a homeowner is eligible to…
Levelized Cost of Energy (LCOE) Template Levelized Cost of Energy (LCOE) Template
1
278
105
The levelized cost of energy (LCOE), also referred to as the levelized energy cost (LEC) or the levelized cost of…
Bank Mixed Statement Ratio Calculator Bank Mixed Statement Ratio Calculator
151
53
The Bank Mixed Statement Ratio Calculator is a tool that you can use to determine a bank's profitability and financial…
Bank Income Statement Ratio Calculator Bank Income Statement Ratio Calculator
169
58
The Bank Income Statement Ratio Calculator is a tool that you can use to determine a bank's profitability, efficiency, and…