Amazon Case Study - Advanced Business Valuation Excel Model
  • Amazon Case Study - Advanced Business Valuation Excel Model
  • Amazon Case Study - Advanced Business Valuation Excel Model
  • Amazon Case Study - Advanced Business Valuation Excel Model
  • Amazon Case Study - Advanced Business Valuation Excel Model
  • Amazon Case Study - Advanced Business Valuation Excel Model
  • Amazon Case Study - Advanced Business Valuation Excel Model
  • Amazon Case Study - Advanced Business Valuation Excel Model
  • Amazon Case Study - Advanced Business Valuation Excel Model
  • Amazon Case Study - Advanced Business Valuation Excel Model
  • Amazon Case Study - Advanced Business Valuation Excel Model
  • Amazon Case Study - Advanced Business Valuation Excel Model
  • Amazon Case Study - Advanced Business Valuation Excel Model
  • Amazon Case Study - Advanced Business Valuation Excel Model
  • Amazon Case Study - Advanced Business Valuation Excel Model
  • Amazon Case Study - Advanced Business Valuation Excel Model
  • Amazon Case Study - Advanced Business Valuation Excel Model
  • Amazon Case Study - Advanced Business Valuation Excel Model
  • Amazon Case Study - Advanced Business Valuation Excel Model
  • Amazon Case Study - Advanced Business Valuation Excel Model
  • Amazon Case Study - Advanced Business Valuation Excel Model
  • Amazon Case Study - Advanced Business Valuation Excel Model
  • Amazon Case Study - Advanced Business Valuation Excel Model
  • Amazon Case Study - Advanced Business Valuation Excel Model
  • Amazon Case Study - Advanced Business Valuation Excel Model
  • Amazon Case Study - Advanced Business Valuation Excel Model
  • Amazon Case Study - Advanced Business Valuation Excel Model
Originally published: 16/01/2019 09:19
Last version published: 15/02/2019 21:30
Publication number: ELQ-25548-2
View all versions & Certificate
certified

Amazon Case Study - Advanced Business Valuation Excel Model

Value Amazon's target share price using DCF analysis, comps analysis, WACC, and more

Description
This Amazon 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.

This business tool includes
1 Amazon Excel Model

Acquire business license for $197.00

Add to cart

Add to bookmarks

Discuss

Reviews

  • No review yet!

keyboard_arrow_leftkeyboard_arrow_right

More tools from CFI

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Amazon Case Study - Advanced Business Valuation Excel Model?

The user community and author are here to help. Go ahead!

please wait...