Three months into my first business, I was celebrating a great sales week when my accountant asked me a question that shut me up: "Do you know how many coffees you actually need to sell before you make a single cent?" I didn't. I was profitable in my head, broke in my bank account, and completely clueless about my break-even point. That conversation cost me a bit of pride and saved me from closing down six months later.
Figuring out how to calculate break even point for new business isn't some fancy finance exercise reserved for MBA grads. It's the difference between guessing and knowing. And when you're new, guessing is expensive.
Key Takeaways
- Break-even point (BEP) is where total costs equal total revenue — you're not losing money, but you're not making any either
- The core formula: Fixed Costs ÷ (Price per unit − Variable Cost per unit)
- You need two versions: BEP in units and BEP in sales value (revenue)
- For startups, the hardest part isn't the math — it's estimating costs you've never actually paid before
- Converting your BEP into a timeline ("I break even in month 7") matters more than the raw number
- The formula assumes constant margins, which is almost never true in your first year
What break-even point actually means for a brand new business
Break-even point is the moment your total revenue covers your total costs. Not a profit. Not a loss. Zero. The exact number of sales where the business stops bleeding and starts standing still.
Sounds underwhelming, right? But here's why it matters so much when you're starting out: it tells you the minimum you have to achieve just to survive. Investors want to see it. Your bank wants to see it. And honestly, you need to see it so you stop lying to yourself about how things are going.
The two flavors: BEP in units and BEP in sales value
Most articles throw one formula at you and call it a day. In practice, you need both versions.
BEP in units tells you how many products or services you must sell. Useful when you sell one clear thing — a course, a coffee, a widget.
BEP in sales value tells you the revenue you need to hit. Useful when you sell a mix of things at different prices, which is most new businesses.
I track both. Every month. It takes me 10 minutes in a spreadsheet I built three years ago and have been refining ever since.
What is the basic BEP formula?
The standard break-even formula is:
BEP (in units) = Fixed Costs ÷ (Selling Price per Unit − Variable Cost per Unit)
That denominator — price minus variable cost — is called the contribution margin. It's what each sale contributes toward covering your fixed costs.
For BEP in sales value, you use:
BEP (in revenue) = Fixed Costs ÷ Contribution Margin Ratio
Where the contribution margin ratio is (Price − Variable Cost) ÷ Price.
That's it. No hidden trick. But the formula is only as good as the numbers you feed it — and for a new business, those numbers are mostly educated guesses.
Fixed costs vs variable costs: the distinction that trips everyone up
Fixed costs don't change with sales volume. Rent. Software subscriptions. Insurance. Your accountant's retainer. The annoying-but-necessary stuff.
Variable costs scale with each sale. Raw materials, payment processing fees, shipping, per-project contractor payments.
The gray zone is where beginners get stuck. Is a part-time employee fixed or variable? Depends — if you need them regardless of sales, they're fixed. If you only bring them in when orders pile up, they're variable. I've seen founders argue about this for hours. Just pick the most accurate characterization and move on.
A full worked example for a new business
Let's use a real scenario — a small online ceramics studio I helped a friend set up last year. Numbers rounded for clarity.
Fixed costs (monthly):
- Studio rent: $800
- Website and shop platform: $40
- Insurance: $60
- Tools and equipment depreciation: $100
- Accounting software: $25
Total fixed costs: $1,025 per month.
Per-unit economics:
- Selling price per mug: $45
- Clay, glaze, packaging: $12
- Payment processing (roughly 3%): $1.35
- Shipping materials: $2
Variable cost per mug: $15.35. Contribution margin: $45 − $15.35 = $29.65.
BEP in units: $1,025 ÷ $29.65 = 34.6 mugs per month. Round up to 35.
BEP in revenue: 35 × $45 = $1,575 in monthly sales.
When she saw that number, she laughed. "I can sell 35 mugs." Then she actually tried. Month one: 12 mugs. Month two: 21. Month four: 38. She crossed her break-even line around week 16. Not because the math was wrong — because life takes longer than the spreadsheet says.
Why the raw number is useless without a timeline
The BEP formula spits out a quantity. What you actually need is a date. That means layering in your sales velocity.
If you expect to sell 8 mugs a week, at 35 mugs to break even you reach the threshold in about 4.5 weeks. If you expect 4 a week, it's closer to 9 weeks. Same formula, wildly different cash-flow implications.
For a new business, this is the number that keeps you up at night — not "how many units" but "how many months of runway before I hit them?"
How to calculate break even point for new business in Excel
Excel isn't fancy, but it's honest. Here's the layout that's worked for me across three businesses.
| Cell | Label | Value / Formula |
|---|---|---|
| A1 | Fixed Costs (monthly) | 1025 |
| A2 | Selling Price per Unit | 45 |
| A3 | Variable Cost per Unit | 15.35 |
| A4 | Contribution Margin | =A2-A3 |
| A5 | Contribution Margin Ratio | =A4/A2 |
| A6 | BEP in Units | =A1/A4 |
| A7 | BEP in Revenue | =A1/A5 |
Two things I always add beyond the basics:
- A row for actual units sold this month, so I can see instantly whether I'm above or below the line
- A chart plotting cumulative revenue against cumulative costs — the intersection is your BEP, visually
That intersection point on a chart taught me more about my business than any paragraph of theory ever did. When I first saw it, I realized my "great month" was still under the line.
Common Excel mistakes I made so you don't have to
Mixing annual fixed costs with monthly sales figures. Trust me, I did this for two months straight. Divide everything into the same time unit.
Forgetting that variable costs shift at scale. If you buy clay in bulk, that $12 per mug might drop to $9 at 100 units. The formula doesn't automatically know that.
Treating your own labor as free. If you quit your job to do this, your time is a cost. Ignoring it makes your BEP look prettier than it is.
The startup-specific problems nobody warns you about
Here's the thing that genuinely frustrated me when I started: the break-even formula was designed for existing businesses with historical data. New businesses have none.
You don't know your real fixed costs yet. Your rent might go up. Your software stack will grow. You'll hire someone sooner than planned.
You don't know your price elasticity. You set a price, then discover customers want to pay less — or more.
And you have no sales history, so any volume assumption is a guess dressed up as a plan.
This is where most BEP tutorials fall apart. They give you a clean formula and pretend the inputs fall from the sky. They don't.
How to handle unstable startup numbers
Run three scenarios. Conservative, expected, optimistic. Different cost and price assumptions in each.
If your conservative scenario breaks even in 18 months and your optimistic one in 4, you know your range of reality. That's more useful than one "precise" number that's wrong anyway.
I also rebuild my BEP every quarter during the first two years. Costs stabilize, prices adjust, and the picture sharpens. A BEP calculated in January is stale by June.
Common questions about break-even for new businesses
What is the difference between BEP in units and BEP in sales value?
BEP in units counts physical sales — how many items. BEP in sales value converts that into revenue — how much money. Same underlying concept, two different lenses.
Use units when you sell one product at one price. Use sales value when you sell multiple things at different prices, because a blended revenue target is easier to act on than a mixed unit count.
Does break-even include my own salary?
It should, if the business is meant to support you. Many tutorials exclude founder pay, which makes the BEP look artificially low.
When I first included my own salary in the fixed costs — a modest $2,000 a month — my break-even number nearly doubled. Painful to see. Necessary to know.
What are the limits of the break-even formula?
The formula assumes constant selling prices and constant variable costs. In reality, both shift — discounts, bulk buying, seasonal demand.
It also ignores cash-flow timing. You might be "profitable" on paper while waiting 60 days for a client to pay. That's why cash-flow forecasting sits alongside your BEP, not behind it.
And it assumes you sell everything you make. Inventory sitting in a warehouse is a cost, not a sale.
What to do with your break-even number
Don't calculate it and file it away. Use it.
Track actual sales against the BEP line weekly. Adjust your pricing when the margin looks too thin. Cut fixed costs ruthlessly in the first year — every dollar you shave off that number moves the break-even point closer.
The number isn't the point. The number is the map. What actually keeps a new business alive is knowing where the cliff is, so you don't walk off it while admiring the view.
