What is Financial Modelling?

Need for Financial Modelling - Financial Modeling using EXCEL is an essential skill required for Finance Professionals extensively used in Corporate Finance, Investment Banking, Equity Research, Credit Research, Project Appraisal, Mergers & Acquisitions, and Portfolio Management Sectors. 

Topics Covered

Financial Modelling using EXCEL

Foundations of Financial Modelling

Preparation of Cash Flow Statement

Understanding Financial Statement in-depth

Ratio Analysis

Forecasting Financial Statements

Modelling Elements of Balance Sheet, P&L Statement & Cash Flow Statement

Integration & Balancing of Financial Model

Sensitivity Analysis, Multiple Cases & Report Writing

 Concepts of Equity Valuations Discounted Cash Flow Based Valuation Techniques

Relative & Residual Valuation Techniques

Understanding Macro economic variables impact on Future Financial Statements

 Using Regression to model forecasted Financial Statements Impact of GDP, Inflation & other macro economic variables on Equity Market Computation & Interpretation of Cash Flow Ratios
Understanding Shares Outstanding Schedule 5-Year Financial Statement Projection Model Calculation of Cost of Equity & Cost of Capital Computation & Interpretation of Cash Flow Ratios Case Study with Questions

Financial Modelling with EXCEL Training COURSE

  • Classroom/Online Financial Modeling Classes(WebEX).
  • Training driven through Case Studies (A listed company).
  • Training conducted by IIM Alumnus
  • After Classes SUPPORT for 1 YEAR.
  • Hands On Coaching- Participants may get their laptops for the training to perform along with the trainer.
  • Support via Email/Phone/Chat/One on One session (with prior appointment).
  • Complete Recording of the 20 Hours Training in Downloadable Format.
  • Attending training again for NO COST.
  • Training Completion Certificate for all participants.
  • Online Trainings will be Live through WebEX - Downloadable Format.

Batch Start Dates

Batch Start Date Batch End Date Timings Fee

Yet to Announced

 

   Rs. 8,000

 

 

 

 

10% discount for a group of 3 or more

15% discount for a group of 5 or more

P.A.C.E - Financial Modeling with EXCEL Recorded DVD's:

P.A.C.E - Recorded Training of Financial Modeling with EXCEL available for Rs. 3000 (Price includes support for 1 Hour). Fee Adjustment for Participants willing upgrade Classroom/Online Training.

Who should attend Financial Modeling with EXCEL Training

  • Investors.
  • Credit analysts.
  • Fund managers.
  • Equity analysts.
  • Equity Traders.
  • Equity sales.
  • Investment bankers.
  • Equity Researchers.
  • Chartered Accountants.
  • Treasures.
  • Executive Level managers.
  • Graduates from any Stream.
  • Students.