Financial Model Fundamentals-Learn the Essential Skills
4.7 (5 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.
48 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Financial Model Fundamentals-Learn the Essential Skills to your Wishlist.

Add to Wishlist

Financial Model Fundamentals-Learn the Essential Skills

Learn to create full financial models including cash flow, working capital, debt and equity calculations.
4.7 (5 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.
48 students enrolled
Created by Andrew de Bruyn
Last updated 5/2015
English
Current price: $10 Original price: $75 Discount: 87% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Create full financial models
  • Understand debt and equity calculations
  • Understand the Excel formulas essential for models
  • Use best practice for user-friendly and robust models
View Curriculum
Requirements
  • Basic Excel skills
  • Understand basic financial concepts like gross profit, assets and liabilities
Description

This course is for business owners, managers, finance professionals or business students who want to learn to build financial models.

If you have basic Excel skills and a basic understanding of financial concepts, you will be able to follow the course.

I teach step-by-step, from simple steps like creating our input sheet to advanced calculations like cost of capital and share buy backs.

Only essential skills are taught; I don't waste time on skills you don't need.

The course is great value for money and it's far easier to learn to build financial models with my video course than trying to learn from a book.

Who is the target audience?
  • Finance and investment professionals
  • Business managers and owners
  • Finance and business students
Students Who Viewed This Course Also Viewed
Curriculum For This Course
27 Lectures
02:32:29
+
How to Use This Course
1 Lecture 00:46
+
Debt Equity Model
5 Lectures 19:48

An introduction to Victoria Additives and the model we need to build.

Preview 03:11

We start to create the first sheet in the financial model, the Input Sheet.

Preview 03:52

An introduction to Name Ranges-the advantages of using them in financial models and how to add them to cells.

Preview 04:15

We add Name Ranges to the Input Sheet for the Victoria Additives model.

Input Sheet Name Ranges for Debt Equity Model
02:58

We start to build the Calculation Sheet for Victoria Additives.

Calculation Sheet for Debt Equity Model
05:32
+
Debt and Equity Calculations
4 Lectures 24:40

An introduction to capital expenditure and depreciation calculations, and adding them into the calculation sheet of the model.

Capital Expenditure and Depreciation
05:26

An introduction to how equity calculations are included in financial models.

Preview 04:21

We build the equity calculations into the calculation sheet.

Equity Calculations for Debt Equity Model
07:26
+
Balance Sheet, Working Capital and Cash Flows
5 Lectures 30:10
Balance Sheets Introduction
01:53

An introduction to working capital and an explanation of the calculations we include in a financial model.

Working Capital Introduction
04:09

We build the balance sheet in our financial model.

Balance Sheet for Debt Equity Model
08:24

An introduction to cash flows and the main calculations around working capital.

Cash Flow Introduction
02:23

We build the cash flow for the Victoria Additives model.

Cash Flow for Debt Equity Model
13:21
+
Fixing a Model and the Output Sheet
4 Lectures 29:32

We look at how to audit formulas, the most common spreadsheet errors and how to detect and fix errors.

Auditing and Fixing Formulas
04:03

I give you the challenge of balancing the balance sheet, and then go through the calculations and steps to do so.

Challenge - Balance the Balance Sheet
06:28

We create the Output Sheet for the Financial Model.

Output Sheet for Debt Equity Model
09:33

I challenge you to create a summary balance sheet and cash flow statement and then go through the steps.

Challenge - Summary Balance Sheet & Cash Flow
09:28
+
Ratio Analysis
2 Lectures 13:21

An introduction to financial ratio analysis typically used in financial models. We also go over debt covenant ratios.

Financial Ratios and Debt Covenants
05:30

We go through adding the financial ratios to our financial model.

Adding Ratios to the Financial Model
07:51
+
Dividends, Cost of Capital and Share Buy Backs
5 Lectures 33:34

Dividend calculations overview and adding dividend calculations to the Victoria Additives model.

Dividends
06:19

Weighted average cost of capital calculations are explained, and we then add WACC calculations to the Victoria Additives financial model.

Weighted Average Cost of Capital
10:57

An explanation of share buy backs and how they can be included in a financial model.

Introduction to Share Buy Backs
03:46

We add share buy back calculations to the financial model.

Adding Share Buy Backs to the Financial Model
08:08

I challenge you to create a WACC table and then I go through the steps with you.

Challenge - WACC Table
04:24
+
Conclusion
1 Lecture 00:38
Conclusion
00:38
About the Instructor
Andrew de Bruyn
4.1 Average rating
192 Reviews
7,071 Students
4 Courses
Management Consultant & CFO | 7000+ 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..