Home / Free tools / Finance & Accounting
Excel · 5 KB
Restaurant Break-Even Calculator
An Excel calculator for break-even sales. Enter monthly fixed costs, variable costs as a percentage of sales, and days open per month; it returns your contribution margin percentage, the sales you need to break even in a month and in a day, and the profit or loss at any sales level you type in.
- Format
- Excel workbook
- Size
- 5 KB
- Price
- Free, no sign-up
- Section
- Finance & Accounting
Work out your break-even sales
Fixed costs stay the same whether you serve one cover or three hundred. Variable costs move with sales - food, beverage, hourly labor, card fees.
What's in it
- Contribution margin percentage calculated as 1 minus your variable cost percentage
- Break-even sales for the month, calculated as fixed costs divided by contribution margin
- Break-even sales per day, divided across the days you actually open
- A projected profit or loss line for any monthly sales figure you enter
How to use it
- Fixed costs are the ones that do not move with sales: rent, insurance, salaried pay, loan payments
- Variable costs move with sales: food, beverage, hourly labor, card fees
- Use days you are genuinely open, not calendar days, for the daily number
- Try lowering fixed costs and the variable percentage separately to see which one moves break-even further
The guide that explains it
Restaurant Break-Even Analysis Explained — Break-even is the sales number where your restaurant stops losing money and starts making it. Here's the formula, a worked example, and how to lower it.