Break-Even Analysis for Small Business: Formula, Example & Free Excel Template

Break-even analysis helps you answer one of the most important financial questions in a small business: how much do you need to sell before you stop losing money?

In this guide, you will learn what break-even analysis is, how to calculate the break-even point in units and sales dollars, how contribution margin affects the result, and how changes in price or costs can move your break-even point. You can also download a free Excel break-even analysis template to apply the calculation to a single product or service.

Key formulas
Break-Even Point (Units) = Fixed Costs ÷ Contribution Margin per Unit
Break-Even Sales ($) = Fixed Costs ÷ Contribution Margin %

Table of Contents

What Is Break-Even Analysis?

Break-even analysis is a financial method used to determine the sales level at which total revenue equals total costs. At the break-even point, the business is not making a profit, but it is no longer operating at a loss.

You can express the break-even point in units or in sales dollars. Both approaches help you establish the minimum level of sales your business needs to cover fixed and variable costs.

The calculation is closely connected to contribution margin, which shows how much of each sale remains after variable costs to help cover fixed costs and eventually generate profit.

What Is Break-Even Analysis Used For?

Break-even analysis can help a small business make several practical decisions:

  1. Evaluate whether a business idea or project is financially realistic.
  2. Set minimum sales targets before expecting a profit.
  3. Support pricing decisions by showing how price affects contribution margin.
  4. Evaluate changes in costs, including rent, payroll, shipping, packaging, commissions, or software.
  5. Analyze investments or hiring decisions that increase fixed costs.
  6. Improve business planning by connecting costs, margins, and required sales volume.

Practical tip: recalculate your break-even point whenever fixed costs, selling prices, logistics costs, payment fees, commissions, or other important cost assumptions change.

Break-Even Point Graph

A break-even chart usually compares total revenue with total costs as sales volume increases. The point where both lines meet represents the break-even point. Sales below that level generate a loss; sales above it can begin to generate profit, assuming the cost and price assumptions remain valid.

How to Calculate the Break-Even Point

For the examples in this guide, we will use the following assumptions:

  • Fixed Costs: $160
  • Variable Cost per Unit: $7
  • Selling Price per Unit: $15
  • Contribution Margin per Unit: $8
  • Contribution Margin %: 53.33%

The contribution margin per unit is calculated first:

Contribution Margin = Selling Price − Variable Cost per Unit
$15 − $7 = $8

The contribution margin percentage is:

Contribution Margin % = Contribution Margin ÷ Selling Price
$8 ÷ $15 = 53.33%

Break-Even Point in Units

This calculation shows how many units you need to sell to cover your fixed costs.

Break-Even Point (Units) = Fixed Costs ÷ Contribution Margin per Unit

Using our example:

$160 ÷ $8 = 20 units

The business must therefore sell 20 units to reach break-even. Starting with the next unit sold, the business can begin generating profit if the assumptions remain unchanged.

Practical application: unit-based break-even is especially useful for businesses that sell a limited number of standardized products or services.

Break-Even Point in Sales Dollars

Businesses with multiple transactions or products often find it more practical to track break-even in revenue rather than individual units.

Break-Even Sales ($) = Fixed Costs ÷ Contribution Margin %

Using the same example:

$160 ÷ 0.5333 ≈ $300

The business needs approximately $300 in sales to cover its fixed and variable costs under these assumptions.

Tracking break-even in sales dollars can be useful when your sales reports, budgets, or targets are primarily managed in revenue rather than units.

Limitations of Break-Even Analysis

Break-even analysis is useful, but it is still a simplified financial model. Its limitations should be understood before using the result for important business decisions.

  • It is primarily an internal planning tool and does not measure market demand or competitor behavior.
  • It assumes that selling prices and variable costs remain reasonably stable within the period analyzed.
  • Discounts and promotions can reduce contribution margin and increase the break-even point.
  • It does not tell you which specific costs should be reduced.
  • It does not replace pricing research, customer analysis, demand forecasts, or competitive analysis.
  • It measures profitability thresholds, but it does not guarantee that the business has enough cash available to pay its obligations.

How Break-Even Changes in a Real Business

In practice, a business’s break-even point can change even when sales appear stable. Small increases in packaging, shipping, transaction fees, commissions, direct labor, or supplier costs can reduce contribution margin and increase the amount the business must sell before becoming profitable.

This is especially relevant in retail and ecommerce. A store can generate significant revenue while still struggling financially if shipping, returns, marketplace fees, payment processing, packaging, and fulfillment consume too much of each sale.

The same principle applies to service businesses. If the direct labor or materials required to deliver each service increase but prices remain unchanged, contribution margin falls and the break-even point rises.

This is why break-even analysis should not be treated as a one-time calculation for a business plan. Recalculate it whenever you change prices, add products, renegotiate supplier terms, hire employees, increase fixed expenses, or significantly change your operating model.

Free Break-Even Analysis Template

You can use the free Excel template to calculate break-even for one product or service. The workbook calculates contribution margin, contribution margin percentage, break-even units, and break-even sales dollars from three inputs.

Quick Instructions

  1. Enter your monthly Fixed Costs.
  2. Enter the Variable Cost per Unit.
  3. Enter the Selling Price per Unit.
  4. Review the calculated Contribution Margin.
  5. Review the Contribution Margin %.
  6. Review the Break-Even Point in Units.
  7. Review the Break-Even Sales amount.
  8. Check the viability indicator before interpreting the result.
  9. Repeat the calculation whenever your price or cost assumptions change.
MetricExample Value
Fixed Costs$160
Variable Cost per Unit$7
Selling Price per Unit$15
Contribution Margin$8
Contribution Margin %53.33%
Break-Even Point20 units
Break-Even Sales$300

Break-Even Example Step by Step

Suppose your business has:

  • Fixed Costs: $160
  • Variable Cost per Unit: $7
  • Selling Price per Unit: $15

1. Calculate Contribution Margin
$15 − $7 = $8

2. Calculate Contribution Margin %
$8 ÷ $15 = 53.33%

3. Calculate Break-Even Point in Units
$160 ÷ $8 = 20 units

4. Calculate Break-Even Sales
$160 ÷ 0.5333 ≈ $300

Break-Even Analysis for Multiple Products and Sales Mix

If your business sells several products, break-even becomes more complex because each product can have a different contribution margin. In that case, you can estimate break-even sales using a weighted contribution margin percentage based on your sales mix.

Weighted Contribution Margin % = Σ (Sales Mix Weight × Contribution Margin %)

Then:

Break-Even Sales = Fixed Costs ÷ Weighted Contribution Margin %

For example:

  • Product A has a 40% contribution margin and represents 60% of sales.
  • Product B has a 20% contribution margin and represents 40% of sales.

The weighted contribution margin is:

(0.60 × 0.40) + (0.40 × 0.20) = 0.24 + 0.08 = 32%

If fixed costs are $160:

$160 ÷ 0.32 = $500 in break-even sales

If the sales mix shifts toward lower-margin products, the break-even point can increase even if total revenue remains similar.

Important: the free Excel template on this page is designed for one product or service. The multiproduct calculation above is included for educational purposes and requires a weighted sales mix analysis.

Break-Even Sensitivity Analysis: What Happens When Variables Change?

Your break-even point changes whenever your selling price, variable cost, or fixed costs change. Testing scenarios can help you understand the financial impact before making a decision.

Base scenario:
Fixed Costs = $160
Selling Price = $15
Variable Cost per Unit = $7
Contribution Margin = $8
Break-Even = 20 units and $300 in sales

Scenario 1: Variable Cost Increases From $7 to $8

The contribution margin decreases from $8 to $7 per unit.

New break-even: approximately 23 units and $343 in sales.

This illustrates a simple rule: when variable costs increase and price stays the same, you generally need more sales to cover the same fixed costs.

Scenario 2: Selling Price Decreases From $15 to $14

With variable cost still at $7, contribution margin falls from $8 to $7.

The contribution margin percentage becomes 50%, so:

Break-Even Point: approximately 23 units
Break-Even Sales: $320

Lowering price without protecting contribution margin can require significantly more sales just to maintain the same financial position.

Scenario 3: Fixed Costs Increase From $160 to $200

If contribution margin stays at $8:

$200 ÷ $8 = 25 units

Using the same 53.33% contribution margin:

$200 ÷ 0.5333 ≈ $375 in sales

Higher fixed costs raise the minimum sales level the business must achieve every period.

Break-Even Analysis vs. Cash Flow

Break-even analysis and cash flow answer different questions.

Break-even analysis tells you when revenue is sufficient to cover costs. Cash flow tells you whether the business has enough cash available at a specific point in time.

A business can technically reach break-even and still experience cash shortages because of delayed customer payments, inventory purchases, seasonality, deposits, loan payments, or other timing differences.

For that reason, use break-even as a profitability threshold and complement it with a cash flow forecast to understand whether your business is likely to have enough cash available over the coming months.

Frequently Asked Questions About Break-Even Analysis

What Is the Break-Even Formula?

For units, use:

Break-Even Point = Fixed Costs ÷ (Selling Price per Unit − Variable Cost per Unit)

For sales dollars, use:

Break-Even Sales = Fixed Costs ÷ Contribution Margin %

How Do You Calculate Break-Even for a Service Business?

For a service business, define one unit as a service, appointment, project, billable hour, or another useful unit of delivery. Variable costs may include direct labor, commissions, supplies, transaction fees, or other costs incurred when the service is delivered. Subtract those variable costs from the selling price to calculate contribution margin, then apply the standard break-even formula.

How Do You Use Break-Even Analysis in Ecommerce?

Include variable costs that occur because an order is placed, such as payment processing fees, marketplace commissions, packaging, fulfillment, shipping subsidies, and an appropriate allowance for returns when relevant. A store can have strong revenue but still require an unrealistic sales volume to break even if the contribution margin per order is too low.

What Is Contribution Margin and Why Does It Matter?

Contribution margin is the amount left from each sale after variable costs:

Contribution Margin = Selling Price − Variable Cost

That amount first contributes toward fixed costs. Once fixed costs have been covered, additional contribution margin can contribute toward profit.

How Do You Calculate Break-Even for Multiple Products?

For multiple products, calculate a weighted contribution margin percentage using each product’s share of sales. Then divide fixed costs by the weighted contribution margin percentage. Because the result depends on sales mix, the break-even point can change when customers purchase a different combination of products.

What Happens to Break-Even When You Offer Discounts or Promotions?

Discounts generally reduce selling price and contribution margin. Before launching a promotion, recalculate break-even using the discounted price. This shows how much additional volume you may need to sell to offset the lower margin.

How Often Should You Recalculate Your Break-Even Point?

Recalculate whenever an important assumption changes, including selling price, rent, payroll, supplier costs, shipping, commissions, packaging, or transaction fees. A monthly or quarterly review can also be useful for businesses with changing costs or prices.

What Are Common Break-Even Analysis Mistakes?

Common mistakes include forgetting small variable costs, mixing fixed and variable expenses, using an unrealistic contribution margin, ignoring discounts or returns, and continuing to use an old calculation after prices or costs have changed.

Is Break-Even the Same as Profitability?

No. At break-even, profit is approximately zero because revenue is covering the costs included in the analysis. Profitability begins when sales move above the break-even level while contribution margin and other assumptions remain favorable.

Can Break-Even Analysis Help You Decide Whether to Hire or Invest?

Yes. If a new employee, facility, subscription, or investment increases fixed costs, you can calculate the new break-even point and compare it with your realistic sales capacity. This does not make the decision for you, but it shows how much additional sales volume the business may need to support the higher cost structure.

Calculate Your Break-Even Point in Minutes

Use the free Excel template to enter your fixed costs, variable cost per unit, and selling price. The workbook automatically calculates contribution margin, break-even units, break-even sales, and provides a simple viability check.

Conclusion: How to Use Break-Even Analysis in Your Business

Break-even analysis gives you a concrete minimum sales target. Instead of asking only whether your business is selling more, you can ask whether those sales are sufficient to cover the cost structure behind them.

Use the break-even point as a management reference rather than a one-time calculation. Recalculate when costs or prices change, compare it with actual sales, and pay attention to contribution margin. If your break-even point keeps increasing, you may need to improve margin, reduce costs, raise prices, or reassess the sales volume your business can realistically achieve.

Break-even analysis also works best when combined with cash management. Once you know how much you need to sell to cover costs, use a 12-month cash flow forecast to evaluate whether the timing of your cash inflows and outflows can support your operations.


Discover more from

Subscribe to get the latest posts sent to your email.

Scroll to Top