Markup vs Margin: Calculate a Selling Price Without Fooling Yourself

Markup and margin both describe gross profit, but they divide by different numbers. That is why a 25% markup does not produce a 25% margin.

Start with three amounts, all on the same tax basis:

• Cost (C): the defined cost of the item or service.
• Selling price (P): the amount charged before any separately treated tax.
• Gross profit (G): P − C.

Then choose the percentage you actually mean.

The two definitions

Markup measures gross profit against cost:

markup = (price − cost) ÷ cost

Gross margin measures gross profit against selling price:

margin = (price − cost) ÷ price

The numerator is the same. The denominator is not.

Example: 25% markup

If cost is 100 and markup is 25%:

price = 100 × (1 + 0.25) = 125

Gross profit is 25. Check the margin:

margin = 25 ÷ 125 = 20%

So:

Example: 25% target margin

To earn a 25% gross margin on a cost of 100, divide by the portion of the price left after margin:

price = cost ÷ (1 − margin)

price = 100 ÷ (1 − 0.25) = 133.333…

At a price rounded to 133.33, gross profit is 33.33 and the achieved margin is approximately 25%. Rounding makes the final decimal slightly different, so calculate on the actual charge.

Formula card

Use decimal percentages in calculations: 25% is 0.25.

A target margin must be below 100%. Dividing by zero at 100%, or a negative number above it, is a sign that the target cannot be produced by this cost-plus formula.

Convert markup and margin directly

If you know the markup:

margin = markup ÷ (1 + markup)

For 25% markup: 0.25 ÷ 1.25 = 0.20, or 20% margin.

If you know the target margin:

markup = margin ÷ (1 − margin)

For 25% margin: 0.25 ÷ 0.75 = 0.3333…, or about 33.33% markup.

These conversions are useful checks—but only when both calculations use the same cost and selling-price definitions.

Define “cost” before trusting the result

The supplier invoice may be only part of the cost to make the sale. Depending on the decision, relevant costs can include:

• inbound freight, duty and handling;
• packaging and delivery;
• card/payment or marketplace fees;
• sales commission;
• licences or cloud usage attached to the unit;
• expected installation/support/warranty effort;
• wastage, returns and bad debt; and
• a deliberate contribution to overhead.

Do not indiscriminately add everything to a unit. Decide with the business/accounting owner which costs are directly attributable, variable, fixed or separately recovered. Use a named field such as landed unit cost or variable service cost instead of an unexplained cost cell.

Gross margin is not net profit. Rent, salaries, financing, tax and other operating costs can consume it.

Keep tax treatment consistent

Compare cost and price on the same basis. If recoverable purchase tax is excluded from cost, calculate the selling price and margin before output tax, then add tax according to the organisation’s current rules. If tax is not recoverable, the cost treatment may differ.

Do not calculate margin from a tax-inclusive selling price against a tax-exclusive cost and call the result meaningful. Confirm the method with the accountant or responsible owner; this article does not determine it.

Discounts reduce margin faster than they look

Suppose cost is 100 and list price is 133.33, approximately a 25% margin. A 10% discount makes the actual price about 120.00:

133.33 × 0.90 ≈ 120.00

Gross profit is now about 20.00, so achieved margin is about:

20 ÷ 120 = 16.67%

The price fell 10%; gross profit fell roughly 40% from 33.33 to 20.00. Calculate on the actual net selling price after discounts/credits and include transaction-linked costs.

A simple spreadsheet layout

Use separate input and result cells:

Calculate achieved percentages again from the rounded price. Add validation so markup and margin cannot be entered simultaneously without an explicit method, and flag missing/zero/negative costs for review rather than hiding errors.

Price with a decision record, not a formula alone

Before approval, record:

• product/service and effective date;
• currency and rounding convention;
• named cost basis and source date;
• markup or margin method;
• discount/commission/payment assumptions;
• tax basis;
• achieved gross profit/markup/margin at the actual price;
• comparison with contractual/market constraints; and
• accountable approver.

The formula can prove its own arithmetic. It cannot prove that customers will buy, that the cost base is complete or that the price supports the business. Those are separate decisions—and making that separation visible is how you avoid fooling yourself.