Accretion / Dilution in Excel
Master Excel Financial Modeling for Business Analysis
Accretion/dilution analysis determines whether a merger or acquisition will increase or decrease earnings per share for the acquiring company's shareholders.
Key Components of M&A Financial Modeling
Target Company Valuation
Calculate the present value of future cash flows and determine acquisition premium. This forms the basis for deal structuring and financing decisions.
Combined Entity Projections
Model the financial performance of the merged companies including synergies and integration costs. This requires detailed revenue and cost assumptions.
EPS Impact Calculation
Determine whether the transaction will increase or decrease earnings per share for existing shareholders. This is the core output of accretion/dilution analysis.
Excel Formula Implementation Process
Set Up Base Calculations
Implement the core formula C10=C7*(1+C8)*C9 to calculate projected earnings growth incorporating growth rates and adjustment factors.
Calculate Combined Metrics
Use formulas like B17=B16*B9 and B19=B17+C17 to aggregate financial metrics from both the acquiring and target companies.
Determine Final EPS Impact
Apply the accretion/dilution formula B28=B27/B15-1 to calculate the percentage change in earnings per share from the transaction.
Stock vs Cash Deal Structures
| Feature | Stock Deal | Cash Deal |
|---|---|---|
| Dilution Risk | Higher - new shares issued | Lower - no new equity |
| Integration Complexity | Complex ownership structure | Simpler post-merger structure |
| Financial Flexibility | Preserves cash reserves | Requires significant capital |
Excel Model Validation Checklist
Broken links can cause cascading errors throughout the entire financial model
Small changes in growth rates or multiples can significantly impact accretion/dilution results
Validate complex formulas by calculating key metrics independently using alternative methods
Ensure formulas like B21=SUM(B19:B20) properly aggregate the intended financial components
Excel vs Specialized M&A Software
The most frequent errors occur in share count calculations and timing assumptions. Always validate that your Excel formulas properly account for when new shares are issued and how they impact weighted average calculations.
The devil is in the details when modeling accretion and dilution - small errors in Excel formulas can lead to significant misvaluation of M&A transactions.
Understanding the Accretion/Dilution Model Structure
The formulas below represent the critical calculations that drive merger and acquisition analysis in modern corporate finance. These Excel formulas form the backbone of any sophisticated accretion/dilution model, helping investment bankers and corporate development professionals determine whether a proposed transaction will enhance or diminish earnings per share for the acquiring company.
Core Valuation and Growth Calculations:
C10=C7*(1+C8)*C9
This formula calculates the target company's projected enterprise value by applying the growth rate (C8) to the base valuation (C7) and incorporating the relevant multiple (C9). This represents a fundamental building block for determining acquisition pricing in today's dynamic M&A environment.
B17=B16*B9
B19=B17+C17
These interconnected formulas build the financing structure, with B17 calculating debt-related costs and B19 aggregating total financing requirements. Understanding these relationships is crucial for structuring deals that optimize capital efficiency.
Tax and Synergy Considerations:
B20=C14*(1-C13)
This after-tax calculation accounts for the tax shield benefits that have become increasingly important in the current regulatory environment, where tax optimization remains a key driver of deal economics.
B21=SUM(B19:B20)
The aggregation of financing costs and tax effects provides the total adjusted cost basis that sophisticated acquirers use to evaluate transaction feasibility.
Dilution Impact Analysis:
B23=B9
B24=C10*C11/B7
B25=SUM(B23:B24)
This sequence calculates the total share count impact, incorporating both existing shares and new issuances required for the transaction. In 2026's market conditions, where equity valuations remain elevated, this calculation often determines deal viability.
Final Accretion/Dilution Determination:
B27=B21/B25
B28=B27/B15-1
These final calculations deliver the critical insight: whether the transaction creates or destroys shareholder value on a per-share basis. The result in B28 represents the percentage accretion or dilution that will ultimately influence board-level decision-making and investor communication strategies.
Mastering these formulas and their interdependencies enables finance professionals to build robust models that can withstand the scrutiny of due diligence processes and support strategic decision-making in an increasingly complex M&A landscape.
Key Takeaways