Skip to content
SheetRank
Deal FlowAcademyInterview PrepFor ProfessorsResourcesPricingSign InCreate account
Deal FlowAcademyInterview PrepFor ProfessorsResourcesPricing
Sign InCreate account

M&A Merger Model (Accretion / Dilution)

Combine two companies in a stock-and-cash deal and build the merger model, not just the EPS test: total uses including transaction fees, the funding mix, new shares issued, after-tax interest on the fee-funded debt, the full purchase-accounting entry through net identifiable assets and the goodwill residual, step-up amortization, and synergies that phase in rather than arriving whole. Then it covers what the EPS analysis alone can't: a contribution table that sums to 100%, pro forma ownership set against it, and a Year 2 build where synergies reach run-rate while the deal costs don't. Every line must be linked, not pasted.

IB · Advanced · about 120 minutes · 33 guided steps

Lesson outline

Acquirer

  1. Step 1: Acquirer Standalone EPS

Purchase & Funding

  1. Step 2: Purchase Equity Value
  2. Step 3: Total Uses of Funds
  3. Step 4: Cash Consideration
  4. Step 5: Stock Consideration
  5. Step 6: New Shares Issued
  6. Step 7: New Debt Raised
  7. Step 8: New Interest Expense
  8. Step 9: After-Tax Interest

Purchase Accounting

  1. Step 10: Net Identifiable Assets Acquired
  2. Step 11: Goodwill Created
  3. Step 12: Incremental D&A from Step-Up
  4. Step 13: After-Tax D&A Step-Up Drag

Pro Forma — Year 1

  1. Step 14: After-Tax Run-Rate Synergies
  2. Step 15: Year 1 Realized Synergies
  3. Step 16: Pro Forma Net Income
  4. Step 17: Pro Forma Shares
  5. Step 18: Pro Forma EPS

Result — Year 1

  1. Step 19: Accretion / (Dilution)
  2. Step 20: Accretion / (Dilution) per Share

Contribution Analysis & Pro Forma Ownership

  1. Step 21: Acquirer % of Pro Forma NI
  2. Step 22: Target % of Pro Forma NI
  3. Step 23: Synergies % of Pro Forma NI
  4. Step 24: Deal Costs % of Pro Forma NI
  5. Step 25: Acquirer Pro Forma Ownership
  6. Step 26: Target Pro Forma Ownership

Pro Forma — Year 2 (Synergy Ramp)

  1. Step 27: Year 2 Acquirer Net Income
  2. Step 28: Year 2 Target Net Income
  3. Step 29: Year 2 Realized Synergies
  4. Step 30: Year 2 Pro Forma Net Income
  5. Step 31: Year 2 Standalone EPS
  6. Step 32: Year 2 Pro Forma EPS
  7. Step 33: Year 2 Accretion / (Dilution)