NAME OF THE COURSE |
Financial Modelling |
|
CERTIFICATION |
Certified Master of Financial Modelling & Management |
|
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 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 a mathematical model of different aspects of the 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 them more flexibility. |
|
|
TRAINING DURATION |
Total Training Hours : 22 Hours |
Training Duration : 1 Week |
Total Training Days : 4-5 Working Days |
|
TRAINING SCHEDULE |
Weekdays (Sunday to Thursday) |
Regular Sessions : 4 – 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 |
|
CERTIFICATION |
Globally recognized certificate from “Kings Global Career Academy” |
|
TEST |
No |
|
LEARNING AIDS |
Yes |
|
COURSE MATERIAL |
Hard & Soft Copies of Study Material |
|
LANGUAGE OF INSTRUCTION |
English |
|
INSTRUCTOR HELPLINE |
Yes |
1. Email |
2. Social Media (For Emergency requirements) |
|
REGISTRATION REQUIREMENTS |
1. Passport Copy |
2. Curriculum Vitae |
3. Passport size photographs |
4. Course Fee |
|
MODE OF PAYMENT |
Cash / Cheque / Credit Card / Bank Transfer. |
|
ELIGIBILITY |
- Corporate finance Executives
|
|
|
|
|
- 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-covariance 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 |
- Best Practice Modelling. Introduces how to model a company’s accounts. The four key stages of modelling: Planning, Documentation, Building and Finalisation.
|
- Income Statements. What should be shown in an income statement and how it needs to be disclosed?
|
- Cash. Introduces the most important calculation in most financial models – the cash calculation
|
- Balance Sheet. Showing what a company owns and what it owes. Working out current assets and current liabilities using ratios
|
- Non-current Assets. Modelling fixed assets. Depreciation – What it is, why we need it, how to model depreciation? Goodwill – How it arises, how it is dealt with in a company’s accounts and how it should be modelled.
|
- Non-current Liabilities. The different types of debt used by a company. How these should be modelled and how to work out the interest on them accurately
|
- Taxation. The adjustments that have to be made to the accounting profit to give the taxable profit and the reasons for these adjustments. How to code a basic tax computation and how to deal with tax losses.
|
- Deferred Tax. What deferred tax is and why it arises. How to model deferred tax on tax losses and deferred tax on accelerated capital allowances.
|
- Sensitivity Analysis. What sensitivity analysis is? Two ways of incorporating sensitivity analysis into a mode and how easy it is to add it to a well-written model.
|
- Data Tables & Graphics. What data tables are and how useful they can be. How to add data tables to a model and use the results to plot appropriate graphic
|