Break-even point calculator and formula

Break-even is the sales volume where profit is exactly zero, because total revenue has just caught total costs. One unit more and you are making money. One unit less and part of your fixed costs is being paid out of something other than sales.

The split that makes the calculation work is fixed against variable. Fixed costs arrive whether you sell one unit or a thousand: rent, insurance, salaried pay, software, loan interest. Variable costs arrive with each sale: materials, packaging, card processing, hourly labour on the line.

Every sale covers its own variable cost first. What is left over is the contribution margin, and the fixed costs get paid off one margin at a time until they run out. The unit where they run out is the break-even point.

In units:

$$Q = \frac{F}{P - V}$$

With $24,000 of fixed costs, a $35 price and $20 of variable cost, the margin is $15 a unit and $Q = 24000/15 = 1600$ units.

The same answer in money runs through the contribution margin ratio, which is the margin as a share of the price:

$$R = \frac{F}{(P - V)/P}$$

Here the ratio is $15/35$, which is 42.86 percent to two places, so $R = 24000/(15/35) = 56000$, which is $56,000 of sales. Keep the fraction rather than the rounded 0.4286 until the last step, because the rounded ratio lands about four dollars short. The unit version answers how many, the revenue version answers how much, and on one product they always agree.

The revenue version is the one to reach for when you sell several different things, because it needs one margin ratio weighted by the sales mix rather than a single price and a single unit cost.

Break-even is a floor, not a plan. To find the volume that earns a specific profit, put the target on top of the fixed costs:

$$Q = \frac{F + T}{P - V}$$

$T$ is the profit you want. It behaves exactly like another fixed cost, because both have to come out of the same margin. On the numbers above, a $12,000 target lifts the requirement from 1,600 units to 2,400.

The reason the arithmetic stays this simple is that the margin per unit does not change with volume. Profit past break-even piles up at $15 a unit, so any target divided by $15 gives the extra units needed.

Debt belongs on the fixed side of this, with one split worth keeping straight. When you are solving for zero profit, only the interest part of a loan payment is a cost, so only the interest belongs in $F$. Repaying principal is money leaving the account, not an expense. Put the whole payment in instead and you are answering a different and higher question, the cash break-even, which is the volume that covers everything actually leaving the account that month. Neither part moves with sales, and the loan payment calculator splits a monthly payment into its interest and principal parts.

Three inputs move it, and they do not move it equally.

• Price. Every dollar of price goes straight into the margin. Lifting the price from $35 to $38 takes the margin from $15 to $18 and drops break-even from 1,600 units to 1,334.
• Variable cost. A dollar saved on each unit does the same work as a dollar added to the price, so a cheaper supplier moves the point just as far as a price rise does.
• Fixed costs. These scale the whole answer. Cut them by a tenth and the break-even volume falls by a tenth, whatever the margin happens to be.

High fixed costs with a wide margin is the operating leverage position: break-even sits a long way out, and every unit past it is worth a lot. Low fixed costs with a thin margin break even early and then climb slowly. Neither shape is safer on its own, which is why break-even is a volume question before it is a cost question.

One caution on the fixed side. Costs are only fixed inside a range: a second oven, a second shift or a bigger unit steps them up, and the formula assumes one straight line. When the decision runs over several years of cash flows rather than one period, net present value is the tool that answers it.