25.6.19
This website uses cookies to ensure you get the best experience on our website. Learn more

The Amazon Case Study

This advanced financial modeling course will teach you to: calculate Amazon's Total Addressable Market (TAM) for each business segment and determine the market share in each; use Amazon's actual financial statements (annual report, 10-k, 10-q, etc) to build a historical 3-statement model; learn how to structure an advanced valuation model in the most efficient way; set up all the assumptions and drivers required to build out the DCF model; create a 10-year forecast for Amazon's business, including an income statement, balance sheet, cash flow statement, supporting schedules, and free cash flow to the firm (FCFF); learn how to deal with advanced topics like segmented revenue, stock-based compensation, capital leases, and more; perform advanced comparable company analysis (Comps) using Capital IQ and PitchBook Data; perform a Sum-Of-The-Parts (SOTP) valuation of Amazon; generate multiple operating scenarios to explore a range of outcomes and values for the business; perform sensitivity analysis on key assumptions and assess the overall impact of the transaction.

Skills / Knowledge

  • Advanced Excel Formulas
  • Advanced Excel Function
  • Pivot Tables
  • Charts and Data Visualization

Issued on

August 11, 2020

Expires on

Does not expire