A 100% leveraged ESOP buyout from valuation to debt-free: sources and uses, seller note and warrants, the internal loan and the 25% test, a ten-year cash waterfall, a stress case, the repurchase schedule and the seller's after-tax comparison. Seven sheets, no macros.
The file follows Carrow Fastener Supply, a fictional distributor sold 100% to its ESOP for $32.76 million, or $27.30 a share. A $15.00 million bank loan, $1.16 million of company cash and a $19.50 million seller note pay for it. The day after closing the shares are worth $0.05; with no federal income tax as an S corporation, the debt is gone by 2034 and the value reaches $51.75 a share at the end of 2036.
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.
ESOP_Transaction_Model_Carrow.xlsx (27 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
This file is the worked case of The ESOP Handbook. The book explains every assumption and every sheet: why the trust may not pay for synergies, how Section 1042 defers the founder's gain, why the internal loan runs thirty years, and how the repurchase obligation grows after the debt is gone.
DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide
Seven sheets, in the order the calculation runs. Blue type on a yellow fill is an input; black type is a formula.
Apply the stress. Set the EBITDA shortfall to 15%: coverage falls to 1.04x in 2027, the equity is below zero at the end of that year, and the seller note is repaid only at maturity. The bank is still paid on schedule, because the seller note bends.
Shorten the internal loan. Set it to 15 years: the contribution needed exceeds 25% of covered payroll in the first year. That is why internal loans usually run far longer than the bank's.
Raise the multiple. Set it to 6.0x: the price and the seller note rise, and first-year coverage falls. Find the price at which coverage drops below the level your lender would accept.
The trust paid $32.76 million with borrowed money and the company carries $34.50 million of acquisition debt, so the equity right after closing is worth $0.06 million. It rebuilds as the debt is repaid: $12.02 at the end of 2029 and $51.75 at the end of 2036 in the base case.
No. Repurchase installments sit in a triangular matrix that reads only earlier years, so the file recalculates without iterative calculation.
You can reuse the structure and replace every input. Carrow and every figure in it are fictional, and nothing here is legal, tax or investment advice.