Course curriculum

  • 1

    Welcome to the Course

  • 2

    Introduction to Financial Modeling

  • 3

    Mastering Components of a Financial Model

    • Components of a Financial Model

    • Understanding the Components of a Financial Model with Example

  • 4

    Understanding the Structure of Financial Model Outputs

    • Understanding the REAL Framework

    • Understanding Business Cycle and Accounting Cycle

    • Incorporating Business Cycle in Financial modeling

    • Generating Financing Assumptions in Financial Modeling

    • Listing the Use of funds for the business

    • Generating your Business Operation Assumptions

    • Understanding the Structure of an Income Statement

    • Understanding the Structure of Balance Sheet using 5-Box Framework

    • Understanding the Structure of Cashflow Statement

    • The Financial Statement Laminate

  • 5

    Financial Modeling Forecasting Formula

    • Forecasting Using Percentage growth method

    • Forecasting with Negative Change formula

    • Forecasting with Absolute Change formula

    • Calculating percentage growth difference in financial modeling

    • Download the Activity File

    • Growth Technique Activity debrief

  • 6

    Understanding the Concept of Drivers in Financial Modeling

    • Understanding what drivers are in Financial Modeling

    • Recognizing drivers for Revenue in Income Statement

    • Recognizing drivers for Operational Line Item in Income Statement

    • Recognizing drivers for Other Income statement Line Item

    • Recognizing drivers for Balance sheet Line Item

    • Activity: Drivers' Activity Instruction

    • Activity: Drivers' Activity Debrief

    • Download Activity File

  • 7

    Building Calculation Schedules in Financial Modeling

    • Application of BASE Schedule in Financial Modeling

    • Application of BCE Schedule in Financial Modeling

    • Application of OWC Schedule in Financial Modeling

    • Download the Activity File

    • Activity: Applying the Schedule Concept in Financial Modeling

    • Activity debriefs of the Schedule Activity

  • 8

    Forecasting Techniques in Financial Modeling

    • Forecasting Techniques: Driver Based Approach

    • Forecasting Techniques using Growth Approach

    • Forecasting Techniques using Average Method

    • Forecasting techniques using Conservative Approach

    • Forecasting techniques using Aggressive Approach

    • Forecasting Techniques using Base Approach

    • Forecasting Techniques using Running Average Approach

    • Forecasting Techniques using Bottom-Up Approach

    • Forecasting Techniques using Top-Down Approach

    • Forecasting Approach using Statistical Method

  • 9

    Building a Financial Model from Scratch

    • Download the Activity File

    • Introduction to the Financial Model Case Study

      FREE PREVIEW
    • Understanding of Business Assumptions

    • Building the Equity Schedule in Financial Modeling

    • Building the Loan Schedule in Financial Modeling

    • Building the Assets Schedule in Financial Modeling

    • Building the Revenue & COS component of Financial Modeling

    • Calculating the Operating Expenses & OWC in Financial Modeling

    • Projecting the Income statement in Financial modeling

    • Projecting the Balance Sheet in Financial Modeling

    • Projecting the Cashflow Statement

    • Download the Completed Financial Model

  • 10

    Resources

    • The 3s Modeling Framework

    • 50 Excel Keyboard Shortcuts for Windows

  • 11

    Evaluation and Course Certificate

    • Instructions

    • Evaluation & Digital Certificate

    • How to Attach your Certificates to your LinkedIn Profile