Break-Even & Profit Margin Calculator

• Finds break-even units and break-even revenue from price, variable cost per unit and fixed costs, with the contribution margin behind them.
• Works out the units and sales needed to reach a profit target, and how far expected sales can fall before you lose money (margin of safety).
• Solves for gross margin and markup, operating margin, net margin after interest and tax, or the price that earns a target margin.
• Charts revenue, cost and profit against units sold and tabulates what a price rise or cut does to break-even and profit.

How to use this calculator

Start with three numbers: what you charge for one unit, what each unit costs you to produce and sell (the variable cost), and what you pay each period whether or not you sell anything (the fixed costs). Use the same period for fixed costs and for expected sales, either a month or a year. Then enter the number of units you expect to sell in that period and, if you have one, a profit target.

Use the first field to choose the headline result. The break-even point is the default, but every figure is calculated whichever you pick, so you can read gross margin, operating margin, net margin and the price for a target margin from the results grid below. Open Advanced to split out the cost of goods (the part of variable cost that belongs in gross margin), add interest expense and an income tax rate for the net margin, and change the step used in the price table.

If you sell more than one product, enter a blended average price and a blended average variable cost, weighted by how many of each you sell. The answer is only as steady as the sales mix.

What break-even means and how it is worked out

Your break-even point is the level of sales at which revenue exactly covers all costs, so profit is zero. Below it you lose money, above it you make money. The calculation rests on one idea: each unit you sell contributes something toward your fixed costs.

Contribution per unit = Price - Variable cost per unit
Contribution margin   = Contribution per unit / Price
Break-even units      = Fixed costs / Contribution per unit
Break-even revenue    = Fixed costs / Contribution margin
Units for a target    = (Fixed costs + Target profit) / Contribution per unit

With the default numbers, a $40 product that costs $22 to make and sell contributes $18.00 a unit, or 45% of the price. Against $12,000 of fixed costs, break-even is $12,000 divided by $18.00, or about 666.7 units. Since you cannot sell part of a unit, the calculator rounds up to 667 units, which is $26,667 of sales. Reaching a $6,000 profit takes ($12,000 plus $6,000) divided by $18.00, or 1,000 units.

Revenue-based break-even is useful when you do not know your unit count, such as a restaurant or service business. Divide fixed costs by the contribution margin and the answer is the sales dollars you need.

Margin of safety and operating leverage

Break-even tells you the floor. The margin of safety tells you how far above it you are. It is the gap between expected sales and break-even sales, shown as a share of expected sales:

Margin of safety = (Expected units - Break-even units) / Expected units

At 900 expected units against a break-even of 666.7, the margin of safety is 25.9%. Sales could fall by about a quarter before the business stops covering its fixed costs. A margin of safety under 10% means a small dip puts you at a loss. If you expect fewer units than break-even, the margin is negative: at 600 units the same business loses $1,200 a month and the margin of safety is -11.1%.

Operating leverage measures how sensitive profit is to a change in sales. It is contribution divided by operating profit, which is 3.86 here. That means a 1% change in sales moves operating profit by roughly 3.9%. The more of your costs are fixed, the higher the leverage: profits rise quickly when sales grow, and fall just as quickly when they shrink. The calculator shows it only when operating profit is positive, since the ratio has no meaning at or below break-even.

Gross, operating and net margin, and markup

Margin and markup are two ways of describing the same profit, and mixing them up is one of the most expensive mistakes in pricing. Margin is profit as a share of the selling price. Markup is profit as a share of cost.

Gross margin     = (Price - Cost of goods) / Price
Markup on cost   = (Price - Cost of goods) / Cost of goods
Operating margin = Operating profit / Revenue
Net margin       = Net profit / Revenue

Suppose the $22 of variable cost includes $18 of materials and labour in the product (cost of goods) and $4 of card fees and shipping. Gross margin is ($40 minus $18) divided by $40, or 55.0%, and the markup on cost of goods is 122.2%. A 55% margin and a 122% markup describe the same sale.

Operating margin goes further: it subtracts all variable costs and the fixed costs. At 900 units, revenue is $36,000 and operating profit is $4,200, so operating margin is 11.7%. Net margin takes off interest and income tax. With $500 of interest and a 25% tax rate, net profit is $2,775 and net margin is 7.7%.

To price for a margin, the calculator asks what price would deliver your target operating margin at your expected volume. For a 20% operating margin it is ($22 plus $12,000 divided by 900 units) divided by 0.80, or $44.17. Dividing by one minus the margin, not multiplying by one plus it, is what converts a margin target into a price.

What a price change does

Price is usually the strongest lever in the model, because a higher price adds profit on every unit without adding cost. Raising the default price from $40 to $44, a 10% increase, lifts contribution to $22 a unit, drops break-even to 546 units and raises operating profit from $4,200 to $7,800 if volume holds. Cutting the price 10% to $36 does the reverse: contribution falls to $14, break-even jumps to 858 units and profit shrinks to $600.

The last column of the price table answers the question every owner asks before a discount: how much more volume do I need to make the same money? A 10% price cut needs about 29% more units just to stand still, because each unit now contributes less. A 10% price rise lets you lose about 18% of your volume and still earn the same profit.

For comparison, a 1% price rise on the default business adds $360 of profit a month. A 1% rise in volume, with price unchanged, adds $162. This is not a rule that raising price is always right: higher prices usually reduce volume, and the table is a reason to test, not a forecast of what customers will do.

Assumptions and limitations

• Linear costs. Price and variable cost per unit are assumed the same at every volume. Real costs change with bulk discounts, overtime and new equipment.
• Fixed means fixed. Fixed costs are assumed constant across the range shown. Past a certain volume you may need more space or staff, which is a step up in fixed cost.
• One product, one price. A mixed product line needs a blended average, and the result changes when the mix does.
• Everything sold is paid for. No bad debts, returns, discounts or inventory build-up are modelled.
• Gross margin uses unit costs only. Fixed production overhead is counted in fixed costs, below gross margin. Accountants who include it in cost of goods will report a lower gross margin.
• Tax is a flat rate. Net profit uses the single rate you enter on positive profit and no tax benefit on a loss. Owners of pass-through businesses pay tax on their personal return at their own rates.
• Estimate only. Use your accounting records for the real figures.

Common mistakes

Leaving out your own pay. If the business must support you, include a salary in fixed costs. Otherwise break-even shows the point where the business covers its bills but you earn nothing.

Putting semi-variable costs in the wrong place. Card processing fees, shipping and sales commissions rise with each sale and belong in variable cost. A phone plan or software subscription does not.

Mixing periods. Fixed costs for a year with monthly sales will give a break-even twelve times too high.

Confusing markup and margin. A 50% markup on cost is a 33% margin, not 50%. Pricing at cost plus 30% and expecting a 30% margin leaves you short of your plan.

Treating break-even as the goal. It is the minimum. Set a profit target and see how many more units it needs.

Frequently asked questions