Mergers and acquisitions (M&A) represent one of the most significant strategic decisions in corporate finance—the consolidation of companies or assets through various types of financial transactions. These deals can reshape entire industries, create market leaders, and unlock substantial value when executed properly.
While you can find separate videos covering M&A theory and accounting fundamentals, this tutorial takes a hands-on approach. We'll construct a comprehensive M&A model in Excel and perform the critical accretion/dilution analysis that investment bankers and corporate development teams rely on to evaluate deal economics.
For our case study, we'll model Google's acquisition of Motorola—a deal that demonstrates the complexities of valuing strategic acquisitions in the technology sector. Our analysis follows a structured four-step methodology that mirrors real-world M&A practices.
Step 1: Deal Assumptions
Every M&A model begins with establishing the fundamental deal parameters. This foundation includes the purchase price methodology, payment structure (cash, stock, or combination), and key timing assumptions. These inputs drive all subsequent calculations and ultimately determine whether the transaction creates or destroys shareholder value.
Step 2: Acquirer shares issued, Target offer value and standalone pretax net income for both
In this phase, we quantify the mechanics of the transaction. We calculate the exact number of new shares the acquirer must issue (for stock deals), determine the total offer value including any premiums, and establish baseline profitability metrics for both companies on a standalone basis. This step is crucial for understanding the relative contribution each entity brings to the combined organization.
Step 3: Pro Forma Net Income
Pro forma earnings represent the financial performance of the combined entity, incorporating hypothetical amounts and estimates to provide a realistic picture of post-merger profitability. These calculations exclude one-time expenses that don't reflect normal operations—such as restructuring costs, integration expenses, or acquisition-related charges—while including expected synergies and operational improvements. In today's M&A environment, investors and analysts scrutinize pro forma numbers closely, as they reveal the true economic rationale behind the deal beyond any short-term noise.
Step 4: Accretion / Dilution Analysis
The accretion/dilution analysis serves as the ultimate litmus test for any M&A transaction. This straightforward yet powerful evaluation determines whether the deal enhances or diminishes the acquirer's earnings per share (EPS) in the immediate term. The analysis compares the acquirer's standalone EPS with the pro forma combined EPS, revealing whether shareholders benefit from improved per-share economics. While this metric doesn't capture long-term strategic value, it provides essential insight into the deal's financial impact and often influences market reception.
When your analysis reveals EPS accretion, it signals positive financial momentum and suggests the transaction creates immediate shareholder value. However, seasoned M&A professionals recognize that quantitative analysis represents only half the equation. Successful deals require equally rigorous qualitative assessment—evaluating strategic fit, cultural compatibility, regulatory risks, and competitive positioning. The most value-creating acquisitions combine strong financial metrics with compelling strategic rationale, ensuring both companies emerge stronger as a unified entity. In an era where integration challenges can derail even the most promising deals, this holistic approach to M&A evaluation has become more critical than ever.