A free restaurant acquisition model in Excel, with SDE, the price and the SBA 7(a) loan
From the seller's net income to SDE, the new lease and a general manager paid at market; then the offer, the gift cards and escrow taken off the cash at closing, the project cost, the equity injection, the seller note on full standby, the loan payment, coverage and the valuation check: one sheet of inputs, live formulas and seven checks.
The worked case, a fictional restaurant, shows SDE of $357,020. With the new lease and a general manager paid at market, it earns $263,240. The buyer offers $735,000, of which the seller receives $573,600 in cash at closing; the project costs $876,700, and an SBA 7(a) loan of $772,700 costs $119,983 a year, a coverage of 2.19x.
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 147 free models.
Restaurant_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 Restaurant Owner, which explains the method behind it, chapter by chapter.
The Financial Model Library: all 148 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, rent today and under the new lease, a general manager's salary at market, the multiple, deferred maintenance, gift cards, the escrow, the closing count, closing costs, working capital, cash, seller note, rate, term and the lender's valuation.
Deal
SDE, the buyer's SDE, adjusted EBITDA, the offer and its multiples, the cash at closing, project cost, injection, loan, payment, coverage and the purchase debt against the valuation.
Checks
Seven tests on the injection, the seller note, the loan size, the coverage, the valuation, the term and unrecorded cash, and an All checks cell.
What the worked case returns
Measure
Value
SDE
$357,020
Base rent increase under the new lease
$7,200
The buyer's SDE
$349,820
General manager at market, with burden
$86,580
Buyer's adjusted EBITDA
$263,240
Offer for the business
$735,000
Offer as a multiple of adjusted EBITDA
2.79x
Cash to the seller at closing
$573,600
Project cost
$876,700
Minimum equity injection
$87,670
SBA 7(a) loan
$772,700
Monthly payment
$9,998.55
Debt service coverage
2.19x
Room below the valuation
$109,300
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, debt for the purchase within the lender's valuation); confirm them with your lender. State wage, tip, liquor and health rules are not in the file.
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; leave unrecorded cash at zero unless a record proves it.
Enter base rent today and under the new lease, and the salary of the general manager who will do the owner's job.
Choose your multiple and the deferred maintenance, and enter the gift cards, the escrow and the closing count of food and bar stock.
Enter closing costs, working capital, your cash, the seller note, the rate, the term and the lender's valuation, and read the checks.
Questions people ask about it
What is SDE for a restaurant?
Net income plus depreciation, interest, one working owner's salary and payroll costs, personal expenses and proved one-time items: what the restaurant produces for one owner who works in it.
Why pay a general manager in the model?
Because the owner's job is real work. Adjusted EBITDA, with the job paid at market, is what a lender tests and what a price should rest on.
Why does the seller receive less cash than the offer?
A seller note on full standby is paid only after the SBA loan, gift cards the buyer will honor are credited against the price, and an escrow may hold part of it against claims.
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 Restaurant 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.