Home/Spreadsheets/Cash Flow & P&L/Coffee Shop Cash Flow Model
Coffee Shop Cash Flow Model
Model your coffee shop's cash flow before you open or expand, in one Excel file. Set your assumptions (traffic, ticket size, rent, staff, COGS), and Revenue, Expenses and a month-by-month Cash Flow projection build automatically. A dashboard shows profit, break-even and runway - exactly what you need for a plan or a lender. It opens in Microsoft Excel and in Google Sheets, has no macros and nothing to install, and is yours to reuse as often as you like.
What you get
- Assumptions drive the whole model
- Automatic revenue projection
- Full expense breakdown
- Month-by-month cash flow
- Profit, break-even and runway dashboard
- Opens in Excel and in Google Sheets
Instant digital download · one-time purchase · no subscription
What it does
- Assumptions drive the whole model
- Automatic revenue projection
- Full expense breakdown
- Month-by-month cash flow
- Profit, break-even and runway dashboard
- Lender and business-plan ready
What it looks like
Every tab in the workbook
These are the actual sheet names in the file, not a feature list.
- Dashboard
- Assumptions
- Revenue
- Expenses
- Cash Flow
Works in
- Microsoft Excel 2016 or later, Windows and Mac
- Google Sheets — upload to Drive and open
- No macros, no add-ins, no subscription
Honest scope
This is a planning and bookkeeping template, not tax or accounting advice. The numbers it reports are the numbers you enter.
