Break-even analysis template
A break-even analysis tells you how much you need to sell each month to cover all your costs. This free template takes your price, your variable cost per unit and your monthly fixed costs, then works out the contribution per unit, the break-even units and sales, and how far your current sales are above or below that line.
Updated November 2026
What does the template look like?
Type your numbers in the white cells. Totals and results add themselves in Excel. Here it is with sample figures, so you can see how it fills in.
| Line | Amount |
|---|---|
| Per unit or job | |
| Selling price | $150.00 |
| Variable cost | $70.00 |
| Contribution | $80.00 |
| Contribution margin | 53.3% |
| Fixed costs per month | |
| Rent | $3,200.00 |
| Salaries and payroll taxes | $6,400.00 |
| Insurance | $450.00 |
| Software and phone | $350.00 |
| Loan payments | $1,100.00 |
| Other fixed costs | $500.00 |
| Total fixed costs | $12,000.00 |
| Break-even units per month | 150 |
| Break-even sales per month | $22,500.00 |
| Where you are | |
| Current sales per month | $26,000.00 |
| Current sales | $26,000.00 |
| Safety margin | $3,500.00 |
| Safety margin % | 13.5% |
How is break-even worked out?
Contribution is the selling price minus the variable cost of one unit or job. Divide your monthly fixed costs by the contribution and you have the units you need to sell to break even. Divide fixed costs by the contribution margin (contribution as a share of price) and you have break-even sales in dollars. Our break-even calculator does the same in your browser.
What can I learn from it?
How much room you have. If you sell $26,000 a month and break even at $15,000, a bad month won't sink you. It also shows which lever works best. A small price increase often moves break-even more than cutting a fixed cost, because it raises the contribution on every sale. Check your pricing with the markup calculator.
Fixed or variable?
If the cost would stay the same at zero sales, it's fixed. If it grows with each sale, it's variable. Some costs are both, such as a phone plan with usage charges. Split them as best you can, since being roughly right is enough to make a decision.
General information, not tax advice for your situation.
Want a plan for this year?
We run your numbers and show you the options.
See our tax planning and CFO serviceShould owner pay go in fixed costs?
Yes, if you want to know what it takes to pay yourself. Leaving it out shows break-even for the business alone.
Does break-even include taxes?
This version is before income tax. Add a line for estimated tax if you want an after-tax figure.
Can I use it for a service business?
Yes. Use a job, an hour or a client as the unit.
Tell us what's messy. We'll tell you what it takes.
Tell us what you need and get a fixed price before any work starts. No pressure and no contract.