This project is a fully dynamic Accretion / Dilution (Merger & Acquisition) Financial Model built entirely in Microsoft Excel.
The purpose of the model is to determine whether an acquisition increases (accretive) or decreases (dilutive) the acquiring company's Earnings Per Share (EPS).
Accretion/Dilution analysis is one of the most important financial models used in Investment Banking, Corporate Development, Private Equity, and M&A Advisory. Before recommending an acquisition to management or clients, analysts must evaluate whether the proposed transaction creates value for shareholders.
This model simulates a real-world M&A transaction by combining the financial statements of both companies, incorporating purchase price assumptions, financing structure, synergies, interest expense, depreciation and amortization adjustments, tax effects, and new share issuance to calculate the post-transaction EPS.
The primary objectives of this project are to:
- Understand the mechanics of mergers and acquisitions.
- Learn how acquisition financing impacts shareholder value.
- Build a dynamic EPS accretion/dilution model from scratch.
- Analyze different financing structures.
- Evaluate the impact of acquisition synergies.
- Develop practical financial modeling skills used by investment bankers.
This project demonstrates understanding of:
- Mergers & Acquisitions (M&A)
- Earnings Per Share (EPS)
- Accretive vs Dilutive Transactions
- Purchase Premium
- Enterprise Value
- Equity Value
- Debt Financing
- Cash Financing
- Stock Financing
- Weighted Average Cost of Capital (WACC)
- Synergies
- Cost Synergies
- Revenue Synergies
- Interest Expense
- Tax Shield
- Goodwill
- Intangible Assets
- Purchase Price Allocation (simplified)
- Share Issuance
- Pro Forma Financial Statements
An Accretion/Dilution Model is used to evaluate whether an acquisition will increase or decrease the acquiring company's Earnings Per Share after the transaction closes.
Instead of only asking:
"Is this acquisition profitable?"
Investment bankers ask:
"Does this acquisition create additional earnings for each shareholder?"
The model combines the financial performance of both companies while adjusting for financing costs, synergies, taxes, and accounting changes to estimate the new Pro Forma EPS.
The percentage difference between the new EPS and the acquirer's standalone EPS determines whether the deal is accretive or dilutive.
The model answers questions such as:
- Should Company A acquire Company B?
- Will the acquisition increase shareholder earnings?
- What financing method produces the highest EPS?
- How much synergy is required for the deal to become accretive?
- What happens if purchase price changes?
- How sensitive is EPS to financing assumptions?
The Excel model follows a structured workflow similar to those used in investment banking.
The model begins with acquisition assumptions such as:
- Purchase Price
- Purchase Premium
- Target Enterprise Value
- Financing Mix
- Tax Rate
- Interest Rate
- Synergy Assumptions
These inputs drive every downstream calculation.
Historical financial information for both companies is entered, including:
- Revenue
- EBITDA
- EBIT
- Net Income
- Shares Outstanding
- Existing Debt
- Cash Balance
These values establish the financial position of each company before the acquisition.
The acquisition can be financed using different sources:
- Cash
- New Debt
- New Equity
- Hybrid Financing
The model calculates:
- Interest expense
- New debt balances
- Shares issued
- Ownership dilution
Expected acquisition synergies are incorporated into the model.
Examples include:
- Cost reductions
- Operational efficiencies
- Procurement savings
- Revenue improvements
The model adjusts operating income to reflect these expected benefits.
The model includes simplified acquisition accounting adjustments such as:
- Goodwill creation
- Asset write-ups
- Additional depreciation
- Intangible amortization
These adjustments affect post-acquisition earnings.
The model combines:
- Acquirer earnings
- Target earnings
- Synergies
- Interest expense
- Taxes
- Accounting adjustments
to estimate post-acquisition Net Income.
The model calculates:
Pro Forma EPS = Pro Forma Net Income ÷ Pro Forma Shares Outstanding
The result is compared against the acquirer's original EPS.
Finally, the model calculates:
Accretion (%) = (Pro Forma EPS − Standalone EPS) ÷ Standalone EPS
Interpretation:
- Positive percentage → Accretive Deal
- Negative percentage → Dilutive Deal
- Zero → EPS Neutral
Examples of user-controlled assumptions include:
- Purchase Price
- Purchase Premium
- Financing Mix (% Cash / Debt / Equity)
- Interest Rate
- Tax Rate
- Cost Synergies
- Revenue Synergies
- Shares Outstanding
- Existing Debt
- Cash Balance
All calculations update dynamically when assumptions are modified.
The model generates key transaction metrics, including:
- Pro Forma Net Income
- Pro Forma EPS
- EPS Accretion/Dilution %
- Shares Issued
- New Debt
- Interest Expense
- Synergy Contribution
- Goodwill Created
- Purchase Premium
- Transaction Summary Dashboard
The model supports scenario analysis by testing changes in assumptions such as:
- Purchase Price
- Financing Mix
- Interest Rate
- Tax Rate
- Cost Synergies
- Revenue Synergies
This allows users to evaluate how different deal structures affect shareholder value.
This project demonstrates proficiency in:
- Financial Modeling Best Practices
- Dynamic Model Design
- Assumption-Driven Calculations
- Scenario Analysis
- Error Handling
- Financial Statement Integration
- Logical Functions
- Lookup Functions
- Financial Ratio Analysis
- Professional Formatting
- Dashboard Design
- M&A Analysis
- EPS Analysis
- Corporate Finance
- Investment Banking
- Financial Statement Analysis
- Valuation Fundamentals
- Acquisition Modeling
- Synergy Analysis
- Advanced Formulas
- IF Functions
- INDEX/MATCH or XLOOKUP
- Dynamic Linking
- Named Ranges
- Data Validation
- Conditional Formatting
- Scenario Analysis
- Sensitivity Tables
- Professional Financial Modeling Layout
By completing this project, I gained practical experience in:
- Building an investment banking financial model from scratch.
- Evaluating whether an acquisition creates shareholder value.
- Modeling multiple acquisition financing structures.
- Understanding the impact of synergies on post-acquisition earnings.
- Constructing dynamic, assumption-driven Excel models.
- Performing professional M&A analysis using industry-standard methodologies.
This project is intended for educational and portfolio purposes. It demonstrates practical financial modeling techniques commonly used in investment banking, corporate finance, and mergers & acquisitions analysis.