Five Days Practical Training using Computer/Laptops
Expected Candidates:
-
Executive directors of financial institutions.
-
Private investors who manage their own portfolios.
-
Middle-class managers and representatives,in particularly, who face decisions related toplanning & investment.
Program Objectives:
By completion of the 5-day course, trainees should be able to:
-
Understand the nature of financial model and their roles in decision making process.
-
How to use excel spreadsheets in financial decision making process.
-
Create spreadsheets that match with their objectives and resources.
-
Draw graphs and charts to present financial situations.
Training Methodology:
To maximize the benefits of the course and to assure skills development, the course would be based
on both theories as well practical cases. It provides the trainee with a wealth of practical knowledge to
take back to the workplace.
Program Contents:
Financial Modeling Review
-
Introduction to Financial Modeling.
-
Basic Valuation Techniques.
-
Pro-forma Modeling
-
Exercises: Build Financial Modeling
Advanced Excel for Financial Modeling
-
Spread sheet tips
-
Multiple sheet models
-
Multiple file models
-
Introduction to VBA
-
Exercises
Financial Model Applications
-
Portfolio optimization
-
Asset pricing
-
Performance measurement
-
Interest rate models
-
Matching the term structure
-
Forecasting
-
Economic order quantity (inventory management)
-
Exercises
Download program brochure
