Practical Financial Modeling Bootcamp - modeling Google
- 4.9
-
![]()
![]()
![]()
![]()
![]()
Brief Introduction
Learn how DCF financial models are built at investment banks and fundsDescription
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)
CorpFin Pro
4.9 Raiting
MBA -The Business fundamentals + 30 hrs of business concepts
- 4.2
-
![]()
![]()
![]()
![]()
![]()
+ 30 hrs , This MBA course is designed to enhance your Business knowledge & learn the foundation concepts of businesses...
The Complete Financial Analyst Training & Investing Course
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Succeed as a Financial Analyst &Investor by Award Winning MBA Prof who worked @Goldman, in Hedge Funds & Venture Capital ...
Practical Financial Modeling Bootcamp - modeling Google
- 4.9
-
![]()
![]()
![]()
![]()
![]()
Learn how DCF financial models are built at investment banks and funds We believe that practice is the best way to learn....
Data Manipulation at Scale: Systems and Algorithms
- 4.3
-
![]()
![]()
![]()
![]()
![]()
Data analysis has replaced data acquisition as the bottleneck to evidence-based decision making --- we are drowning in it. At the end of this course, you will be able to:...
