The Complete Financial Model Builder Course-Build 7 Models

Learn all the tools you need to build financial models by building 7 different financial models.
4.1 (14 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
138 students enrolled
Instructed by Andrew de Bruyn Business / Finance
$19
$75
75% off
Take This Course
  • Lectures 88
  • Length 9 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2015 English

Course Description

My name is Andrew, and I am the creator the the Complete Financial Model Builder Course.

I have over 2 financial degrees and over 20 years' financial experience. I have always enjoyed financial modelling, and I want to share my knowledge with you.

I have taken a different approach to other courses in financial models; I go through 7 models in order to teach a range of model building skills.

We go through 7 financial models:

  1. Financial Model Basics - you learn the basics of financial models
  2. Beyond The Basics - best practice, working capital, balance sheets and cash flows
  3. Debt Equity Model - equity calculations and debt calculations incorporated into a model
  4. Investment Scenario Model - a model for investments that includes multiple scenarios
  5. Corporate Scenario Model - a full corporate model that incorporates multiple scenarios
  6. Capital Investment Appraisal Model - a model for evaluating a capital investment
  7. Pricing Model - a model for determining optimum pricing to customers.

We go through many different company types: Pet Food Wholesaler, Clothing Wholesaler, Chemical Manufacturer, Investment Fund, Platinum Mine,Electricity Provider and an Office Equipment Company.

If you are a

  • business owner
  • manager
  • finance professional or
  • business student

and want to learn all-round financial model building skills, then this course is for you.

By the end of the course, you will be able to

  • build accurate models
  • understand all essential Excel formulas and functions for financial models
  • create flexible models for multiple scenarios
  • adapt your skills to a variety of industries and requirements.

In summary, this is one of the best value-for-money courses on financial models.
Hope to have you as a student soon.
Regards

Andrew

What are the requirements?

  • You need basic Excel skills - you don't need advanced skills, but you need to know the basics
  • Basic accounting/business concept understanding - high school business studies or accounting should suffice.

What am I going to get from this course?

  • Create complete financial models from start to finish
  • Understand all essential financial formulas
  • Develop flexible models that look at multiple scenarios
  • Create models for a variety of industries and business types

What is the target audience?

  • This course is meant for business owners, business managers and students of business/finance, who would like a thorough grounding in building financial models.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: How to Use this Course
01:14

How to use this course and get the most out of it.

Section 2: Financial Model Basics
05:00

An introduction to financial modelling - definition, its benefits and the users of models

03:42

Guidelines for financial modelling - structure, format and the process to be followed in building models

04:50

The first step in building the model is analysing historical data so we can determine the key ratios.

We analyse the historical data we received, using the SUMIF formula, which allows us to summarise data using a category.

07:31

We continue to analyse historical data, this time using two categories with the SUMIFS formula.

05:47

Once we have summarised historical information, we can determine the key ratios we are going to use to build the financial model.

07:24

Once we have decided on the key ratios, we can start building the first sheet in the model, the input sheet.

07:43

After the input sheet is created, we can create the calculation sheet.

03:19

The last section in a model is the output section. The most common output is a profit and loss statement.

04:50

We analyse the outputs of our financial model for two main reasons:

  • to detect and correct errors in the model
  • to report on the outcome of financial decisions; we need to report on the future financial effect of business decisions, which is the main purpose of building models.
06:10

A sensitivity table is a very useful tool to see how sensitive the model's outputs are to a change in inputs.

02:45

In this lecture, I challenge you to build your own model, using what you've learned so far.

Section 3: Beyond the Basics
06:46

Introduction to Name Ranges - what they are and how they improve our models.

08:15

Learn to build the Input Sheet using Name Ranges.

06:25

We continue with Name Ranges and build the Calculation Sheet.

08:07

We build the Output Sheet with Name Ranges.

04:09

An introduction to Working Capital - explanation and basic calculations.

05:02

We start by including inputs and name ranges for working capital.

04:38

The next step is adding working capital calculations into the calculation sheet.

02:54

An introduction to balance sheets for financial models.

09:03

The next step in our modelling process is to build the balance sheet.

04:57

We learn how to format cells based on conditions that we specify. This highlight errors in the input sheet and also makes the output sheet highlight trends or performance against target.

02:10

An introduction to modelling cash flow, especially working capital.

07:15

Learn to build the cash flow statement calculations.

02:44

We complete the output sheet - adding the balance sheet and cash flow statement.

02:54

The IF..THEN function is one of the most useful functions in Excel for financial models. Here we learn a basic use of the function.

05:12

Data validation is a way of restricting the range of data a user can input. This makes model inputs less likely to have errors and makes the model more professional.

04:24

Protecting the sheets to prevent users from altering the structure, calculations and outputs of the model.

06:31

To end this section of the course, I give you a challenge and go through it with you.

Section 4: Debt Equity Model
03:37

An introduction to Victoria Additives and the key ratios and assumptions we will use.

05:12

We start to build the input sheet for the debt equity model

03:03

We continue with the input sheet for the Victoria Additives debt equity model.

02:39

We add the name ranges to the input sheet for the Victoria Additives model.

07:35

How to create a debt table - what inputs are needed, how to use the payment formula and what links to create.

05:27

We go over a plant & equipment calculation table, including depreciation, and how the table needs to link into the other sections of the model.

04:21

An overview of the main equity calculations for a financial model.

07:26

We add the equity calculation tables for share values, number of shares and the accumulated profit table to the calculation sheet.

08:24

We now build the balance sheet, using the input sheet and the calculations done so far.

13:21

Building the Cash Flow for our Debt Equity model.

04:03

How to audit and check formulas, particularly in the calculation sheet.

06:28

I give you a challenge to fix the balance sheet, then I go through the solution with you.

09:33

We build the output sheet for Victoria Additives and answer the questions at the beginning of the course.

09:28

I give you a challenge of building a summary balance sheet and cash flow statement, then go through the solution with you

05:30

We add debt ratios and covenant calculations to the model.

07:51

We add 3 ratios to the calculation sheet and output sheet and then do a comparison to a covenant ratio.

06:19

Adding dividend payments to the model.

10:59

An outline of WACC and adding the calculation to the model.

03:46

An introduction to share buy backs and how they can be included in a financial model.

08:08

We go through the calculations for share buy backs in the Victoria Additives model.

04:59

I challenge you to build a WACC table and then go through the exercise with you.

Section 5: Scenario Model
02:50

An introduction to scenario models. We go through Streethill Investment's requirements for an equity portfolio model, with multiple scenarios in the model.

05:43

We add the input sheet to the Scenario Model

05:55

We continue with the building of the input sheet for the Scenario Model.

03:20

We build the calculation sheet for our Scenario Model, Streethill Investments.

04:23

Learn how to insert a drop down menu box (a combo box) that users can use to select different options. We insert this into the output sheet, so that the users can select different scenarios.

04:57

We complete the calculation and output sheets

09:25

We use the Scenario Model to create a table of portfolio values for the High, Medium and Low scenarios, choosing different investment weightings.

Section 6: Corporate Scenario Model
07:13

This is an introduction to Rhino Platinum, our model platinum mining company, and the outline of the model we wish to build in this section.

10:16

We start building the Input Sheet for the Rhino Platinum financial model.

12:42

We continue to build the Input Sheet for Rhino Platinum.

06:23

I challenge you to insert an IF..THEN error message if the input balance sheet does not balance, as well as set up conditional formatting and data validation. I then go through the solution.

07:29

I challenge you to add a drop-down menu box to the output sheet and link it to the calculation sheet. I go through the solution step by step.

07:51

We continue with the calculation sheet and set out the income statement.

06:23

We go over the depreciation calculation in Rhino Plats, where there is ongoing capital expenditure.

04:22

I challenge you to build the balance sheet and cash flow statement; then I start going through the steps involved.

07:07

We continue to build the balance sheet for Rhino Platinum.

11:32

We complete the working capital and other cash flow calculations.

08:41

We build the interest calculation, using an IF..THEN formula, depending on whether our cash flow is positive or negative.

03:03

We go through circular calculations (like the interest & tax calculations in Rhino Platinum) and how to switch on iterative calculations.

08:00

We change the formulas in the calculation sheet and go through a method of viewing and changing formulas.

05:09

We complete the output sheet for Rhino Platinum and build a summary financial report.

11:38

We use the model to generate investment values for the High, Medium and Low scenarios and use two different operating cost inflation rates.

Section 7: Capital Investment Appraisal Model
08:53

We go through the purpose of Capital Appraisal Models. We then go through Present Value, Future Value and Internal Rate of Return calculations.

04:11

Introduction to Sonnenlicht Energie and the requirements the company has from the Capital Appraisal Model.

09:00

We go through Nested IF calculations in order to do the sliding scale revenue calculation.

07:48

We now go on to build the income statement section of the calculations.

08:55

We go over terminal cash flows - the cash flows that need to be included at the end of the plant's life.

07:43

The output sheet of the appraisal model - a company approval form.

00:43

I challenge you to change the Nested IF calculations.

Section 8: Pricing Model
03:13

An introduction to the purpose of a pricing model and requirements of the pricing model.

10:35

We begin to build the Pricing Model by building the input and calculation sheets.

19:18

We continue building the Friscopy Input and Calculation sheets.

05:39

Description of macros and how to create macros.

02:45

We go through the steps in using the Goal Seek function.

03:55

We complete the input sheet and add a Macro with Goal Seek function.

08:43

We complete the output sheet

05:14

In the final lecture in the section, I challenge you to create a range of hurdle rates in the model.

Section 9: Conclusion
00:42

Course conclusion - thanks and final thoughts.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Andrew de Bruyn, Management Consultant & CFO | 6000+ Udemy Students

My name is Andrew and I'm originally from South Africa. I have a two degrees in Accounting and Business Management and I qualified as a Chartered Accountant. I gained extensive experience as a CFO and Financial Manager in several industries from manufacturing to diamond mining to fashion clothing. I have always enjoyed Excel and financial modelling, and honed my skills at companies listed in New York and London. I have several courses on Udemy and enjoy sharing my skills with others..

Ready to start learning?
Take This Course