m&a community logo
M&A modeling: How to build models for successful integration
Back to Insights

M&A modeling: How to build models for successful integration

US M&A
Updated: Jul 23, 2024

M&A modeling plays a vital role in evaluating the financial feasibility of combining companies. These models provide insights that guide strategic decision-making throughout the merger process.

What is a merger model? What are merger model assumptions? How are effective M&A models built? Find out in the article.

What is an M&A model?

An M&A model is a financial tool used in corporate finance to evaluate the potential impact of a merger or acquisition between two companies. The primary purpose of the merger model is to determine if the transaction will be financially beneficial for the acquiring company and its shareholders.

More precisely, it helps in assessing the target company’s value, forecasting the combined financial performance, estimating potential synergies, analyzing different financing options, and determining whether the deal will be accretive or dilutive to the acquiring company’s earnings per share (EPS). 

This allows decision-makers to make informed choices about whether to proceed with the merger or acquisition, ensuring strategic alignment between the two companies.

An M&A model can also be called a merger model or acquisition model.

Also read

You might also be interested in reading our comprehensive articles on financial modeling examples and company valuation methods.

Understanding the basics of M&A modeling

Merger and acquisition modeling involves several principles that are critical for evaluating the financial impacts of a merger or acquisition. Here are the key concepts:

  • Synergy capture

It involves identifying financial synergy that arises from the merger, such as cost savings or increased revenue that would not be achievable independently. This often requires a thorough analysis of both companies’ operations to determine where efficiencies can be gained.

  • Cost integration

It focuses on combining operations, systems, and processes to reduce expenses. This can involve consolidating facilities, reducing workforce redundancies, and streamlining administrative functions, which can lower operating costs and improve profitability. 

  • Revenue enhancement

It looks at ways to boost sales or market share through the merger, such as cross-selling products, expanding into new markets, and leveraging the combined strengths of both companies.

Accurate acquisition modeling requires detailed financial projections, including forecasting revenues, expenses, cash flows, and earnings, and involves analyzing different scenarios and assumptions to assess the potential impact on the single business entity. 

Reliable models are crucial for conducting a thorough risk assessment, identifying rewards, determining the feasibility of achieving projected synergies, and ultimately deciding whether to proceed with the merger or acquisition. 

Effective M&A modeling enables executives and board members to make informed decisions that align with strategic objectives, maximize shareholder value, and ensure a successful M&A integration.

Merger model assumptions

Assumptions are critical to the construction of a merger and acquisition model. They provide a structured framework to forecast future financial performance and the potential success of the deal. 

Assumptions guide the model’s inputs and outputs, affecting everything from projected revenues and costs to synergies and valuation metrics. Without well-founded assumptions, the model’s projections could be highly inaccurate, leading to poor decision-making.

Let’s explore the assumptions and see how they impact various parts of the model like cash flow projections, valuation, and synergy calculations:

1.
Revenue growth rates

This assumption involves predicting how the combined company’s revenue will grow over time. It often takes into account historical growth rates, market trends, and the potential for new market expansion.

2.
Cost synergy realization

Cost synergies in M&A are the efficiencies and savings expected from the merger, such as reduced operational costs, shared resources, and economies of scale. The mergers and acquisitions model assumes a timeline for realizing these synergies and estimates the annual cost savings.

3.
Revenue synergies

Revenue synergies refer to the increased revenue potential from the merger, such as cross-selling opportunities, new customer acquisition, and expanded market reach. Assumptions are made regarding the timing and magnitude of these additional revenues.

4.
Integration costs

These are the one-time costs associated with integrating the two companies, including expenses related to merging IT systems, rebranding, severance for redundant positions, and legal and advisory fees.

5.
Market conditions

These are assumptions about the overall economic impact, industry-specific trends, and competitive landscape. This includes interest rates, inflation rates, and market growth rates, which affect both the cost of capital and potential growth opportunities.

6.
Financing assumptions

This includes the structure of the deal (cash, stock, or a combination), the interest rate on any debt used to finance the acquisition, and the terms of equity issuance.

7.
Tax rates

Assumptions about the effective tax rate post-merger, which can significantly impact the company’s net income and cash flow projections.

Merger modeling assumptions significantly influence cash flow projections, valuation, and synergy calculations. For example, revenue growth rates impact projected revenues and cash inflows, affecting the top line of the cash flow statements. Cost synergies reduce operating expenses, leading to higher net incomes and improved valuations.

Integration costs, on the other hand, increase short-term cash outflows, reducing initial net cash flow. Market conditions affect the discount rate used in discounted cash flow (DCF) valuations, influencing the present value of future cash flows.

Financing assumptions impact interest expenses and overall net cash flow, while tax rate assumptions affect net income and available cash for reinvestment or distribution.

Steps to build an effective M&A model

Here’s a short step-by-step guide on how to build a merger model.

1. Making acquisition assumptions

When constructing merger models, it’s crucial to start with acquisition assumptions. If the buyer’s stock is undervalued, the buyer may prefer to use cash rather than equity for the acquisition to avoid diluting existing shareholders by issuing many new shares.

On the other hand, the target company might prefer receiving equity, especially if they believe it will appreciate more than cash. Reaching a mutually acceptable consideration is vital for finalizing the deal.

Key assumptions include:

  • Purchase price. Determine the price to acquire the target company.
  • New shares issued. Calculate the number of new shares to be issued as part of the consideration.
  • Cash consideration. Value the cash component to be paid to the target.
  • Synergies. Estimate the cost savings from combining the businesses.
  • Timing for synergies. Predict when the synergies will be realized.
  • Integration costs. Forecast the one-time expenses for integrating the two companies.
  • Financial adjustments. Make necessary accounting-related adjustments.

2. Projecting financials

Next, make financial projections, similar to those in a regular DCF model. Analysts need to make assumptions about revenue growth, profit margins, fixed and variable costs, capital structure, capital expenditures, and all other accounts on the company’s financial statements.

This involves building a three-statement model, linking the income statement, balance sheets, and cash flow statement. This step should be done separately for both the target and the acquirer.

3. Valuing businesses

After completing the projections, perform a valuation of each business using a DCF analysis, comparable company analysis, and precedent transactions. This step involves several assumptions and requires a skilled analyst to ensure accurate and reliable valuations.

Key steps include:

  • Comparable company analysis. Compare the target with similar companies.
  • DCF model. Build the DCF model to estimate the intrinsic value.
  • WACC calculation. Determine the weighted average cost of capital.
  • Terminal value. Calculate the business’s terminal value.

4. Business combination and making pro forma adjustments

When combining the two companies, add the balance sheet items of the target to those of the acquirer. This process involves several accounting adjustments, such as calculating goodwill and adjusting for stock shares and options. This is also where synergy estimates are integrated.

Key assumptions include:

  • Form of consideration. Decide on cash or shares.
  • Purchase price allocation (PPA). Allocate the purchase price.
  • Goodwill calculation. Determine goodwill from the acquisition. Note that goodwill occurs when the buyer pays more than the fair market value of the net tangible assets listed on the target company’s balance sheet.
  • Accounting practice adjustments. Reconcile any differences in accounting practices.
  • Synergies calculation. Include estimated synergies.

5. Conducting accretion/dilution analysis

The final step is to assess whether the acquisition will be accretive or dilutive to the buyer’s earnings per share (EPS). An accretive deal increases the buyer’s EPS, while a dilutive deal decreases it. This analysis helps the buyer understand the impact of the target’s financial performance on the combined company’s EPS.

Key assumptions include:

  • New shares issued. Calculate the number of new shares issued.
  • Earnings acquired. Estimate the earnings from the target.
  • Synergy impact. Assess the effect of synergies on earnings.

Accretion and dilution

Let’s explore the merger model example through an accretion/dilution analysis to understand how the transaction impacts the EPS of the acquiring company.

Here are the proposed acquisition details:

Acquisition cost — $10,000

Method — 50% cash and 50% stock (using Company A’s stock price of $20 per share)

MetricCompany ACompany B
Net income$3,000$2,000
Shares outstanding500400
Current EPS$3,000 / 500 = $6.00 per share$2,000 / 400 = $5.00 per share

And this is how you calculate if the acquisition is accretive or dilutive:

StepsDescription
1. Calculate new shares issued
  • Cash portion of acquisition cost: $10,000 * 50% = $5,000
  • Number of new shares issued (using Company A’s stock price) = $5,000 / $20 = 250 shares
2. Combined outstanding shares post-merger
  • Company A’s original shares (500) + New shares issued (250) = 750 shares
3. The combined net income of both companies
  • $3,000 (Company A) + $2,000 (Company B) = $5,000
4. Combined EPS
  • Combined net income ($5,000) / Combined outstanding shares (750) = $5,000 / 750 = $6.67 per share
5. Accretion/dilution analysis
  • Compare EPS post-merger ($6.67) with Company A’s original EPS ($6.00)
  • Calculate accretion: ($6.67 / $6.00) – 1) * 100% = (1.1117 – 1) * 100% = 11.17%

The calculated 11.17% increase in EPS indicates that the merger is accretive to Company A. It suggests that the merger is expected to increase EPS for the combined company, potentially enhancing shareholder value.

Note: In practice, additional factors such as synergies, integration costs, financing structure, and tax implications would be incorporated into a comprehensive merger model. Additionally, keep in mind that, typically, advanced financial modeling and mergers and acquisitions software are used for conducting detailed merger analysis. 

Challenges in M&A modeling

Here are some common challenges faced when building out financial models for mergers or acquisitions:

1.
Data accuracy and availability

Reliable and accurate data is critical for M&A models. However, obtaining detailed and precise financial information from the target company can be challenging, especially if the target company is private or has less stringent reporting requirements.

Solution. Establish data-sharing agreements with the target company to ensure transparency and access to accurate information.

2.
Forecasting assumptions

Creating accurate financial projections involves numerous assumptions about future revenue, costs, and market conditions, which can be uncertain and subjective.

Solution. Use historical data and industry benchmarks to make assumptions. Conduct sensitivity analysis to understand the impact of different assumptions on the model outcomes and develop multiple scenarios to cover a range of potential states.

3.
Valuation discrepancies

Different valuation methodologies (discounted cash flow, comparable company analysis, leveraged buyout model) can lead to different results, causing potential disagreements.

Solution. Use a combination of valuation techniques to get a comprehensive view of the target’s value. Engage independent valuation experts to provide an unbiased assessment.

4.
Debt structure and interest expense

Measuring the costs of debt, modeling the optimal debt financing structure, and forecasting interest rates can be difficult, especially in volatile economic conditions.

Solution. Use current market data and economic forecasts to model various interest rate scenarios and their impact on the company’s financial health.

5.
Tax implications

Modeling the tax implications of the acquisition, including changes in tax rates, tax credits, and the impact of different ways of deal structuring, can be complex.

Solution. Engage tax advisors to assess the tax implications of the deal. Incorporate detailed tax modeling into the financial analysis to understand the net impact on the company’s financial position.

6.
Post-merger integration impact

Accurately modeling the financial impact of post-merger integration activities, including synergies and integration costs, is complex and uncertain.

Solution. Develop detailed post-merger integration planning with specific financial targets. Monitor the integration process closely and update the financial model regularly to reflect actual performance against projections.

Key takeaways

  • M&A modeling evaluates the financial impact of mergers and acquisitions, helping assess synergies, financial performance, and EPS accretion or dilution.
  • Assumptions in acquisition models guide projections of revenue growth, cost synergies, integration costs, and market conditions, influencing decision-making accuracy.
  • Using multiple valuation methods (e.g. DCF, comparable company analysis) ensures a comprehensive view of the target’s value, minimizing discrepancies.
  • Challenges in M&A modeling include data accuracy, forecasting uncertainties, valuation discrepancies, debt structuring complexities, and intricate tax implications.

Building robust M&A models is crucial for ensuring informed decision-making and strategic alignment during mergers and acquisitions. These models provide a structured approach to assess financial feasibility, evaluate synergies, and mitigate integration risks, ultimately enhancing the chances of successful integration and value creation for stakeholders.

Tags
M&A NA