- 1 year
- Intermediate
- Course Certificate
- Number of Units98
- Number of Quizzes0
- 11 hours, 21 minutes Gift this course
Course Curriculum
Section 01: Financial Modelling - Introduction | |||
Course Promo | 00:07:00 | ||
Course Road Map and Outline | 00:03:00 | ||
What is Financial Modelling? | 00:02:00 | ||
Inputs and Outputs in Financial Modelling Process | 00:01:00 | ||
What is Financial Modelling used for? | 00:06:00 | ||
Key Components of a Financial Model | 00:03:00 | ||
Short Overview of completed Financial Model | 00:06:00 | ||
Section 02: Finance and Accounting Basics for Financial Modelling | |||
Accounting Basics and Accounting Equation | 00:04:00 | ||
Accounting Basics – Debits and Credits | 00:08:00 | ||
Accrual Accounting v Cash Accounting | 00:06:00 | ||
Prepaid Expenses and Unearned Revenue with Accrual v Cash Accounting | 00:04:00 | ||
Section 03: Key Components of Financial Modelling Explained | |||
Balance Sheet Basics for Financial Modelling | 00:06:00 | ||
Income Statement or Profit or Loss Statement (Explained) | 00:05:00 | ||
Cashflow Statement – Basics about Cashflow Statement | 00:04:00 | ||
Two Methods of Cashflow Statement Explained | 00:05:00 | ||
Indirect Method of Cashflow Explained in detail | 00:12:00 | ||
Section 04: Basics of Excel Formulas and Functions (For Financial Model Building) | |||
Introduction of the Formulas and Functions for the Financial Model | 00:04:00 | ||
Basics of Choose Function – Explained | 00:13:00 | ||
Basics of MAX and MIN Functions – Explained | 00:07:00 | ||
Basics of IF Function | 00:07:00 | ||
Basics of IF Function and NestedIF Statements | 00:06:00 | ||
VLOOKUP Function – Explained | 00:06:00 | ||
Match Function – Explained | 00:11:00 | ||
VLOOKUP Function with Match Function | 00:06:00 | ||
SUM IF Function – Explained | 00:05:00 | ||
OFFSET Full Introduction | 00:14:00 | ||
IFS Function | 00:08:00 | ||
Section 05: Introduction to the Financial Model in Excel | |||
Brief Overview of Financial Model | 00:01:00 | ||
What are the Excel Basics of Financial Model | 00:06:00 | ||
Walkthrough of the Completed Model | 00:17:00 | ||
Build as many Scenarios you want with this Financial Model | 00:08:00 | ||
Section 06: Building Income Statement for New Business | |||
Sales Forecast – Basic Structure | 00:06:00 | ||
Sales Forecast – Growth Rate and Validation tab | 00:10:00 | ||
Sales Forecast – Growth Type Selection with Form Controls | 00:07:00 | ||
Sales Forecasting Finalisation | 00:07:00 | ||
Model Cost of Goods Sold – Opening Stock | 00:04:00 | ||
Cost of goods sold – Growth Rates modelling | 00:08:00 | ||
Model Cost of Goods Sold – Setting up formulas for Gross Profit Change | 00:07:00 | ||
Cost of Goods Sold Finalising | 00:11:00 | ||
Cost of Goods Sold/Gross Profit Change – Logic Behind Setting Up | 00:03:00 | ||
Direct cost and Gross Profit | 00:05:00 | ||
Indirect Operating Overheads – Dynamic Property Rental cost | 00:10:00 | ||
Indirect Operating Overheads – Other Overheads | 00:06:00 | ||
Indirect Operating Overheads – Using IFS Function | 00:06:00 | ||
Fixed Assets and Depreciation Schedule | 00:05:00 | ||
Fixed Assets Schedule – Setting Gross Cost and Depreciation | 00:07:00 | ||
Fixed Assets Schedule – Finalising and Linking Depreciation to PL | 00:07:00 | ||
Fixed Assets Schedule – Sales and Purchase of Assets | 00:03:00 | ||
Equity and Loan Schedule – Preparation and Linking to PL | 00:09:00 | ||
Finishing up Income Statement Modelling | 00:03:00 | ||
Section 07: Building Cashflow Statement for New Business | |||
Cash Inflow – Cash Sales and Collection from Credit Sales | 00:14:00 | ||
Cash Inflow – Dynamic Growth Rate setup with Form Controls | 00:04:00 | ||
Cash Inflow – Credit days selection drop-down menu with Form controls | 00:04:00 | ||
Cash Inflow – Dynamic Collection days with OFFSET Function | 00:09:00 | ||
Cash outflow – Model Cash Purchases and Payments to suppliers | 00:12:00 | ||
Cash outflow – Direct overheads and Indirect overheads | 00:12:00 | ||
Cash Conversion Ratio – Measure Net Profit to Cashflow for business | 00:04:00 | ||
Cash outflow – Capex Payment, Line of Credit and Funding Movement | 00:07:00 | ||
Section 08: Building Trade Finance Schedule (LOC) for New Business | |||
Build a Revolving Line of Credit Schedule/Overdraft Credit Schedule | 00:07:00 | ||
Revolving Line of Credit – Interest Modelling | 00:02:00 | ||
Revolving Line of Credit – Linking LOC Funding to Cashflow Statement | 00:11:00 | ||
Section 09: Error Proofing Entire Model - IMPORTANT (New Business) | |||
How to Setup Validation and Error Check for the entire Model – Part 1 | 00:08:00 | ||
How to Setup Validation and Error Check for the entire Model – Part 2 | 00:06:00 | ||
How to Setup Validation and Error Check – Conclusion | 00:03:00 | ||
Section 10: Fixed Assets Schedule - Expansion (New Business) | |||
Fixed Asset Schedule Expansion and Why we need it | 00:03:00 | ||
Fixed Assets Schedule Expansion – Building it Step by step | 00:16:00 | ||
Section 11: Indirect Method of Cashflow Statement and Balance Sheet (New Business) | |||
Building Balance Sheet – Assets Modelling | 00:10:00 | ||
Building Balance Sheet – Liability Side | 00:08:00 | ||
Indirect Method of CF Statement – Cashflow Model Part 1 | 00:08:00 | ||
Indirect Method of CF Statement – Cashflow Building Part 2 | 00:06:00 | ||
Updating Error Checks and Validations | 00:07:00 | ||
Creating KPI Cards for New Business Financial Model | 00:08:00 | ||
Section 12: Building Financial Model for Existing Business | |||
Building Existing Business Financial Model – Updating Ranges Tab | 00:06:00 | ||
Building Existing Business Financial Model – Creating Periods | 00:06:00 | ||
Building Existing Business Financial Model – Updating Validations and Error Checks | 00:11:00 | ||
Building Existing Business Financial Model – Finalisation and KPI Cards | 00:11:00 | ||
Section 13: Building Dashboards for Financial Model | |||
Overview of the New Financial Model | 00:09:00 | ||
Data Table Preparation for the charts – Part 1 | 00:09:00 | ||
Data Table Preparation for the charts – Part 2 | 00:04:00 | ||
Data Table Preparation for the charts – Part 3 | 00:03:00 | ||
Building First Column Chart – Sales and Gross Profit | 00:04:00 | ||
Building Column Chart – with Max and Min Gross Profit % | 00:06:00 | ||
Building Column Chart – with Max and Min Net Profit % | 00:04:00 | ||
Building Column Chart for 12 Months Sales and Gross Profit | 00:03:00 | ||
Building Column Chart for 12 Months Gross Profit % and Net Profit % | 00:09:00 | ||
Building Column Chart for Cashflow, Collection and Payments for 12 Month | 00:08:00 | ||
Building Column Chart for Trend of Operating Cashflow for 12 Months | 00:08:00 | ||
Building a Donut Chart – Sales Products Distribution | 00:07:00 | ||
Download FREE Stock Images for Dashboard’s Background | 00:05:00 | ||
Importing Background Image and Setting up Dashboard | 00:05:00 | ||
Creating Chart Backgrounds for an Amazing visual effect | 00:06:00 | ||
Finalising New Business’s Dashboard with KPI Cards | 00:09:00 | ||
Existing Business’s Dashboard Creation – Reusing New Business Dashboard | 00:12:00 | ||
Waterfall Chart for Net Cashflow Performance | 00:15:00 | ||
Section 14: Bonus: Financial Model in Google Sheets | |||
Overview of the Financial Model in Google Sheets | 00:19:00 | ||
WaterChart for Net Cashflow Performance in Google Sheets | 00:07:00 | ||
Section 15: Course Wrap up and Thank you | |||
Wrap up and Thank you (Some Important points) | 00:01:00 | ||
Downloadable Resources | |||
Resource – Financial Forecasting Model for New Business | 00:00:00 |
Course Ratings
No Ratings found for this course.