Corporate Finance, M&A Divestitures & IRC Section 355 Split-Offs
Corporate Split-Off Exchange Offer Proration & EPS Formula
Calculate IRC Section 355 Split-Off Parent Shares Retired (M), Oversubscribed Tender Proration Factor (%), Post-Split RemainCo EPS ($/sh), and EPS Lift vs Pro-Rata Spin-Off (%).
Unlike a pro-rata spin-off, an IRC §355 split-off retires parent shares like a tax-free buyback!
When a conglomerate separates a subsidiary under IRC Section 355, a Pro-Rata Spin-Off distributes subsidiary shares as a dividend to all Parent shareholders—leaving Parent diluted share count unchanged (500M shares). In contrast, a Split-Off Exchange Offer invites Parent shareholders to surrender Parent shares in exchange for SpinCo_Offered / Exchange_Ratio Parent shares retired! Because exchange offers typically price SpinCo at a 7%–8% value sweetener, tenders are heavily oversubscribed—triggering a Tender Proration Factor = MIN(1, Max_Parent_Accepted / Parent_Shares_Tendered) while shrinking RemainCo’s denominator to lift post-separation EPS!
Verify on a Healthcare Split-Off Exchange Offer—Parent_PreSplit_Shares = 500.00M (B2), SpinCo_Shares_Offered = 216.00M (B3), Exchange_Ratio = 4.32 SpinCo shares per 1 Parent share (B4 -> Max Parent Accepted = 216 / 4.32 = 50.00M shares), Actual_Parent_Tendered = 200.00M shares (4.0x oversubscribed, B5), and RemainCo_Standalone_Net_Income = $2,250.00M (B6): Parent Shares Retired equals 50.00M (E2), Tender Proration Factor is 50 / 200 = 25.00% (E3), Post-Split RemainCo EPS reaches 2,250 / (500 - 50) = $5.00/sh (E4), beating a pro-rata spin-off ($4.50/sh) by +11.11% (E5)!
| IRC §355 Split-Off KPI (500M Parent, 216M SpinCo @ 4.32x, 200M Tendered, $2,250M NI) | Formula | Verified Output |
|---|---|---|
| Parent Shares Retired (M) | MIN(Tendered_M, SpinCo_Offered_M / Exch_Ratio) | 50.00M (40.00M @ 40M Tender) |
| Tender Proration Factor (%) | MIN(1, (SpinCo_M / Exch_Ratio) / Tendered_M) * 100 | 25.00% (100.00% @ 40M Tender) |
| Post-Split RemainCo EPS ($/sh) | RemainCo_NI_M / (Parent_Shares_M - Retired_M) | $5.00/sh ($4.89/sh @ 40M) |
| EPS Lift vs Pro-Rata Spin (%) | ((SplitOff_EPS - Spin_EPS) / Spin_EPS) * 100 | 11.11% (8.70% @ 40M Tender) |
Split-Off Share Retirement, Proration & RemainCo EPS Formula
Validate Parent_Shares > 0, SpinCo_Offered > 0, Exchange_Ratio > 0, Max_Accepted = SpinCo / Ratio < Parent_Shares, Tendered > 0, and RemainCo_NI > 0!
=LET(pr_s, B2, sp_o, B3, ex_r, B4, tn_s, B5, ni_r, B6, IF(OR(pr_s <= 0, sp_o <= 0, ex_r <= 0, sp_o / ex_r >= pr_s, tn_s <= 0, ni_r <= 0), "Invalid Split-Off Input", LET(rt_s, MIN(tn_s, sp_o / ex_r), ep_s, ni_r / (pr_s - rt_s), ep_0, ni_r / pr_s, ROUND(((ep_s - ep_0) / ep_0) * 100, 2))))Undersubscribed Clean-Up Spin Check (Set Parent Tendered Shares = 40.00M)
Lower Actual_Parent_Tendered B5 from 200.00M to 40.00M (< 50.00M capacity): Proration Factor E3 hits 100.00% (all tendered shares accepted!), Parent Shares Retired E2 is 40.00M, RemainCo EPS E4 is 2,250 / 460 = $4.89/sh, and EPS Lift E5 is 8.70%!
=IF(ISTEXT(E5), E5, ROUND(B6 / (B2 - MIN(B5, B3 / B4)), 2))Try the example
Use the original values or change them to test your understanding.