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
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
Structuring a Financial model
Setting cell styles
Setting Labels and Units
Model and Excel Tolerances
Colour Schemes
Useful excel shortcuts
General Formulas used in financial modelling
NPV
IRR
SUMIF
INDEX
MATCH
Financial Model Basics
Gearing ratios
Types of debt
Types of equity
mixed instruments of finance
Types Bonds
Structuring of equity and debt
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
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
Sample Financial Models
Financial Model Assignments
Financial Modelling certification