# Coffee Shop Chain Model See how customer traffic, average spend, food sales, and labour shape a coffee shop. - Canonical: https://finamodel.com/templates/coffee-shop - Excel download: https://finamodel.com/templates/coffee-shop.xlsx - Category: Consumer - Model type: Operating model - Difficulty: Intermediate - Audiences: Investors & analysts, Founders & operators, Coffee and café operators, Search-fund and PE buyers, Consumer and retail investors, Lenders and analysts - Tags: coffee-shop, cafe, specialty-coffee, rollup, dcf ## Overview 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's included - 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 - Revenue sheet: four product tiers, product revenue, subscription and loyalty, mobile and delivery fees, total revenue - P&L sheet: revenue to net income with cost of goods sold, labour and overhead, margins, identity check - FCF sheet: NOPAT, depreciation add-back, capex, change in NWC, unlevered FCF, discount factor, PV - Valuation sheet: sum of PV, terminal value, enterprise value, equity value, value per share, implied EV/EBITDA - Dashboard with cafes, transactions, utilisation, revenue per cafe and per transaction, EBITDA margin, EV, per share, and revenue mix ## 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. ## Product mix drives the ticket and margin Revenue is the product of a cafe estate, the transactions it fills, and the product mix of those transactions. The model makes cafe count, transactions per cafe, a utilisation ramp, and a four-tier product mix explicit, so total transactions and revenue per transaction are transparent operating metrics an analyst can flex against the cost stack rather than a top-down growth rate. ## Designed for one-edit responsiveness Every input, the cafe pipeline, transactions per cafe, the utilisation ramp, the product mix, the average ticket, the full cost stack, capex, working capital, and the WACC, is a named-range cell. Edit one and the operations build, revenue, P&L, free-cash-flow bridge, valuation, and dashboard all recompute. No formula rewrites are needed to test a pricing, mix, or expansion scenario. ## An unlevered DCF, not an EBITDA shortcut A coffee chain builds out and equips each cafe with an espresso bar and fit-out and turns over bean and food inventory, so the model bridges to unlevered free cash flow and discounts it at a WACC with a Gordon-growth terminal value. Enterprise value bridges through net debt to equity value and a per-share figure, and the implied EV/EBITDA falls out as a sanity check against where specialty coffee platforms change hands. ## Workbook structure ### Cover Workbook overview, sheet legend, units, and tab-colour key. - Title and scope framing - Sheet-by-sheet purpose summary - Units and tab-colour legend ### Assumptions Every driver in one sheet: cafes, utilisation, product mix, costs, capital, valuation. - Year-1 cafes, new cafes per year, transactions per cafe, managers per cafe, average ticket - Utilisation with an annual ramp and a practical ceiling - Product-tier shares, price indices and net margins, subscription and fee inputs, price escalation - Store-manager and barista comp and wage, the percent-of-gross-profit overhead lines, depreciation, tax - Maintenance capex, build-out cost per cafe, NWC, base-year revenue - WACC, terminal growth, net debt, shares ### Operations Cafes, transactions, utilisation, and staff. - Opening plus new cafes equals closing cafes - Utilisation ramps from a Year-1 input, capped at a ceiling - Transactions per cafe equal mature transactions times utilisation - Total transactions equal closing cafes times transactions per cafe - Store-manager and barista headcount equal closing cafes times per-cafe FTE - Transactions per barista as a productivity metric ### Revenue Revenue by product tier and ancillary. - Each tier equals total transactions times product share times average ticket times price index times escalation - Product revenue subtotal - Subscription and loyalty equals closing cafes times subscribers times annual fee - Mobile and delivery fees equal total transactions times fee per transaction - Total revenue ### P&L Revenue to net income. - Revenue from the Revenue sheet - Cost of goods sold as the inverse of the per-tier net margin - Gross profit and gross margin - Store-manager and barista labour by headcount, the percent-of-gross-profit overhead stack - EBITDA, depreciation, EBIT, tax on positive EBIT, net income, margins, identity check ### FCF Unlevered free cash flow bridge. - EBIT and unlevered tax from the P&L - NOPAT equals EBIT less unlevered tax - Add back depreciation - Maintenance capex on revenue and build-out capex on new cafes - Change in net working capital on revenue growth - Unlevered free cash flow - Discount factor and PV of UFCF ### Valuation Discounted cash flow. - Sum of PV of explicit UFCF - Gordon-growth terminal value and its PV - Enterprise value - Less net debt to equity value - Shares outstanding and value per share - Implied EV/EBITDA ### Dashboard Headline metrics and revenue mix. - Cafes, transactions, utilisation, revenue per cafe and per transaction - Revenue and EBITDA - EBITDA margin - Enterprise value and value per share - Revenue mix across product, subscription, and fees ## Features - **Product mix drives the ticket and margin:** Revenue is the product of a cafe estate, the transactions it fills, and the product mix of those transactions. The model makes cafe count, transactions per cafe, a utilisation ramp, and a four-tier product mix explicit, so total transactions and revenue per transaction are transparent operating metrics rather than a top-down growth rate, and the food-and-retail-versus-brewed-coffee spread is visible in the blend. - **Labour is the cost, and it is modelled as headcount:** A coffee shop is a people-intensive, shift-driven business, so store-manager and barista pay is the largest operating line and is built bottom-up from FTEs per cafe, wage, benefits and wage inflation. Because store labour sits in operating expense rather than cost of goods, the gross margin runs high and the EBITDA margin is the meaningful profitability line, and the remaining overhead is geared to gross profit the way a real multi-site operator would expect. - **An unlevered DCF, not an EBITDA shortcut:** A coffee chain 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 EBITDA to cash through NOPAT, depreciation, maintenance and build-out capex, and the change in working capital, then discounts the unlevered free-cash-flow stream at a WACC with a Gordon-growth terminal value to a defensible enterprise and equity value. ## Use cases - **Intrinsic valuation:** Set the cafe pipeline, utilisation ramp, product mix, the cost stack, and a WACC, and read the enterprise value, equity value, value per share, and implied EV/EBITDA. Sense-check the multiple against where specialty coffee platforms change hands. - **Roll-up and pipeline planning:** Flex new cafes per year and the build-out cost per cafe to see how the de novo and tuck-in pipeline consumes cash and lifts transaction volume, and watch revenue per cafe and the EBITDA margin respond as the chain scales. - **Mix and pricing stress test:** Shift the product mix toward higher-ticket food and beans or compress the per-tier net margins to model menu-pricing and food-cost pressure, and read the revenue-per-transaction, gross-margin, EBITDA-margin and valuation impact. ## Frequently asked questions ### 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. ## Related templates - [Restaurant Unit Economics and Multi-Unit Model](https://finamodel.com/templates/restaurant-model) - [Franchise Unit Economics Model](https://finamodel.com/templates/franchise-model) - [Brewery Operations Model](https://finamodel.com/templates/brewery-model)