Advanced Financial Modeling & Valuation (Amazon)- On-demand

Advanced Financial Modeling & Valuation (Amazon)- On-demand
CFI is a global provider of online financial training courses with a focus on practical applications. Most courses involve hands on Excel tutorials, which take participants beyond the theory to develop job-based skills. All participants are automatically issued certificates of completion after successfully finishing each course. The price of the course varies and are based on a function of a few criteria including, (1) their duration (CPD hours), (2) level of difficulty, and (3) demand for the topic.


EL19200001

Welcome to CFI's advanced financial modeling course - a case study on how to value Amazon.com, Inc (AMZN).  This course is designed for professionals working in investment banking, corporate development, private equity, and other areas of corporate finance that deal with valuing companies and performing advanced methods of valuation.

LEARNING OBJECTIVES
By completing this strategy course, you'll be able 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

AMAZON CASE STUDY

This course is built on a case study of Amazon, where students are tasked with building a financial modeling and performing comparable company analysis to value AMZN shares.

Through the course of the transaction, students will learn:

  • How equity research analysts value the company (including looking at an actual report from Morningstar)
  • How to find comparable companies in Capital IQ and PitchBook Data, as well as how to export their financial information
  • How to handle advanced accounting topics like capital leases (treated as debt) and stock-based compensation (a non-cash expense that's dilutive)
  • How to create a dashboard and summary output that highlights the most important information from the model

1 Passport Day Plus $100 - 8 PD Hours

When
4/1/2019 - 3/31/2020
Where
On-line