This 40 Hour practical course is designed to equip the participants with a sound financial modelling skills and techniques to prepare and forecast financial statements needed in a modern corporate world. Participants will gain a firm understanding of the modelling process and financial ratios analysis.
The training is run in small groups ensuring direct interaction with the trainer throughout the whole course and each session is concluded with a practical model building exercise.
At the end of the training participants will be able to:
- Build a financial model from a scratch using the best structuring techniques.
- Use efficiently key Excel functions to construct sound financial forecasting models.
- Build interactive excel/VBA dashboards to automate Excel operations.
- Create a forecast income, cash flow statement and balance sheet.
- Interpret and analyse the key ratios used in a financial forecast.
Ÿ Tips for Setting up a Financial Model
Ÿ Obtaining Source Data
Ÿ Formatting & clearing data
Ÿ Spreading Historic Financial Statements
Ÿ Setting up model framework
Ÿ Analyzing past trends
Ÿ Normalising earnings and source data
Ÿ Key adjustments
Ÿ Calculating Key Ratios
Ÿ Determining Growth drivers
Ÿ Arriving at Key Assumptions
Forecasting Income Statement
Ÿ Determining revenue / cost drivers
Ÿ Forecasting Income Statement (5 Years)
Modeling Fixed Assets
Ÿ Drivers on Asset intensity
Ÿ Forecasting Capital Expenditure
Ÿ Modeling integrated financial model.
Ÿ Key links to other statements for cash flow
Ÿ Modeling cash flow statement
Ÿ Calculating cash flow to equity
Ÿ Understanding and calculating WACC
Ÿ Estimating cost of Equity
Ÿ Calculating Beta
Ÿ Determining Peer group
Ÿ Valuation using discounted cash flow (DCF)
Ÿ Terminal cash flows, growth and terminal values
Advance Data Presentation Skills
- Financial Analysts
- Equity Research Analysts
- Portfolio Managers
- MBA Finanace Students
- Those looking to make a career in Equity Valuation / Investment Banking
- Equity Valuation
- Financial Analyst
- Equity Research Analyst
- Portfolio Manager
- Capital Budgeting
- Investment Banking
- M & A Analyst
- Credit Analysts
Training Approach: Training on LIVE projects.
Duration: 25 Hours
Program Delivery : Live Class room training.
Weekend & Weekday classes.
Fee for this module:- Rs. 12,000/-