Financial Modelling – Source Advisory

Source Advisory > Financial Modelling

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

And Everything in between

Dashboards

Module - I

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

Module - II

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

Module - III

Sample Financial Models
Financial Model Assignments
Financial Modelling certification