Stackrows
Coffee Shop Valuation Template
A
B
C
D
E
F
G
1
Category
Budget
Actual
2
3
4
5
6
7
8
Business Inputs
SDE Multiple Approach
Asset-Based Approach
Lease Analysis
Revenue Multiple Approach
Valuation Summary

Coffee Shop Valuation Template

Value your coffee shop using seller's discretionary earnings multiples, an asset-based approach, lease analysis, and revenue benchmarks — built around how cafés actually sell in the private market.

$29Save 4+ hours vs. building a coffee shop business valuation model from scratch
Instant download after purchase
Works in Excel & Google Sheets
30-day money-back guarantee
.xlsx210 KB6 sheetsUpdated 2026-03-23

What's Inside This Coffee Shop Valuation Template

This template includes 6 worksheets, each designed for a specific part of your coffee shop financial workflow:

1

Business Inputs

The data entry foundation for the entire valuation model. Enter your trailing twelve-month revenue broken out by category: espresso and coffee drinks, brewed coffee and tea, food and pastries, merchandise and retail bags, and any other revenue streams such as catering, private events, or wholesale. The expense section captures cost of goods split by coffee and consumables, food and pastry costs (whether made in-house or purchased from a bakery), labor by role type (baristas, shift leads, and management separately), occupancy costs including base rent, CAM charges, and utilities, equipment maintenance and repairs, supplies and packaging, marketing, and business insurance. Owner compensation — salary, any draws, and personal expenses run through the business — is entered separately and normalized for SDE calculation. On the asset side, enter the current estimated market value of key equipment: commercial espresso machines, grinders, brewers, refrigeration, POS system, and furniture and fixtures. The lease section captures monthly base rent, remaining lease term in months, whether the lease is assignable to a buyer, and the option periods available at the current rent or formula-based escalations. All downstream valuation sheets pull directly from these inputs.

2

SDE Multiple Approach

Seller's Discretionary Earnings is the standard income-based valuation method for owner-operated coffee shops. The sheet starts from net income and adds back the owner's total compensation — salary, draws, and any personal expenses run through the business — along with depreciation and amortization on equipment and leaseholder improvements, interest on any business debt, and documented one-time expenses that won't recur under new ownership (a major equipment repair, a one-time marketing campaign, or a legal expense). The resulting SDE figure represents the total cash available to one full-time owner-operator. Independent coffee shops typically sell at 1.5–3.0x trailing twelve-month SDE, with the multiple driven primarily by four factors: lease terms (a long-term lease at below-market rent with assignability and renewal options is worth significantly more to a buyer than a month-to-month or expiring lease), location and foot traffic quality, revenue trend direction (growing versus flat or declining over the trailing twenty-four months), and whether the shop is truly owner-independent in daily operations or requires the current owner to be present most hours. The sheet includes a multiple selection matrix scoring these four factors so you can identify where your shop falls in the range and what would move it higher before listing.

3

Asset-Based Approach

A floor-value calculation based on the tangible assets a buyer would be acquiring. Enter the current market resale value (not original purchase price) for each asset category: commercial espresso machines, grinders, brewers, refrigeration and display cases, blenders and equipment, POS hardware and software, furniture and fixtures, smallwares and supplies, and any owned leaseholder improvements with remaining useful life. Inventory value at cost — green coffee beans, roasted coffee, syrups, food inventory — is included as a working capital component. The sheet calculates total tangible asset value, then layers in a goodwill component representing the business's ability to generate earnings above what a buyer could earn simply by liquidating the assets and reinvesting elsewhere. For most coffee shops operating profitably, goodwill represents the largest component of the transaction price — the value of the customer base, the trained staff, the recipes and menu, and the operating business that a buyer is inheriting rather than building from scratch. The asset-based approach is most relevant when a shop is operating near break-even or when a buyer needs to establish a minimum bid floor in a distressed situation. For profitable shops, the SDE multiple approach will almost always produce a higher number, and the asset approach serves as a cross-check to ensure the SDE-derived price is defensible.

4

Lease Analysis

Lease terms are the factor most specific to coffee shop valuations and the one buyers scrutinize most carefully after reviewing the income statement. A coffee shop's value is inseparable from its location, and the lease governs how securely a buyer can operate in that location and at what cost. This sheet quantifies the lease component of the transaction. Enter the current base rent, lease expiration date, and any option periods along with the option terms — fixed rent extension, market rate adjustment, or consumer price index-based escalation. The lease assignment section documents whether the landlord must consent to assign the lease to a buyer, whether the current owner would carry personal guarantee obligations through close, and whether there are any co-tenancy clauses, exclusivity provisions, or use restrictions in the lease that could affect the buyer's operational plans. A rent-to-revenue ratio is calculated against your inputs — a healthy coffee shop typically runs rent at 8–12% of gross revenue, and ratios above 15% are a flag that buyers will raise in diligence. The remaining lease value section calculates the premium a buyer is effectively receiving if the shop's rent is below current market rates for comparable retail space, and the risk exposure if the lease expires within twelve to twenty-four months of a transaction close.

5

Revenue Multiple Approach

A gross revenue screening method that establishes a broad value range as a cross-check against the SDE approach. Coffee shops in private transactions typically sell at 0.3–0.6x trailing twelve-month gross revenue, with the range reflecting the significant variation in profitability across shops at similar revenue levels — a $600,000-per-year shop running lean on owner compensation with controlled labor might generate $120,000 in SDE, while another $600,000 shop with high rent and owner draws might generate $50,000. The revenue multiple is most useful as a quick market-positioning tool: it tells you where your shop sits relative to comparable transactions before you've worked through the full SDE normalization, and it catches situations where the SDE multiple produces a price that seems out of line with what the market typically pays for a shop at your revenue level. The sheet adjusts the baseline range for revenue trend (growing revenue commands a premium over flat or declining), revenue mix (a higher percentage of coffee drinks versus food typically indicates better margins and a simpler operation to transfer), and whether the business has a consistent catering or wholesale revenue stream that provides predictable recurring income beyond walk-in retail.

6

Valuation Summary

A single-page output consolidating all three valuation approaches — SDE multiple, asset-based, and revenue multiple — into one view across conservative, base, and optimistic scenarios. The summary shows what each method produces, highlights the SDE approach as the primary method, and notes where the asset floor or the revenue multiple cross-check diverges significantly from the earnings-based result. A lease impact section quantifies how the specific lease situation — remaining term, assignability, rent-to-revenue ratio — is adjusting the SDE multiple selection up or down from the midpoint range. A sensitivity table shows how the SDE valuation changes as the multiple moves in 0.25x increments from 1.25x to 3.25x, giving both buyer and seller a clear view of the negotiation range. A deal structure comparison shows how the same underlying value can be structured as a cash sale at close, a seller-financed transaction, or an earnout tied to revenue retention over the twelve months following close — because many coffee shop transactions are seller-financed at least in part, and the structure materially affects what price a seller can realistically achieve. The summary sheet also flags any specific risk factors — lease expiration within eighteen months, a rent-to-revenue ratio above 15%, or a revenue decline in the trailing twelve months — that buyers will raise and that sellers should address before going to market.

Coffee Shop Valuation Template Features

  • SDE normalization with full owner compensation add-back and a multiple selection matrix scoring lease terms, location, revenue trend, and owner dependency
  • Asset-based floor value calculation covering equipment, leaseholder improvements, and inventory with goodwill layered on top
  • Lease analysis quantifying remaining term value, rent-to-revenue ratio, assignment terms, and option period impact on buyer risk
  • Revenue multiple cross-check benchmarked to coffee shop and independent café transactions with revenue mix and trend adjustments
  • Deal structure comparison showing cash sale, seller financing, and earnout scenarios side by side in the Valuation Summary
  • Three-scenario output with SDE sensitivity table showing the full negotiation range and lease-specific multiple adjustments

How to Use This Coffee Shop Business Valuation Spreadsheet

Start with the Business Inputs sheet. Pull your trailing twelve-month revenue by category from your POS system — most coffee shop POS platforms (Square, Toast, Clover) can export a revenue breakdown by product category. Separate coffee and espresso drinks from food, merchandise, and any catering revenue, because buyers weigh these differently when assessing how easily the revenue transfers. For expenses, work from your profit and loss statement: cost of goods, labor by role, rent, utilities, and all the other operating costs. Owner compensation needs to be completely broken out — your salary, any profit distributions, and any personal expenses run through the business, from your health insurance to a personal vehicle. You'll also need your lease documentation to fill out the lease section: current monthly rent, expiration date, option periods, and a note on whether the landlord consent is required to assign the lease to a buyer.

Work through the SDE Multiple Approach sheet and the Lease Analysis together. The multiple selection matrix scores your shop on four factors — lease terms, location and foot traffic, revenue trend, and how dependent daily operations are on the current owner — and maps those scores to a specific SDE multiple range. The lease analysis is often where owners are surprised: a shop paying $6,000 per month in a location where comparable retail space now rents for $9,000 is sitting on substantial below-market lease value, and that premium should be reflected in the multiple or in the asking price. A shop with a lease expiring in fourteen months, with no guaranteed renewal option, faces the inverse problem — a buyer is acquiring a profitable business that might not exist in its current location in a year, and that uncertainty compresses the multiple significantly. Run the asset-based approach in parallel to establish a floor value, which is the minimum a rational buyer would pay for the physical assets alone.

Review the Valuation Summary before having any conversation with a business broker, commercial real estate advisor, or prospective buyer. The sensitivity table shows how the SDE valuation shifts across the realistic multiple range — and for a coffee shop generating $80,000 per year in SDE, the difference between 1.75x and 2.75x is $80,000 in transaction value, which is material. The deal structure comparison is worth particular attention: many independent coffee shop transactions are structured with seller financing because the buyer pool is often individuals without access to conventional bank financing, and a seller who can offer terms at 60–70% of the purchase price often achieves a higher total price than a seller who insists on cash at close. Understanding the range before you negotiate puts you in a much better position than discovering these dynamics mid-transaction.

Know what your coffee shop is worth before you sell

Enter your revenue, SDE, equipment values, and lease terms — and get a defensible valuation range with the SDE approach, asset floor, and lease analysis that buyers will use to make their offer.

How Coffee Shops Are Valued When They Sell

Coffee shop valuations are grounded in three realities that distinguish them from most other small businesses. First, the physical assets matter more here than in service businesses — a well-maintained La Marzocca or Synesso espresso machine, commercial grinders, and a full café build-out represent tens of thousands of dollars that set a floor below which the transaction price almost never falls. Second, the location and lease are as important as the financials — arguably more so, because a profitable coffee shop in a lease that expires in twelve months without a renewal option is worth fundamentally less than the same shop with a ten-year lease at a favorable rent, even if the P&L looks identical. And third, coffee shops are among the most commonly owner-operated businesses in the small business market, which means the owner-dependency question — whether daily operations require the current owner to be present — directly affects what multiple a buyer will accept.

The factors that push a coffee shop valuation toward the upper end of the 1.5–3.0x SDE range are well-understood by experienced buyers and business brokers. A long-term lease with below-market rent is the single most valuable non-financial asset a coffee shop can have; buyers pay for the security of knowing they can operate in that location at a predictable cost for years after close. A trained and stable staff that doesn't depend on the owner to open, manage service quality, or maintain customer relationships reduces the operational risk a buyer is taking on. A revenue trend that has grown year-over-year in the trailing twenty-four months signals that the business is not dependent on its current owner's energy or customer relationships to sustain performance. And a revenue mix that's weighted toward coffee and espresso drinks rather than food — because food adds labor and waste complexity that doesn't proportionally improve margins — typically signals a cleaner, more transferable operation.

The practical process of preparing a coffee shop for sale typically takes twelve to twenty-four months if an owner wants to achieve a price at the upper end of the range. Lease negotiation is the highest-leverage step: extending a lease that's within two years of expiration, securing an option period at a known rent, and confirming with the landlord in writing that the lease is assignable to a buyer can move the SDE multiple meaningfully on its own. Cross-training staff so that the shop can operate without the owner present — even just for a few weeks — demonstrates to buyers that the business model is operationally sound. Cleaning up the books so that owner compensation is clearly documented and the financials can be independently verified takes time if they haven't been kept that way. Owners who think through these factors before engaging a business broker consistently receive better offers than those who list the business and discover the obstacles mid-transaction.

Coffee Shop Industry at a Glance

Financial templates built for coffee shops and cafes — from single-location espresso bars to multi-location roasters. Pre-loaded with beverage cost categories, wholesale account structures, and industry KPIs.

Revenue Drivers

  • Espresso & specialty drinks
  • Drip coffee & batch brew
  • Food & pastry sales
  • Wholesale bean sales
  • Office coffee service accounts
  • Catering & event service

Key Cost Categories

  • Coffee beans & specialty ingredients (COGS)
  • Dairy & alternative milks
  • Food/pastry COGS
  • Labor
  • Rent & occupancy
  • Equipment maintenance & repair
  • Packaging & supplies
  • Marketing

Typical Margins

Gross: 60-70% · Net: 5-15%

Seasonality

Strongest in fall and winter when hot drink demand peaks; slower in summer unless cold brew and iced drink sales are high. Morning rush (6–10am) drives the majority of daily revenue.

Key Performance Indicators

Average ticket sizeCups sold per dayLabor cost percentageBeverage cost percentageWholesale revenue as % of total

Coffee Shop Valuation FAQ

Coffee Shop Valuation Template

$29