A Beginner-Friendly Break-Even Worksheet
Worked example: You charge $80 for a service that costs $30 to deliver. Each sale leaves $50 toward the month’s fixed costs. If those costs are $1,000, it takes 20 sales to cover them: $1,000 ÷ ($80 minus $30) = 20. At 19 sales you are $50 short. The twentieth covers the last $50; it is not $50 of profit.
Gather the numbers first
Choose one product or service and one time period, such as a month. Keep the units consistent. Write down the selling price per unit, the variable cost for each sale, and the fixed costs for that period. Variable costs change with the number of sales; fixed costs stay the same over the period you are analyzing, even if you make fewer sales.
Include costs that are easy to overlook: payment fees, packaging, delivery, materials, returns, and the time needed to fulfill an order. If you exclude your own labor, say so. The resulting break-even point will not show whether the business compensates you for that work. Avoid mixing a one-time startup purchase with monthly costs unless you state how you are treating it.
Use fixed costs ÷ (price per sale minus variable cost per sale) for a single product or service with positive contribution. If you can sell only whole units, round a fractional result up. For example, $1,010 divided by $50 is 20.2, so you need 21 sales. The SBA break-even resource provides more background.
Calculate contribution per sale
Subtract variable cost per unit from selling price per unit. The amount left is the contribution available to cover fixed costs. For example, if a service sells for $80 and its variable delivery costs are $30, the contribution is $50 per service. This does not mean $50 is profit; fixed expenses still need to be covered.
Then divide fixed costs for the period by contribution per unit. The SBA gives the break-even formula in units as fixed costs divided by selling price per unit minus variable cost per unit (SBA: Break-even point). In the example, with $1,000 in monthly fixed costs and $50 contribution per service, the result is 20 services for the month, before any costs omitted from the calculation.
Use a simple worksheet
- Product or service and time period: ______
- Price per unit: $______
- Variable cost per unit: $______
- Contribution per unit (price minus variable cost): $______
- Fixed costs in the period: $______
- Break-even units (fixed costs divided by contribution): ______
Check the result against capacity. Can you realistically deliver that many units in the chosen period? Can you reach enough customers? If the answer is no, the formula has not failed; it has shown that the assumptions need another look.
What if the result is zero or negative?
If price equals variable cost, each sale contributes nothing toward fixed costs. If variable cost is greater than price, each additional sale increases the shortfall under those assumptions. There is no positive sales volume that covers fixed costs until you change the price, reduce variable costs, change the offer, or reconsider the idea. Do not divide by zero or treat a negative contribution as a usable break-even number.
A zero or negative contribution is a prompt to investigate, not proof that a business can never work. Some costs may be misclassified, the offer may have several products, or a different service mix may change the result. Recalculate with clearly labeled assumptions rather than hiding the problem in an average.
Test a range instead of trusting one answer
Make a few versions of the worksheet with different prices, costs, or sales mixes. Label them as scenarios, not predictions. If a small change in the assumptions moves the break-even point sharply, that is a risk worth understanding before you spend. Compare the result with customer evidence and delivery capacity, then update the worksheet when actual costs become available.
For example, if variable delivery cost rises from $30 to $40 while price stays $80, contribution falls from $50 to $40. With $1,000 in fixed costs, the simple break-even estimate moves from 20 to 25 services. This is a sensitivity check, not a prediction that you will sell either quantity. It shows why measuring actual delivery costs matters.
The simple formula assumes one product or service and a consistent price and variable cost per unit. If you sell several items, calculate each one separately first; a blended break-even estimate depends on the sales mix, which may change. Do not hide that uncertainty in a single average.
Keep break-even separate from a financial plan
The break-even result says how many units cover the costs you included under those assumptions. It does not show whether customers will buy that quantity, whether you can deliver it, or whether cash will arrive before bills are due. It is also not a complete profit target if you have left out owner compensation, financing costs, taxes, or other relevant expenses. List exclusions beside the worksheet so a reader can see what the number does not include.
Use the result as a question for the next test: can you reach enough buyers, at this price, with these costs? If not, revisit the offer or assumptions instead of treating the calculated number as a sales goal. For a worked example focused on one digital product, see A Website Model That Makes Money. The SBA also offers broader startup-cost guidance; use a qualified bookkeeper or accountant when you need help deciding which costs belong in your own analysis.