Course
|
Financial Modeling

Mergers and Acquisitions

Mergers and Acquisitions are transactions in which the ownership of companies is combined into a single entity. This course will show you how to analyze a fictional acquisition in the clothing retail industry.
2 HOURS
Advanced
14 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Understand the benefits of mergers and acquisitions
Develop a merger model in Excel
Calculate synergies and implementation costs in a merger
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
helping to build
data, Tech & ai skills in
g2-badgebritish-airwaysjotunamazon-logopwc-logoford-logo
Course
|
Financial Modeling

Mergers and Acquisitions

Mergers and Acquisitions are transactions in which the ownership of companies is combined into a single entity. This course will show you how to analyze a fictional acquisition in the clothing retail industry.
2 HOURS
Advanced
14 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Understand the benefits of mergers and acquisitions
Develop a merger model in Excel
Calculate synergies and implementation costs in a merger
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

What’s Included

14 Lessons
What are Mergers and Acquisitions?
4 MINS
LESSON
What are Mergers and Acquisitions?
Exercise

This introductory lesson explains what mergers and acquisitions are, and why companies decide to pursue them. We also learn how synergies work and about the qualitative factors that can affect these transactions.

How to Build Merger Models
5 MINS
LESSON
How to Build Merger Models
Exercise

Merger models are very different to basic valuation models, as they contain 3 separate models in 1. In this lesson, I'll show you how a merger model is constructed and the metrics used to evaluate the attractiveness of a transaction

Introducing the Merger Case
3 MINS
LESSON
Introducing the Merger Case
Exercise

ShirtShop is a fictional clothing retailer that wants to acquire another retailer TrouserTown. In this lesson, we learn the motivation behind the proposed transaction and the synergies that ShirtShop hopes to achieve.

Analyzing the Acquirer
3 MINS
LESSON
Analyzing the Acquirer
Exercise

This lesson examines the recent financial performance of both the Acquirer in our proposed deal. We do this primarily by examining the Income Statement, which may help us understand the motivations behind this deal.

Funding the Proposed Transaction
3 MINS
LESSON
Funding the Proposed Transaction
Exercise

In this lesson, we examine the likely sources of funds that the acquirer will use to fund the transaction. This requires us to review the balance sheet of both the acquirer and the target

Deal Synergies
3 MINS
LESSON
Deal Synergies
Exercise

In this lesson, we project both the cost synergies and the revenue synergies that the acquirer has assumed will occur once the companies are combined.

Defining our Transaction Assumptions
5 MINS
LESSON
Defining our Transaction Assumptions
Exercise

Our transaction assumptions in the merger model focus primarily on the sources of funding and the fees incurred in completing the deal.

Sources and Uses of Funds
5 MINS
LESSON
Sources and Uses of Funds
Exercise

In this lesson, we complete a Sources and Uses of Funds Table for the transaction. This simple calculation is complicated by the cash available on the target's balance sheet.

Combining Income Statements Part 1
4 MINS
LESSON
Combining Income Statements Part 1
Exercise

In this lesson, we combine income statements for both the target and the acquirer. We also learn how to include the impact of synergies on our revenues and costs.

Combining Income Statements Part 2
6 MINS
LESSON
Combining Income Statements Part 2
Exercise

We finally complete our combined income statement in this lesson and calculate our net income projections for the enlarged company.

Accretion and Dilution
4 MINS
LESSON
Accretion and Dilution
Exercise

Every merger is either accretive or dilutive. In this lesson, we learn what these terms mean and how to quickly perform accretion / dilution analysis in our case study.

Cash Flow and Debt Analysis Part 1
7 MINS
LESSON
Cash Flow and Debt Analysis Part 1
Exercise

To project the cash and debt balance for the next 5 years, we need to create a simplified Statement of Cash Flows for the combined entity. In this lesson, we calculate the amount of cash available for debt repayment

See More
See Less
Certifications
Earn a certificate with every exam you complete. All successful course completions are recognized by CPD, CPE, and NASBA. As your team gains confidence, skill, and speed, your firm becomes more competitive.
Earn cPE / CPD Credits
No items found.
Get More Info
Looking to understand how Kubicle can better help your organization meet its learning objectives?  Book some time with one of our consultants today.
Contact Information
Looking to speak to someone directly?
01 700 9000
info@kubicle.com
Dublin, Ireland
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Plus Size YourLearning with Academies+
THE PLATFORM OF CHOICE FOR 1M+ USERS

A Learner Experience Designed to Deliver Transformation

Testimonials

How Leading Teams Use Kubicle to Upskill & Excel

Heineken Case Study
ADL Logo