What you'll learn

Analyze a live merger deal and how was the target valued (EV and EV / EBITDA multiples)
Prepare pro forma 3 statements for the acquirer in the year the deal was completed
Learn Valuation
Learn Pro forma adjustments

Requirements

Basic Accounting and MS Excel Knowledge
Passion to learn

Description

In this course, we will first understand about the various terminologies being used in merger modeling. Post which, we will go through with the detailed merger model, wherein we will learn, how to create assumption sheet, calculation of the purchase price. Further, we will also understand the how the merger deal would be funded. There are various expenses such as the financing expenses, advisory fees, purchase price allocation that would be calculated with specific to the deal. Next comes the main part of M& A modeling where we would be creating the proforma balance sheet and P&L, accretion/dilution analysis and preparing the sensitivity tables. Through these tutorials we are going to learn merger modeling concepts with the help of case studies. The training will include the following;

Analyze a live merger deal and how was the target valued (EV and EV / EBITDA multiples)

Prepare pro forma 3 statements for the acquirer in the year the deal was completed

Valuation

Pro forma adjustments

Who is the target audience?

Students who are pursuing CFA, MBA (finance), CA
Professionals in the field of investment banking/equity research