Companion files · Buying a Small Business
Value it, finance it with an SBA loan and seller notes, and close without overpaying.
These are the companion files of Buying a Small Business by Julian R. Sterling.The book on Amazon →
The two Excel workbooks that produced every figure in the book, re-verified and corrected where they were wrong. Units are thousands of dollars; blue cells are inputs, black cells are formulas, and each workbook ends with a Check sheet setting the printed figure beside the live one: 122 controls in all, every one green. Around them: the same two models with the inputs emptied, thirteen working documents to print, forty questions that mark themselves, and three cases the book names and never takes to a number. Nothing is locked, protected or watermarked.
Free to download. No sign-up, no email address, nothing to fill in.
Seven workbooks, the printable documents and the read-me. Each group below can also be downloaded on its own. Last revised 24 September 2026.
Optional. When a workbook on this page is corrected or a new worked case goes up, readers on the list get one email, plus a short note when a new book comes out. The downloads do not need it.
Join the reader listRun by MailerLite, off this site. How your address is used.
Each has a Check sheet that puts every printed figure beside the live formula, and a Scenarios sheet that says which single input reproduces each sensitivity in the book. No macros, no circular references, no external links. Download these two67 KB
Deal A · Chapters 2 to 10, 13 to 15
An HVAC contractor listed at 3.21 million. The bridge from 917,000 of broker SDE to 676,000 of adjusted EBITDA; sources and uses with the valuation cap and the FY2027 guaranty fee solved in closed form, which fixes the loan at 2,340,000; ten years of operations with bonus depreciation and the 80 percent loss rule; the exit allocated by asset class. Revised: under the price-only reading of the valuation cap, with an appraisal below the price, the cap carried the fee on the uncapped loan and the loan ran past its own cap; at an appraisal of 2,300,000 the loan is 2,348,553, not 2,348,817. The shipped figures do not change. Sixty checks, among them the lender’s maximum price in closed form: 3,282,798.
Download the workbook34 KBDeal B · Chapters 3, 8 and 11
A cleaning company whose largest customer, a hospital system, is 34 percent of revenue and about 77 percent of profit. Shipped at 1.59 million, just under the lender's maximum, so that you can watch it fail the book's own test in years 3 to 5. Type 34% into one cell to lose the hospital. Re-verified: the lender’s maximum is 1,595,346, and the book’s own test, cash coverage of 1.25 in the weakest of years 3 to 5, is met at 1,338,130. Sixty-two checks.
Download the workbook34 KB| Lender's coverage, year 1 | 1.56x |
| Cash coverage, year 1 (after capex and tax) | 0.96x |
| Tri-County cash coverage, years 3 to 5, at 1.59 million | 1.10x to 1.12x |
The two workbooks with their inputs emptied: 68 on Cedar Ridge’s Inputs sheet, 65 on Tri-County’s. The Check sheets count what is still missing and test what holds for any inputs.
Deals A and B · every sheet
The seller’s three years, the broker’s add-backs and the quality of earnings, the price and the working capital, the equity injection and the two seller notes, the SBA terms and the fee tiers, the tax elections, the exit and the stress switch, all emptied, with the same formulas behind them. Every sheet fills in once the last input is entered; the appraisal and the exit multiple may stay blank, as the book leaves them.
The book’s inputs are listed in a text file inside the archive. Type them back in and the book’s figures come back with them: a loan of 2,340,000, 1.56 and 0.96 in year 1, 1.10 to 1.12 at Tri-County.
Download the blank set59 KBThirteen pages to print and use. A4, with margins wide enough for US Letter.
Deals A and B · every chapter with a figure
The add-back schedule, broker against quality of earnings, with the evidence that settles each line. The quality-of-earnings request list. The price in four multiples, beside the lender’s maximum and the book’s cash test. Sources and uses with the valuation cap read three ways. The guaranty fee and the loan that sizes itself, tier by tier. The seller notes read from both sides. Coverage year by year, the lender’s ratio beside the cash one. The allocation and the tax years. The stress pack. The customer concentration worksheet. The walk-away price, with the guarantee beside the return. The exit by asset class. Both fact patterns, with the order of work.
Download the PDF33 KBA workbook that marks itself. Answer in the yellow cells; the marking fills in as you go.
Both deals · all parts of the book
Seven on earnings and price, seven on sources and uses, seven on coverage and cash, six on tax and the exit, seven on Tri-County, and six on the three cases below. Numbers are marked to a tolerance, multiple choice to the letter, and the score sheet counts your errors part by part: that is your revision list.
Nothing is hidden. The marking sheet holds every answer, every tolerance, and the reason for each answer.
Download the question book17 KBNew material, not a restatement. Three situations the book names and never takes to a number. Each case is one workbook: the note is the first sheet, the model is the rest, and a checks sheet closes it. Type your own figures in and every finding recomputes.
Deal A · the exit and the guarantee · Case one
Workbook A prints the 64.1 per cent return on 162,897 of cash beside the 2,340,000 the buyer personally guarantees, and stops there. At the book’s mildest shock, 10 per cent of revenue lost from year 2, the buyer puts in 273,206 of personal cash over five years just to keep paying. Liquidated at the end of year 3 (recoveries ADDED), the guarantee is called for 1,227,329 to 1,265,487 whatever the shock: the loss runs to 8.5 to 12.5 times the cash invested. The lender’s own test fails at a loss of 7.33 per cent.
Deal B · Chapters 3, 8 and 11 · Case two
At the entry multiple, 1,217,978 of the 1,590,000 is the hospital’s profit, and the price assumes it renews with certainty. Without it the business carries 373,273 at the lender’s 1.25. If it leaves at the year-2 renewal the buyer funds 738,112 over five years; at the book’s own buyer’s price of 1,338,000 still 531,029. An 80 per cent chance of renewal (ADDED) prices the business at 1,346,404, and bringing the lender back to 1.25 takes new revenue worth 95.8 per cent of the hospital’s.
Deal A · the seller notes · Case three
At the seller’s discount rates (ADDED), the 2,600,000 headline is worth 2,533,642 in cash today. Paid that value in cash, with no notes, the buyer needs 313,759 at closing against 162,897, but covers year 1 at 1.04 instead of 0.96. The notes save the buyer 150,862 of cash and 193,642 of guaranteed debt, for 66,358 of the seller’s value: negotiate them and the price as one number.
Download the three cases54 KB| Units | thousands of dollars: 2,340.0 is 2,340,000 |
| Blue text | an input, on the Inputs sheet only: you may edit these |
| Black text | a formula: do not overtype these |
| Yellow fill | an assumption that carries the answer |
| Check sheet | the printed figure beside the computed one, with a tolerance and an OK; in the blank set and the cases, each control states its own verdict and the file ends ALL OK |
| ADDED | a figure the book does not give, used in the cases and marked wherever it appears |
The workbooks open in Microsoft Excel, LibreOffice Calc, Google Sheets and Numbers; the PDF prints on A4 or US Letter. They use no macros and no add-ins, so nothing needs to be enabled or trusted. If your spreadsheet asks to update links on opening, decline: there are none.
| 24 Sep 2026 | Both workbooks re-verified, 122 checks. Under the price-only reading of the valuation cap, with an appraisal below the price, the loan is now solved with the fee on the capped loan: 2,348,553 at an appraisal of 2,300,000, not 2,348,817. Every figure the book prints is unchanged. Tolerances tightened to 0.0005 on ratios, and the lender’s maximum price added in closed form. Added: a blank set, thirteen working documents, forty questions that mark themselves, and three cases. |
More in corporate finance, with free companion files. The full list of titles is on the author page.
Discover more of Julian R. Sterling's practical library of models, checklists and worked cases.
Read the related analysis Browse Julian R. Sterling's books Browse all companion filesAlso available as a standalone free template: Small business acquisition model (SBA loan).
If this book helped — or didn’t — a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The workbook stays free either way.