Course Overview

This course will help to understand Financial Modeling tool that can be used to forecast a picture of a security or a financial instrument or a company’s future financial performance based on the historical performance of the entity. Financial Modeling includes preparing of detailed company specific models which are then used for decision making and performing financial analysis. It is nothing but constructing a financial representation of some, or all, aspects of the firm or given security or  it is mathematical model of different aspects of financial health of a given company and this model can be made on a simple not book paper or in excel, with later it is easily possible to analyse  the impact of different assumptions or change in value of various variables hence gives the more flexibility.

Training DurationTotal Training Hours : 30 Hours
Training Duration : 1 Week
Total Training Days : 5 Working Days
Training SchedulesWeekdays (Sunday to Thursday)
Regular Sessions : 6 Hrs Per day (9am to 2pm or 3.00pm to 9.00 pm)
Food & refreshments Included

WeekEnds (Friday & Saturday)
Fast Track Sessions: 8 Hours per day (9am to 5pm)
Food & refreshments Included

1) Certificate from Laurels Training Institute, Attested by Knowledge & Human Development Authority (KHDA) government of Dubai, UAE

2) Certificate from American Institute of Professional Studies (AIPS) from USA (After 15 Days of course Completion which will couriered to the attendees office address)

Learning AidsYes
Course MaterialHard & Soft Copies of Study Material
Language of InstructionEnglish
Instructor HelplineYes
1. Email
2. Social Media (For Emergency requirements)
Registration Requirements1. Passport Copy
2. Curriculum Vitae
3. Passport size photographs
4. Course Fee
Mode of Payment:Cash / Cheque / Credit Card / Bank Transfer.
Eligibility Criteria
(Who should attend this training)

Corporate finance Executives

Financial analysts

Investment bankers

Financial controllers

Finance managers

Professionals responsible for project valuation, project finance, portfolio managers, and professionals in the private investment industry."

Course Benefits

Construct and examine the characteristics of distributions of returns, calculate the variance co-variance matrix and use it to select optional portfolios.

Develop, construct and run an event study analysis of the abnormal returns.

Estimate betas and calculate a firm's cost of capital.

Calculate the value of an option using Black Scholes and the binomial model, and apply Monte Carlo methods to option pricing.

Develop a spreadsheet-based equity valuation model
Course Contents / Outline

The course covers the following main topics: construction and examination of the characteristics of distributions of returns; calculation of the variance co-variance matrix and its application to select portfolios; test of market efficiency using simple tests; developing, constructing and running event studies; estimating betas and calculating a firm's cost of capital; calculating the value of an option using the Black-Scholes model; applying Monte Carlo methods to financial problems; using and developing spreadsheet based solutions to financial problems; using Excel techniques.

Introduction - basic financial calculations in Excel;

Portfolio models;

Market efficiency;

Event studies;


Option pricing models;

Monte Carlo methods;

Corporate finance models.

© Laurels Training Institute 2017. All Rights Reserved.