Business Planning

Break-even calculator

Fixed costs per period
Price per unit
Variable cost per unit
Target profit
Optional. Set 0 and the target row simply repeats the break-even.
Units to break even 334
5000 ÷ (25 − 10)
Revenue at break-even 8,333.33
Contribution per unit 15
Contribution margin 60 %
Units per day 10.95
Units to hit the target profit 534
Fixed ÷ (price − variable cost)

Break-even units are fixed costs divided by contribution per unit. On the figures above, 5,000 of fixed costs against a contribution of 15 gives 333.33, rounded up to 334 units, and 8,333.33 of revenue. The 3,000 target profit needs 8,000 of contribution, which is 533.33 units — so 534, rounded up for the same reason.

How to find your break-even point

1 Enter fixed costs for one period: rent, salaries, software, insurance. Use the same period throughout.
2 Enter the price and the variable cost of one unit, counting only costs that rise when you make one more.
3 Read the units and the revenue needed to cover the fixed costs.
4 Set a target profit to see the volume that reaches it, or leave it at zero and the target row repeats the break-even.
5 Compare the contribution margin against a price change before you compare it against a cost change.

The output to read first is the contribution margin, not the unit count, because it tells you which lever moves the answer fastest. Take the figures above. Raise the price ten per cent, from 25 to 27.50, and contribution goes from 15 to 17.50, dropping break-even from 333.3 units to 285.7: a fall of one seventh. Cut the variable cost by the same ten per cent instead, from 10 to 9, and contribution reaches only 16, so break-even falls to 312.5, or one sixteenth. The two levers look symmetrical and are not, because a price rise adds its whole value to contribution while a cost cut adds only its own smaller share. On a thin contribution margin the asymmetry gets sharper still.

The unit rows round up and the money rows do not, on purpose. Both unit counts are whole units, because a partial one does not cover its share: 333 units of contribution comes to 4,995 against 5,000 of fixed cost, and 533 comes to 7,995 against a target that needs 8,000, so the answers are 334 and 534. Revenue at break-even and units per day are computed from the exact fraction instead, which is why revenue reads 8,333.33 and not 334 × 25 — the extra two-thirds of a unit is the margin by which 334 clears the line rather than sits on it. Multiply the rounded count yourself if you want the takings at the volume you would actually sell.

Units per day divides by 30.44, the average length of a month. The row therefore assumes the fixed costs you entered are monthly. Enter an annual rent and the daily figure is out by a factor of twelve, which is the most common way to get a wrong answer from this page.

Splitting costs into fixed and variable is a modelling decision rather than a fact about the costs, and the model quietly assumes both lines are straight. Real fixed costs come in steps: one van covers a volume, and the next unit past that needs a second van, so the break-even chart has a jump in it that a single division cannot show. Real variable costs bend too, downward through volume discounts on materials and upward through overtime. The straight-line answer is a good approximation near your current volume and gets worse the further you extrapolate from it.

Contribution margin is also not gross margin, though the two get quoted interchangeably. Contribution subtracts only the costs that vary with volume; a reported gross margin usually nets off some fixed production overhead as well, so it comes out lower for the same product. Using a gross margin figure in this panel understates contribution and overstates the volume you need.

Two things the count cannot carry on its own. First, price is treated as independent of volume, and it usually is not: selling twice as many normally costs a discount, more advertising, or both, and advertising that scales with volume belongs in the variable column rather than the fixed one. Second, depreciation is a fixed cost but not a cash outflow, so a business can be below its accounting break-even and still not run out of money. If the question is survival rather than profitability, strip the non-cash items out of the fixed costs and read the answer again.

What people use it for

  • Deciding whether a product line is viable
  • Working out the sales needed to cover a new hire
  • Modelling a price change against a cost reduction
  • Preparing a business plan
  • Finding the volume that funds a target profit rather than merely covering costs
  • Separating a cash break-even from an accounting one

Questions

Fixed costs divided by contribution per unit, where contribution is price minus variable cost.

Was this tool any good?
Internal signal only · I use it to find the tools worth rebuilding