This 2 day advanced program aims to equip the participants with knowledge and tools to apply their financial modelling skills on project finance feasibility, data analysis, dashboard designs and Merger and Acquisition. We will cover case studies on power and real estate sector.
Perform financing mix and accretion dilution analysis
Learn to apply scenario analysis and sensitivity analysis for M&A and private equity transactions
Differentiate key modeling techniques between Modeling for Mezzanine Capital Investments and modeling for Investments in convertible structures
Master IRR and NPV analysis
Learning structuring of finance for a LBO transaction
Learn circular reference technique
Learn to design Data Dashboards
Gain expertise in creating dynamic charts
Who should attend
Professionals and graduate students working or aspiring to work in the field of investment banking, project consultancy, private equity, corporate finance, asset valuation and equity research
Financing Mix and Accretion-Dilution Analysis
Merger Mix Analysis
Contribution and Breakeven Analysis
Sensitivity Analysis using data tables and Scenario Analysis
Charting for M&A modeling
Case Study: Middle East Real Estate Deal
Circular Break Flag
Working knowledge of different kinds of financing
Incorporating revolver loans
Financial analysis of the project
Debt covenant analysis and Check sheet concept
Debt structuring using different types of financing options
Free cash flow analysis
NPV and IRR analysis for project
Data Analysis and Dashboard design:
Working with Charts and Tables in Excel
Analyzing Data using Pivot Tables
Principles of Dashboard Design and Reporting
Making Interactive and Dynamic Dashboards
Summarization & presentation of a financial model
Karan Sharma, CFA
Over 8 years of experience in M&A advisory, financial modelling, buy side equity research, advanced excel and financial statement analysis.
Rahul Sonthalia, CFA
Over 11 years of experience in the area of macro-economic research, equity research, investment banking, with specialization in financial analysis, equity valuation, and Financial Modeling.
Currently there are no public classes/sessions scheduled for this course yet. For any in-house or private training, please contact us.
The fee includes presentation material, refreshments and networking lunch.
Get 20% discount on the course fee, if you are a CIMA or IMA member
Get 20% discount, when four or more individuals register.
Get 15% discount, if you are a Past Student who has completed a course with us.
Get 10% discount, when you register 2 weeks prior to the course start date.