Business calculator

Break-even calculator

Find out how many units, jobs or billable hours you need to sell before your business stops losing money. Enter your fixed costs for a period, the price and the variable cost of each sale, and optionally a profit target. The calculator shows break-even units, break-even revenue and the contribution margin behind them.

  • โœ“ Break-even units
  • โœ“ Break-even revenue
  • โœ“ Contribution margin
  • โœ“ Profit target

Your numbers

Shows profit or loss and your margin of safety at that volume.

Result

Break-even point

โ€“

Assumes a constant price and cost per unit. Check pricing with the profit margin calculator.

How to calculate your break-even point

  1. 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.
  2. 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.
  3. 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.
  4. 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.

StepWorkingResult
Contribution margin per cake25 โˆ’ 1510
Contribution margin ratio10 รท 2540%
Break-even units1,000 รท 10100 cakes a month
Break-even revenue100 ร— 25 (or 1,000 รท 40%)2,500
Cakes for a 500 profit(1,000 + 500) รท 10150 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?
Divide fixed costs by the contribution margin per unit, which is the price minus the variable cost per unit. With 1,000 of fixed costs, a price of 25 and a variable cost of 15, break-even is 1,000 รท 10 = 100 units.
How do I calculate break-even revenue?
Multiply break-even units by the price, or divide fixed costs by the contribution margin ratio. 1,000 of fixed costs at a 40% contribution margin ratio needs 2,500 of sales.
What if my price is lower than my variable cost?
Then each sale loses money and there is no break-even point, however much you sell. Raise the price or reduce the cost of each unit before looking at volume. The calculator shows a warning in this case.
What counts as a fixed cost and what is variable?
Fixed costs stay the same whatever you sell in the period: rent, salaries, insurance, subscriptions, loan repayments. Variable costs rise with each sale: materials, packaging, shipping, sales commission, card processing fees.
How many units do I need to sell to make a profit target?
Add the target profit to fixed costs and divide by the contribution margin per unit. For a 500 profit with 1,000 fixed costs and a 10 margin per unit, you need 150 units.
Can I use a break-even calculator for services?
Yes. Treat one hour or one job as the unit, use your hourly or job price, and put only the costs tied to each job in variable cost. The result is the number of hours or jobs per period you must bill to cover overheads.

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