Why choose our Financial Modelling Course

Introductory Video Lecture

Inspired by FAST and SMART international modelling standards. Accepted across the industry. These standards inspire modelling practices of the BIG-4, Investment Bankers and KPOs 

Financial Modelling - Beginners to Pros

Covering all The Whites, GrAys and Blacks of Financial Modelling

Scenarios & Sensitivities

model scenarios.PNG
model calculations.PNG
model dashboard.PNG

Dashboards

And Everything in between

Module - I

Module - II

Module - III

  1. What is Financial Modelling

    • Basic Finance and accounting

      • Rules of Accounting

      • Working Capital

      • Amortization

      • Depreciation

      • Taxes

      • Basic Financial Statements

      • Uses and Applications of Finance

    • Modelling requirements

    • The need for Financial Modelling

  2. Structuring a Financial model

    • Setting cell styles

    • Setting Labels and Units

    • Model and Excel Tolerances

    • Colour Schemes

    • Useful excel shortcuts

  3. General Formulas used in financial modelling

    • NPV

    • IRR

    • SUMIF

    • INDEX

    • MATCH

  4. Financial Model Basics

    • Gearing ratios

    • Types of debt

    • Types of equity

    • mixed instruments of finance

    • Types Bonds

    • Structuring of equity and debt

  1. Financial Model Intermediates

    • Structuring Interest payments

    • Structuring Debt payments

      • Annuity

      • Bullet

      • Balloon

      • Sculpted

      • Sculpted Optimized

      • Profiler

    • Structuring of reserves

      • DSRA

      • MMRA

      • VAT facilities

      • Working Capital Facilities

    • Staying in line with Bank covenants 

      • DSCR

      • LLCR

      • Payment Periods

  2. Advanced Financial Modelling

    • Ratio Analysis

    • Dashboard creation

    • Graphs and Charts

    • Summary sheets

    • Leverage multipliers

    • EBITDA multipliers and enterprise value

    • Terminal value calculation

    • Calculation of NPV and IRR on a dual timeline

    • Use of Macros for iterative calculations

  1. Sample Financial Models

  2. Financial Model Assignments

  3. Financial Modelling certification