Overview

The Mergers & Acquisition (M&A) Model provides a
projection for a company looking to potential merger or acquire another
company. This model runs through different scenarios and synergies to forecast
future value after the transaction. Included in the template you will find:

 

        
A Deal Assumptions Section with key drivers for
the Acquirer and Target company and a 5-scenario analysis

        
Accretion/Dilution with a Sensitivity Analysis

        
Proforma Model merging the two companies with
alternative synergy assumptions

        
Debt & Interest section highlighting the
different debt schedules and repayment

        
Assumption section for each company with a 3
Scenario analysis

        
The Income Statement, Balance Sheet and Cash
Flow Statement for the Acquirer and Target companies

        
Supporting Schedules Section for PPE and Working
Capital

        
Discounted Cash Flows Valuation for each company

On the first tab is the Deal Assumptions sections where the
details of the deal structure are input. There is another section for a
5-scenario analysis for the assumptions of the synergy and financing of the
merger/acquisition. Below this is the calculation of Goodwill for the Closing
Balance sheet at the time of the deal. This is followed by the
Dilution/Accretion analysis regarding stock prices and a sensitivity analysis
using Takeover Premium, Revenue Enhancement and Target Share Price to impact
the change in Share Price and Earnings per Share.

The Proforma for the Merger/Acquisition is on the next tab.
This consists of an Assumptions section that will tie to the debt schedule
below along with a few assumptions for the Income Statement and Balance Sheet.
After the 3 Statement section, there is the debt schedule that outlines each
form of debt and their interest/repayment schedule. At the bottom, there is a
DCF Valuation after the deal and a Merger Integration section, which is
highlighted in green to show that every cell is linked to another tab in the
model.

The next two tabs are for the Acquirer and Target companies
and their financial projections. All assumptions can be modified to fit
specific key drivers of the business to see their impact on the Mergers &
Acquisition Model. Up to years of historical data can be entered into the
income statement, balance sheet, and cash flow statement; the following
projected years are driven by formulas from the Assumptions section according
to the selected scenario in cell I9. The projection period in the Supporting
Schedules section consists of all formulas that are tied to the Assumptions and
3 Statement sections so no editing is necessary. The DCF Valuation section
displays the Terminal Value for each company using the Discounted Cash Flows
Method. This section offers an Intrinsic and Market value and the respective
share price.

All cells in blue font are input cells where custom
information can be entered. All cells in black font are formulas set to
streamline the model. All cells in green font represent a link to another tab
in the model. Sections are grouped to condense the model to view sections
individually.

Reviews Add a review
No reviews yet

More From D'Errico Financial Services LLC

Browse our top rated business templates. See All
Multi-Family Housing Rental Renovation Model
2,806
0
The Multi-Family Housing Rental Renovation model projects monthly future cash flows from the renovation and rental of a multi-family housing…
Real Estate Development Model
3,122
0
 The Real Estate Development model projects monthly future cash flows from a development property from the purchase of the land…
Consumer Loan Model
2,998
0
The Consumer Loan model breaks down the financing structure of a bundle of consumer loans absorbed by a lender. This…
Venture Capital Financial Model
3,226
9
The Venture Capital Returns Model is used to provide an analysis into an investment return for a VC fund. This…
DCF Valuation Financial Model
3,387
2
The DCF Valuation Model builds on the 3 Statement model by adding a business valuation component for investment through the…
Private Equity Financial Model
3,137
3
The Private Equity Acquisition Model provides a business valuation of a target company for investment. The Private Equity Acquisition Model…
See All