Employee Ownership, Corporate Succession & ERISA / IRC §4975 Leveraged ESOPs
Leveraged ESOP Suspense-Share Release & Repurchase Formula
Calculate ERISA / IRC §4975 Leveraged ESOP General Principal-Plus-Interest Suspense-Share Release Fraction, Shares Allocated to Employee Accounts, IRC §404(a)(9) Principal + Interest Tax Shield ($M), and IRC §409(h) Share Repurchase Obligation ($).
Track both ERISA suspense-share release and emerging IRC §409(h) cash repurchase obligations!
In a Leveraged Employee Stock Ownership Plan (ESOP) buyout, the ESOP trust borrows via an internal company loan to acquire sponsor stock held initially in an unallocated Suspense Account! Under ERISA / Treas. Reg. §54.4975-7(b)(8) (General Principal-Plus-Interest Rule), each annual employer contribution paying Current_Year_P&I releases Suspense_Shares * (Current_Year_P&I / (Current_Year_P&I + Future_Remaining_P&I)) into active employee accounts! Uniquely under IRC §404(a)(9), C-Corp sponsors deduct BOTH loan principal and interest via ESOP contributions—yet private-company CFOs must simultaneously reserve cash for IRC §409(h) Repurchase Obligations as departing/retiring employees put vested shares back to the company at rising appraised Fair Market Value (FMV)!
Verify on a Middle-Market Engineering Firm ESOP—Beginning_Suspense_Shares = 500,000 sh (B2), Current_Year_Internal_Loan_P&I = $4.80M (B3), Remaining_Future_Loan_P&I = $43.20M (total remaining P&I = $48.00M, B4 -> Suspense Release Fraction = 4.80 / 48.00 = 0.1000 in E2, allocating 50,000 shares to employees in E3!), C_Corp_Tax_Rate = 0.25 (25.0%, B5 -> Deductible P&I Tax Shield = 4.80 * 0.25 = $1.20M in E4), Appraised_Share_FMV = $12.00/sh (B6), and Annual_Turnover_Put_Rate = 0.08 (8.0%, B7): Emerging Annual Repurchase Cash Need on the released cohort is 50,000 * 12.00 * 0.08 = $48,000 (E5)!
| Leveraged ESOP Metric (500k Suspense Sh, $4.8M / $43.2M P&I, 25% Tax, $12 FMV, 8% Put) | Formula | Verified Output |
|---|---|---|
| ERISA P&I Release Fraction | Current_PI / (Current_PI + Future_PI) | 0.1000 (1.0000 Final Payoff Yr) |
| Employee Allocated Shares (sh) | Beginning_Suspense_Shares * Release_Frac | 50,000 sh (500,000 Final Yr) |
| C-Corp Principal+Int Tax Shield ($M) | Current_Loan_PI_M * Tax_Rate | $1.20M |
| Cohort Repurchase Obligation ($) | Allocated_Shares * Share_FMV * Put_Rate | $48,000 ($120,000 @ $30 FMV) |
ERISA Suspense-Share Release & IRC §409(h) Repurchase Formula
Validate Suspense_Shares > 0, Current_P&I > 0, Future_P&I >= 0, Tax_Rate in [0, 0.50), Share_FMV > 0, and Put_Rate in [0, 0.50]!
=LET(sp_s, B2, pi_c, B3, pi_f, B4, tx_r, B5, fm_v, B6, pt_r, B7, IF(OR(sp_s <= 0, pi_c <= 0, pi_f < 0, tx_r < 0, tx_r >= 0.5, fm_v <= 0, pt_r < 0, pt_r > 0.5), "Invalid Leveraged ESOP Input", LET(rf_c, pi_c / (pi_c + pi_f), al_s, sp_s * rf_c, ROUND(al_s * fm_v * pt_r, 2))))Deleveraging Valuation Surge & Final Loan-Payoff Checks
As acquisition debt pays down, equity FMV per share often jumps 2.5x: set B6 = $30.00/sh to watch Cohort Repurchase Cash E5 surge to $120,000! Then set Future_Remaining_P&I B4 = 0 (final loan year) to verify Release Fraction E2 = 1.0000 and all 500,000 remaining shares allocate cleanly (E3)!
=IF(ISTEXT(E5), E5, ROUND(B2 * (B3 / (B3 + B4)), 0))Try the example
Use the original values or change them to test your understanding.