Selling Price from Margin Calculator

The maths behind it

Selling price from a target margin is cost divided by one minus the margin. Written out: price = cost ÷ (1 − margin), with the margin as a decimal.

Division rather than multiplication, because the margin is a share of the price being solved for rather than of the known cost. This is the same pattern that governs reverse VAT, reverse payment fees and marketplace break-even pricing, anything expressed as a percentage of the unknown belongs in the denominator.

Putting numbers to it

Cost $28, target margin 55%. Price = 28 ÷ 0.45 = $62.22. Check: profit is $34.22 on $62.22, which is 55%.

The addition version gives 28 × 1.55 = $43.40, on which the margin is $15.40 ÷ $43.40 = 35.5%. Nearly twenty points of intended margin lost.

At a 70% target the divergence is worse still: the correct price is $93.33 and the addition version gives $47.60, which carries a 41% margin. The higher the target, the more damage the wrong operation does, which means the products a business most wants to protect are the ones the error hits hardest.

Where it is unreliable

It answers what price the margin requires, not what price the market supports. Where the two disagree, the calculation is telling you something about the cost base rather than about the price.

It is also only as good as the cost. Using an invoice price rather than a landed and fulfilled cost produces a price that appears to hit the target and misses it by whatever was excluded, commonly a third of the real cost on imported goods.

How to act on this

Use it as a floor and set the actual price from the market. Where the market pays more, the extra is captured value; where it pays less, either the cost has to change or the product does not belong in the range.

Build the calculation into a pricing sheet with landed cost as the input, so that a supplier price change automatically produces a new floor. Most catalogues drift out of margin because costs moved and prices did not, and the drift is invisible until someone recalculates by hand.

Setting the target margin itself

The formula takes the target as given, and choosing it is the harder question. Work backwards from what the price has to carry: contribution has to cover advertising, fulfilment, overheads and profit, all as shares of revenue.

If advertising runs at 18% of revenue, fulfilment at 12%, overheads at 10% and the target net margin is 12%, then 52 points of gross margin are spoken for before anything is left over. A 55% target leaves three points of slack, which is thin. A 65% target leaves thirteen, which is a business.

That calculation also shows when a product cannot work. If the market price implies a 45% gross margin against a cost structure needing 52%, no amount of pricing skill closes the gap: the answer is a cheaper cost base, a lower advertising dependency, or a different product.