Coffee Shop Financial Model (Spreadsheet)

Know whether your cafe survives month eight before you sign the lease.

Who this is for: people planning to open a cafe in the next 18 months, and owners running one without a real cash model. Who it is not for: shops that already have an accountant-built model; this will not tell you anything yours does not.

What is in the file:

• 12-month financial model as a CSV that imports into Google Sheets or Excel in one click
• Drinks-per-day growth curve you can set to your own assumptions
• Pre-built revenue, cost, and cash sections with the 30% COGS and 35% labor targets
• Maintenance reserve line, because espresso machines break on schedule
• The cumulative cash row, the only number that matters

The math: a bookkeeper typically bills more than $29 for a single hour, and building this from scratch takes several. Structured by people who have watched cafes die of optimism. Pairs with the Coffee Shop Startup Workbook.

If it is not useful, reply to your receipt and we refund it, no forms.

Pre-launch ordering: the shop register opens soon; until then order this by invoice via the contact page with the product name as the subject. You will receive a PayPal or bank invoice and delivery within 2 business days of payment.

Goes well with: the Coffee Cost Calculator and the Cafe Health Check. Related reading: Coffee Shop Profit Margin Guide.