Financial Modelling - Equity Valuations using EXCEL

Valuations an important element for in Equity Research for Credit & Investment decission plans and forecasting of the organization in order to help investors for making Investment decisions.

Topics Covered

Financial Modelling - Equity Valuations using EXCEL

Understanding of Key Financial Statements

Understanding & Interpreting Data from Annual Reports

Preparation & Analysis of Cash Flow Statement.

Calculating Financial Ratios.

Using EXCEL Functions to forecast.

Regression - model forecasted Financial Statements

Understanding the drivers for forecasting

Depreciation & Debt Schedule

 Discounted Cash Flow based Valuation Calculation of Cost of Equity & Cost of Capital

Valuation using FCFF & FCFE approached

Understanding key valuation ratios like P/E, P/BV, P/S, P/CF

 Calculating residuals like EVA & MVA Monte-Carlo simulation & Sensitivity Analysis Case Study with Questions

Equity Valuations using EXCEL Training:

  • Classroom/Online 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 complete 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

19-May-2012 (Weekend)

20-May-2012 (Weekend)

 9AM to 5PM Rs. 5,000

 

 

 

10% discount for a group of 3 or more

15% discount for a group of 5 or more

P.A.C.E - Equity Valuations using EXCEL Recorded DVD's:

P.A.C.E - Recorded Trainingavailable for Rs. 2,500. Fee Adjustment for Participants willing upgrade Classroom/Online Training

SUPPORT FOR RECORDED DVD'S:

  • Support via Email/Phone/Chat/One on One session for 1 hour (with prior appointment).
  • Updated recordings of the training in downloadable format for 1 year at no extra cost.

Who should attend Equity Valuations using 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.