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.

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

OPTIONAL
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)

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."

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.

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;

Bonds;

Option pricing models;

Monte Carlo methods;

Corporate finance models.