Explore

Practical Financial Modeling Bootcamp - modeling Google

12 hours on-demand video

$ 12.99

Save Course

Go to Course

Brief Introduction

Learn how DCF financial models are built at investment banks and funds

Description

We believe that practice is the best way to learn. That is why we have created a practical course to help you to learn financial modelling from scratch (or improve your skills).

In this course, we are going to build a financial model of Alphabet, a parent company of Google. We aim to show how financial models are created at the leading financial institutions. That is why we have decided to pick up a real company and prepare a proper financial model, i.e. not the simplified version as most of the other courses do.

We understand the challenges of building full-blown models from scratch for people who have little experience in the field. That is why we have decided to split the course into three substantial parts:

1) In the first stage, we are going to prepare a three statement model. We'll start by downloading the financials of Alphabet. Then step-by-step, we'll show how forecasts are built for every line in each financial statement. We'll use the format in which Alphabet reports, not a simplified version. In order not to confuse you at this stage, for some metrics (e.g. revenue), we are going to use broker consensus forecasts. We'll come back to such metrics later in the course

2) In the second stage, we are going to build a DCF valuation using both FCFF and FCFE approaches. We'll base our DCF valuation on the three-statement model we have developed on the first stage

3) After we finish our DCF valuation, we'll enhance our forecasts. We are going to replace the metrics for which we used broker consensus with our estimates. This way, the course participants will be able to focus first on the three-statement model and then on building forecasts. We think that such streamlining will make the process much more efficient.

Along the way, we'll describe some corporate finance concepts as well as common practices used in the industry.

We hope that you'll enjoy the course, and after taking it, you will be able to build full-blown models yourself.

We try to be fully transparent. That is why we ask you to review the contents of the course before you purchase it (especially the lecture called "Before you buy this course").

Also, don't forget about Udemy's 30-Day Money-Back Guarantee if you don't like the course.

Thank you for your interest and hope to see you soon.

Requirements

Requirements
Desire to learn new skills
Basic understanding of corporate finance (or ability to learn on the go)
Basic knowledge of Microsoft Excel (or ability to learn on the go)

Recommended for you

TensorFlow: Artificial Intelligence with TensorFlow: 3-in-1

Begin your journey to build next-generation AI models from scratch with TensorFlow and create your own machine learning Contents and Overview...

Save Course

Logistic Regression in R Studio

Logistic regression in R Studio tutorial for beginners. You can do Predictive modeling using R Studio after this course. After completing this course, you will be able to:...

Save Course