# The Exit Planning Advisor: companion files

Julian R. Sterling

## What is here

- **Exit_Planning_Advisor_Model.xlsx**: the workbook that rebuilds the Quillfield exit plan and reproduces the figures of the book with live formulas. Sheets: Inputs, Readiness, Owner's Number, Value Today, Value Drivers, Third-Party Sale, Management Buyout, ESOP, Family Transfer, Comparison, Checks.
- **Exit_Planning_Advisor_Toolkit.docx**: the 8 checklists of Appendix B (the discovery meeting; the readiness assessment; the owner's number; the planning valuation and the net proceeds bridge; the value acceleration plan; choosing the route; the tax and estate questions for the CPA and the estate attorney; the contingency file), in editable form.

## Which sheet answers which chapter

- Chapter 3: Readiness (the scorecard, 17 out of 40 in January 2027, 32 targeted for 2029)
- Chapter 4: Owner's Number (a portfolio of $10,857,143, so $9,000,000 needed from the business after tax)
- Chapters 5 and 6: Value Today (adjusted EBITDA of $2,100,000, enterprise value of $9,975,000, $6,681,812 after tax from a sale today, a value gap of $2,318,188)
- Chapters 7 to 9: Value Drivers (fiscal 2029 under the plan, enterprise value of $14,955,750, and the bridge of $4,980,750)
- Chapter 10: Third-Party Sale (present value after tax of $10,633,154)
- Chapter 11: Management Buyout (a seller note of $4,602,000, present value of $9,143,500)
- Chapter 12: ESOP (section 1042: $7,216,890 of replacement property, $1,704,222 of tax deferred, present value of $11,451,984 before it)
- Chapter 13: Family Transfer (present value of $8,515,158, and the gift variant)
- Chapter 14: Comparison (the four routes side by side against the owner's number)
- Appendix A: 12 exercises, with the answers the workbook returns

## Two inputs to change first

1. On Inputs, set the withdrawal rate to 4.0 percent: the portfolio needed, the owner's number and the value gap move with it.
2. On Inputs, set the owner's discount rate to 10 percent: watch which routes still clear the owner's number on the Comparison sheet. Reset the inputs afterwards: the Checks sheet compares the workbook with the figures printed in the book.

Blue type on a light blue background is an input, black type a formula, green type a link to another sheet. Every input is on the Inputs sheet. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs.

Tax in the workbook is one blended teaching rate, a simplification: the workbook is not a tax calculator, and real figures come from the CPA and the estate attorney. Tarrowmere Advisory, Quillfield Precision, the owner and the family are fictional; multiples, rates, costs, fees and dates are teaching assumptions, not market data, the terms of any real engagement or a forecast. Provided as is, without warranty. Not legal, tax, accounting or investment advice.
