Mergers and Acquisitions Model Overview
Master Financial Modeling for Corporate Transactions
This analysis uses the real-world example of Google acquiring Motorola to demonstrate practical M&A modeling techniques and accretion/dilution analysis.
Key M&A Analysis Components
Deal Structure
Establishing the fundamental assumptions and parameters that will drive the entire M&A model. This includes purchase price, financing structure, and transaction terms.
Financial Integration
Calculating the combined financial metrics of both companies post-transaction. This involves determining share issuance and standalone performance metrics.
Value Assessment
Performing accretion/dilution analysis to determine if the transaction creates or destroys shareholder value through EPS impact evaluation.
M&A Model Building Process
Deal Assumptions
Establish the foundational parameters of the transaction including valuation multiples, premium paid, and financing structure.
Share Calculation and Standalone Metrics
Calculate acquirer shares issued, determine target offer value, and establish standalone pretax net income for both companies.
Pro Forma Net Income
Develop combined financial statements with hypothetical amounts and estimates, excluding one-time expenses like restructuring costs.
Accretion/Dilution Analysis
Perform the critical test to evaluate deal merit by determining if post-transaction earnings per share increase or decrease.
Pro forma earnings describe a financial statement that has hypothetical amounts built into the data to give a picture of a company's profit if certain nonrecurring items were excluded.
Accretion vs Dilution Outcomes
While accretion/dilution analysis is crucial, you must also consider qualitative factors to ensure the M&A transaction makes strategic sense for both acquirer and target companies.
M&A Model Validation Checklist
Ensures the foundation of your model reflects market conditions and company capabilities
Critical for accurate pro forma calculations and meaningful accretion/dilution results
Proper treatment of one-time items and synergies affects final EPS calculations
Understanding how changes in assumptions impact deal attractiveness and risk profile
Quantitative accretion must align with qualitative strategic benefits for deal success
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.
Key Takeaways