A break-even calculator shows how many units or dollars of sales a business needs to cover its costs before it begins generating operating profit. This guide explains the required inputs, the core formulas, two worked examples, and a simple spreadsheet structure you can revisit whenever prices, costs, or sales assumptions change.
Overview
Break-even analysis connects pricing and cost assumptions to a practical sales target. At the break-even point, total revenue equals total fixed costs plus total variable costs. The result is neither a profit nor a loss.
A break-even calculator is useful when you are:
- Setting a sales target for a new product or service
- Testing whether a proposed price can support the current cost structure
- Comparing a full-time hire, equipment purchase, or other fixed investment
- Building a budget or annual plan with realistic volume assumptions
- Explaining profitability thresholds to department or leadership teams
The most important output is usually break-even units, but a useful model can also show break-even revenue, contribution margin, target-profit volume, and margin of safety. Treat the result as a planning estimate rather than a guarantee. It is only as reliable as the costs, prices, and sales mix entered into it.
For broader planning, connect the result to a strategic planning template or a strategy dashboard template. Break-even is most useful when it informs an owner, target, or decision.
How to estimate your break-even point
Start by separating costs into fixed and variable categories. Then calculate the contribution margin, which is the amount left from each sale after its variable cost. That remaining amount contributes toward fixed costs and, after fixed costs are covered, profit.
Core formulas
Unit contribution margin = Selling price per unit − Variable cost per unit
Contribution margin ratio = Unit contribution margin ÷ Selling price per unit
Break-even units = Total fixed costs ÷ Unit contribution margin
Break-even revenue = Total fixed costs ÷ Contribution margin ratio
For example, if a product sells for $80 and has a variable cost of $50, its unit contribution margin is $30. If monthly fixed costs are $12,000, the business must sell 400 units to break even:
$12,000 ÷ $30 = 400 units
Break-even revenue is 400 units multiplied by the $80 selling price, or $32,000. The same result can be calculated using the contribution margin ratio of 37.5%: $12,000 ÷ 0.375 = $32,000.
Calculating a target profit
To estimate the volume needed for a specific operating profit, add the target profit to fixed costs before dividing by the unit contribution margin:
Required units for target profit = (Fixed costs + Target profit) ÷ Unit contribution margin
If fixed costs are $12,000, the target profit is $6,000, and the contribution margin is $30, the required volume is 600 units. This target is more useful for planning than break-even alone because it identifies the sales level needed to produce a defined result.
Inputs and assumptions
A reliable business calculator should make each assumption visible. Avoid putting one blended cost figure into a model without documenting what it includes.
Fixed costs
Fixed costs generally remain stable over the selected period, at least within a relevant operating range. Examples can include rent, salaried staff, software subscriptions, insurance, planned depreciation, and recurring administrative costs. Use the same time period for every input: monthly fixed costs should be compared with monthly sales and monthly variable costs.
Variable cost per unit
Variable costs change with the number of units or service engagements delivered. They may include materials, packaging, transaction fees, commissions, shipping, usage-based software, or contractor payments directly tied to delivery. Include costs that scale with sales even if they are small individually.
Selling price
Use the realized selling price rather than a headline list price when discounts, credits, refunds, or different customer tiers are common. If prices vary substantially, calculate separate scenarios or use a weighted average based on the expected sales mix.
Units and time period
Define a unit carefully. For a product business, it may be one item or order. For a service business, it could be one billable project, subscription month, consultation, or delivery hour. The unit should match how revenue and variable costs are recorded.
Spreadsheet layout
A simple Excel strategy template or Google Sheets calculator can use these rows:
- Selling price per unit
- Variable cost per unit
- Unit contribution margin
- Contribution margin ratio
- Total fixed costs
- Break-even units
- Break-even revenue
- Target profit
- Required units for target profit
- Forecast units
Use formulas instead of manually typing calculated outputs. Add notes beside assumptions so another person can understand the model and update it without rebuilding the analysis.
Worked examples
Product business example
Assume a business sells a product for $80. The variable cost is $50 per unit, and monthly fixed costs are $12,000.
- Unit contribution margin: $80 − $50 = $30
- Contribution margin ratio: $30 ÷ $80 = 37.5%
- Break-even units: $12,000 ÷ $30 = 400 units
- Break-even revenue: 400 × $80 = $32,000
If the sales forecast is 500 units, the margin of safety is 100 units, or 20% of forecast volume. Margin of safety can be calculated as:
Margin of safety units = Forecast units − Break-even units
Margin of safety percentage = (Forecast units − Break-even units) ÷ Forecast units
At 500 units, estimated operating profit before other adjustments is 500 × $30 − $12,000, or $3,000. This estimate assumes the price, variable cost, and fixed costs remain consistent across the range.
Service business example
Assume a consulting firm charges $2,000 per project. Direct delivery costs average $800 per project, and monthly fixed costs are $18,000.
- Contribution margin per project: $2,000 − $800 = $1,200
- Contribution margin ratio: $1,200 ÷ $2,000 = 60%
- Break-even projects: $18,000 ÷ $1,200 = 15 projects
- Break-even revenue: 15 × $2,000 = $30,000
The result should be interpreted alongside capacity. A service business may have a positive contribution margin but still be unable to reach break-even if the team cannot deliver 15 projects in the period. Capacity, lead time, utilization, and payment timing should be reviewed separately from the basic break-even calculation.
Mixed products and services
If you sell multiple products with different prices and margins, a single-unit formula can mislead you. Use an expected sales mix and calculate a weighted average contribution margin, or calculate break-even separately for each major product line. Revisit the mix if customers are shifting toward lower-margin offerings.
When to recalculate
Recalculate your break-even point whenever a material assumption changes. At minimum, review it during budgeting and forecasting cycles. A calculator should be revisited when:
- Prices, discounts, or contract terms change
- Supplier costs, wages, commissions, or delivery costs move
- Rent, subscriptions, payroll, or other fixed costs are added or removed
- A product, service package, or customer mix changes
- You add capacity or make a significant equipment or hiring decision
- Actual sales volume differs consistently from the forecast
- Exchange rates, tax assumptions, or other financial inputs affect your model
Use scenarios rather than one optimistic forecast. A practical spreadsheet can include conservative, expected, and upside cases, with separate values for price, variable cost, fixed cost, and volume. Compare the resulting break-even point with your sales capacity and cash requirements.
Finally, connect the calculation to a broader ROI and break-even analysis when evaluating an investment, and review pricing assumptions with a pricing strategy calculator. Record the date, owner, and assumptions in the workbook. That small discipline makes the model easier to trust, update, and use in the next planning meeting.
