Small Business
Break-Even Calculator
Enter fixed costs, variable cost per unit and price to find the sales volume needed to break even.
- Delivery
- Instant download
- Purchase
- One-time payment
- Format
- Google Sheets
- Excel
- Updated
- August 2026
Break-even units
538/mo
- Fixed costs$4,200/mo
- Variable cost/unit$6.20
- Price/unit$14.00
Sample data preview of the Break-Even Calculator spreadsheet, shown for illustration only.
What this spreadsheet does
Without knowing the break-even point, it's hard to know if a sales target, price change or new cost is actually sustainable.
What you can do with it
- Find how many units must sell to cover costs
- Test how a price change shifts the break-even point
- Decide if a new fixed cost is sustainable at current sales
What's included
Sheet tabs
- Break-Even Summary
- What-If Comparison
Features
- Fixed cost and variable cost per unit inputs
- Automatic break-even unit and revenue calculation
- What-if comparison for different price points
- Simple break-even chart data
How it works
- 1Enter fixed costs and variable cost per unit
- 2Enter your selling price
- 3Review the break-even unit and revenue totals
Who it's for
Small business owners planning pricing, costs or a new product launch.
Frequently asked questions
What counts as a fixed cost versus a variable cost?
Fixed costs stay the same regardless of sales volume, like rent. Variable costs scale with each unit sold, like materials.
You might also need
Pricing & Profit Margin Calculator
Set a price from cost and target margin, or check margin on an existing price.
- Google Sheets
- Excel
Small Business Cash Flow Tracker
See money in, money out and projected balance by month.
- Google Sheets
- Excel
Inventory Tracker
Track stock levels, reorder points and inventory value.
- Google Sheets
- Excel
Small Business Quarterly Estimated Tax Tracker
Know what to set aside and pay the IRS each quarter, calculated from your income log.
- Google Sheets
- Excel