Companion files · The Private Markets Career Guides
Selling a Business From Listing to Closing: Valuation, SDE and Add-Backs, Buyer Financing and SBA Loans, Deal Structure and Small Business M&A.
DRM-free PDF edition, $19.99: searchable, printable, instant download.Buy the PDFFree sample
These are the companion files of the book. One workbook rebuilds the sale of Corvale Climate Services, the fictional HVAC service company of the case, by Thornbeck Business Advisors, a fictional brokerage: revenue of $6,800,000, seller’s discretionary earnings of $1,157,000, and a final price of $3,370,000. It follows the add-backs, the valuation and the re-trade, the success fee, two offers in today’s money, the SBA buyer’s sources and uses, the debt service and coverage, the allocation of the price, the brokerage’s own year and a main street sale beside it. A toolkit holds the checklists of Appendix B in an editable form.
The archive holds the workbook, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links. The workbook recalculates in Excel, LibreOffice or Google Sheets.
Chapters 3 to 7 and 10 to 14, and Appendix A
An Inputs sheet holds every assumption of the case, and one sheet follows each step of the sale: Normalization, Valuation, Fee, Offers, Sources and Uses, Debt Service, Allocation, Firm, Main Street. A Checks sheet puts the figures printed in the book beside the cells that compute them, and the 16 exercises of Appendix A run on it.
Download the workbook33 KBAppendix B
Before taking a listing; The engagement agreement; Normalizing the numbers; Confidentiality and marketing materials; Qualifying a buyer; Comparing offers and the letter of intent; Financing and due diligence; The closing week.
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me3 KB| The earnings | Pre-tax income of $612,000 plus $545,000 of add-backs: SDE of $1,157,000, and adjusted EBITDA of $1,007,000 after a general manager’s cost |
| The re-trade | A quality of earnings finding of $40,000 takes the price from $3,500,000 to $3,370,000 at the letter of intent multiple; the fee becomes $262,200 |
| The financing | An SBA 7(a) loan of $3,267,000 repaid at $512,672 a year: coverage of 1.89x on confirmed adjusted EBITDA of $967,000 |
The files are provided as they are, without warranty of any kind. The model is illustrative: Thornbeck Business Advisors, Corvale Climate Services, its owner, the buyers and Listing B are fictional, and prices, multiples, fees, splits, costs, interest rates and dates are the book’s assumptions, not the terms of any real engagement, the quote of any real market or a forecast. Nothing here is legal, tax, accounting or investment advice.