Advanced Financial Modeling & Valuation Course - Amazon AMZN

Overview

Advanced Financial Modeling & Valuation Course - Amazon

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.


Advanced financial modeling course (Amazon)


Advanced Financial Modeling Course Objectives

This advanced financial modeling course has several objectives including:

  • 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


Advanced DCF Model Course on Amazon


Amazon (AMZN) 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


Advanced valuation amazon case study


Why Take CFI's Advanced financial Modeling Course?

This course is perfect for anyone who wants to learn how to build a detailed financial model for a public company, from the bottom up.  The video-based lessons will teach you all the formulas and functions to calculate things like segmented revenue, marketable securities, accrued expenses, unearned revenue, additional paid-in capital, stock-based compensation, long-term debt, capital and finance leases, and much more.

In addition to learning the detailed mechanics of how to build the financial model for Amazon, students will also learn how to think about intrinsic value, internal rate of return (IRR), and weigh the pros and cons of an investment opportunity.

 

Advanced Financial Modeling and Valuation Course - Comps Table


What’s Included in the Advanced Modeling Course?

This advanced financial modeling and valuation course include all of the following:

  • Blank Amazon model template
  • Completed Amazon model template (dashboard, DCF model, Comps model, WACC analysis, scenarios, etc)
  • 5+ hours of detailed video instruction
  • Certificate of completion


Recommended Prerequisites

You are expected to have either completed the stated prerequisite course(s) or possess the equivalent knowledge prior to enroling in this course:

  1. Excel Crash Course
  2. Building a 3 Statement Financial Model
  3. Business Valuation Modeling


CFI advanced modeling amazon


Financial analyst certification

For beginners to advanced users, this advanced modeling course is designed to teach you how to be a world-class financial analyst. 

This class is one of the 9 required "Core" courses for CFI's financial analyst training program, which grants the Financial Modeling & Valuation Analyst (FMVA) certification.


Disclaimer

This course is intended solely for educational and training purposes. The information contained herein does not constitute investment advice, or an offer to sell, or the solicitation of any offer to buy any securities of Amazon.com, Inc. (NasdaqGS: AMZN) or any other security.

This content in this course has not been approved or disapproved by (a) Amazon.com, Inc., (b) S&P Global Market Intelligence Inc., (c) Pitchbook Data, Inc., (d) Morningstar, Inc., (e) any equity research analyst that covers Amazon.com, Inc., or (f) any securities regulator in any province or territory of Canada, the United States Securities and Exchange Commission or any other United States federal or state regulatory authority, and no such commission or authority has passed upon the merits, accuracy or adequacy of this content, nor is it intended that any will.

The information in this course does not constitute the provision of investment, tax, legal or other professional advice. As with all investments, there are associated risks and you could lose money investing – including, potentially, your entire investment. Prior to making any investment, a prospective investor should consult with its own investment, accounting, legal and tax advisers to evaluate independently the risks, consequences and suitability of that investment.

No reliance may be placed for any purpose on the information and opinions contained herein or their accuracy or completeness, and nothing contained herein may be relied upon in making any investment decision.

What You'll Learn

Lesson
Multimedia
Exams
Files

Advanced Financial Modeling & Valuation

$197.00 Enroll Now Free Preview

Approx 13.0 hrs to complete

Upgrade

From $847.00
CFI Full Immersion Bundle & FMVA® Certification
Buy Now
From $497.00
CFI Self-Study Bundle & FMVA® Certification
Buy Now

Path to Certification

Prerequisite Courses

6 courses from beginning to intermediate level.

01Optional

Core Courses

9 courses from beginning to intermediate level.

02Required

Elective Courses

Take 3 out of 8 courses at an advanced level.

03Required

Get Certified

Submit your FMVA®️ checklist and order your certificate.

04Required

Join Our Community

Get access to the Global Corporate Finance Society.

05Optional

How the Certification Works

FMVA® Financial Analyst Certification courses are offered 100% online, allowing you the flexibility to start the financial analyst program anytime and learn when it’s most convenient for you.
Students must complete all core and elective courses (12 in total) and demonstrate mastery of the topics through successful completion of course materials, quizzes, and assessments.
Within 48 hours of program completion, your Blockchain Verified FMVA Certification will be emailed to you.

What Our Students Say

Kaushik Agarwal
Has to be the most difficult course on the entire FMVA program.
This was the only course wherein time allotted seemed to be lower even if it was higher. A breakup of the course would be better - because even though the pre-requisites stated seemed enough - they weren't. The course content is phenomenal. 4 stars because the course was too fast-paced.
Marc-Olivier Caron
Course was good, until the final 2%
The pace of the course was good. A couple of good tips for efficiency. Not as in-depth as I would have liked it to be (for example, I would have liked a lot more time on Pro forma models and adjustments for capital structures). All-in-all, I was quite pleased with it until the last 2%, when I realized I had to redo entire models from scratch just to complete the last 2% of it. Did not finish the course for this very reason. I do not want to spend another 3 hours + redoing the exact same things I just did just so I can tick the box and say I have finished the course. It might be a good idea to create a version of the course for people who have no interest in the "certification" and just have a quick quiz to recap the material.
See More

Frequently Asked Questions

Can I download the Excel files and financial modeling templates?
How long do I have to complete the courses?
Are CFI courses verified?
Are there any additional fees or costs?
What currency are your courses priced in?
How do I earn my certificates?
Can I email the instructor if I have questions?
Will these courses help me advance my career?
More Questions?

FMVA® Financial Analyst Certification

Become a Financial Modeling and Valuation Analyst (FMVA)® by completing all required courses in accounting, finance, modeling, Excel, presentations, and strategy. From beginner to advanced courses you will have the complete training you need to become a world-class financial analyst.

Upgrade

From $847.00
CFI Full Immersion Bundle & FMVA® Certification
Buy Now
From $497.00
CFI Self-Study Bundle & FMVA® Certification
Buy Now