Separate markup from margin before setting a selling price

Markup uses cost as its base; margin uses selling revenue as its base. Confusing the two can produce a selling price lower than the one you intended.

The examples here are hypothetical planning calculations, not recommended prices or tax advice. Keep the revenue and cost basis consistent, identify the period and currency, and ask an accountant about the treatment appropriate to your business.

Use one simple example

Suppose an item costs ₹600 under your chosen cost definition and sells for ₹1,000. The difference is ₹400.

Markup is ₹400 divided by ₹600, or about 66.67%. Margin is ₹400 divided by ₹1,000, or 40%.

Both describe the same ₹400 difference from different starting points. A 40% markup and a 40% margin are therefore not interchangeable.

Calculate the price from a markup

If you apply a 40% markup to the ₹600 cost, the calculation is ₹600 × 1.40 = ₹840.

The difference is then ₹240. As a share of the ₹840 selling price, that is about 28.57%, not 40%.

This is why a spreadsheet column labelled simply “percentage” is dangerous. Name the calculation and its base.

Calculate the price from a margin

To target a 40% margin on the same stated cost, divide cost by one minus the desired margin: ₹600 ÷ 0.60 = ₹1,000.

This calculation assumes the ₹600 contains the costs you intend to cover in that margin. It does not automatically account for costs you left out.

Do not use a target margin at or above 100% in this formula. The arithmetic no longer describes a normal positive-cost selling price.

Define the cost boundary

Write what the ₹600 includes: materials, purchased goods, production labour or another defined set. Different boundaries produce different interpretations.

If you exclude payment charges, packaging or shipping subsidy, the resulting difference is not the amount available after those costs.

For operational decisions, a separate contribution calculation can help. It subtracts the variable costs associated with the sale rather than treating every remaining rupee as final profit.

Keep taxes and discounts consistent

Do not compare a tax-inclusive selling amount with costs on an incompatible basis. Use the treatment appropriate to your records and obtain professional advice where needed.

Apply the calculation to the actual revenue after a discount, not the crossed-out price. In the example, selling at ₹900 instead of ₹1,000 leaves ₹300 against the same ₹600 cost, giving a 33.33% margin on that boundary.

The advertised percentage discount and the change in margin percentage are different quantities.

Account for percentage-based costs separately

Suppose a hypothetical variable charge is 3% of the selling amount. At ₹1,000 it is ₹30; at ₹900 it is ₹27.

If that charge was excluded from the ₹600, the remaining contribution becomes ₹370 or ₹273 respectively, before other excluded costs.

These are illustrative rates, not a provider tariff. Use the actual applicable fee and transaction base in your own sheet.

Label the result honestly

A product-level margin is not automatically net business profit. Rent, software, administration and other overhead may still need funding.

Likewise, money received is not proof that every cost has been paid or that cash is available for withdrawal.

Keep a column naming the result: gross spread under the defined cost, contribution after stated variable costs, or another clearly described measure. Avoid using profit as a loose label for all of them.

Check the spreadsheet with a known case

Enter the ₹600 and ₹1,000 example and confirm that it produces 66.67% markup and 40% margin. Then test the ₹840 price.

If the sheet reports the same percentage for markup and margin, inspect the denominator.

Use the distinction to make pricing conversations precise. You can choose a price for several business reasons, but the arithmetic should describe that choice correctly.

For broader handmade costing, see pricing handmade products. The essential first step is to know what your percentage is measuring before using it to make a decision.