Mergers and Acquisitions Modeling using Excel Course
In this course, we will first understand about the various terminologies being used in merger modeling and discuss various merger case studies. 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. This course is a guide that will cover the theoretical parts of M&A. We will be covering all the key concepts about mergers and acquisitions by going through some real life examples and case studies.
Further, 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. We have used company’s result press releases and investor presentation to find out relevant data, hence this can assure the reliability of any past data and future projections.
The training will include the followings in details;
What is M&A?
Why M&A?
Distinction between M&A?
Types of Mergers
Valuation Methods
What to Look For?
Why Merge?
Stages involved in M&A
Doing the Deal
What M&A Firms Do?
M&A Effects
Merger failures
Due diligence
Case Studies
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
By the end of this course, You will understand all the important concepts of M&A. You will became familiar with M&A process and you will have mastered Mergers and Acquisitions Modeling.
Get a Reminder
Rating | Not enough ratings |
---|---|
Length | 11 total hours |
Starts | On Demand (Start anytime) |
Cost | $18 |
From | Udemy |
Instructors | Institute of Investment Banking, Banking and Finance School |
Download Videos | Only via the Udemy mobile app |
Language | English |
Subjects | Business |
Tags | Business Finance Finance & Accounting Financial Modeling & Analysis |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Case Aide 2 $35k
Case Specialist 4 $36k
Case Specialist 3 $36k
Case Worker 1 2 $40k
Case Management 1 $41k
Case Planner 2 $42k
Case Management 1 2 $45k
CASE EXPEDITOR $49k
Case Analyst 2 $57k
Case Management 4 $69k
Case Researcher $82k
Clinical Studies Manager (Marketing Studies) $91k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Rating | Not enough ratings |
---|---|
Length | 11 total hours |
Starts | On Demand (Start anytime) |
Cost | $18 |
From | Udemy |
Instructors | Institute of Investment Banking, Banking and Finance School |
Download Videos | Only via the Udemy mobile app |
Language | English |
Subjects | Business |
Tags | Business Finance Finance & Accounting Financial Modeling & Analysis |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course