Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice realworld skills and achieve your goals.
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:
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
and want to learn allround financial model building skills, then this course is for you.
By the end of the course, you will be able to
Andrew
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.
Section 1: How to Use this Course  

Lecture 1  01:14  
How to use this course and get the most out of it. 

Section 2: Financial Model Basics  
Lecture 2  05:00  
An introduction to financial modelling  definition, its benefits and the users of models 

Lecture 3  03:42  
Guidelines for financial modelling  structure, format and the process to be followed in building models 

Lecture 4  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. 

Lecture 5  07:31  
We continue to analyse historical data, this time using two categories with the SUMIFS formula. 

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

Lecture 7  07:24  
Once we have decided on the key ratios, we can start building the first sheet in the model, the input sheet. 

Lecture 8  07:43  
After the input sheet is created, we can create the calculation sheet. 

Lecture 9  03:19  
The last section in a model is the output section. The most common output is a profit and loss statement. 

Lecture 10  04:50  
We analyse the outputs of our financial model for two main reasons:


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

Lecture 12  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  
Lecture 13  06:46  
Introduction to Name Ranges  what they are and how they improve our models. 

Lecture 14  08:15  
Learn to build the Input Sheet using Name Ranges. 

Lecture 15  06:25  
We continue with Name Ranges and build the Calculation Sheet. 

Lecture 16  08:07  
We build the Output Sheet with Name Ranges. 

Lecture 17  04:09  
An introduction to Working Capital  explanation and basic calculations. 

Lecture 18  05:02  
We start by including inputs and name ranges for working capital. 

Lecture 19  04:38  
The next step is adding working capital calculations into the calculation sheet. 

Lecture 20  02:54  
An introduction to balance sheets for financial models. 

Lecture 21  09:03  
The next step in our modelling process is to build the balance sheet. 

Lecture 22  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. 

Lecture 23  02:10  
An introduction to modelling cash flow, especially working capital. 

Lecture 24  07:15  
Learn to build the cash flow statement calculations. 

Lecture 25  02:44  
We complete the output sheet  adding the balance sheet and cash flow statement. 

Lecture 26  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. 

Lecture 27  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. 

Lecture 28  04:24  
Protecting the sheets to prevent users from altering the structure, calculations and outputs of the model. 

Lecture 29  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  
Lecture 30  03:37  
An introduction to Victoria Additives and the key ratios and assumptions we will use. 

Lecture 31  05:12  
We start to build the input sheet for the debt equity model 

Lecture 32  03:03  
We continue with the input sheet for the Victoria Additives debt equity model. 

Lecture 33  02:39  
We add the name ranges to the input sheet for the Victoria Additives model. 

Lecture 34  07:35  
How to create a debt table  what inputs are needed, how to use the payment formula and what links to create. 

Lecture 35  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. 

Lecture 36  04:21  
An overview of the main equity calculations for a financial model. 

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

Lecture 38  08:24  
We now build the balance sheet, using the input sheet and the calculations done so far. 

Lecture 39  13:21  
Building the Cash Flow for our Debt Equity model. 

Lecture 40  04:03  
How to audit and check formulas, particularly in the calculation sheet. 

Lecture 41  06:28  
I give you a challenge to fix the balance sheet, then I go through the solution with you. 

Lecture 42  09:33  
We build the output sheet for Victoria Additives and answer the questions at the beginning of the course. 

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

Lecture 44  05:30  
We add debt ratios and covenant calculations to the model. 

Lecture 45  07:51  
We add 3 ratios to the calculation sheet and output sheet and then do a comparison to a covenant ratio. 

Lecture 46  06:19  
Adding dividend payments to the model. 

Lecture 47  10:59  
An outline of WACC and adding the calculation to the model. 

Lecture 48  03:46  
An introduction to share buy backs and how they can be included in a financial model. 

Lecture 49  08:08  
We go through the calculations for share buy backs in the Victoria Additives model. 

Lecture 50  04:59  
I challenge you to build a WACC table and then go through the exercise with you. 

Section 5: Scenario Model  
Lecture 51  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. 

Lecture 52  05:43  
We add the input sheet to the Scenario Model 

Lecture 53  05:55  
We continue with the building of the input sheet for the Scenario Model. 

Lecture 54  03:20  
We build the calculation sheet for our Scenario Model, Streethill Investments. 

Lecture 55  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. 

Lecture 56  04:57  
We complete the calculation and output sheets 

Lecture 57  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  
Lecture 58  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. 

Lecture 59  10:16  
We start building the Input Sheet for the Rhino Platinum financial model. 

Lecture 60  12:42  
We continue to build the Input Sheet for Rhino Platinum. 

Lecture 61  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. 

Lecture 62  07:29  
I challenge you to add a dropdown menu box to the output sheet and link it to the calculation sheet. I go through the solution step by step. 

Lecture 63  07:51  
We continue with the calculation sheet and set out the income statement. 

Lecture 64  06:23  
We go over the depreciation calculation in Rhino Plats, where there is ongoing capital expenditure. 

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

Lecture 66  07:07  
We continue to build the balance sheet for Rhino Platinum. 

Lecture 67  11:32  
We complete the working capital and other cash flow calculations. 

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

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

Lecture 70  08:00  
We change the formulas in the calculation sheet and go through a method of viewing and changing formulas. 

Lecture 71  05:09  
We complete the output sheet for Rhino Platinum and build a summary financial report. 

Lecture 72  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  
Lecture 73  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. 

Lecture 74  04:11  
Introduction to Sonnenlicht Energie and the requirements the company has from the Capital Appraisal Model. 

Lecture 75  09:00  
We go through Nested IF calculations in order to do the sliding scale revenue calculation. 

Lecture 76  07:48  
We now go on to build the income statement section of the calculations. 

Lecture 77  08:55  
We go over terminal cash flows  the cash flows that need to be included at the end of the plant's life. 

Lecture 78  07:43  
The output sheet of the appraisal model  a company approval form. 

Lecture 79  00:43  
I challenge you to change the Nested IF calculations. 

Section 8: Pricing Model  
Lecture 80  03:13  
An introduction to the purpose of a pricing model and requirements of the pricing model. 

Lecture 81  10:35  
We begin to build the Pricing Model by building the input and calculation sheets. 

Lecture 82  19:18  
We continue building the Friscopy Input and Calculation sheets. 

Lecture 83  05:39  
Description of macros and how to create macros. 

Lecture 84  02:45  
We go through the steps in using the Goal Seek function. 

Lecture 85  03:55  
We complete the input sheet and add a Macro with Goal Seek function. 

Lecture 86  08:43  
We complete the output sheet 

Lecture 87  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  
Lecture 88  00:42  
Course conclusion  thanks and final thoughts. 
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..