A free auto repair shop acquisition model in Excel, with SDE and the SBA 7(a) loan
From the seller's net income to SDE, then to the earnings a buyer actually owns once the rent is at market, family labor is replaced and the owner's job is paid, then the offer, the project cost, the equity injection, the seller note on full standby, the loan payment and debt service coverage: one sheet of inputs, live formulas and five checks.
The worked case, a fictional shop, shows SDE of $416,745. Rent at market, an outside bookkeeper and the owner's job at a market salary leave $315,705. The buyer offers $1,085,000, the project costs $1,217,000, and an SBA 7(a) loan of $1,072,000 costs $166,457 a year, a coverage of 1.90x.
Get the template
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.
Auto_Repair_Shop_Acquisition_Model.xlsx (12 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.
The book behind this model
This model goes with The Auto Repair Shop Owner, which explains the method behind it, chapter by chapter.
The Financial Model Library: all 130 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).
This free file stays free. Secure checkout by Stripe.
Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →
What is in the file
3 sheets. Inputs can be changed; everything else is a formula, and the last sheet checks the figures against the book.
Inputs
The seller's trailing twelve months, the seller's salary, rent today and under the new lease, the family member's wage and its replacement, the owner's market salary, the multiple, deferred equipment, inventory, closing costs, working capital, cash, seller note, rate and term.
Deal
SDE, the buyer's SDE, adjusted EBITDA, the offer and its multiples, project cost, injection, loan, payment and coverage.
Checks
Five tests on the injection, the seller note, the loan size, the coverage and the term, and an All checks cell.
What the worked case returns
Measure
Value
SDE (seller's discretionary earnings)
$416,745
Rent increase under the new lease
$36,000
Saving on the family member's work
$22,320
The buyer's SDE
$403,065
The owner's job at market, with burden
$87,360
Buyer's adjusted EBITDA
$315,705
Offer
$1,085,000
Offer as a multiple of adjusted EBITDA
3.44x
Project cost
$1,217,000
Minimum equity injection
$121,700
SBA 7(a) loan
$1,072,000
Monthly payment
$13,871.42
Debt service coverage
1.90x
Every figure is a teaching assumption of the book's fictional case, not a market norm. The checks restate SBA rules as in force in November 2026 (10 percent minimum injection for an initial acquisition, a seller note on full standby for at most half of it, coverage of 1.25); confirm them with your lender.
How to use it on your own case
Type the seller's net income and add-backs from the trailing twelve months, with the seller's salary.
Enter the rent paid today and under the new lease, the family labor to replace and a market salary for the owner's job.
Choose your multiple, the deferred equipment to deduct and the parts inventory.
Enter closing costs, working capital, your cash, the seller note, the rate and the term, and read the checks.
Questions people ask about it
What is SDE for an auto repair shop?
Net income plus depreciation, interest, one working owner's salary and payroll costs, personal expenses and proved one-time items: what the shop produces for one owner who works in it.
Why adjust the rent when the seller owns the building?
The rent a seller pays to his own building company is whatever suited him; a buyer will pay market rent under a new lease, and the difference comes off earnings.
How much down payment does an SBA loan need for a repair shop?
For an initial acquisition, at least 10 percent of total project cost under the SBA's procedures as in force in November 2026; a seller note on full standby can provide at most half of it.
Is this template really free?
Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.
Go further
The free workbooks of The Auto Repair Shop Owner go further: the full companion set, blank models and the worked cases of the book.
LCR and NSFR calculatorLiquidity coverage and net stable funding built line by line, with encumbrance and six defensible readings.
Risk-weighted assets (RWA) calculatorStandardised against internal-model RWA, the mortgage loan split, CET1 ratios and the year the output floor binds.
Credit scorecard modelA points scorecard built from counts: bins, weight of evidence, information value and the leaking variable.
Price waterfall analysisList price to pocket price for one account and a whole company: nine leakages, ranked and added up.