How to Build a Coffee Shop Financial Model

A financial model is where your coffee shop dream meets math. It’s the spreadsheet that answers the question every lender, investor, and honest entrepreneur needs answered: will this business make money?

Most aspiring coffee shop owners either skip financial modeling entirely (dangerous) or build one based on wildly optimistic assumptions (equally dangerous). The goal is a model that’s realistic, conservative, and useful as an ongoing planning tool — not just a document you create once to impress a bank.

Revenue Projections

Your revenue model starts with three numbers: average transactions per day, average ticket size, and operating days per year. For a new specialty coffee shop in a decent location:

Transactions per day: 150–250 in the first year is a realistic range for a well-located shop. Some shops do more. Many do less. Don’t model 400 transactions per day unless you have very strong evidence to support it.

Average ticket size: $5.50–$7.50 for a specialty coffee shop in 2026, depending on your market, food offerings, and pricing strategy. A shop serving only coffee will be on the lower end. Add food and you’ll push higher.

Operating days: If you’re open 7 days a week, that’s 364 days (closed Christmas or a similar day). Many shops close one day a week, giving you 312 operating days.

At 200 transactions/day, $6.50 average ticket, 312 days: that’s $405,600 in annual revenue. That’s a reasonable first-year target for many markets. Build three scenarios: conservative (150 transactions), moderate (200), and optimistic (250). Plan your expenses around the conservative number.

Cost of Goods Sold (COGS)

COGS is what you spend on the ingredients and supplies that go directly into what you sell. For coffee shops, target 25–32% of revenue.

• Coffee beans: $8–$15 per pound for quality specialty coffee. A pound makes roughly 40–45 shots of espresso or 20–25 cups of drip. Your bean cost per drink should be $0.30–$0.75.
• Milk and alternatives: $0.30–$0.80 per drink depending on type (whole milk is cheapest, oat milk is most expensive).
• Cups, lids, sleeves: $0.15–$0.30 per serving for disposable. Dine-in ceramic cups pay for themselves quickly.
• Food items: If buying wholesale pastries, target 40–50% food cost. If preparing in-house, 30–40%.
• Syrups, sauces, toppings: Small per-drink cost ($0.05–$0.15) but add up over volume.

Your total COGS should land between 25–32%. If it’s higher, your pricing is too low or your waste is too high. Track COGS weekly in your first few months — it’s the fastest lever you can pull to improve profitability.

Labor Costs

Labor is the biggest operating expense for most coffee shops, typically 30–40% of revenue. This includes wages, payroll taxes, and benefits.

Model your labor needs by shift, not by revenue percentage. How many baristas do you need during peak hours (7–10 AM)? How many during slow periods (2–4 PM)? Most shops over-staff during slow periods and under-staff during rushes. Build your schedule to match actual demand patterns.

Don’t forget to model yourself. If you’re working 50 hours a week, that’s labor cost — even if you’re not taking a paycheck yet. Your financial model should include a reasonable owner’s salary. If the business only works because the owner works for free, it doesn’t actually work.

Fixed Operating Expenses

These are the costs that stay roughly the same regardless of how busy you are:

• Rent: Your largest fixed cost. Should be 8–15% of revenue. If rent exceeds 15%, your location may be too expensive for your revenue potential.
• Utilities: $800–$2,000/month for a typical coffee shop. Espresso machines and refrigeration drive most of the cost.
• Insurance: $200–$500/month for general liability, property, and workers’ comp.
• Software/subscriptions: POS system, accounting, scheduling, music licensing. Budget $300–$600/month.
• Loan payments: If you’ve financed your build-out or equipment. Factor in principal and interest.
• Marketing: $200–$500/month for a new shop. Much of your marketing should be organic, but budget for printed materials, local sponsorships, and online tools.

Break-Even Analysis

Your break-even point is the revenue level where total revenue equals total expenses. Below break-even, you’re losing money. Above it, you’re profitable.

To calculate: add up all your fixed monthly costs (rent, utilities, insurance, loan payments, your salary). Divide by your contribution margin (revenue minus variable costs like COGS and hourly labor). The result is the monthly revenue you need to cover all costs.

Most well-run coffee shops break even within 12–18 months. If your model shows break-even at 24+ months, re-examine your assumptions. Either your costs are too high, your pricing is too low, or your location can’t support enough volume.

Cash Flow Is King

Profitability and cash flow are different things. A shop can be profitable on paper but still run out of cash if it doesn’t have enough working capital to cover the gap between expenses (which happen immediately) and revenue (which builds over time).

Build a monthly cash flow projection for your first 18 months. Include your startup costs, pre-opening expenses, and the reality that revenue in months 1–3 will be significantly lower than months 6–12. Most experts recommend having 3–6 months of operating expenses in reserve before opening. This cash cushion is what keeps you alive while you build your customer base.