Practical Financial Modeling Bootcamp - modeling Google
4.4 (27 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
121 students enrolled

Practical Financial Modeling Bootcamp - modeling Google

Learn how DCF financial models are built at investment banks and funds
4.4 (27 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
121 students enrolled
Created by CorpFin Pro
Last updated 3/2020
English
English [Auto]
Current price: $12.99 Original price: $19.99 Discount: 35% off
1 day left at this price!
30-Day Money-Back Guarantee
This course includes
  • 12 hours on-demand video
  • 10 articles
  • 31 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • How to build a proper financial model: operating model and full three statements
  • DCF valuation of a company using both FCFF and FCFE approaches
  • Corporate finance: both theoretical and practical concepts
  • Common practices in financial modelling (sensitivity analysis, scenarios, frequently used shortcuts and tools, etc.)
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)
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.

Who this course is for:
  • People interested in finance
  • People pursuing career in finance
  • People who want to learn new skills
  • People who are interested in building a financial model for fundraising or for investment decisions
Course content
Expand all 43 lectures 12:11:01
+ Building a three statement model
21 lectures 06:27:15
Intro thoughts
07:48
Files to use and watching tips
01:39
Obtaining financials
03:28
OPTIONAL: Formatting
35:50
OPTIONAL: Useful shortcuts and tips in Microsoft Excel (Windows version)
33:49
OPTIONAL: Ways to structure a model
22:40
Understanding how companies operate
08:48
Revenue
28:23
Costs and expenses
10:32
Current assets
25:31
Non-current assets
55:25
Current liabilities
35:57
Equity
25:36
Cash Flow From Operating Activities (CFO)
18:34
Cash Flow From Investing Activities (CFI)
07:59
Cash Flow From Financing Activities (CFF)
05:42
Iterative calculations - Microsoft Excel
00:11
OPTIONAL: Mistakes
20:10
Finishing income statement
08:22
Switcher
07:47
+ DCF valuation
3 lectures 01:18:47
Theoretical background and FCFF - part 1
27:29
FCFF - part 2
40:16
FCFE
11:02
+ Enhancing our projections
9 lectures 04:07:29
Revenue
01:07:13
Costs and expenses
41:22
Capex
08:32
Depreciation
29:37
Income taxes
14:22
Debt and revolver
46:21
WACC
31:36
Integrated version of the model
01:37
+ Additional materials (OPTIONAL)
1 lecture 00:37
Changes in lease reporting and impact on valuation
00:37