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.