# The Business Broker: companion files

Julian R. Sterling

## What is here

- **Business_Broker_Model.xlsx**: the workbook that rebuilds the Corvale sale and reproduces the figures of the book with live formulas. Sheets: Inputs, Normalization, Valuation, Fee, Offers, Sources and Uses, Debt Service, Allocation, Firm, Main Street, Checks.
- **Business_Broker_Toolkit.docx**: the 8 checklists of Appendix 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), in editable form.

## Which sheet answers which chapter

- Chapter 5: Normalization (add-backs of $545,000, SDE of $1,157,000, adjusted EBITDA of $1,007,000, and the figures after the quality of earnings)
- Chapter 6: Valuation (the range, the asking price of $3,750,000, the letter of intent at $3,500,000)
- Chapter 13: Valuation (the re-trade to $3,370,000)
- Chapter 4: Fee (the scale, the fee of $262,200 on the final price, the retainer and the price path)
- Chapter 10: Offers (the SBA buyer's offer worth $3,284,403 today against $3,195,759 for the private equity offer)
- Chapter 11: Sources and Uses (total project cost of $3,630,000, an SBA 7(a) loan of $3,267,000, the valuation test)
- Chapter 12: Debt Service ($512,672 a year, coverage of 1.89x, the stress and the repayment schedule)
- Chapter 14: Allocation (the Form 8594 classes and $2,520,000 of goodwill)
- Chapter 3: Firm (fee revenue of $1,404,000, the funnel and the weighted pipeline)
- Chapter 7: Main Street (Listing B at $360,000 and its 7(a) Small loan)
- Appendix A: 16 exercises, with the answers the workbook returns

## Two inputs to change first

1. On Inputs, set the accepted flag of the one-time legal fees to 0: SDE, EBITDA, the re-traded price, the fee, the financing and the coverage all move with it.
2. On Inputs, raise the SBA loan rate by one point: watch the annual debt service and the coverage on the Debt Service 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.

Thornbeck Business Advisors, Corvale Climate Services, its owner, the buyers and Listing B are fictional; prices, multiples, fees, splits, costs, interest rates and dates are teaching assumptions, not the terms of any real engagement, the quote of any real market or a forecast. Provided as is, without warranty. Not legal, tax, accounting or investment advice.
