Merger Model: M&A Acquisition

For example, let’s say an acquirer’s standalone EPS is $1.00, but it increases to $1.10 post-acquisition. Of course, accretion / (dilution) analysis cannot determine whether an acquisition will actually pay off or not. With that said, a decline in EPS (i.e. “dilution”) tends to be perceived negatively and signals the acquirer might have overpaid for an acquisition – in contrast, the market views an increase in EPS (i.e. “accretion”) positively.

At Exitwise, we can help you work with the best M&A experts, such as investment bankers and business appraisers, who can help you with merger modeling for an optimized exit. When two companies merge, the purchase price dynamics usually impact the acquirer’s earnings per share. Specifically, we’ll walk through the Income Statement combination in a merger model here, since it’s one of the most important steps in the entire process. The best way to develop merger modeling proficiency is practice. For investment banking interviews, you must understand both the how and the why of merger modeling. For investment banking interviews, merger modeling represents a core technical competency that every candidate must understand.

On the leveraged buyout (LBO) side, well, you can’t do a traditional LBO for commercial banks because they’re already levered to the max and because debt is not just an “extra” for them but rather a core part of their operations. That’s one of the more important multiples when you’re working with life insurance companies, and you often use it in place of P / E. Embedded Value by itself is a valuation methodology, but you can also calculate a P / EV (Price Per Share / Embedded Value Per Share) multiple based on this analysis.

Creating Acquisition Assumptions

So you might end up paying out 60% in year 1, 30% in year 2, and 10% in year 3, which means that there’s a big difference between recognized expenses and cash expenses.
You’ll combine the projections of both companies to see what the future might hold post-merger.
Since EPS is defined as Net Income / Shares Outstanding, and since Net Income includes Interest Income and Interest Expense, this metric is very useful for analyzing M&A deals.
An LBO or leveraged buyout is a model usually used by private equity companies when evaluating and acquiring a target company.
Key Excel functions include SUM, IF, INDEX-MATCH, and LOOKUP to automate calculations and ensure accuracy in linking data between financial statements.
Depending on the company, these teams will fall directly under the CEO or CFO.
It determines whether a deal is accretive (increases EPS) or dilutive (decreases EPS).

This is the process of assessing whether the deal has achieved its strategic and financial objectives, and what are the key drivers and challenges of the integration. These are some of the main topics that need to be considered when writing a section about financial reporting and disclosure requirements for M&A transactions. The goodwill impairment test affects the income statement and the balance sheet of the combined entity, as well as the calculation of key financial ratios and metrics. The pro forma financial information provides a basis for comparing the performance and financial position of the combined entity with the separate entities before the M&A transaction. The acquisition method is used when the acquirer obtains control of the acquiree, while the equity method is used when the acquirer obtains significant influence, but not control, of the acquiree.

Step 5: Perform Accretion/Dilution Analysis

These are key to understanding the merger’s impact on shareholders. Accretion happens when a merger increases the earnings per share for the new company, while dilution happens when the earnings per share decrease. As AI continues to evolve, its role in financial modeling will only grow. M&A modeling is not just about crunching numbers; it’s about shaping the future of a company.

Step 4. Forecast Headcount Reduction and Opex Synergies

The mergers and acquisitions (M&A) group in investment banking provides advisory services on either sell-side or buy-side transactions. Lastly, some companies employ internal teams that analyze transactions and M&A opportunities. This was not a major hurdle for the Microsoft-LinkedIn deal, but for many strategic acquisitions, it is. When LinkedIn sought a higher offer from Microsoft in the later stages of negotiation, Microsoft performed a synergy analysis to ensure that the deal would not be dilutive. (Recall that the actual purchase price was $196.00.) The fairness opinion is a controversial document since the financial advisor (in this case Qatalyst) is highly incentivized to align its opinion with management’s. The merger proxy even tells us how, after the deal with Microsoft was signed, one bidder came back in and offered significantly more!

The acquirer typically builds a merger model to measure the extent of this impact and decide whether the deal is ideal. Discover how a merger model measures accretion or dilution to earnings per share (EPS) and impacts M&A transactions. Building a merger model requires combining technical financial modeling skills with strategic understanding of deal dynamics.

Build models using public transaction announcements, varying assumptions to see how results change. This explains why synergy assumptions are among the most scrutinized elements of merger analysis. The payment method matters because stock consideration increases shares outstanding while cash consideration does not. This analysis compares the acquirer’s standalone EPS to pro forma EPS after combining with the target. This simple metric drives significant deal decisions because shareholders and boards care deeply about earnings impact.

Valuation Multiples – Banks and Insurance

Estimating these synergies accurately is crucial because it directly impacts the valuation of the merger. By tweaking these assumptions, they can simulate different scenarios to see how the merger might play out financially. This analysis helps in determining if the merger will add value to shareholders or not. So, grab your Excel spreadsheet, sharpen your financial acumen, and let’s explore the exciting world of M&A modeling! In summary, M&A modeling combines financial expertise, strategic thinking, and analytical rigor.

Analysts may use ______ and rely more on assumptions when public financial records are not available. In preparing a ______ model, the latest financial records of the ______ and the ______ are gathered first. Reflects consolidated assets, liabilities, equity to evaluate financial position post-merger.

Using Excel formulas like SUM, IF, INDEX-MATCH, and LOOKUP helps automate calculations and scenario analysis. Ensure all accounting policies are standardized to prevent discrepancies in financial reporting. It determines whether a deal is accretive (increases EPS) or dilutive (decreases EPS). There are different ways to measure the success of an M&A deal, depending on the perspective and the purpose of the evaluation. The final step is to propose and execute the corrective and improvement actions to address the gaps and issues, and to enhance the performance of the deal.

Target Information

The period between deal announcement (i.e. when the merger agreement is signed) and deal completion (i.e. when the two companies legally merge) can last anywhere from a few weeks to several months.
So it’s not as if financial institutions are completely, 100%, different from normal companies.
We show you their transaction history, fee structure, and estimated valuations for your company.
Assumptions guide the model’s inputs and outputs, affecting everything from projected revenues and costs to synergies and valuation metrics.
This section provides a complete, production-ready merger model template that can be used as-is for mid-market and large company M&A transactions.

As referenced above, there are many inputs and assumptions required in any type of M&A model. Note that goodwill is when the acquiring company pays greater than the fair market value of net tangible assets from the target company’s balance sheet. This step is where the financials of the companies are merged and scrutinized. The projections made in an M&A model are the same as in any other type of financial model.

One of the most important aspects of any merger and acquisition (M&A) deal is the post-merger evaluation and performance analysis. The key financial reporting and disclosure requirements for M&A transactions and how to model them in financial modeling. Tax considerations are critical in M&A deals, as they can significantly impact the financial outcome of the transaction. M&A transactions can have a significant impact on employees of both the acquiring and target companies. These considerations play a crucial role in shaping the financial modeling process of combining two or more companies. You need to account for the effects of the M&A transaction, such as the purchase price, goodwill, intangible assets, debt, equity, and transaction costs, on the financials of the combined entity.

Each funding source has a different “cost,” so from a financial perspective, acquirers want to use the lowest-cost funding source (Cash) as much as possible. Having the tools to provide accurate and time-sensitive deal analysis is invaluable in the M&A universe. Careful analysis will have taken place prior to any deal to ensure that it is beneficial before undertaking it. For listed companies, this information should be available in the latest company report or quarterly/annual filing. It also allows for sensitivity analysis of the inputs and assumptions.

Events like the dot-com bubble burst can drastically affect merger success. Overestimating synergies, merger model not anticipating market shifts can lead to outcome discrepancies. Since EPS is defined as Net Income / Shares Outstanding, and since Net Income includes Interest Income and Interest Expense, this metric is very useful for analyzing M&A deals. Key Excel functions include SUM, IF, INDEX-MATCH, and LOOKUP to automate calculations and ensure accuracy in linking data between financial statements. Book an exclusive demo with our CEO Dhruv or reach out at to see the impact firsthand.

Incorporate detailed tax modeling into the financial analysis to understand the net impact on the company’s financial position. Additionally, keep in mind that, typically, advanced financial modeling and mergers and acquisitions software are used for conducting detailed merger analysis. When constructing merger models, it’s crucial to start with acquisition assumptions.

The gaps and issues should be prioritized and categorized according to their impact and urgency, and the root causes and implications should be analyzed. The third step is to identify the areas where the performance of the deal has fallen short of the expectations, and the reasons behind them. The analysis should also consider the external factors and events that may have affected the performance, such as macroeconomic conditions, competitive dynamics, regulatory changes, etc. This can include financial statements, operational reports, market research, customer feedback, employee surveys, etc. The next step is to gather the relevant data and information to evaluate the performance of the deal.

When two or more companies decide to merge or acquire each other, it marks the beginning of a complex process that requires careful planning and execution. You need to assess the reasonableness and feasibility of the projections, and adjust the drivers and assumptions if necessary. You need to compare the projected financials with the historical financials and the industry averages, and explain any significant deviations or outliers. You also need to link the financial statements and ensure that they balance and reconcile. Identify and estimate the key drivers and assumptions for the projections.