Course curriculum

  • 1

    Financial Modelling - Complete Introduction

  • 2

    Finance and Accounting Basics for Financial Modelling

  • 3

    Key Components of Financial Modelling Explained

  • 4

    Basics of Excel Formulas and Functions (For Financial Model Buidling)

  • 5

    Introduction to the Financial Model in Excel

  • 6

    Building Income Statement for the New Business

    • Revenue/Sales Forecast - Basic Structure
    • Revenue/Sales Forecast - Growth Rate and Valiation tab
    • Revenue/Sales Forecast - Growth Type Selection with Form Controls
    • Revenue/Sales Forecasting Finalisation
    • Model Cost of Goods Sold - Opening Stock
    • Model Cost of goods sold - Growth Rates modeling
    • Model Cost of Goods Sold - Setting up formulas for Gross Profit Change
    • Cost of Goods Sold Modelling Finalisation
    • Why to setup Cost of Goods Sold/Gross Profit Change - Logic Behind it
    • Modelling Direct cost and Gross Profit
    • Modelling Indirect Opearting Overheads - Dynamic Property Rental cost
    • Modelling Indirect Opearting Overheads - Other Overheads
    • Model Indirect Operating Overheads - Using IFS Function (optional)
    • Model Fixed Assets and Depreciation Schedule
    • Fixed Assets Schedule - Setting Gross Cost and Depreciation
    • Fixed Assets Schedule - Finalising and Linking Depreciation to PL
    • Fixed Assets Schedule - Sales and Purchase of Assets
    • Model Equity and Loan Schedule - Preparation and Linking to PL
    • Finishing up Income Statement Modelling
    • Time For Exercise - Create your own Income Statement
  • 7

    Building Cashflow Statement for New Business (Direct Method)

    • Cash Inflow - Cash Sales and Collection from Credit Sales
    • Cash Inflow - Dynamic Growth Rate setup with Form Controls FREE PREVIEW
    • Cash Inflow - Credit days selection drop down menu with Form controls
    • Cash Inflow - Dynamic Collection days with OFFSET Function
    • Cash outflow - Model Cash Purchases and Payments to suppliers
    • Cash outflow - Direct overheads and Indirect overheads
    • Cash Conversion Ratio - Measure Net Profit to Cashflow for business
    • Cash outflow - Capex Payment, Line of Credit and Funding Movment
  • 8

    Building Trade Finance Schedule (LOC) for New Business

    • Build a Revolving Line of Credit Schedule/Overdraft Credit Schedule
    • Revolving Line of Credit - Interest Modelling
    • Revolving Line of Credit - Linking LOC Funding to Cashflow Statement
  • 9

    Error Proofing Entire Model - IMPORTANT (New Business)

    • How to Setup Validation and Error Check for the entire Model - Part 1
    • How to Setup Validation and Error Check for the entire Model - Part 2
    • How to Setup Validation and Error Check - Conclusion
  • 10

    Fixed Assets Schedule - Expansion (New Business)

  • 11

    Indirect Method of Cashflow Statement and Balance Sheet (New Business)

    • Indirect Method of CF Statement - Building Balance Sheet - Assets Modelling
    • Indirect Method of CF Statement - Building Balance Sheet - Liability Side
    • Indirect Method of CF Statment - Cashflow Model Part 1
    • Indirect Method of CF Statment - Cashflow Building Part 2
    • Indirect Method of CF Statment - Updating Error Checks and Validations
    • Creating KPI Cards for New Business Financial Model
  • 12

    Building Financial Model for Existing Business

    • Building Existing Business Financial Model - Updating Ranges Tab
    • Building Existing Business Financial Model - Creating Periods
    • Building Existing Business Financial Model - Update Error Checks
    • Building Existing Business Financial Model - Finalisation and KPI Cards
    • Time for Exercise - Create Existing Business Dasboard on your own!
    • Time For Exercise - Build Your Business's Financial Model
  • 13

    Create Impactful and stunning Dashboards for Financial Model

    • Overview of the Completed Dashboard FREE PREVIEW
    • Data Preparation for the charts - Part 1 FREE PREVIEW
    • Data Preparation for the charts - Part 2
    • Data Preparation for the charts - Part 3
    • Building First Column Chart - Sales and Gross Profit
    • Building Column Chart - with Max and Min Gross Profit % FREE PREVIEW
    • Building Column Chart - with Max and Min Net Profit %
    • Building Column Chart for 12 Months Sales and Gross Profit
    • Building Column Chart for 12 Months Gross Profit % and Net Profit %
    • Building Column Chart for Cashflow, Collection and Payments for 12 Month
    • Building Column Chart for Trend of Operating Cashflow for 12 Months
    • Building a Donut Chart - Sales Products % Share
    • Download FREE Stock Images for Dashboard's Background
    • Importing Background Image and Setting up Dashboard
    • Creating Chart Backgrounds for an Amazing visual effect
    • Finalising New Business's Dashboard with KPI Cards
    • Time for Exercise ! Create Existing Business Dashboard
    • Existing Business's Dashboard Creation - Reusing New Business Dashboard Part 1
    • Bonus: Waterfall Chart for Net Cahflow Performance
  • 14

    Bonus: Financial Model in Google Sheets

  • 15

    Course Wrap up and Thank you

    • Wrap up and Thank you (Some Important points)