Most small businesses don’t fail because the product is bad. They fail because the cash runs out before the sales catch up. A break even calculator helps you see that gap early, showing the exact point where your revenue covers every dollar of cost and the first dollar of profit begins.
Knowing that number protects your cash in practical ways. You can price a new product with confidence, decide whether a lease or a hire makes sense, and spot a launch that needs more runway than you have. Guessing is expensive. A clear target is not.
The good news is that the math takes seconds. A calculator handles the arithmetic once you enter your fixed costs, variable costs, and selling price. Below, we walk through the simple formula, work through unit-based examples, and show how to build your own version in Excel. We also look beyond break-even to ask what your profits could become when you put them to work over time.
How Do You Calculate Break-Even? The Simple Formula
The core formula is fixed costs ÷ contribution margin per unit. Contribution margin is your price per unit minus your variable cost per unit. Our Break-Even Calculator runs this math for you, but it helps to understand it first.
Key Terms
- Fixed costs: expenses that stay flat, such as rent, insurance, and salaries.
- Variable costs: expenses that rise with each unit, such as materials and shipping.
- Price per unit: what a customer pays you for one item.
Worked Example
Say fixed costs are $6,000 a month, you sell a candle for $20, and it costs $8 to make. The contribution margin is $12. Divide $6,000 by $12 and you get 500 units. At $20 each, that is $10,000 in revenue.
Common Input Mistakes
- Leaving out per-unit costs like packaging or payment fees.
- Treating a semi-variable cost as fully fixed.
- Using list price instead of the price after discounts.
- Mixing monthly and yearly figures.
How Many Units Do You Need to Sell to Break Even?
Once you have your unit number, turn it into a target you can track. Divide it by the months you plan to operate. If you need 1,200 units to cover costs this year, that’s 100 a month, or about 25 a week.
Units versus revenue
Break-even in units shows volume. Break-even in revenue shows dollars, and you get it by multiplying units by your selling price. Units suit a single product, while revenue works better when you sell a mix.
Test price changes and cost increases
Rerun your numbers with a higher supplier cost or a $2 discount. A small change in what each unit contributes can move your target more than you’d expect.
The margin versus markup trap
Markup is a percentage of cost, while margin is a percentage of price. A 50% markup produces only a 33% margin, so mixing them up can leave you underpriced. Read more about markup in business, then check your profit margin before locking in a price.
Break-Even Calculator in Excel, Online, and Beyond
Is there a break-even formula in Excel?
Yes, though Excel has no dedicated function for it. The math is one division, so a simple cell formula does the job.
Build a simple sheet with three inputs
- B1: total fixed costs
- B2: price per unit
- B3: variable cost per unit
In B4, enter =B1/(B2-B3) to get break-even units. Multiply that by B2 for break-even revenue. Change any input and the answer updates instantly.
When an online calculator is faster
If you only need a quick answer, a break even calculator saves you from building anything. It also helps when you want to test a few prices side by side. Just remember that late-paying customers change your numbers, so it’s worth understanding what it costs to collect before you trust a result.
UK, crypto and other special cases
UK sellers should keep VAT out of the price input, since it isn’t revenue you keep. For crypto, include trading fees on both the buy and the sell side, and check how your local tax rules treat gains.
Beyond Break-Even: What Will $50,000 Be Worth in 20 Years?
Reaching break-even tells you when a venture stops losing money. It doesn’t tell you what your profit will be worth later. That’s where the time value of money comes in: a dollar today can be invested, while a dollar years from now is worth less in practice.
Illustrative Growth Examples
These figures use assumed, constant annual returns, not predictions:
- 4% a year: $50,000 grows to roughly $109,600 after 20 years.
- 6% a year: about $160,400.
Inflation Changes the Picture
Rising prices reduce what each dollar buys. If inflation averaged an assumed 3% annually, $50,000 in 20 years would have the purchasing power of only about $27,700 today.
Tie Profit Goals to Long-Term Plans
Once you pass break-even, decide where profit goes. Maybe it funds equipment, or a property project where gutter installation costs need budgeting. Setting targets in future-adjusted terms keeps your plan realistic.
Put Your Numbers to Work Before You Spend a Dollar
Every good decision about pricing or launching starts with three things: your real costs, your selling price, and the number of units it takes to cover both. Once you know them, a break even calculator turns guesswork into a clear target you can plan around.
Before you commit money, run a few scenarios. Nudge the price, trim a cost, and see how the target moves. Start today: gather your figures, enter them, and let the results guide your next move.
Frequently Asked Questions
How do you calculate break-even?
Divide your total fixed costs by the contribution margin per unit, which is the selling price minus the variable cost per unit. The result is the number of units you must sell to cover all costs. Multiply by price to find break-even revenue. A break even calculator automates these steps.
Is there a break-even formula in Excel?
Excel has no single built-in break-even function, but you can build one with a simple formula. Enter fixed costs in one cell, price and variable cost in others, then use =FixedCosts/(Price-VariableCost). Goal Seek can also find the sales volume where profit equals zero.
How much will $50,000 be worth in 20 years?
It depends on the rate of return or inflation. At a 7% average annual return, $50,000 grows to about $193,000 in 20 years. At 5%, it reaches roughly $132,700. If inflation averages 3%, $50,000 would have the buying power of only about $27,700 in today's dollars.
How to figure out how to break-even?
Start by listing fixed costs, such as rent and salaries, and variable costs per unit, such as materials. Compare your price to the variable cost to see the margin per unit. Then divide fixed costs by that margin. To reach break-even sooner, raise prices, cut costs, or increase sales volume.
