A free liquor store acquisition model in Excel, with SDE, the inventory and the SBA 7(a) loan
From the seller's net income to SDE, books that charge purchases as cost put on two inventory counts, the new lease and the owner's hours paid at market; then the offer, the inventory price at the closing count, 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 six checks.
The worked case, a fictional store, shows SDE of $280,051 on the seller's books. Put on the counts, with the new lease and the owner's hours paid, the store earns $223,229. The buyer offers $730,000 plus $391,100 of inventory, the project costs $1,209,100, and an SBA 7(a) loan of $1,064,100 costs $165,230 a year, a coverage of 1.35x.
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 136 free models.
Liquor_Store_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 Liquor Store Owner, which explains the method behind it, chapter by chapter.
The Financial Model Library: all 137 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 and the rise in stock between two counts, rent today and under the new lease, the owner's hours and their market cost, the multiple, deferred equipment, the closing count and dead stock, closing costs, working capital, cash, seller note, rate, term and the lender's valuation.
Deal
SDE on the books and on the counts, the buyer's SDE, adjusted EBITDA, the offer and its multiples, the inventory price, project cost, injection, loan, payment, coverage and the purchase debt against the valuation.
Checks
Six tests on the injection, the seller note, the loan size, the coverage, the term and the valuation, and an All checks cell.
What the worked case returns
Measure
Value
SDE on the seller's books
$280,051
SDE on the two inventory counts
$308,051
Base rent increase under the new lease
$6,900
The buyer's SDE
$301,151
The owner's hours at market, with burden
$77,922
Buyer's adjusted EBITDA
$223,229
Offer for the business
$730,000
Offer as a multiple of adjusted EBITDA
3.27x
Inventory price at the closing terms
$391,100
Project cost
$1,209,100
Minimum equity injection
$120,910
SBA 7(a) loan
$1,064,100
Monthly payment
$13,769.19
Debt service coverage
1.35x
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 liquor 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 and the rise in stock between two counts.
Enter base rent today and under the new lease, and the hours and rates that replace the owner's work.
Choose your multiple and the deferred equipment, and enter the closing count: saleable stock, dead stock and what you pay for it.
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 liquor store?
Net income plus depreciation, interest, one working owner's salary and payroll costs, personal expenses and proved one-time items: what the store produces for one owner who works in it.
Why put the seller's books on the inventory counts?
Books that charge every purchase as cost treat stock still on the shelf as sold; two counts a year apart show what the year really earned, and an estimate does not.
Is the inventory included in the price of a liquor store?
Usually not: it is counted at cost at closing and added to the price, with agreed terms for dead stock and out-of-code beer, and it is part of the SBA project cost.
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 Liquor Store 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.