Salon Business Plan & Financial Model
See how many appointments you need to break even, and your first three years of profit.
$6.30Regular price $9-30%$9Buy now
1 / 8
Coffee Shop Business Plan & Financial Model
Turn seats, menu prices and staff into 36 months of covers, profit, break-even and cash.
$6.30Regular price $9-30%$9
Fall Sale: 30% off at checkout, ends Nov 15.
–Days––Hours––Min––SecThe financial projections for your coffee shop business plan, café business plan or restaurant business plan template, in one spreadsheet. Enter your seats, two services with their own average bill, food and beverage cost %, staff schedule and rent, and it builds a 36-month model where covers can never outgrow your dining room. The dashboard shows prime cost, profit and break-even in covers a month.
Format: Excel + Google Sheets · PDF guide
License: Personal & Business
Made for you if…
- You are opening a café, coffee shop or restaurant and need the numbers for your business plan or a bank loan
- You want to know how many guests a month you need before you sign a lease
- You prefer a clear spreadsheet to hiring a consultant or learning accounting software
What you’ll get done
- See your break-even in covers a month, and which months fall short
- Know your food, drink and prime cost % and your profit margin for each year
- Find the lowest cash month before you open, so you raise enough money
What’s inside
- 01Blank financial model (.xlsx) that opens in Excel and Google Sheets
- 02Example file filled in for a 48-seat café-restaurant with lunch and dinner services
- 03Tabs: Dashboard (12 key numbers, sales vs costs and cash charts, Year 1-3 columns, cost breakdown, covers vs break-even), Assumptions, 36-month Monthly model, Annual summary (P&L)
- 0411-page PDF guide, including how to open it in Google Sheets
- 05Prints on US Letter paper
Try the free version
Run the numbers with the Menu Pricing Calculator
Price a dish from what it costs to make, and check the food cost of the prices already on your menu. The Coffee Shop Business Plan & Financial Model keeps it going month after month.
Open the free tool
Goes well with
Airbnb Business Plan & Financial Model
Turn units, nightly rates and seasons into 36 months of occupancy, profit and cash.
$6.30Regular price $9-30%$9Buy now
Small Business Planner & Goal Tracker
Goals, sales, cash and weekly priorities for a business of one, in a sheet and on paper.
$6.30Regular price $9-30%$9Buy now
Frequently Asked Questions
Does it work in Google Sheets?
Yes. Your PDF guide has a link that makes your own Google Sheets copy in one click, with no upload needed. It also works in Excel 2019 or later and Microsoft 365.
Does it work for a coffee shop with no table service?
Yes. Rename the two services, for example Morning and Afternoon, and set the table turns and average bill for each. Seats and turns still set the ceiling on how many guests you can serve.
Can I use it as a menu pricing calculator?
It works at the level of your average bill and food cost %, not dish by dish. Change the average bill or food cost % and you see the effect on gross margin, prime cost and break-even right away.
Is it a download or a subscription?
A one-time download. You pay once and keep the files.