FundingWatcher
Home / Tools / Break-Even Point Calculator

Break-Even Point Calculator

Break-even units per month
Break-even revenue per month
Contribution margin per unit
Profit
Investment recovered in

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.
ValueCalculationResult
Contribution margin per unit$50 - $20$30
Contribution margin ratio$30 / $5060%
Break-even units$40,000 / $30 = 1,333.33, rounded up1,334
Break-even revenue$40,000 / 60%$66,667
Profit at 1,500 units1,500 × $30 - $40,000$5,000
Months to recover $60,000$60,000 / $5,00012 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%.

PricePrice per unitMargin per unitBreak-even unitsBreak-even revenueChange in units
-20%$40$202,000$80,000+50%
-10%$45$251,600$72,000+20%
As entered$50$301,334$66,667
+10%$55$351,143$62,857-14.3%
+20%$60$401,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 costVariable cost per unitMargin per unitBreak-even unitsBreak-even revenueChange in units
-20%$16$341,177$58,824-11.8%
-10%$18$321,250$62,500-6.2%
As entered$20$301,334$66,667
+10%$22$281,429$71,429+7.1%
+20%$24$261,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.

ProductPriceVariable costMarginShare of unitsUnits at break-evenRevenue at break-even
Product A$50$20$3050%606.1$30,303
Product B$120$70$5030%363.6$43,636
Product C$20$5$1520%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

ListRowsCSVWith 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
namedomainwebsitelinkedindescriptionfoundedemployeescityregioncountrysectorsfunding_stagelast_roundlast_round_datelast_round_usdtotal_raised_usdroundsinvestors
QABULA HOLDINGS PTY LTDqabulaholdings.co.zahttps://www.qabulaholdings.co.zahttps://za.linkedin.com/company/qabulaholdings20151 to 10PretoriaNA - South AfricaSouth AfricaLogistics and supply chainPre-seedPre-seed2026-11-221
Blindsightblindsight.iohttps://blindsight.iohttps://www.linkedin.com/company/blindsightaiBlindsight provides cybersecurity products that protect AI systems and software-as-a-service applications from emerging threats.20251 to 10ZürichZurichSwitzerlandArtificial intelligence; Cybersecurity; Software; Generative AISeedAngel2026-11-191
Sciphagesciphage.comhttp://sciphage.com/https://www.linkedin.com/company/sciphageSciphage develops natural functional alternatives that reduce the use of antibiotics.201411 to 50BogotáDistrito EspecialColombiaBiotech; Climate techSeedSeed2026-11-111070001070003The Ganesha Lab
Zhiyi Technology2026BeijingBeijingChinaSeedSeed2026-11-111
PORTport.cityhttps://port.cityhttps://www.linkedin.com/company/port-global2020LondonEnglandUnited KingdomClimate techSeedSeed2026-11-1016302466326049323
BALLASballas.bizhttps://www.ballas.bizhttps://www.linkedin.com/company/ballasxBALLAS manufactures commercial facilities, hotels, stores, offices, and houses.202251 to 100GinzaTokyoJapanManufacturing; Logistics and supply chainSeries BSeries B2026-11-1015817996490585218
Light Framelightframe.techhttps://www.lightframe.tech/https://www.linkedin.com/company/lightframe1Light Frame builds core banking and portfolio management technology for wealth managers.20241 to 10ProvidenceRhode IslandUnited StatesFintech; Software; SaaSSeedSeed2026-11-10510000068000002Half Court Ventures; ATX Venture Partners; New Stack Ventures; Rogue Venture Partners; Underdog Labs
Shanghai Peptide Biotechnologytaixin-bio.comhttps://www.taixin-bio.com/2015ShanghaiShanghaiChinaHealth care; ManufacturingSeedSeed2026-11-101400001400002
ZeroBoundary Aviation2025HefeiAnhuiChinaSeedAngel2026-11-101
Zhengyuan Quantum2026HardwareSeedAngel2026-11-101