Knowing how to calculate the break-even point is one of the first things to do before setting prices, hiring staff, or launching a new product. It is the sales figure that allows a company to cover all its costs without generating losses or profits. Below this level, the business loses money; above it, it starts to make a profit. For a small business or a freelancer, having this clear reference changes the conversation with the bank, with partners, and with the team itself, as it stops relying on vague estimates.
What is the Break-Even Point and What is it For
The break-even point indicates how much a business needs to sell for its revenue to equal its total costs, that is, the sum of fixed costs and variable costs. It can be expressed in units sold or in euros of revenue, and both figures convey the same information from different angles.
It is useful to see it as a boundary. If sales fall below this threshold, revenues do not cover the structure. If they are above it, each additional sale contributes profit. That is why the indicator is useful for setting realistic business goals, assessing whether a new product is worthwhile, and understanding how much leeway the company has in the event of a drop in demand.
The Formula in Units
The calculation starts from three data points: fixed costs, which do not change regardless of sales volume, such as rent, salaries of permanent staff, or insurance; the selling price per unit; and the variable cost per unit, which does increase with each sale, such as raw materials, packaging, or shipping. The formula is as follows:
Break-even point in units = Fixed costs / (Selling price per unit - Variable cost per unit)
The difference between the price and the variable cost is known as the contribution margin. It is the portion of each sale that remains to cover fixed costs. The greater this margin, the fewer units are needed to reach break-even.
Let’s assume a business has 10,000 euros in monthly fixed costs, a selling price of 50 euros, and a variable cost of 30 euros per unit. The contribution margin is 20 euros. Dividing 10,000 by 20 gives a result of 500 units per month. With this figure, the company exactly covers its costs. Sale number 501 already generates profit.
How to Convert the Result to Euros
Often, it is more useful to know the target in revenue rather than in units, especially if the company sells very different products or works with services. To calculate it, the value formula is used:
Break-even point in value = Fixed costs / (1 - Variable cost per unit / Selling price per unit)
Using the same data from the example, the variable cost represents 60% of the price (30 divided by 50), so the contribution margin is 40%. Dividing the fixed costs by 0.4 results in 25,000 euros in monthly revenue. This is the same result as multiplying 500 units by 50 euros, which serves as a quick check.
What the Figure Means for Daily Management
The break-even point alone says little if it is not compared with actual sales. The difference between the two figures is called the margin of safety and measures how much revenue can fall before the company incurs losses. If in the previous example the business sells 600 units per month, the margin of safety is 100 units, equivalent to 16.7% of its sales. If demand drops by 10% in a slow season, it will still be above break-even.
A narrow margin of safety indicates that the business has little cushion. This does not mean it is in bad shape, but any rise in costs or drop in orders will immediately affect it. That is why this indicator is often reviewed alongside sales forecasts and cash flow.
Fixed and Variable Costs: Where Calculations Often Go Wrong
The most common mistake is misclassifying expenses. Some costs seem fixed but change with activity, such as overtime or sales commissions. Others, like commissions from card terminals or payment gateways, are overlooked because they are automatically deducted, even though they reduce the margin of each transaction and should be included among variable costs.
Another common error is mixing periods. If fixed costs are monthly, the break-even point must also be monthly. Calculating with annual costs and comparing with monthly sales leads to misleading conclusions. When the result seems too high or too low, it is advisable to first check if any costs are missing and whether the price used is the actual one.
When the Business Sells Multiple Products
If the company has several references with different margins, it is not enough to input a single price. It is necessary to calculate a weighted average price and a weighted average variable cost based on the sales mix. For example, if 50% of the units correspond to a high-margin product, 30% to a medium-margin product, and 20% to a low-margin product, the average contribution margin comes from combining those percentages. Then, the fixed costs are divided by that average margin, and the result is allocated among products according to their weight in sales.
This approach has a practical consequence. If the mix shifts towards lower-margin products, the overall break-even point rises even if the price of each product does not change. This helps to understand why a company can sell more and still have profitability issues.
What Moves the Break-Even Point
Any change in the variables of the calculation translates into a new threshold. An increase in fixed costs, for example, when opening a location or hiring a person, raises the number of sales needed. Increasing variable costs, as a result of a more expensive new supplier, has the same effect by reducing the margin of each unit. Conversely, a price increase or a negotiation that lowers material costs decreases the break-even point.
A higher break-even point is not always bad news. An investment in technology or production capacity may raise the structure's costs, but if the expected growth in revenue compensates for that increase, the decision may be reasonable. The useful question is whether the additional sales will arrive in a reasonable timeframe.
How to Calculate It in Excel
A spreadsheet is sufficient to get started. In Excel, simply place the price per unit in one cell, the variable cost per unit in another, and the fixed costs in a third. In a fourth cell, calculate the contribution margin by subtracting the variable cost from the price, and in a fifth, divide the fixed cost by that margin. This yields the break-even point in units and, by multiplying it by the price, in euros.
If there is already a model with income and expenses, the Goal Seek function allows finding the necessary units for the result to be zero. It has the advantage of working even if the relationship between costs and sales is not perfectly linear, and allows testing scenarios by changing one figure at a time. With this tool, a small business can quickly check what would happen if rent increases by 10% or if the price decreases by 5%.
With the data from the example, the conclusion is simple: the business needs to invoice 25,000 euros per month or sell 500 units to avoid losing money. Any figure above that line is already profit.
You may also like
