How to calculate your break-even point
- Enter fixed costs for a period. Costs that do not change with sales volume, such as rent, salaries, insurance, software and loan repayments, for one month or one year.
- Enter price and variable cost per unit. The selling price of one unit, job or hour, and the cost that comes with each one: materials, packaging, card fees, shipping, subcontractor time.
- Add a profit target (optional). Enter the profit you want for the same period to see the sales needed to reach it, not just to break even.
- Read the result. Break-even units are shown exactly and rounded up to whole units, with the revenue they bring in and your contribution margin.
Break-even point formula
Break-even units = fixed costs รท (price per unit โ variable cost per unit)
The part in brackets is the contribution margin per unit: what each sale leaves over to pay fixed costs after its own costs are covered. Once enough sales have covered fixed costs, every further sale adds its contribution margin to profit. This is the same method the US Small Business Administration (SBA) describes for its break-even point calculation.
- Break-even revenue = break-even units ร price, or fixed costs รท contribution margin ratio.
- Contribution margin ratio = (price โ variable cost) รท price.
- Units for a profit target = (fixed costs + target profit) รท contribution margin per unit.
Worked example
A small bakery has fixed costs of 1,000 a month. It sells cakes at 25 each, and the ingredients and box for each cake cost 15.
| Step | Working | Result |
|---|---|---|
| Contribution margin per cake | 25 โ 15 | 10 |
| Contribution margin ratio | 10 รท 25 | 40% |
| Break-even units | 1,000 รท 10 | 100 cakes a month |
| Break-even revenue | 100 ร 25 (or 1,000 รท 40%) | 2,500 |
| Cakes for a 500 profit | (1,000 + 500) รท 10 | 150 cakes (3,750 revenue) |
A second check: fixed costs of 1,200, a price of 8 and a variable cost of 3 give 1,200 รท 5 = 240 units and 1,920 of revenue. When the answer is not a whole number, round up: 1,000 รท (7 โ 4) = 333.33, so you need to sell 334 units to cover costs.
Break-even for a service business or freelancer
The formula works the same when you sell time instead of products. Use your price per hour or per job as the price, and only the costs that come with each hour or job as the variable cost: subcontractors, materials, travel, payment fees. Your fixed costs are the monthly overheads you pay whether or not you work: software, insurance, phone, accountant, workspace, and the minimum you need to pay yourself.
Example: a cleaner charges 120 per job, spends 20 per job on supplies and travel, and has 2,000 of monthly costs including a minimum draw. Break-even is 2,000 รท 100 = 20 jobs a month. If each job takes three hours, that is 60 billable hours. If the number looks too high for the hours you can realistically sell, either the price is too low or the overheads too high; the hourly rate calculator works the problem from the other end, starting with the income you need.
Break-even formula in Excel or Google Sheets
Put fixed costs in B1, price in B2, variable cost in B3 and target profit in B4 (0 if none):
- Break-even units:
=B1/(B2-B3) - Whole units:
=ROUNDUP(B1/(B2-B3),0) - Break-even revenue:
=B1/((B2-B3)/B2) - Units for the target:
=ROUNDUP((B1+B4)/(B2-B3),0) - Profit at a volume in B5:
=B5*(B2-B3)-B1
Wrap the formulas in =IF(B2<=B3,"price too low",โฆ) to avoid a divide-by-zero or a negative answer.
What to do with the number
- Test a price change. Raising the cake price from 25 to 27 lifts the contribution margin from 10 to 12 and cuts break-even from 100 to 84 cakes. Check how a price change moves your margin with the profit margin calculator.
- Check a new fixed cost. A 300 a month lease on equipment needs 300 รท contribution margin extra sales to pay for itself.
- Know your margin of safety. The gap between expected sales and break-even sales shows how far sales can fall before you make a loss.
- Collect the money. Break-even only counts once customers pay. Invoice promptly with the free invoice generator and set clear payment terms.
Break-even analysis assumes a constant price and variable cost per unit and that fixed costs stay fixed over the range you are looking at. If you sell several products, use an average price and variable cost weighted by your sales mix, or run each product separately.
Glossary
- Fixed costs
- Costs that do not change with sales volume during the period.
- Variable cost
- A cost incurred for each unit, job or hour sold.
- Contribution margin
- Price minus variable cost: what each sale contributes to fixed costs and profit.
- Margin of safety
- How far sales can fall from the expected level before reaching break-even.
Frequently asked questions
How do you calculate the break-even point?
How do I calculate break-even revenue?
What if my price is lower than my variable cost?
What counts as a fixed cost and what is variable?
How many units do I need to sell to make a profit target?
Can I use a break-even calculator for services?
Related topics
- break even calculator
- break even point formula
- break-even revenue
- units to break even
- contribution margin calculator
- break even analysis
- break even point calculator
- profit target