Break-Even With Target Profit Calculator

See how many units you must sell to cover fixed costs and still take home the profit you are targeting.

How it is calculated

Contribution margin per unit is price − variable cost. The profit target you type is after tax, so the tool first converts it into the pre-tax profit that must be earned: pre-tax target = target ÷ (1 − tax rate ÷ 100). Required units are (fixed costs + pre-tax target) ÷ contribution margin, rounded up to whole units, and required revenue is the unrounded units times the price. Plain break-even units are fixed costs ÷ contribution margin. The margin of safety compares your planned units with the required units, not with plain break-even: (planned − required) ÷ planned × 100, and it is 0 when planned units are 0. If price does not exceed variable cost, or the tax rate is 100% or more, there is no result.

Worked example

Fixed costs are 60000, the price is 40 and variable cost per unit is 25, so the margin per unit is $15.00. The owner wants 30000 after a tax rate of 25%: 30000 ÷ 0.75 = $40,000.00 before tax. Required units = (60000 + 40000) ÷ 15 = 6,666.7, rounded up to 6,667, and required revenue is $266,666.67. Plain break-even is 60000 ÷ 15 = 4,000 units. With 7000 planned units, the margin of safety is (7000 − 6666.7) ÷ 7000 = 4.76%.

Try this example →

Common mistakes

  • Entering a pre-tax profit target: the field is after-tax, and the tool grosses it up, so typing a pre-tax figure overstates the units needed.
  • Entering the tax rate as a fraction (0.25) instead of a percentage (25): 0.25% hardly changes the target, so the answer looks too optimistic.
  • Putting total cost per unit (including a share of fixed costs) in the variable-cost field; that double-counts fixed costs.
  • Reading the margin of safety as a distance above plain break-even: here it measures planned sales against the units needed for the profit target, so it can be negative even when you are above break-even.
  • Entering a variable cost equal to or above the price: there is no contribution margin and no result.

Sources

About this calculator

Standard break-even analysis finds where revenue covers costs exactly; this variant extends the formula to find the sales volume needed to also clear a specific profit target: Target Units = (Fixed Costs + Target Profit divided by (1 - Tax Rate)), divided by Contribution Margin per Unit, where contribution margin is price minus variable cost per unit. Dividing the after-tax target by (1 - tax rate) grosses it back up to the pre-tax profit the business actually needs to earn.

Business owners and finance teams use this to answer a more useful question than plain break-even: not just how many units keep them from losing money, but how many units get them to the profit they actually need this quarter. The margin of safety — how far your planned sales sit above the units needed to reach the profit target — comes along with it, showing how far sales could fall before the target is missed.

Was this helpful?

You can pick up to 3 reactions.

Comments

  • Be the first to comment.

Popular calculators

All Calculators