Coffee Shop Financial Model - Covers, Prime Cost & Break-Even (Excel)

A busy cafe is not the same as a profitable one. The margin lives in prime cost. A queue out the door feels like success, but a coffee shop is won or lost on the cost of what goes in the cup and the wages behind the counter. Prime cost is where the profit hides.

What This Model Does

The Vespera Coffee Shop Financial Model builds sales from:

• Seats

• Covers

• Average spend

• Trading hours

Then measures them against:

• Food cost

• Drink cost

• Labour cost

To show the true contribution of the business.

Who Buys This Model

• Cafe founders

• Multi-site operators

• Franchisees

• Lenders and landlords who assess them
  
  

The One Number is Prime Cost Percentage. This is the number that decides whether a busy cafe actually keeps anything. The model builds it from ingredient cost and labour so you can see the exact point where volume turns into profit.

Key Model Features

• Revenue build from covers, average spend, and dayparts

• Food, drink, and labour cost lines

• Prime cost percentage

• Break-even coverage

• Startup cost and fit-out

• Monthly cash flow

• Scenario toggle
  
  

Use This Model To

• Plan a new cafe or a second site with confidence

• Test how price, footfall, and staffing move the margin

• Size the startup cash you need

• Present a fundable plan to a lender or landlord

• Institutional grade

• Excel-based

• Run the numbers first