
Break-even point: formula, how to calculate it and examples
Published on:
Reading time: 9 min
Topic: Entrepreneurship
Author: Leandro Valencia
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
- The three figures you need
- The break-even point formula
- Example 2: a freelance designer who charges per project
- Example 3: a store with several products
- How to do it in Excel or Google Sheets
- What moves the break-even point
- Common mistakes
- Conclusion
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
Separate fixed and variable costs
List what you pay every month no matter what you sell, and what grows with each sale.
Calculate the contribution margin
Selling price minus unit variable cost: what each sale contributes toward fixed costs.
Apply the formula
Fixed costs divided by the contribution margin for units; by the margin in % for sales.
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

Business Plan Examples for Startups and SMBs (With Template)
How to write a lean business plan in 7 blocks, with a copy-ready template and 2 worked examples: a B2B SaaS and an online store in Latin America.

Smoke test: validate demand without code before building
How to run a smoke test with a fake door landing page, a refundable pre-order and 50–100 USD in ads to measure payment intent and CAC before you build.

Jobs to Be Done (JTBD): What It Is, Examples and How to Apply It
What Jobs to Be Done is and how to use it: the 4 forces of progress, timeline interviews with ready-to-use questions and a plan to validate your product.
Partnerships
Tools I use every day, on better terms for this community.