Financial Modeling Using Microsoft Excel : General : Managerial and Financial Training [MFTC]

Financial Modeling Using Microsoft Excel
By MFTC

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