ExcelModelling Templates$50

Merger & Accretion/Dilution Model

About this resource

M&A modelling is core to any IB technical interview. This template walks through every step of a merger model, from consideration structure and purchase price allocation to synergy build and pro-forma EPS accretion/dilution — the exact analysis asked in banking interviews.

Sheets included

01Deal Summary (acquirer/target, consideration)

02Purchase Price Allocation & Goodwill

03Pro-Forma P&L (combined income statement)

04Synergies (revenue & cost, with ramp-up)

What's included

Full consideration structure: cash, stock, debt

Purchase price allocation and goodwill calculation

Revenue and cost synergy build with ramp-up schedule

Pro-forma income statement and EPS analysis

Accretion/dilution sensitivity table

M&Amerger modelaccretiondilutionmodelling

Price

$50

Instant download after payment

Secure payment via Stripe

Lifetime access