A break-even analysis calculator shows how many units or how much revenue you need before a product, service, or project covers its costs. This guide explains the break-even point formula, contribution margin, target profit calculations, and how to build an updateable break-even spreadsheet for comparing pricing and sales scenarios.
Overview
Break-even analysis connects your costs, price, and expected sales volume. The result is the point at which total revenue equals total costs. Below that point, the activity produces a loss; above it, each additional sale contributes towards profit after its variable cost has been covered.
A break-even calculator is useful for setting sales targets, checking a proposed price, reviewing a new product, or deciding whether a project is commercially viable. It is not a forecast by itself. It is a decision tool that shows what must happen under a defined set of assumptions.
The basic break-even point formula is:
Break-even units = Fixed costs ÷ Contribution margin per unit
Contribution margin per unit is the amount left from each sale after the variable cost of that sale:
Contribution margin per unit = Selling price per unit − Variable cost per unit
To find the break-even revenue rather than the number of units, multiply the break-even units by the selling price. Alternatively, use the contribution margin ratio:
Break-even revenue = Fixed costs ÷ Contribution margin ratio
The contribution margin ratio is contribution margin divided by selling price. Keep the pricing basis consistent throughout the calculation. For example, use prices excluding VAT if the VAT amount is collected on behalf of the tax authority and is not business revenue. A UK business may also want to compare the result with its Excel budget and cash flow model, because break-even profit and cash break-even are not always the same.
How to estimate your break-even point
Start by choosing the period and decision you are analysing. A monthly product calculation, an annual service plan, and a one-off project may use different cost groupings. Write the period at the top of the worksheet so that monthly fixed costs are not accidentally compared with annual sales.
- List fixed costs. Include costs that remain broadly unchanged within the relevant sales range, such as rent, software subscriptions, salaried management time, insurance, or committed overheads.
- Calculate the variable cost per sale. Include costs that rise with each unit, order, customer, or project. Depending on the business, this may include materials, packaging, transaction charges, delivery, commission, or contractor time.
- Enter the selling price. Use the actual price you expect to receive, and state whether it is VAT-inclusive or VAT-exclusive.
- Calculate contribution margin. Subtract variable cost per unit from selling price per unit. If the result is zero or negative, the calculation cannot produce a normal break-even point without changing the price or cost structure.
- Divide fixed costs by contribution margin. This gives the number of units required to cover the selected fixed costs.
- Round the sales requirement up. If the result is 412.4 units, the practical target is at least 413 units. For services, where sales may be measured in hours or retainers, use an appropriate operational unit.
A simple break-even spreadsheet can place assumptions in one input block and formulas in a separate results block. For example:
- Price per unit: £80
- Variable cost per unit: £32
- Fixed costs: £12,000
- Contribution margin: £48
- Break-even units: 250
- Break-even revenue: £20,000
In Excel, the core formulas could be written as =FixedCosts/(Price-VariableCost) for break-even units and =BreakEvenUnits*Price for break-even revenue. Add input validation and clear labels rather than hiding assumptions inside long formulas. For a more detailed model, compare the result with a break-even analysis Excel template that includes scenario planning and formula checks.
Inputs and assumptions
The quality of a break-even result depends more on the inputs than on the arithmetic. Use a short assumptions note beside each input so another person can understand what has been included.
Fixed costs
Fixed does not mean permanent. It means that the cost is treated as fixed for the period and volume range being analysed. A warehouse, for example, may be fixed at current capacity but increase if sales require more space. Separate committed costs from discretionary spending where possible. This lets you model a minimum operating break-even point and a fuller break-even point that includes planned spending.
Variable costs
Do not omit small per-sale costs if they become material at scale. Payment charges, packaging, fulfilment, sales commissions, support time, and returns can all reduce contribution margin. For project work, estimate variable labour and external supplier costs carefully. If staff time is not charged directly but is limited, it still has an economic cost and may need to be included for pricing decisions.
Price and product mix
Use the net price after discounts, credits, or expected refunds rather than a headline list price. If a business sells several products with different prices and margins, a single-product break-even calculation may be misleading. Use a weighted average contribution margin based on an assumed sales mix, or calculate separate scenarios for each product group.
Target profit
A break-even point produces zero operating profit. To calculate the sales volume needed for a target profit, add the target profit to fixed costs:
Target-profit units = (Fixed costs + Target profit) ÷ Contribution margin per unit
This is useful for turning a broad financial objective into an operational sales target. If you need help checking price assumptions, compare the model with a markup versus margin calculator. Markup is applied to cost, while margin is measured as a percentage of selling price; confusing the two can materially distort the result.
Worked examples
Example 1: physical product
A business sells a product for £80 excluding VAT. The variable cost is £32 per unit, and monthly fixed costs are £12,000.
The contribution margin is £80 − £32 = £48. The break-even volume is £12,000 ÷ £48 = 250 units. Break-even revenue is 250 × £80 = £20,000.
If the business wants a monthly operating profit of £4,800, the target-profit calculation is (£12,000 + £4,800) ÷ £48 = 350 units. At 350 units, expected revenue is £28,000 and contribution after variable costs is £16,800, leaving £4,800 after fixed costs.
Example 2: professional service
A consultant charges £600 for a fixed-scope engagement. Each engagement requires £150 of subcontractor and delivery costs. Monthly fixed costs allocated to the practice are £6,750.
Contribution per engagement is £450. Break-even volume is £6,750 ÷ £450 = 15 engagements. The revenue requirement is 15 × £600 = £9,000.
This result should be checked against capacity. If one consultant can complete only 10 engagements in the period, the model identifies a gap that cannot be solved by sales activity alone. The choices may include increasing price, reducing delivery cost, changing scope, adding capacity, or reducing fixed costs.
Example 3: comparing prices
Suppose fixed costs are £10,000 and variable cost is £25 per unit. At a price of £50, contribution margin is £25 and break-even volume is 400 units. At a price of £60, contribution margin is £35 and break-even volume falls to approximately 286 units, rounded up.
The higher price is not automatically better. It may reduce demand, increase sales effort, or change the expected mix of customers. Add a sales-volume assumption to each price scenario and calculate expected operating profit as:
Operating profit = (Expected units × Contribution margin) − Fixed costs
A three-column best-case, base-case, and worst-case model can make these trade-offs easier to review. The Excel scenario planning template provides a useful structure for keeping those assumptions visible.
When to recalculate
Revisit the break-even calculator whenever a key input changes, not just at the end of the financial year. Recalculate when you change prices, introduce discounts, renegotiate supplier rates, add staff, change rent or software commitments, alter delivery methods, or move into a different sales channel.
It is also sensible to review the model when actual results differ consistently from assumptions. Compare forecast and actual selling prices, variable costs, sales mix, and volume. If the business is growing, check whether fixed costs remain fixed at the new scale. A sales dashboard can help connect the calculation to real performance; see the sales dashboard template for Excel for a KPI-tracking approach.
Use this practical review process:
- Copy the current version of the spreadsheet and date the new version.
- Update price, fixed cost, variable cost, and expected volume assumptions separately.
- Check that VAT treatment, period length, discounts, and product mix are still consistent.
- Review break-even units, break-even revenue, target-profit volume, and capacity together.
- Compare the result with the cash flow forecast, because an accounting break-even point does not show payment timing or working-capital requirements.
- Record the decision, owner, and next review date beside the assumptions.
A break-even analysis calculator is most valuable when it remains updateable. Keep inputs clearly separated from formulas, retain scenario columns, and avoid replacing assumptions with unexplained hard-coded numbers. Used this way, the calculator becomes a repeatable decision tool for pricing, budgeting, sales planning, and target setting rather than a one-off calculation.
