Investment Banking & Corporate M&A
M&A EPS Accretion / Dilution & Breakeven Synergy Formula
Calculate Pro-Forma M&A Earnings Per Share under mixed stock-and-debt acquisition financing, EPS Accretion/Dilution percentage, and Pre-Tax Breakeven Synergies.
Model mixed stock-and-debt M&A EPS accretion and exact breakeven synergies!
In investment-banking merger consequences analysis, acquiring a target for Purchase_Equity_Value P_deal financed by Stock_Consideration_Share w_stk in [0, 1] (issuing New_Shares = (w_stk * P_deal) / P_acq at Acquirer Share Price P_acq) and Debt/Cash Share (1 - w_stk) at Pre-Tax Borrowing/Foregone Rate i_debt (with Effective Corporate Rate tau_corp) yields Pro-Forma Combined Net Income NI_pf = NI_acq + NI_tgt + (Synergies - (1 - w_stk) * P_deal * i_debt) * (1 - tau_corp) divided by Pro-Forma Diluted Shares S_pf = S_acq + New_Shares!
Verify on Acquirer_Net_Income NI_acq = $400M (B2), Acquirer_Shares S_acq = 100M (B3 -> Standalone EPS = $4.00/sh), Acquirer_Share_Price P_acq = $80.00 (B4, P/E = 20.0x), Target_Net_Income NI_tgt = $60M (B5), Offer_Equity_Value P_deal = $1,600M (B6, 26.7x Target P/E > 20.0x Acquirer P/E!), Stock_Mix_Share w_stk = 0.50 (50% stock = $800M -> 10.00M New Shares in E2; 50% new debt = $800M, B7), Debt_Interest_Rate i_debt = 0.06 (6.0% -> $48M interest, B8), Pre_Tax_Cost_Synergies = $30M (B9), and Effective_Rate tau_corp = 0.25 (25.0%, B10): Pro-Forma Net Income is 400 + 60 + (30 - 48) * 0.75 = 460 - 13.50 = $446.50M across 110.00M shares -> Pro-Forma EPS = $4.0591 -> $4.06/sh (+1.48% Accretive, +0.0148 in E4)! Notice that in an all-stock deal (w_stk = 1.00 -> 20M new shares, zero interest), 482.50 / 120 = $4.0208 (+0.52%), whereas with zero synergies (B9 = 0 at w_stk = 1.00), paying 26.7x stock for a 20.0x acquirer is -4.17% Dilutive ($3.8333/sh)!
| M&A Merger Consequences Metric ($1.6B Deal, 50% Stock / 50% Debt @ 6%) | Formula | Verified Output |
|---|---|---|
| New Acquirer Shares Issued (M) | (w_stk * P_deal) / P_acq | 10.00M (S_pf = 110.00M) |
| Pro-Forma Combined EPS ($/sh) | NI_pf / (S_acq + New_Shares) | $4.0591 / sh (vs $4.0000 Base) |
| EPS Accretion / Dilution (%) | (EPS_pf - EPS_base) / EPS_base | +0.0148 (+1.48% Accretive) |
| Pre-Corp Breakeven Synergies ($M) | Required Synergy Lift for EPS_pf = EPS_base | $21.33M (Current $30M > $21.33M) |
Pro-Forma Combined EPS & Accretion/Dilution Ratio Formula
Check Breakeven Pre-Corporate-Rate Synergies algebraically: to earn $4.00/sh on 110M pro-forma shares requires NI_pf = $440.00M; since NI_acq + NI_tgt = $460M and net debt interest cost is $48M * 0.75 = $36M ($424M pre-synergy NI), net synergies needed equal $16.00M, or $16.00M / 0.75 = $21.33M!
=LET(ni_a, B2, sh_a, B3, px_a, B4, ni_t, B5, dl_v, B6, w_st, B7, rt_d, B8, sy_p, B9, tx_c, B10, IF(OR(ni_a <= 0, sh_a <= 0, px_a <= 0, dl_v <= 0, w_st < 0, w_st > 1, rt_d < 0, sy_p < 0, tx_c < 0, tx_c >= 1), "Invalid Merger Input", LET(sh_n, (w_st * dl_v) / px_a, in_p, (1 - w_st) * dl_v * rt_d, ni_pf, ni_a + ni_t + (sy_p - in_p) * (1 - tx_c), ep_pf, ni_pf / (sh_a + sh_n), ep_bs, ni_a / sh_a, ROUND((ep_pf - ep_bs) / ep_bs, 4))))Exact Pre-Tax Breakeven Synergy Hurdle Formula
Solve NI_pf / S_pf = NI_acq / S_acq directly for Synergies_BE = MAX(0, Interest + ((EPS_base * S_pf - NI_acq - NI_tgt) / (1 - tau_corp)))!
=LET(ni_a, B2, sh_a, B3, px_a, B4, ni_t, B5, dl_v, B6, w_st, B7, rt_d, B8, tx_c, B10, IF(ISTEXT(E4), E4, LET(sh_pf, sh_a + (w_st * dl_v) / px_a, ep_bs, ni_a / sh_a, in_p, (1 - w_st) * dl_v * rt_d, ROUND(MAX(0, in_p + ((ep_bs * sh_pf - ni_a - ni_t) / (1 - tx_c))), 2))))Try the example
Use the original values or change them to test your understanding.