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.
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:
Business Inputs
The data entry foundation for the entire valuation model.
SDE Multiple Approach
Seller's Discretionary Earnings is the standard income-based valuation method for owner-operated coffee shops.
Asset-Based Approach
A floor-value calculation based on the tangible assets a buyer would be acquiring.
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.
Revenue Multiple Approach
A gross revenue screening method that establishes a broad value range as a cross-check against the SDE approach.
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.
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.
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.
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
Coffee Shop Valuation FAQ
More Coffee Shop Templates
Coffee Shop Balance Sheet Template for Excel
$29
Coffee Shop Budget Template for Excel
$29
Coffee Shop Business Plan Template for Excel
$39
Coffee Shop Cash Flow Template for Excel
$29
Coffee Shop Expense Tracker Template for Excel
$29
Coffee Shop Financial Model Template for Excel
$29
Coffee Shop Income Statement Template for Excel
$29
Coffee Shop Invoice Template for Excel
$29
Coffee Shop KPI Dashboard Template for Excel
$29
Coffee Shop P&L Template for Excel
$29
Coffee Shop Pro Forma Template for Excel
$29
Coffee Shop Project Budget Template for Excel
$29
Coffee Shop Sales Forecast Template for Excel
$29
More Valuation Templates
Coffee Shop Valuation Template
$29