Break-even Calculator
A lightweight web version of your Breakeven Worksheet - MASTER.xlsm. Enter assumptions below — outputs update instantly.
Data Input Area
Rent, salaries, utilities, insurance, etc.
Optional adjustments to fixed costs (adds to base).
Set target profit to build into breakeven table.
If set, replaces calculated GP%.
The step between rows in the results table.
Used for daily targets.
Key Outputs
Gross Profit %
—
Break-even Sales ($ / yr)
—
Monthly Break-even ($)
—
Weekly Break-even ($)
—
Daily Break-even ($)
—
Break-even Sales = (Base Fixed + "What If" Fixed) ÷ Gross Profit %
Results Table (Annual)
| Sales ($) | Fixed Costs ($) | Variable Costs ($) | Total Costs ($) | Profit ($) | Cumulative Profit ($) | Profit as % of Sales |
|---|
Variable Costs = (1 − GP%) × Sales. Total Costs = Fixed + Variable. Profit = Sales − Total Costs.