Certified MASTER OF Financial Modelling & MANAGEMENT

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
  • 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-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