
Coffee Shop Business Plan Template
Build a realistic coffee shop business plan with per-cup economics, equipment and buildout costs, and a 3-year financial projection that accounts for seasonality and growth in sales per location.
What's Inside This Coffee Shop Business Plan Template
This template includes 5 worksheets, each designed for a specific part of your coffee shop financial workflow:
Executive Summary
A high-level overview of your coffee shop concept, market opportunity, and financial snapshot.
Startup Costs & Funding
Details all capital required to open a coffee shop, typically $120,000–$300,000 depending on location and ambition.
Revenue Forecast
A 12-month detailed revenue projection for year one, then annual summaries for years two and three.
Projected P&L
Annual profit and loss statement showing revenue, cost of goods sold (coffee beans at 18–22% of revenue, pastries and supplies at 20–25%), labor (3–4 full-time staff plus part-time coverage, typically 35–40% of revenue), occupancy (rent, utilities, insurance, typically 8–12% of revenue), and operating expenses (marketing, credit card processing, maintenance, supplies).
Dashboard
A visual management tool showing real-time key metrics: total startup investment required, monthly and annual revenue by year, break-even analysis (the daily customer count and average transaction value needed to cover fixed costs), gross margin %, labor %, occupancy cost %, operating margin %, and a 36-month cumulative cash flow chart.
Coffee Shop Business Plan Template Features
- Per-cup and per-transaction revenue model with daily customer count assumptions
- Cost of goods sold split by product category (espresso drinks, drip, food, retail) with industry benchmarks
- Staffing model with part-time and full-time labor tracked separately as % of revenue
- Startup costs tracker for espresso machines, POS, buildout, and inventory
- Seasonal adjustment factors reflecting coffee shop traffic patterns throughout the year
- Break-even analysis showing required daily customer count and average ticket to cover costs
How to Use This Coffee Shop Business Plan Spreadsheet
Start with the Executive Summary and Startup Costs sheets. Gather quotes from espresso equipment vendors and commercial buildout contractors so you can populate the capital requirements section accurately. A typical single-location coffee shop requires $120,000–$250,000 in startup investment. Enter your estimates for rent, equipment, build-out, initial inventory, and working capital. The total flows automatically to the Revenue Forecast to calculate what daily customer count and ticket size you need to reach break-even.
Move to the Revenue Forecast sheet and enter your assumptions: how many customers per day during the ramp-up period (most coffee shops start at 40–60% of capacity in month one and reach 80–95% by month four), what's your average transaction value (espresso drinks average $5–$6, drip coffee $2–$3, food items add another $3–$5), and how seasonal is your location (downtown commute locations stay strong year-round; suburban vacation towns spike in summer). Adjust the labor staffing to match your concept—a small walk-up counter operation needs fewer staff than a full-service seating area with WiFi and long-stay customers.
From location research to lender-ready projections in an afternoon
Enter your location, daily customer assumptions, and product mix—the model builds your 3-year financial outlook, break-even analysis, and startup capital requirement automatically.
Why Coffee Shop Owners Need a Detailed Business Plan
Coffee shop economics are driven by three variables: daily customer count, average transaction value, and labor efficiency. The per-cup model in this template forces you to think about realistic foot traffic rather than wishful-thinking revenue numbers. A busy urban coffee shop might hit 300–500 customers per day; a suburban location 80–150. Most first-time operators underestimate how long the ramp-up takes—it's common to operate at 40–50% of target traffic in the first two months while word-of-mouth builds and the team becomes efficient. Modeling this ramp explicitly, rather than assuming full traffic from day one, keeps your working capital requirement realistic and ensures you don't run out of cash in month two.
Labor is the largest operating expense in most coffee shops, running 35–45% of revenue depending on whether you operate a simple counter-service model or a full-service cafe with seating and WiFi. A single-location owner-operated shop can hit 30% labor with strong discipline and good scheduling. A fully-staffed cafe with morning rush coverage, afternoon coverage, and evening closers will run 40–45%. Coffee cost should be 18–22% of revenue; pastries and food typically add another 20–25% to COGS. Occupancy (rent, utilities, insurance) usually runs 8–12% of revenue; avoid exceeding 12% or profitability becomes difficult. The math is tight but achievable if you control these three inputs.
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 Business Plan Template FAQ
More Coffee Shop Templates
Coffee Shop Balance Sheet Template for Excel
$29
Coffee Shop Budget Template for Excel
$29
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
Coffee Shop Valuation Template for Excel
$29
More Business Plan Templates
Coffee Shop Business Plan Template
$39