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.
Courses » Finance & Accounting » Finance » Mergers and Acquisitions » Mergers and Acquisitions Modeling using Excel Course
Disclosure: when you buy through links on our site, we may earn an affiliate commission.
Mergers and Acquisitions Modeling using Excel Course
Learn from scratch. Understand processes, methods, stages in M&A, funding, expenses, deal structure, advisory, modeling
Created by
9.1
CourseMarks Score®
Freshness
Feedback
Content
Top Mergers and Acquisitions courses:
Detailed Analysis
CourseMarks Score®
CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.
Freshness Score
Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.
Student Feedback
New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.
Content Score
The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.
Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.
This course contains:
Table of contents
Description
You will learn
✓ Learn Distinction between M&A. Types of Mergers Valuation Methods and What to Look For.
✓ Understand Why Merge. Stages involved in M&A. Doing the Deal etc.
✓ Understand What M&A Firms Do, M&A Effects, Merger failures, Due diligence with 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
✓ Learn Valuation
Requirements
• A computer with MS Excel
This course is for
• Professionals in the field of investment banking/equity research
How much does the Mergers and Acquisitions Modeling using Excel Course course cost? Is it worth it?
Does the Mergers and Acquisitions Modeling using Excel Course course have a money back guarantee or refund policy?
Are there any SCHOLARSHIPS for this course?
Who is the instructor? Is Institute of Investment Banking a SCAM or a TRUSTED instructor?
9.1
CourseMarks Score®
Freshness
Feedback
Content