Practical Financial Modeling Bootcamp - building a model of Google | CorpFin Pro | Skillshare

Practical Financial Modeling Bootcamp - building a model of Google

CorpFin Pro

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
34 Lessons (12h 3m)
    • 1. Course preview

      1:17
    • 2. Part 1 - What is a financial model

      6:30
    • 3. Part 1 - Tips to make this course more efficient

      3:00
    • 4. Part 2 - Intro thoughts

      7:48
    • 5. Part 2 - Obtaining financials

      3:28
    • 6. Part 2 - OPTIONAL: Formatting

      35:50
    • 7. Part 2 - OPTIONAL: Useful shortcuts and tips in Microsoft Excel (Windows version)

      33:49
    • 8. Part 2 - OPTIONAL: Ways to structure a model

      22:40
    • 9. Part 2 - Understanding how companies operate

      8:48
    • 10. Part 2 - Revenue

      28:23
    • 11. Part 2 - Costs and expenses

      10:32
    • 12. Part 2 - Current assets

      25:31
    • 13. Part 2 - Non-current assets

      55:25
    • 14. Part 2 - Current liabilities

      35:57
    • 15. Part 2 - Non-current liabilities

      23:04
    • 16. Part 2 - Equity

      25:36
    • 17. Part 2 - Cash Flow From Operating Activities (CFO)

      18:34
    • 18. Part 2 - Cash Flow From Investing Activities (CFI)

      7:59
    • 19. Part 2 - Cash Flow From Financing Activities (CFF)

      5:42
    • 20. Part 2 - OPTIONAL: Mistakes

      20:10
    • 21. Part 2 - Finishing income statement

      8:22
    • 22. Part 2 - Switcher

      7:47
    • 23. Part 3 - Theoretical background and FCFF (1/2)

      27:29
    • 24. Part 3 - FCFF - continued (2/2)

      40:16
    • 25. Part 3 - FCFE

      11:02
    • 26. Part 4 - Revenue - detailed

      67:13
    • 27. Part 4 - Costs and expenses - detailed

      41:22
    • 28. Part 4 - Capex

      8:32
    • 29. Part 4 - Depreciation

      29:37
    • 30. Part 4 - Working capital

      6:49
    • 31. Part 4 - Income taxes

      14:22
    • 32. Part 4 - Debt and revolver

      46:21
    • 33. Part 4 - WACC

      31:36
    • 34. Next steps

      1:50

About This Class

Course 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 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.

Files used in the course

You can find files used in the process (excel files and a file with links to download financials) in the project section.

IMPORTANT: Iterative calculations should be turned on. Instruction is available on the official Microsoft Office Help page (https://support.office.com/en-gb/article/remove-or-allow-a-circular-reference-8540bd0f-6e97-4483-bcf7-1b49cd50d123). Go to the "Learn about iterative calculation" section and follow the steps outlined there.

Prior knowledge required

We expect you to have:

  1. Knowledge of Microsoft Excel
  2. Basic understanding of corporate finance

You can still take the course without the skills above. We'll try to explain things on the go. However, in this case, be prepared to spend additional time educating yourself too.

Applications required for financial modelling

You can use any spreadsheet application you would like to. We highly recommend Microsoft Excel (2007 version onwards) on a Windows machine since it is the most common set-up used for financial modelling. However, the model should work the same way on most other applications. It even works on Google Sheets (which do not require you to install an app locally on your machine, you can use a browser instead). But please beware that (i) some of the functionality of Microsoft Excel could be unavailable on Google Sheets, Apple Numbers, LibreOffice Calc and other packages, and (ii) the files created in the packages might not be fully cross-compatible. Thus, we recommend using Microsoft Excel when building a model for external use or review.

We will be using Microsoft Excel on a Windows machine, and all shortcuts and tips will be relevant for this set-up only.

Who is this course for

A wide range of people might be interested in gaining financial modelling skills. Below are some possible scenarios:

  • To make investment decisions for example whether to buy or sell stocks of a particular company
  • To support your assumptions on a project or justify a business case
  • While starting a new business to estimate the financial results of a venture
  • In your existing startup - for fundraising objectives. Most investors will require a financial model as a part of your fundraising pack to better understand how you plan to make money, etc.

Knowledge of financial modelling is instrumental:

  • When pursuing a degree in business or finance
  • For your job interviews especially in the financial industry

"Disclaimers"

IMPORTANT: Please note that this course is not optimized/designed to be watched on small screens (e.g. mobile phones)

While this course covers all main financial modelling topics, it is not a comprehensive guide. We are going to cover most topics in detail. However, there are some things which will be modelled only high-level. The reason for this is that you need a lot of information (which is usually not available) to model such items. All such topics are in the vast majority of cases modelled high-level as we do in this course. We'll demonstrate that brokers are also using the same approach later in the course. These topics are taxes, stock-based compensation, goodwill, minority interest, associates, and some other. In some instances, people model these advanced topics in greater detail. Still, usually, such calculations are possible when you have access to non-public company information, e.g. you are working on a deal.

Like every human, we make mistakes when we speak or type. However, these are not critical things, they do not change the messages, and most people won't even notice them.

We followed the 80/20 rule when we were preparing this course (this is an excellent way to fight the natural desire to improve things continuously). We have not polished every single thing (e.g. change wording, take out every parasite words, clear sound like "aaa", "mmm"). Instead, we have left most of the course in the way we have recorded it the first time with some minor edits (e.g. taking out pauses). Polishing would take so much time that developing this course would become unreasonable for us. Moreover, it would not add any real value. Also, we think for most people, it would be easier to understand the content of the course in the shape and form we have recorded it initially. Usually, it is easier to digest unpolished (natural) content.

When you watch the videos, the screen might change rapidly since we move between the pages. If you are lost, it might make sense to have a look at the bottom of the workbook - the active worksheet is always highlighted. Please also note that you can change the speed of the video. We tried to speak slowly to make it easier to digest the information for some readers, but many people prefer more dynamic videos, in such cases, you can increase the playback speed to 1.25x or 1.5x. At higher speeds (1.75x+), the videos might sound a bit "robotic".