|
Products & Services
|
Financial Modelling Training Course Outline
Course Description: Financial model is an integral part of any investment and banking decisions. To analyse the financial and economic viability of any project, bankers, corporate managers, government officials and policy makers frequently use computer based financial models. This course is designed to enable the participants to work with financial models as well as constructing new financial models. While every project will have unique features, and each spreadsheet its own techniques, certain principles apply generally to the construction of financial models, and these principles are the prime considerations throughout this training.
Topic- Purpose and uses of Financial Model
- Introduction to MS Excel
- Creating charts
- Built-in functions
- Defining cells
- Tracking and protection
- Goal seek and macros, etc.
- Working examples of Financial Model
- Annuity debt profile
- Level principal debt profile
- Fixed and variable rate interest calculation
- Borrowing capacity measurement
- Up-front, pro-rata and back-ended equity infusion
- Calculation of up-front fees, monitoring fees, and commitment fees
- Net present value (NPV)
- Internal rate of return (IRR)
- Economic rate of return (ERR)
- Return on equity (ROE)
- Inflation index prediction
- Exchange rate index prediction
- Calculation of tariff
- Calculation of levelized tariff
- Debt service cover ratio (DSCR)
- Loan life cover ratio (LLCR)
- Constructing a Financial Model
- Golden rules
- Input / assumption sheet
- Calculation sheets
- Output / report sheet
- How to make a model flexible
- Sensitivity analysis
- Auditing Financial Model