Break-Even Point Calculator
Break-even chart
Formula
Contribution margin per unit = Price per unit - Variable cost per unit
Contribution margin ratio = Contribution margin per unit / Price per unit
Break-even units = Fixed costs / Contribution margin per unit
Break-even revenue = Fixed costs / Contribution margin ratio
Profit = Units sold × Contribution margin per unit - Fixed costs
Months to recover an investment = Upfront investment / Monthly profit
- Fixed costs
- Costs per month that stay the same at any sales volume, such as salaries, rent and software.
- Price per unit
- The amount a customer pays for one unit, after discounts.
- Variable cost per unit
- The cost that comes with each unit sold, such as materials, shipping and payment fees.
- Contribution margin
- The part of each unit's price left over to pay fixed costs.
- Break-even point
- The monthly volume at which revenue equals fixed plus variable costs and profit is $0.
- Upfront investment
- A one-off amount spent before sales start, such as tooling or a product launch, that monthly profit has to repay.
| Value | Calculation | Result |
|---|---|---|
| Contribution margin per unit | $50 - $20 | $30 |
| Contribution margin ratio | $30 / $50 | 60% |
| Break-even units | $40,000 / $30 = 1,333.33, rounded up | 1,334 |
| Break-even revenue | $40,000 / 60% | $66,667 |
| Profit at 1,500 units | 1,500 × $30 - $40,000 | $5,000 |
| Months to recover $60,000 | $60,000 / $5,000 | 12 months |
How the break-even formula is derived
Profit = Units × Price - Units × Variable cost - Fixed costs
At break-even profit is $0, so Units × (Price - Variable cost) = Fixed costs
Units = Fixed costs / (Price - Variable cost)
Multiply break-even units by the price to get break-even revenue: Fixed costs × Price / (Price - Variable cost), which is fixed costs over the contribution margin ratio. On the default numbers that is $40,000 / 60% = $66,667, the same as 1,333.33 units × $50. The unrounded figure is the exact crossing on the chart; whole units are rounded up, because 1,333 units still leave a loss.
Break-even sensitivity to price and variable cost
Price moves break-even more than its own percentage, because the whole change lands on the margin. A 10% lower price takes the margin from $30 to $25 and raises break-even by 20%. A 20% lower price raises it by 50%.
| Price | Price per unit | Margin per unit | Break-even units | Break-even revenue | Change in units |
|---|---|---|---|---|---|
| -20% | $40 | $20 | 2,000 | $80,000 | +50% |
| -10% | $45 | $25 | 1,600 | $72,000 | +20% |
| As entered | $50 | $30 | 1,334 | $66,667 | |
| +10% | $55 | $35 | 1,143 | $62,857 | -14.3% |
| +20% | $60 | $40 | 1,000 | $60,000 | -25% |
Variable cost moves it less in this example, because 10% of $20 takes $2 off the margin, against $5 for 10% of the price: 10% more variable cost raises break-even by 7.1%.
| Variable cost | Variable cost per unit | Margin per unit | Break-even units | Break-even revenue | Change in units |
|---|---|---|---|---|---|
| -20% | $16 | $34 | 1,177 | $58,824 | -11.8% |
| -10% | $18 | $32 | 1,250 | $62,500 | -6.2% |
| As entered | $20 | $30 | 1,334 | $66,667 | |
| +10% | $22 | $28 | 1,429 | $71,429 | +7.1% |
| +20% | $24 | $26 | 1,539 | $76,923 | +15.4% |
Default inputs: fixed costs $40,000, price $50, variable cost $20. One input changes at a time.
Break-even with several products
With more than one product, weight each product's contribution margin by its share of units sold. In the example the weighted margin is $30 × 50% + $50 × 30% + $15 × 20% = $33 per unit, so break-even is $40,000 / $33 = 1,212.1 units in total, split by the same mix, and $78,788 of revenue. Averaging the three margins without weights gives $31.67 and 1,263.2 units, which is wrong unless all three sell in equal numbers. If the mix shifts toward Product C, break-even rises.
| Product | Price | Variable cost | Margin | Share of units | Units at break-even | Revenue at break-even |
|---|---|---|---|---|---|---|
| Product A | $50 | $20 | $30 | 50% | 606.1 | $30,303 |
| Product B | $120 | $70 | $50 | 30% | 363.6 | $43,636 |
| Product C | $20 | $5 | $15 | 20% | 242.4 | $4,848 |
Example with made-up products and $40,000 of fixed costs.
Margin of safety
Margin of safety = (Units sold - Break-even units) / Units sold
Margin of safety is how far sales can fall before the business makes a loss. At 1,500 units against a break-even of 1,333.33, it is 166.7 units, or 11.1% of sales, worth $8,333 of revenue. A drop of more than 11.1% in a month turns the $5,000 profit into a loss.
Break-even for a subscription business
Break-even customers = Fixed costs per month / (Monthly revenue per customer × Gross margin)
A subscription business counts customers instead of units. At $100 a month and an 80% gross margin each customer brings $80 of gross profit, so $40,000 of fixed costs needs 500 paying customers. Customers leave, so holding that number takes new ones every month: at 3% monthly churn, 500 customers lose 15 a month that sales has to replace.
Break-even in Excel and Google Sheets
Neither program has a break-even function. Put fixed costs in B1, price per unit in B2 and variable cost per unit in B3, then:
Break-even units: =B1/(B2-B3)
Whole units: =ROUNDUP(B1/(B2-B3),0)
Break-even revenue: =B1/((B2-B3)/B2)
Profit at the units in B4: =B4*(B2-B3)-B1
The same formulas work in both programs. To solve for a price instead, Excel's Goal Seek (Data, What-If Analysis) sets the profit cell to 0 by changing B2; Google Sheets offers the same through its Goal Seek add-on.
Questions
How do I calculate the break-even point?
Subtract variable cost per unit from price to get the contribution margin, then divide fixed costs by it. With fixed costs of $40,000, a price of $50 and a variable cost of $20, the margin is $30 and break-even is $40,000 / $30 = 1,333.33, so 1,334 units a month.
What is the formula for a break-even point?
Break-even units = Fixed costs / (Price per unit - Variable cost per unit). Break-even revenue = Fixed costs / Contribution margin ratio, where the ratio is the contribution margin divided by the price.
Is there a break-even formula in Excel?
Excel has no built-in break-even function. With fixed costs in B1, price in B2 and variable cost in B3, =B1/(B2-B3) gives break-even units and =ROUNDUP(B1/(B2-B3),0) rounds up to whole units. The same formulas work in Google Sheets.
What is a contribution margin?
It is the part of the price left after the variable cost of that unit, the money each sale adds toward fixed costs. At $50 and $20 it is $30 per unit, or 60% of the price.
What is the difference between break-even point and payback period?
Break-even is a monthly volume at which profit is $0. Payback is the time monthly profit takes to repay an upfront investment. At 1,500 units the example makes $5,000 a month, so a $60,000 investment pays back in 12 months.
How do fixed costs change the break-even point?
Break-even units rise in proportion to fixed costs. Adding 10% to $40,000 moves break-even from 1,333.3 to 1,466.7 units. Price and variable cost act through the margin, so their effect is larger than their own percentage change, as the sensitivity tables show.
Burn and unit economics
Full lists as CSV
One-time per list| List | Rows | CSV | With contacts |
|---|---|---|---|
| Startups funded in the last 90 days | 4,521 | ||
| Angel investors | 23,916 | ||
| Venture capital firms | 23,051 | ||
| Private equity firms | 9,693 | ||
| Investment partners | 6,734 | ||
| Startup accelerators | 3,207 | ||
| Micro VC funds | 2,364 | ||
| All lists: 79,515 investors and 167,242 startups, two files | 246,757 |
Sample rows
first 10 of 4,521, Startups funded in the last 90 days| name | domain | website | description | founded | employees | city | region | country | sectors | funding_stage | last_round | last_round_date | last_round_usd | total_raised_usd | rounds | investors | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|