Coffee Shop Chain Model
Consumer Financial Model (Free Excel Download)
Plan coffee-shop performance using transactions, average ticket, daypart mix, food attachment, labor, rent, supplies, and new stores to forecast margins and payback.
professionals from Deloitte
Used by professionals from
About this model
This model helps you plan a coffee shop, café, or small chain. It brings coffee, food, retail, and catering sales together with the ingredients, staff, rent, and equipment costs needed to serve customers every day.
Use it to assess a new location, an existing shop, or a rollout plan. Test customer traffic, pricing, opening hours, and staffing to see how they shape profitability and cash flow.
What every model includes
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
What's inside the Coffee Shop Chain Model
- Cafe inputs: Year-1 cafes, new cafes per year, transactions per cafe, managers per cafe, average ticket
- Utilisation: Year-1 utilisation with an annual ramp and a practical ceiling
- Product mix: espresso and specialty, brewed coffee and tea, food and pastry, and retail beans and merchandise shares, per-tier price indices and net margins
- Ancillary: subscribers per cafe and annual subscription fee, mobile and delivery fee per transaction, price escalation
- Cost structure: store-manager and barista comp and wage with benefits and wage growth; occupancy, marketing, technology and SG&A as % of gross profit; depreciation (% of revenue); tax
- Capital and working capital: maintenance capex %, cafe build-out cost per cafe, NWC % of revenue growth, base-year revenue
- Valuation: WACC, terminal growth, net debt, shares outstanding
- Operations sheet: cafe roll-forward, utilisation ramp, transactions per cafe, total transactions, staff headcount, transactions per barista
Inside the Coffee Shop Financial Model: Cafes, Transactions, and Valuation
This coffee shop financial model helps you evaluate a multi-location specialty café chain. It connects the cafe roll-forward and capacity-utilisation ramp to total transactions, then to product-mix revenue and a full P&L.
You can trace how store growth and customer volume drive gross profit, EBITDA and unlevered free cash flow, and see how the DCF translates operating performance into enterprise and equity value.
Cafe roll-forward and the transaction build
The chain grows by opening a fixed number of new cafes each year. Opening cafes plus new cafes gives closing cafes, which then drive store-manager and barista headcount, transaction volume and the per-cafe crew.
- Each cafe supports a mature number of transactions per year, set by site traffic, seating and drive-thru throughput. That mature volume is multiplied by a utilisation factor – the share of mature volume actually filled – to give effective transactions per cafe.
- Closing cafes times transactions per cafe produces total transactions. Utilisation starts at a Year 1 input and ramps by a fixed number of percentage points annually, capped at a practical ceiling.
The year's new cafes also determine build-out capital expenditure through a per-cafe de novo investment.
Product-mix revenue and the margin spread
Revenue is built tier by tier: transactions times each tier's share times the average ticket times that tier's price index, escalated at a menu step-up.
- A food or retail sale carries a price index above one, while brewed coffee sits well below it, so the blended revenue per transaction emerges from the mix – and as the mix shifts toward higher-ticket food and beans, the blended figure expands even with flat transaction volume. Cost of goods sold is each tier's revenue times one minus that tier's net margin.
- Food and retail carry a real product cost, while espresso and brewed coffee are almost all margin over a few cents of milk, beans and a cup. Subscription and loyalty income (closing cafes times subscribers per cafe times annual fee) and mobile and delivery fees (transactions times fee per transaction) layer on top, also escalated.
All monetary figures are in dollars.
Operating costs, EBITDA and margin progression
Store-manager and barista labour are headcount-driven – FTEs per cafe times wage, loaded for benefits and escalated at the wage-growth rate – and they are the dominant cost. Because store labour sits in operating expense rather than cost of goods, the blended gross margin runs high and EBITDA margin is the meaningful profitability line.
- The remaining overhead – occupancy and rent, marketing and advertising, technology and POS, and corporate SG&A – is set as a percentage of gross profit rather than revenue, recognising that the true operating scale of a high-gross-margin café is gross profit.
- As the utilisation ramp and price escalation lift gross profit while per-cafe labour grows only with headcount and wage inflation, the EBITDA margin expands modestly across the forecast horizon.
Free cash flow and DCF valuation
Unlevered free cash flow is NOPAT plus depreciation, less total capital expenditure (maintenance plus the de novo build-out of the year's new cafes), less the change in working capital.
- Working capital is a light call on cash: coffee is a near-cash business that collects at the register and buys beans and supplies on trade terms, so only a small fraction of revenue growth ties up in net working capital.
- The DCF sums the present value of explicit unlevered free cash flows and the present value of a Gordon-growth terminal value to enterprise value, then subtracts net debt to arrive at equity value and value per share. The model also reports implied EV/EBITDA.
A one-page dashboard summarises cafes, transactions, utilisation, revenue per cafe, revenue per transaction, revenue, EBITDA, EBITDA margin, enterprise value and value per share.
Formatted to IB standards
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Frequently asked
What is a coffee shop financial model?+
A coffee shop financial model captures the seven-year operating economics and intrinsic value of a multi-location specialty coffee and café chain that sells espresso and specialty drinks, brewed coffee and tea, food and pastry, and retail beans and merchandise, with a recurring subscription and loyalty programme and mobile and delivery fees. It rolls a cafe count forward, converts a capacity-utilisation ramp into total transactions, prices transactions across a four-tier product mix at a blended average ticket and price index, runs the high-gross-margin barista-heavy cost stack to EBITDA, and discounts an unlevered free-cash-flow stream to enterprise value, equity value, and value per share.
How is coffee shop revenue built?+
Revenue is driven by the cafe estate and its utilisation: total transactions equal closing cafes times transactions per cafe times a utilisation factor that ramps to a ceiling, and product revenue splits those transactions across an espresso, brewed-coffee, food and retail mix, each priced at a blended average ticket times a per-tier price index. Cafe-driven subscription and loyalty income and transaction-driven mobile and delivery fees layer on to total revenue.
Why is the product mix so important?+
An espresso drink, a brewed coffee, a food item and a bag of retail beans each carry very different price points and product economics, so the realised ticket and the blended margin both fall out of the mix rather than the raw transaction count. The model makes the per-tier price indices and net margins explicit so an analyst can flex the mix and pricing and watch revenue per transaction, gross profit and EBITDA move together.
Why an unlevered DCF instead of an EBITDA multiple?+
A coffee chain still builds out and equips each cafe with an espresso bar and fit-out and turns over bean and food inventory, so EBITDA overstates cash. The model bridges to unlevered free cash flow, NOPAT plus depreciation, less maintenance and build-out capex, less the change in working capital, and discounts it at a WACC, then adds a Gordon-growth terminal value. The implied EV/EBITDA falls out as a sanity check rather than as the valuation input.
Have more financial modelling questions? Contact us
Related templates
Restaurant Unit Economics and Multi-Unit Model
Single-unit operating metrics, cost of goods sold, labor, rent, and multi-unit chain economics.
Franchise Unit Economics Model
Economics template for franchise systems modeling unit-level P&L, franchise fees, royalties, and multi-unit growth scenarios.
Brewery Operations Model
Craft brewery financial projections with production and distribution.
E-Commerce Unit Economics
P&L model for e-commerce business with CAC, LTV, gross margin, and unit economics.
