Need for Financial Modeling with EXCEL

Financial Modelling 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 for Infrasructure, Merger & Project Financing

Merger Model using a case study

In-depth Financial Statement Analysis of both Acquirer and Target company

Merger Deal Structuring

Estimate various types of synergies – revenue, COGS and SG&A synergies

Accretion/Dilution model and Credit Ratios

Leveraged Buyout (LBO)

Combined Financial Statements projection including the synergies

Making an Integrated Balance sheet, Income Statement & Cash Flow Statement

 Working with Depreciation, Debt & Tax Usage of Advanced EXCEL Functions for valuation

Projecting the Revenue & Expenses sheets based on Assumptions

Working with Depreciation, Debt & Tax

 Model driven Sensitivity and Scenario Analysis Infrastructure or Project Financing Model Case Study Based Approach

Financial Modeling for Infrastructure Project Financing & MERGERS TRAINING DETAILS

  • Available as Classroom as well as Online Training
  • 20 Hours - 4 Days of Comprehensive Training.
  • Training driven through Case Studies.
  • Training conducted by IIM Alumnus
  • Support via Email/Phone/Chat/In Person for 1 year after the training
  • Facility to attend the training one more time at no extra cost.
  • Training Completion Certificate
  • Merit Certificate to those participants who work out satisfactorily and submit a detailed report
    • For Faculty Profile Click Here

Batch Start Dates

Batch Start Date Batch End Date Timings Fee

8-Mar-2012

(Weekday)

9-Mar-2012

(Weekday)

 8AM-5PM Rs. 6000

 

 

 

 

10% discount for a group of 3 or more

15% discount for a group of 5 or more