Merger and Acquisition Modeling using Microsoft Excel

Lets learn how to create a merger model and perform valuation with the help of a dummy company example.

5

 59m | 6 Videos | 66901 Views |   Intermediate

Merger and Acquisition Modeling Using Excel:

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.

The training will include the following;

• Introduction on mergers
• Discuss company Profile
• Preparing merger model
• Calculation of enterprise value

Target Customers:

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

Pre-Requisites:

• Basic Accounting and MS Excel Knowledge
• Passion to learn

Back to top ?