Practical Financial Modeling Bootcamp - modeling Google
- 12 hours on-demand video
- 10 articles
- 31 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- 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.)
- 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)
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.
- 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