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

The Amazon Case Study

Colin Sparke MBA MRAeS

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

December 18, 2020

Expires on

Does not expire