Break-Even Analysis: Test the Assumptions

What does break-even sensitivity analysis tell you?

Break-even sensitivity analysis tests how the sales threshold changes when an assumed price or cost changes. Start with a defined offer and period. Calculate the threshold, then challenge the inputs and check whether the operation could deliver that volume. A calculated threshold is not evidence of demand. This is business education, not financial advice. Financial decisions belong with a licensed financial adviser.

The useful output is a question you can investigate. Which unsupported assumption makes the plan look workable? A spreadsheet can answer the arithmetic before the business has earned any confidence in its inputs.

What exactly is the calculation covering?

The U.S. Small Business Administration defines break-even as total revenue equalling total cost. Its single-product formula divides fixed costs by selling price per unit minus variable cost per unit.

Write the boundary above the calculation. Which offer? Which unit? Which period? Which costs are included? Our example uses one service package in one month. It is deliberately narrower than a complete financial forecast.

All figures below are fictional teaching inputs. They are not client results, market prices, recommended budgets or return projections. The model excludes tax, financing and investment spending. Its result covers only the named cost base. A qualified accountant should determine the scope and treatment needed for a real business.

Our proposed input record has an evidence field beside every figure. A checked contract, a recorded completed job and an unsupported planning estimate should remain visibly different. Mark an unknown as unknown. Do not fill it with the number that makes the answer attractive.

Can you reproduce the base case without a spreadsheet?

Assume the fictional service has $12,000 of monthly costs held constant across the volume being examined. Each completed package sells for $200 and incurs $80 of variable cost. Assume every package sold is completed within the month.

The contribution from one package is $200 minus $80, or $120. The threshold is $12,000 divided by $120, or 100 packages.

Check it from the other direction. At 100 packages, sales are $20,000. Variable costs are $8,000. Add the $12,000 constant cost layer and total costs are also $20,000. The difference is zero.

Now assume only 90 packages sell. Sales are $18,000 and variable costs are $7,200. After the same $12,000 cost layer, the model shows a $1,200 shortfall. That is a conditional calculation, not a prediction that 90 customers will buy.

Keep the shortfall visible beside the threshold. “We need 100” leaves out what happens if the evidence currently supports a smaller volume. The model has not solved that gap by naming it.

Which input changes the threshold most in this example?

Change one input at a time before combining changes. The following scenarios retain the base case except for the stated difference.

The first change lowers price by $20 and raises the threshold by 20 packages. The second adds $20 to unit cost with the same threshold effect. The third adds $3,000 to fixed cost and requires 25 more packages.

The combined case requires 50 more packages than the base case. It does not require 40 more. The two individual threshold changes cannot simply be added. Recalculate using the combined $80 contribution.

This is a sensitivity table, not a probability table. We have assigned no likelihood to any row. Calling the base row “expected” would claim evidence the example does not contain.

For a real review, record why each alternative deserves attention. A documented supplier quotation is different from an arbitrary stress. Both can be useful if labelled honestly. Neither should be quietly presented as an observed cost.

What if the threshold sits beyond delivery capacity?

Add another fictional constraint. Assume the current operation can complete no more than 110 packages in the month while meeting its stated requirements. That limit is an example input, not a productivity benchmark.

At the base price and cost, 110 packages produce $13,200 of contribution. Subtracting $12,000 leaves $1,200 within this simplified model. At the reduced price, the same 110 packages produce $11,000 of contribution and leave a $1,000 shortfall.

The reduced-price threshold is 120. The assumed operation can deliver 110. Writing 120 into a sales target does not close the ten-package gap.

Suppose a proposed capacity change would raise the fixed cost layer to $15,000. At the reduced price and unchanged $80 variable cost, the revised threshold becomes 150 packages. The earlier 120-package answer no longer describes that proposal.

This does not recommend hiring, outsourcing or buying equipment. It identifies what evidence the proposal needs. What capacity would the change actually provide? Which requirements must still pass? What costs would change besides the fixed layer? Keep those questions together before approving a commitment.

Which assumptions stop the simple model travelling too far?

ACCA's explanation of cost-volume-profit analysis describes important limits. The analysis assumes a single product or a constant sales mix. Its linear cost and revenue relationships apply only within a restricted activity range. Costs must be separated into fixed and variable components, with fixed costs constant within the relevant range.

Our practical response is to write a boundary beside each scenario. Name the offer, volume range and cost arrangement it represents. If a proposed change requires different premises, create another scenario instead of extending the old row.

With several offers, document the assumed mix. Do not replace different packages with an average whose composition the reader cannot reconstruct.

Pricing research answers a separate question: what buyers will accept under stated terms. Our pricing research guide deals with that evidence. A price that lowers the calculated threshold still needs a buyer.

What happens at zero or negative contribution?

Return to the fictional $12,000 fixed cost. If price and unit variable cost are both $80, each package contributes zero toward that cost. No finite number of identical packages covers it under these assumptions. Division by zero does not produce a useful sales target.

If price is $70 while variable cost stays $80, each package adds a $10 shortfall before fixed costs. At 100 packages, that shortfall is $1,000. Including the $12,000 fixed layer makes it $13,000.

Do not hide this case by displaying a negative break-even volume. Inspect the input definitions and the offer. More of the same transaction does not repair this particular arithmetic.

Does reaching break-even mean cash is available?

No. The SEC's financial-statement guide distinguishes profit from cash generation. Cash-flow reporting also includes investing and financing activity. This simplified operating model does not tell you what cash the bank account contains or when a payment can be made.

Keep a separate dated record of receipts and payments. Ask the finance owner to reconcile that record with the operating scenario. The accountant should resolve reporting treatment. Counsel should resolve contractual obligations. Investment and financing decisions need the appropriate licensed financial adviser.

What evidence should leave the review?

Our proposed review note contains five fields: the decision being considered, the base inputs, the scenario that changes the answer, the missing evidence and the person responsible for obtaining it.

A useful fictional conclusion would be: “At the reduced price, the threshold exceeds our assumed delivery limit. The next task is to verify capacity and the complete cost of changing it.” That is a research assignment. It is not approval to expand.

Preserve the original table when evidence arrives. Add a dated revision that identifies the changed input and its source. Someone else should be able to reconstruct why the answer moved. Retain rejected versions with the reason they were set aside. Our measurement playbook explains how to keep definitions and ownership visible.

This is the point of our working method. Make the assumption inspectable before the commitment becomes expensive. The model earns its place when it tells the team what to verify next.

Sources

• U.S. Small Business Administration: Break-even point, definition and single-product formula. Updated October 3, 2024. Read September 19, 2026.
• ACCA: Cost-volume-profit analysis, model assumptions. Read September 19, 2026.
• SEC: Beginners' guide to financial statements, cash and profit distinction. Updated February 6, 2017. Read September 19, 2026.