A break-even calculator shows how many units, subscriptions, or projects a business must sell to cover its costs—and how sales targets change when prices, expenses, or profit goals move. This guide explains the break-even point formula, the inputs to collect, practical examples, and a reusable spreadsheet workflow for pricing and planning decisions.
Overview
Break-even analysis answers a simple operating question: at what sales volume will total revenue equal total costs? Below that point, the business is operating at a loss; above it, each additional sale contributes toward profit after its variable cost has been covered.
The calculation is useful for product launches, subscription planning, freelance quotes, hiring decisions, and monthly budget reviews. It is not a forecast by itself. It is a structured way to test whether a proposed price and sales volume can support the costs behind an offer.
There are two common outputs:
- Break-even units: the number of products, subscriptions, or projects required to cover costs.
- Break-even revenue: the sales value required to cover costs.
You can also use the same model as a profit target calculator by adding the desired profit to fixed costs. For decisions involving a new tool, campaign, or project, compare this analysis with a broader ROI calculator so that both the required sales volume and the expected return are visible.
How to estimate
Start by separating costs into fixed and variable categories. Then calculate the contribution margin—the amount from each sale available to cover fixed costs and profit.
Contribution margin per unit = selling price per unit − variable cost per unit
Once you have that figure, use the break-even point formula:
Break-even units = fixed costs ÷ contribution margin per unit
For revenue:
Break-even revenue = break-even units × selling price per unit
If you have a profit target, add it to fixed costs:
Required units for a target profit = (fixed costs + target profit) ÷ contribution margin per unit
Round the unit result up to the next whole sale. A result of 250.2 units means the business needs 251 units to reach or exceed the target under the stated assumptions. For revenue calculations, retain enough precision during the calculation and round only the final presentation.
A reusable spreadsheet layout
Create one input area and one results area in a spreadsheet. A simple structure is:
| Cell or field | Input or formula |
|---|---|
| Selling price | Enter the price per unit, subscription, or project |
| Variable cost | Enter the cost directly associated with one sale |
| Fixed costs | Enter costs for the selected period |
| Target profit | Enter zero for break-even, or a desired profit amount |
| Contribution margin | Selling price − variable cost |
| Break-even units | Fixed costs ÷ contribution margin |
| Target units | (Fixed costs + target profit) ÷ contribution margin |
| Break-even revenue | Break-even units × selling price |
Add separate scenario columns for a lower price, base price, and higher price. You can also test a higher variable cost or a different sales target without changing the original assumptions. If the contribution margin is zero or negative, the offer cannot reach break-even through sales volume alone; its price or cost structure must change.
Inputs and assumptions
The quality of a break-even calculator depends on the quality of its inputs. Use a consistent period, such as one month, quarter, or year. Do not combine annual fixed costs with monthly sales unless you convert them to the same period.
Fixed costs
Fixed costs generally do not change directly with each additional sale during the period being modeled. Depending on the business, the checklist may include:
- Rent, hosting, software subscriptions, and equipment leases
- Salaries or planned payroll that remain stable within the period
- Insurance, accounting, legal, and administrative costs
- Base marketing or sales costs that are not tied to each transaction
- Loan or financing commitments included in the operating plan
Classify costs based on how they behave in your own operation. A contractor, for example, may be a fixed monthly commitment in one arrangement but a per-project variable cost in another.
Variable costs
Variable costs increase as sales increase. They may include materials, packaging, shipping, payment processing, sales commissions, usage-based software, fulfillment, or delivery labor. For services, include the time and direct resources required to deliver each project. A hourly-to-project rate calculator can help translate estimated delivery time into a project cost.
Use the price that the business actually retains for the calculation. If a tax such as VAT is collected from the customer and remitted separately, model the applicable tax treatment consistently rather than treating pass-through tax as operating revenue. For tax-inclusive and tax-exclusive conversions, see the VAT calculator guide.
Business model comparison
| Business type | Unit | Typical fixed-cost focus | Typical variable-cost focus |
|---|---|---|---|
| Product business | One item sold | Premises, staff, equipment, base marketing | Materials, packaging, shipping, transaction fees |
| Subscription business | One active customer or subscription period | Platform, support team, administration | Usage, support load, payment fees, third-party services |
| Service business | One project or billable engagement | Core team, software, office, administration | Delivery time, contractors, travel, project-specific tools |
For subscriptions, define whether the model measures new subscriptions, active accounts, or monthly recurring subscriptions. For services, check capacity as well as break-even volume: the result may be financially attractive but impossible to deliver with available staff and billable hours.
Worked examples
Example 1: Product sales
Assume monthly fixed costs of $12,000, a selling price of $80 per product, and a variable cost of $32 per product.
- Contribution margin: $80 − $32 = $48
- Break-even units: $12,000 ÷ $48 = 250 units
- Break-even revenue: 250 × $80 = $20,000
To target $6,000 in monthly profit, calculate ($12,000 + $6,000) ÷ $48 = 375 units. At the same price, the target revenue is $30,000. If the price changes, recalculate both the contribution margin and the required revenue.
Example 2: Subscription offer
Suppose fixed monthly costs are $9,000, the monthly subscription price is $40, and the average variable cost per active subscriber is $8.
- Contribution margin: $40 − $8 = $32
- Break-even subscriptions: $9,000 ÷ $32 = 281.25, rounded up to 282
- Break-even revenue at 282 subscriptions: 282 × $40 = $11,280
This model assumes the subscriptions are active for the full period and that churn, discounts, refunds, and billing timing are represented in the chosen inputs. If those factors are material, add scenarios rather than hiding them inside one optimistic average.
Example 3: Service projects
A service business has fixed monthly costs of $7,000. It charges $1,500 per project and incurs $600 in direct delivery costs per project.
- Contribution margin: $1,500 − $600 = $900
- Break-even projects: $7,000 ÷ $900 = 7.78, rounded up to 8
- Break-even revenue at eight projects: 8 × $1,500 = $12,000
Before adopting the result, check whether eight projects fit the team’s available delivery capacity. If not, test a higher price, lower delivery cost, narrower scope, or a different staffing plan. For pricing context, compare your assumptions with a gross margin versus markup calculator.
When to recalculate
Revisit the break-even model whenever a major input changes, not only at year-end. A practical review schedule includes:
- Before a launch: replace estimates with the latest price, supplier, staffing, and delivery assumptions.
- During pricing reviews: test discounts, price increases, bundles, and changes in payment or fulfillment costs.
- Before hiring: add the expected payroll and related fixed costs, then calculate the additional sales required.
- After cost changes: update software, rent, materials, contractor rates, shipping, and transaction fees.
- Monthly or quarterly: compare actual units, revenue, and costs with the model and revise the assumptions.
- When tax or accounting treatment changes: confirm whether prices and costs are being modeled consistently, especially for tax-inclusive sales.
Keep the original scenario, the current operating case, and at least one conservative case in the spreadsheet. Label the period, currency, tax treatment, and date of each revision. A quarterly review can sit alongside a broader team productivity audit, while recurring meeting or coordination costs can be reviewed with a meeting cost calculator.
The most useful break-even calculator is one you can update quickly. Before making a pricing, hiring, or launch decision, replace the assumptions, confirm that fixed and variable costs are classified consistently, compare at least three scenarios, and check whether the required volume is operationally achievable. Then save the revised model with its review date so the next decision starts with current numbers rather than old estimates.
