The free break-even analysis Excel template
A real, working spreadsheet with live formulas, an auto-updating chart, target profit, and multi-product support, plus the one formula almost every other guide skips: how to solve for price when part of your variable cost is itself a percentage of price.
An accurate mockup of the actual template's Inputs & Calculator tab. Blue cells are inputs, black cells are live formulas that recalculate the moment an input changes.
Download the template
Four tabs: Instructions, Inputs & Calculator, Chart Data (with a live break-even chart), and Multi-Product. Every formula is real and editable. Nothing is a hardcoded number or a locked cell.
Download the .xlsx templateWhat's actually inside the file
Fixed costs, price, variable cost (both dollar and percentage-based), break-even units and revenue, margin of safety, target profit, and the break-even price formula, all on one tab.
A 13-row revenue-vs-cost table, pulling directly from the Inputs tab, feeding a live line chart that shows exactly where the two lines cross.
A three-product example with price, variable cost, and sales mix per product, computing a weighted-average contribution margin and splitting the blended break-even back out per product.
A one-page legend explaining the blue-input, black-formula color convention used throughout, so nothing gets accidentally overwritten.
The core formula
Everything else in the template is a variation on this one line. In Excel, with fixed costs in cell B4, price in B5, and variable cost in B6, the formula is simply =B4/(B5-B6). No array formulas, no Goal Seek, no add-ins. A single division, once the three inputs are in place.
Building it yourself, cell by cell
If you'd rather build this from scratch than start from the template, here's the same structure, in order.
Two habits keep this from breaking later. First, never type a number directly into a formula cell. If variable cost needs to reference $18, put $18 in its own input cell and reference that cell, not the literal number, so a future change only has to happen once. Second, use absolute references ($B$4 instead of B4) the moment a formula gets copied down a column of multiple rows. Otherwise Excel shifts the reference on every row and the formula quietly points at the wrong cell two rows down.
The break-even chart
The classic break-even chart plots two lines against units sold: total revenue (a straight line starting at $0) and total cost (a straight line starting at fixed costs, then rising with variable cost per unit). Where the two lines cross is the break-even point. Below it, cost sits above revenue and every unit sold adds to a loss; above it, revenue sits above cost and every additional unit adds to profit.
Built from the template's own default numbers: $8,000 fixed costs, $45 price, $18 variable cost plus a 2.9% processing fee. The lines cross at 311 units, matching the Break-even units cell exactly.
To build this in Excel: select the unit, revenue, and cost columns on the Chart Data tab, then Insert → Chart → Line Chart. Because every value in those columns is a formula referencing the Inputs tab, the chart redraws itself automatically the moment a fixed cost, price, or variable cost changes, with no manual updating required.
When you actually need Goal Seek
Most break-even guides introduce Goal Seek immediately, as if it's required for the basic calculation. It isn't. Solving for break-even units from known fixed costs, price, and variable cost is a direct formula, shown above, with no iteration needed at all.
Goal Seek earns its place specifically when a formula would otherwise be circular, when the thing you're solving for appears on both sides of the equation. The clearest example: solving for the price that hits a target margin, where part of variable cost is itself a percentage of that same price (a payment processing fee, for instance). Price depends on variable cost, and variable cost depends on price, so Excel can't solve that directly with a plain formula. Goal Seek (Data → What-If Analysis → Goal Seek, set the profit cell to 0 by changing the price cell) numerically converges on the answer instead.
The template sidesteps this entirely with a closed-form algebraic version of the same formula, covered next, so Goal Seek is available as a backup method, not a requirement.
Goal Seek isn't the default tool for break-even. It's the fallback for the one specific case where the algebra gets circular and a direct formula won't solve it.
The break-even price formula
The formula almost no other guide covers properly: solving for price, not units, when part of variable cost is a percentage of price.
This solves a specific, common real-world problem: a business has a fixed monthly capacity (a kitchen that can only turn out so many meals, a service business with a fixed number of billable hours) and needs to know what price breaks even at that capacity, given costs that are partly dollar-based (materials, direct labor) and partly percentage-based (a card processing fee, a marketplace commission).
With $8,000 in fixed costs, a 600-unit monthly capacity, $18 in dollar-based variable cost per unit, and a 2.9% processing fee: Price = (1 ÷ (1 − 0.029)) × ($18 + ($8,000 ÷ 600)) = 1.0299 × ($18 + $13.33) = 1.0299 × $31.33 = $32.27. At that exact price, selling all 600 units of capacity produces exactly $0 profit, verified directly in the template, where the formula in cell B25 is live and recalculates for any capacity, cost, or fee percentage.
Target profit and margin of safety
Both are one-line extensions of the core formula, already live in the template. At $8,000 fixed costs, a $25.70 contribution margin, and a $5,000 target monthly profit: units needed = ($8,000 + $5,000) ÷ $25.70 ≈ 506 units. Against an expected 700 units sold, margin of safety is 700 − 311 = 389 units, or about 55.5%, meaning sales could fall by over half before the business dropped back to break-even.
Multi-product break-even
A single-product break-even formula doesn't work once a business sells several products at different margins. A coffee shop selling lattes, pastries, and sandwiches needs a weighted-average contribution margin instead, built from each product's own margin multiplied by its share of the total sales mix.
Summed, the weighted-average contribution margin is $3.21. Against $12,000 in fixed costs, blended break-even is $12,000 ÷ $3.21 ≈ 3,738 total units, and splitting that back out by the same sales mix gives roughly 2,056 lattes, 1,121 pastries, and 561 sandwiches, the specific combination that clears fixed costs given how the business actually sells. The Multi-Product tab in the template builds this with live formulas for exactly this scenario, editable for any number of products.
Common Excel mistakes
A formula like =8000/(45-18) works once, but breaks the entire point of a template. Every input should live in its own cell, referenced by formulas, so a single change updates everything downstream.
A formula referencing B4 without the dollar signs shifts to B5, B6, B7 as it's copied down a column. Use $B$4 for any cell that should stay fixed across every row.
A cost that scales with volume (materials, packaging, per-unit shipping) belongs in variable cost, not fixed. Misclassifying even one line item shifts the break-even calculation in a way that's easy to miss until the number looks wrong.
Payment processing fees, marketplace commissions, and sales tax remitted by the business are all percentage-based variable costs. Omitting them (as most simple break-even formulas do by default) understates true variable cost and overstates the resulting margin.
For a live version of the core calculation with no spreadsheet required, useful for a quick check before opening Excel at all, the break-even point calculator runs the same math instantly, and the CVP analysis calculator extends it to target profit and margin of safety in one place.
Frequently asked questions
Yes. No email signup, no watermark, no locked cells. Download it directly, it's a real .xlsx file with live formulas you can edit and keep.
Set up three input cells (fixed costs, price per unit, and variable cost per unit), then a fourth cell with the formula =FixedCosts/(Price-VariableCost). That's the whole calculation; everything else in a break-even workbook (charts, target profit, margin of safety) builds on that one formula.
Not for the standard calculation. Solving for break-even units from known costs and price is a direct formula, no Goal Seek required. Goal Seek becomes useful specifically when solving for price or volume with a variable that depends on itself, like the break-even price formula covered below.
Price = (1 ÷ (1 − % of price that's variable cost)) × (dollar-based variable cost + (fixed costs ÷ unit capacity)). It solves directly for the price needed to break even when part of your variable cost, like a payment processing fee, is itself a percentage of price, which otherwise creates circular math.
Use a weighted-average contribution margin instead of one product's CM. Multiply each product's contribution margin by its share of total sales mix, sum those, and divide fixed costs by that blended number. The Multi-Product tab in the template does this with live formulas.
Download the free template again, or run the numbers instantly on the break-even point calculator.