Break-Even Analysis: How to Calculate Your Break-Even Point

Updated September 2026 · 12-minute read

A break-even analysis answers the most important question in business, the one hiding underneath every pricing debate, marketing budget, and "should I quit my day job" conversation: exactly how much do I have to sell before I stop losing money? Most owners guess. The maths takes five minutes. This guide walks through the break-even formula, a full worked example for a product business and one for a service business, the multi-product version nobody explains properly, and what to do with the number once you have it.

What Is Break-Even Analysis?

Break-even analysis is the calculation that finds the exact sales volume where total revenue equals total costs. At the break-even point, profit is zero — but that's not a failure state; it's the finish line of your fixed costs. Below it, every unit contributes something but not enough, and the month ends in the red. Above it, something remarkable happens: because fixed costs are already covered, every additional unit sold adds its entire contribution margin straight to profit. Sell candle 161 in the example above and you make the full $15 — not $15 minus a share of the rent, because the rent is already paid for.

That asymmetry is why break-even is the most practical number in small-business finance. It converts everything vague about a business plan into one concrete target: 160 candles a month. 43 billable hours a month. $3,840 in sales a month. You can argue with a projection; you can't argue with 160.

Where break-even sits relative to your actual sales then tells you the health of the business in a single glance — which is exactly what lenders and investors look for in the financials section of a business plan (see our business plan Excel template guide for how it slots into the full document).

The Break-Even Formula (Two Versions)

Everything in break-even analysis comes from four numbers: your fixed costs, your price, your variable cost per unit, and — derived from the middle two — your contribution margin. The formulas:

Both versions produce the same answer from the same inputs — they just express it differently. The units version is the one you'll actually run your business on ("I need to sell 160"), while the revenue version is how you sanity-check a sales goal that includes multiple products ("I need $3,840 in the till").

Step 1. Sort Every Cost into Fixed or Variable

The entire analysis rests on this sorting, and it's where most first attempts go wrong. The test is simple: if selling one more unit changes the cost, it's variable; if it doesn't, it's fixed.

Ambiguous costs get a judgement call — the rule is: pick a bucket, note the assumption, and stay consistent. A cost-tracking system like our expense tracker template makes this sorting far easier because every dollar already has a category.

Step 2. Work Out Your Contribution Margin (Worked Example)

Meet the worked example we'll use throughout: a small soy-candle business. The numbers, broken down the way you'd actually pull them from a bank statement:

62.5% is a healthy contribution margin ratio for a hand-made product — every sales dollar brings 62.5 cents toward fixed costs. Food businesses run 60–70% too; retail runs 25–40%, which is why retail needs so much volume.

Step 3. Apply the Formula — and Read the Answer Properly

Now the division:

Read that as a daily target and it becomes even more concrete: 160 candles a month is roughly 8 candles a day, every day (or 40 on each of four market weekends). A number you can hold in your head is a number you can manage against.

The break-even P&L, visualised

Notice the shape: going from 160 to 220 candles — 37% more sales — produced $900 of profit, because all 60 extra candles contributed their full $15. Notice also that 100 candles doesn't mean "a bit of a loss": it's a $900 hole.

Step 4. Add a Target Profit — the Formula's Big Sister

Break-even tells you when profit is zero, which is interesting. What you actually want to know is when profit hits a number worth having. Add the target to fixed costs and divide by the same contribution margin:

This single calculation is the honest heart of pricing: it converts "I'd like to earn $2,000 from this" into a monthly production and sales plan. If 294 candles a month is impossible given your production capacity or market size, the business model — not your effort — is the problem, and you've found that out with a calculator instead of a bad year.

Step 5. Reality-Check with Margin of Safety

The margin of safety measures how much room sits between expected sales and the cliff edge:

27% means sales can fall by more than a quarter before the month turns to loss. That's a survivable cushion. The practical reading: under 10% and any slow month wipes out profit; 20%+ absorbs a bad month; 30%+ absorbs a genuine shock like a supplier price rise or a lost customer. A business with a 5% margin of safety isn't a business yet — it's a pricing problem wearing a business costume.

The Price Experiment Every Owner Should Run Once

Because price sits inside the contribution margin, small price changes swing the break-even point violently — far more than most owners expect. Here is the candle business priced three ways:

A $3 price rise — 12.5% — cuts the break-even volume by 26 candles a month. If the market tolerates $27, that's a month of breathing room for free. This is the arithmetic behind every "should I raise my prices?" debate, and it's why the complete pricing decision (competitors, positioning, value) deserves its own deep-dive: see how to price a product.

Break-Even with Multiple Products: The Weighted-Average Method

Real businesses sell more than one thing, and this is where textbook break-even articles usually wave their hands. The fix is a weighted-average contribution margin built from your sales mix. Say the candle business also sells soap ($12 price, $6 variable) and gift sets ($45 price, $15 variable), and the mix is 50% candles, 30% soap, 20% gift sets:

Break-even = $2,400 ÷ $15.30 ≈ 157 units per month, split by the mix: ~79 candles, ~47 soaps, ~31 gift sets — about $3,860 in revenue. (The $2 of slop versus $3,840 in the single-product version is rounding, which is exactly what a spreadsheet break-even looks like in real life.)

One warning: the mix is an assumption, not a law. If a bestseller dies and the mix shifts toward soap's thinner $6 margin, the weighted average falls and break-even rises — recompute it whenever the mix changes materially, and watch actual margins in a KPI dashboard so you notice.

Break-Even for Service Businesses: Hours Instead of Units

Selling your time? The formula doesn't change — the unit does. A consultant billing $95/hour with about $10/hour in variable costs (software licences, professional insurance allocated per engagement, payment fees) has a contribution margin of $85 per hour. With $3,600/month in fixed costs (co-working desk, insurance, accounting, marketing):

The capacity check matters more than the number itself: a solo consultant has roughly 120 billable hours in a month (about 60% of working hours is the realistic ceiling once admin, sales, and non-billable work take their cut — our freelance rate calculator covers that maths). 43 billable hours to break even is comfortable. 110 would mean one slow fortnight sinks the month — that's a rate problem, not a sales problem: raise the rate and the hours needed fall.

How to Do Break-Even Analysis in Excel (for $0)

Because the maths is one division, a spreadsheet is genuinely the best tool for break-even analysis — the formulas below are the entire job:

Wrap the break-even formulas in ROUNDUP — you can't sell two-thirds of a candle. For price sensitivity, put prices down a column and the formula across, or use Data → What-If Analysis → Data Table.

You have three realistic ways to get this built, at three very different price points:

LivePlan pricing verified September 2026. The decision rule: if break-even is all you need, the spreadsheet wins on cost, speed, and control — subscription software earns its fee when you also want automated accounting sync and industry benchmarks.

What Break-Even Analysis Is Actually For

A break-even number sitting in a spreadsheet changes nothing. Here are the four decisions it should be actively driving:

• Pricing decisions. The $24→$27 experiment above cut break-even from 160 to 134 candles. Every price debate now starts with arithmetic instead of vibes.
• Go/no-go on a new product or channel. A new product line's break-even is its minimum viable volume. If the farmers' market requires 60 candles a weekend to cover its fees and you've never sold more than 40, you know before you book the stall — this is also the fastest filter for new product ideas.
• Spending decisions. Fixed costs are a dial: add $500/month of fixed spend (equipment lease, assistant, ads) and break-even rises to 2900 ÷ 15 = 194 candles — 34 more than before. Any fixed-cost increase can be priced in units: is what this buys me worth 34 extra candles a month?
• Marketing reality. An extra $500 in ads must generate 500 ÷ 15 = 34 extra candles to pay for itself. That's a measurable bar for every campaign — and a CRM tracker tells you whether it clears it.

The 6 Mistakes That Make a Break-Even Analysis Wrong

1. Leaving out your own pay. Most owner break-evens quietly assume the owner works for free. Decide deliberately: if the business must pay you, add your salary to fixed costs (break-even rises); if it's a side business, note that assumption in writing.
2. Misfiling variable costs as fixed (or the reverse). Sales commissions and card fees are variable; the workshop rent is fixed. Every misfiled cost bends the break-even point in the wrong direction.
3. Using averages instead of per-unit costs. "$4,000 of materials for 400 candles" must be divided down to $10/unit before it meets the formula — averages across fluctuating batches hide price rises.
4. Ignoring step costs. Some costs jump in cliffs — the second kiln, the part-time assistant at 300 candles. Between 0 and 160 candles the analysis is true; at 250 it can silently break. Recompute at the steps.
5. Calculating it once. Costs change; break-even drifts. The number is only as good as its last update — re-run it whenever a supplier changes prices, rent moves, or you change yours.
6. Confusing break-even with cash flow. Break-even is a profit concept; it says nothing about when money arrives. A business can break even every month and still go under from slow-paying customers and inventory sitting in the garage. That's what a 12-month cash flow forecast is for — see cash flow forecast in Excel (and keep an inventory tracker on the stock side).

Final Word

The best way to do a break-even analysis is in a spreadsheet: sort your costs into fixed and variable, divide total fixed costs by contribution margin per unit, and treat the result — 160 candles, 43 hours, $3,840 — as this month's real target. Then add your target profit to fixed costs and divide again, because surviving is not the goal; the goal is the 294th candle. Recompute when prices or costs move, keep an eye on the margin of safety, and don't mistake break-even for cash flow. Five minutes of division, and the most important question in your business has an exact answer instead of a hopeful one.

Related guides: Cash Flow Forecast Excel Template · How to Price a Product · Business Plan Excel Template · Small Business KPI Dashboard · Freelance Rate Calculator · Inventory Tracker Excel Template