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 all-round financial model building skills, then this course is for you.
By the end of the course, you will be able to
An introduction to financial modelling - definition, its benefits and the users of models
Guidelines for financial modelling - structure, format and the process to be followed in building models
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.
We continue to analyse historical data, this time using two categories with the SUMIFS formula.
Once we have summarised historical information, we can determine the key ratios we are going to use to build the financial model.
Once we have decided on the key ratios, we can start building the first sheet in the model, the input sheet.
After the input sheet is created, we can create the calculation sheet.
The last section in a model is the output section. The most common output is a profit and loss statement.
We analyse the outputs of our financial model for two main reasons:
A sensitivity table is a very useful tool to see how sensitive the model's outputs are to a change in inputs.
Introduction to Name Ranges - what they are and how they improve our models.
Learn to build the Input Sheet using Name Ranges.
We continue with Name Ranges and build the Calculation Sheet.
We build the Output Sheet with Name Ranges.
An introduction to Working Capital - explanation and basic calculations.
We start by including inputs and name ranges for working capital.
The next step is adding working capital calculations into the calculation sheet.
An introduction to balance sheets for financial models.
The next step in our modelling process is to build the balance sheet.
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.
An introduction to modelling cash flow, especially working capital.
Learn to build the cash flow statement calculations.
We complete the output sheet - adding the balance sheet and cash flow statement.
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.
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.
Protecting the sheets to prevent users from altering the structure, calculations and outputs of the model.
To end this section of the course, I give you a challenge and go through it with you.
An introduction to Victoria Additives and the key ratios and assumptions we will use.
We start to build the input sheet for the debt equity model
We continue with the input sheet for the Victoria Additives debt equity model.
We add the name ranges to the input sheet for the Victoria Additives model.
How to create a debt table - what inputs are needed, how to use the payment formula and what links to create.
We go over a plant & equipment calculation table, including depreciation, and how the table needs to link into the other sections of the model.
An overview of the main equity calculations for a financial model.
We add the equity calculation tables for share values, number of shares and the accumulated profit table to the calculation sheet.
We now build the balance sheet, using the input sheet and the calculations done so far.
Building the Cash Flow for our Debt Equity model.
How to audit and check formulas, particularly in the calculation sheet.
I give you a challenge to fix the balance sheet, then I go through the solution with you.
We build the output sheet for Victoria Additives and answer the questions at the beginning of the course.
I give you a challenge of building a summary balance sheet and cash flow statement, then go through the solution with you
We add debt ratios and covenant calculations to the model.
We add 3 ratios to the calculation sheet and output sheet and then do a comparison to a covenant ratio.
Adding dividend payments to the model.
An outline of WACC and adding the calculation to the model.
An introduction to share buy backs and how they can be included in a financial model.
We go through the calculations for share buy backs in the Victoria Additives model.
I challenge you to build a WACC table and then go through the exercise with you.
An introduction to scenario models. We go through Streethill Investment's requirements for an equity portfolio model, with multiple scenarios in the model.
We add the input sheet to the Scenario Model
We continue with the building of the input sheet for the Scenario Model.
We build the calculation sheet for our Scenario Model, Streethill Investments.
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.
We complete the calculation and output sheets
We use the Scenario Model to create a table of portfolio values for the High, Medium and Low scenarios, choosing different investment weightings.
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.
We start building the Input Sheet for the Rhino Platinum financial model.
We continue to build the Input Sheet for Rhino Platinum.
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.
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.
We continue with the calculation sheet and set out the income statement.
We go over the depreciation calculation in Rhino Plats, where there is ongoing capital expenditure.
I challenge you to build the balance sheet and cash flow statement; then I start going through the steps involved.
We continue to build the balance sheet for Rhino Platinum.
We complete the working capital and other cash flow calculations.
We build the interest calculation, using an IF..THEN formula, depending on whether our cash flow is positive or negative.
We go through circular calculations (like the interest & tax calculations in Rhino Platinum) and how to switch on iterative calculations.
We change the formulas in the calculation sheet and go through a method of viewing and changing formulas.
We complete the output sheet for Rhino Platinum and build a summary financial report.
We use the model to generate investment values for the High, Medium and Low scenarios and use two different operating cost inflation rates.
We go through the purpose of Capital Appraisal Models. We then go through Present Value, Future Value and Internal Rate of Return calculations.
Introduction to Sonnenlicht Energie and the requirements the company has from the Capital Appraisal Model.
We go through Nested IF calculations in order to do the sliding scale revenue calculation.
We now go on to build the income statement section of the calculations.
We go over terminal cash flows - the cash flows that need to be included at the end of the plant's life.
The output sheet of the appraisal model - a company approval form.
I challenge you to change the Nested IF calculations.
An introduction to the purpose of a pricing model and requirements of the pricing model.
We begin to build the Pricing Model by building the input and calculation sheets.
We continue building the Friscopy Input and Calculation sheets.
Description of macros and how to create macros.
We go through the steps in using the Goal Seek function.
We complete the input sheet and add a Macro with Goal Seek function.
We complete the output sheet
In the final lecture in the section, I challenge you to create a range of hurdle rates in the model.
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..