Featured image for Break-even point: formula, how to calculate it and examples

Break-even point: formula, how to calculate it and examples

Published on:

Reading time: 9 min

Topic: Entrepreneurship

Author: Leandro Valencia

#break-even point#break-even point formula#contribution margin#fixed costs#finance for entrepreneurs#entrepreneurship

Learn the break-even point formula in units and in sales, with worked examples for a coffee shop, a freelancer and a store with several products.

Table of Contents

How many coffees, projects or orders do you need to sell each month to avoid losing money? That question has an exact answer, called the break-even point. It is the sales level at which revenue covers all costs: you neither earn nor lose.

Knowing that number changes concrete decisions: whether you can afford a pricier location, whether raising your price makes sense, or whether hiring someone forces you to sell twice as much. This guide gives you the formula in units and in money, three complete examples and how to build it in Excel or Google Sheets in five minutes.

If you want to build the full financial plan (assumptions, a 12-month income statement and cash), start with the basic financial plan for small businesses. Here we focus only on the break-even point.

The three figures you need

Before the formula, split your costs into two groups:

  • Fixed costs: you pay them every month whether you sell or not. Rent, payroll (including your own salary), software, accountant, a loan installment, internet.
  • Variable costs: they grow with every unit sold. Raw materials, packaging, the payment gateway or marketplace fee, shipping, a salesperson's commission.
  • Selling price: what you charge per unit, before VAT. VAT is not yours: you collect it and pay it to the government.

With that you calculate the key figure, the contribution margin:

Unit contribution margin = Selling price − Unit variable cost
Contribution margin (%)  = Unit contribution margin ÷ Selling price

The contribution margin is what each sale leaves to pay fixed costs. When the sum of those contributions equals the fixed costs, you have reached the break-even point.

The break-even point formula

Break-even point in units = Fixed costs ÷ Unit contribution margin
Break-even point in sales = Fixed costs ÷ Contribution margin (%)

Use the units version when you sell something countable (coffees, T-shirts, licenses). Use the sales version when you have many products at different prices or sell services by the hour.

Example 1: a neighborhood coffee shop

The numbers are illustrative, in Colombian pesos and per month.

Item Value
Average ticket (before VAT) 18,000 COP
Variable cost per ticket (coffee, milk, cup, card terminal fee) 7,200 COP
Unit contribution margin 10,800 COP
Contribution margin (%) 60 %
Rent 3,500,000 COP
Payroll (two people, including the owner) 6,000,000 COP
Utilities 900,000 COP
Software, accountant and others 600,000 COP
Total fixed costs 11,000,000 COP
Units = 11,000,000 ÷ 10,800 = 1,018.5  →  1,019 tickets per month
Sales = 11,000,000 ÷ 0.60   = 18,333,333 COP per month

Open 30 days a month, that is about 34 tickets a day just to avoid losing money. You can compare that number with reality: how many people walk past the door? How many buy today? If the new location demands 60 tickets a day and the current one sells 40, you already know the move is a bet, not a formality.

How much to sell to earn what you want

If the owner wants a profit of 4,000,000 COP per month on top of a salary, the sum goes in the numerator:

Target units = (Fixed costs + Desired profit) ÷ Unit contribution margin
             = (11,000,000 + 4,000,000) ÷ 10,800 = 1,388.9  →  1,389 tickets

Margin of safety

The margin of safety tells you how far your sales can fall before you enter a loss:

Margin of safety = (Current sales − Break-even sales) ÷ Current sales

If the coffee shop sells 22,000,000 COP a month today: (22,000,000 − 18,333,333) ÷ 22,000,000 = 16.7 %. A weak rainy month or roadworks on the street that cut sales by 20 % put it in the red.

Example 2: a freelance designer who charges per project

In services, the "unit" can be a project, an hour or a retainer client. Values in dollars, per month:

Item Value
Price per project 600 USD
Payment platform fee (5 %) 30 USD
Subcontracted illustrator per project 60 USD
Contribution margin per project 510 USD
Designer's target salary 900 USD
Software (Adobe, Figma, hosting) 120 USD
Coworking 180 USD
Total fixed costs 1,200 USD
Projects = 1,200 ÷ 510 = 2.35  →  3 projects per month

With two projects she does not make it; with three she does. That figure helps decide the price: at 750 USD per project the margin rises to 652.50 USD and two projects are enough (1,200 ÷ 652.50 = 1.84). To set that price with margin and fees properly calculated, use the profit margin calculator or the guide on how to calculate the selling price.

Example 3: a store with several products

When you sell several products, each contributes a different margin. The solution is a weighted contribution margin based on the sales mix.

Product Price Variable cost Unit margin % of units sold Weighted margin
A 50 30 20 50 % 10.0
B 80 40 40 30 % 12.0
C 120 84 36 20 % 7.2
Total 100 % 29.2

With fixed costs of 5,840 per month:

Total units = 5,840 ÷ 29.2 = 200 units
A = 200 × 50 % = 100   B = 200 × 30 % = 60   C = 200 × 20 % = 40

Check: revenue is 5,000 + 4,800 + 4,800 = 14,600, variable costs are 3,000 + 2,400 + 3,360 = 8,760 and the difference is 5,840, exactly the fixed costs. Zero profit.

The example holds a lesson: product C has the highest price but a margin of only 30 %. If the mix tilts toward C, you need more units to reach break-even even though you bill more.

How to do it in Excel or Google Sheets

One sheet is enough. Put the data in column B:

Cell Item Formula
B1 Selling price (value)
B2 Unit variable cost (value)
B3 Monthly fixed costs (value)
B4 Contribution margin =B1-B2
B5 Contribution margin (%) =B4/B1
B6 Break-even point in units =ROUNDUP(B3/B4,0)
B7 Break-even point in sales =B3/B5

ROUNDUP rounds up, because you cannot sell half a coffee. If your spreadsheet is set to a Spanish locale, the function is REDONDEAR.MAS and the separator is a semicolon.

What moves the break-even point

The value of the calculation lies in scenarios. With the coffee shop from the example:

Change New calculation Break-even tickets
Current situation 11,000,000 ÷ 10,800 1,019
Rent rises by 500,000 COP 11,500,000 ÷ 10,800 1,065
Price rises by 1,000 COP 11,000,000 ÷ 11,800 933
Variable cost rises by 800 COP 11,000,000 ÷ 10,000 1,100

Raising the price by 5.6 % cuts the tickets needed by 8 %. That is why a small price adjustment often weighs more than cutting expenses: it acts on every sale, not once a month. If variable costs rise with inflation and you do not touch the price, break-even drifts away without you noticing. Reviewing these leaks is part of finding and plugging your business's money leaks.

Common mistakes

  • Leaving out your salary. If you work in the business and do not pay yourself, the break-even point comes out low and the business looks viable when it is not.
  • Including VAT in the price. VAT is not your income; always use the price before taxes.
  • Forgetting commissions. Payment gateway, marketplace, card terminal or delivery app fees are variable costs and can eat 10 % to 30 % of the price.
  • Calculating it only once. Prices, rents and suppliers change. Review it every quarter or whenever a big cost changes.
  • Confusing break-even with cash. You can be above the break-even point and run out of money if your customers pay in 60 days. That is what the projected cash flow is for.

Frequently asked questions

Does the break-even point work for an idea that is not selling yet?

Yes, and it is one of the first numbers worth working out. With estimated costs and a tentative price you know how many customers you need. Then you can check whether that demand exists with a market study or a smoke test.

What do I do if the break-even point comes out impossible?

You have three levers: raise the price, lower the variable cost or lower fixed costs. If no reasonable combination makes it reachable, the business model needs a different design. Review the Business Model Canvas before investing more.

Conclusion

The break-even point is a division, but it forces you to organize your costs, put a price on your own work and see how much each sale contributes. Calculate it today with your real numbers, test it with three scenarios and keep it in sight: it is the minimum goal of the month.

Step-by-step guide

  1. Separate fixed and variable costs

    List what you pay every month no matter what you sell, and what grows with each sale.

  2. Calculate the contribution margin

    Selling price minus unit variable cost: what each sale contributes toward fixed costs.

  3. Apply the formula

    Fixed costs divided by the contribution margin for units; by the margin in % for sales.

  4. Test scenarios

    Change the price, rent or variable cost and see how far the break-even point moves.

Frequently asked questions

What is a company's break-even point?

It is the sales level at which revenue exactly covers all costs, fixed and variable. At that point profit is zero: below it you lose money and above it you start to earn.

What is the break-even point formula?

In units: fixed costs ÷ (selling price − unit variable cost). In sales: fixed costs ÷ contribution margin as a percentage. The contribution margin percentage is (price − variable cost) ÷ price.

Does my salary go in the fixed costs?

Yes. If you work in the business, your salary is a fixed cost even if you do not pay it to yourself today. If you leave it out, the break-even point comes out lower than the real one and the business looks profitable when it only survives thanks to your unpaid work.

How do you calculate the break-even point with several products?

You calculate a weighted contribution margin based on the sales mix (what percentage of units each product sells). Fixed costs are divided by that weighted margin, and the total units are split according to the same mix.

Related Posts

Keep exploring similar content that may interest you

Partnerships

Tools I use every day, on better terms for this community.

Affiliate links. Your price does not change.See all partnerships
Training program

Ready to turn your idea into a real project?

Transforma is the program where you will learn to create, execute and scale your project with clarity and method.

Discover the Transforma Program