Retail Valuation Template

Start with the Assumptions sheet. Enter your store's trailing 12-month revenue, gross margin, and operating expenses by category. The most important step is calculating accurate SDE — add back your owner salary, owner benefits (health insurance, vehicle, phone), depreciation, amortization, and any non-recurring expenses like a one-time legal fee or a renovation cost that won't repeat. The sheet guides you through this add-back process line by line. If you're valuing a store you're considering buying, use the financials from the offering memorandum and verify them against tax returns — the SDE figure in a broker listing is often optimistic, so take the time to normalize it yourself.

With your earnings inputs in place, move to the Income Approach sheet and select the SDE multiple that fits your store type and situation. The reference table on that sheet shows typical ranges by retail category — specialty stores with loyal repeat customers and strong gross margins command higher multiples than commodity retailers or stores with heavy online competition. On the Market Approach sheet, enter any comparable sales you can find. Your business broker is the best source for these; if you don't have a broker, BizBuySell's sold listings are a reasonable proxy. On the Asset-Based sheet, enter your inventory at cost and make an estimate of FF&E replacement value.

The Valuation Summary brings all three methods together. For most retail businesses, the income approach carries the most weight — buyers primarily pay based on what the store earns. Review the implied metrics at the bottom of the summary sheet: if your implied price-to-revenue ratio is well above 0.5x or your SDE multiple is above 3x, double-check your earnings normalization, since those levels are only justified by strong growth, a prime lease, or a proprietary product lineup. The summary is designed to be printable for use in listing conversations, buyer negotiations, SBA loan applications, and partnership buy-sell discussions.

Retail businesses are valued primarily on their Seller's Discretionary Earnings — the normalized profit available to a full-time owner-operator after all operating expenses and before the owner's compensation. This is different from EBITDA, which assumes professional management; SDE adds back owner salary because most retail buyers are buying a job as well as a business. A store generating $200,000 in SDE selling at a 2.5x multiple implies a $500,000 purchase price — and the buyer expects that business to continue generating that $200,000 annually to recover the purchase price in about five years. The multiple is essentially a proxy for how much risk and confidence the market assigns to the future earnings stream.

Several factors push retail SDE multiples up or down from the 1.5x–3x midmarket range. Multiples expand when the store has a long lease at favorable rent (below 10% of revenue), a loyal customer base with high repeat purchase rates, a proprietary or exclusive product line, strong online sales that supplement the physical location, and consistent revenue growth over multiple years. Multiples compress when the lease is short or above-market, the store faces direct Amazon or big-box competition, inventory turnover is slow (excess dead stock is a liability, not an asset), or the business is heavily dependent on the owner's personal relationships. A store with a well-documented customer file, an active email list, and trained staff who will stay on after the sale can command a meaningfully higher multiple than one where the owner is the business.

In practice, retail transactions involve two separate negotiations: the business value (based on earnings) and the inventory value (based on cost). Most retail business sales are structured as an asset purchase where the buyer pays an agreed multiple for the goodwill and operating assets, then pays separately for inventory at cost — either a fixed amount estimated at closing or an actual physical count on the day of transfer. This template handles both: the Income and Market approaches value the business as a going concern excluding inventory, while the Asset-Based sheet captures inventory separately. Understanding this structure matters when you're comparing offers — a buyer offering a lower multiple but agreeing to pay full inventory cost may be making the same total offer as one quoting a higher multiple on a lower SDE.