Finance template
Break-even analysis
Find how many units you need to sell to cover fixed costs, and what it takes to hit a profit goal. A chart shows revenue crossing total cost.
- Free
- No account needed to try
- Download as .xlsx
What's inside
Everything is a normal workbook once you open it: change the numbers, rename the sheets and make it yours.
1 sheet
- Break-even
86 formulasTotals, lookups and checks are already worked out, so the sheet updates as you type. 116 filled cells in all.
Built in
- Charts
- Conditional formatting
- Named ranges
- 1 chart
- 5 conditional format rules
A look at the Break-even sheet
The top left of the first sheet, calculated by SheetsBat. Open the template to see all of it.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Break-even analysis | |||||||
| 2 | Handmade ceramic planters. Change the yellow inputs to test your own numbers. | |||||||
| 3 | Inputs | Results | ||||||
| 4 | Price per unit | $48.00 | Contribution margin per unit | $28.50 | ||||
| 5 | Variable cost per unit | $19.50 | Contribution margin ratio | 59.4% | ||||
| 6 | Fixed costs per month | $21,600 | Break-even units | 758 | ||||
| 7 | Expected units per month | 900 | Break-even revenue | $36,384 | ||||
| 8 | Target profit per month | $5,000 | Units for target profit | 934 | ||||
| 9 | Chart step (units) | 100 | Profit at expected units | $4,050 | ||||
| 10 | Margin of safety | 15.8% | ||||||
| 11 | ||||||||
| 12 | ||||||||
- break even
- contribution margin
- pricing
- profit
More finance templates
FinancePersonal monthly budgetPlan income and spending for the month and see what is left at a glance. Compare planned and actual amounts by category with a chart.
FinanceInvoice trackerTrack every invoice you send, what has been paid and what is overdue today. An aging summary groups open balances by how late they are.
FinanceCap tableModel ownership through seed and Series A rounds with share prices worked out from each pre-money valuation. See fully diluted ownership and a simple payout at an exit value.
FinanceStartup financial modelA three year quarterly model for a subscription startup: customers, revenue, hiring plan, operating costs and cash. Change the assumptions and every quarter recalculates.
Start your break-even analysis now
It opens in your browser in a second. Create a free account to save it, share it and open it anywhere.