Return Rate Impact on Margin Calculator

Understanding the return rate margin calculator — concept and principle

Returns quietly eat into ecommerce profit. A product that looks healthy at a 64% gross margin can earn much less once refunds, return shipping, handling and unsellable items are counted. This calculator estimates the profit per order shipped and the net margin after returns, so you can see how much a given return rate really costs and how much it is worth reducing.

How it is calculated

Let P be the price, C the product cost, R the return rate, H the cost per return and S the share of returned items that can be resold. Per order shipped:

• Profit = (P − C) − R × (P − C) − R × H − R × (1 − S) × C
• Net margin after returns = profit ÷ P × 100
• Margin with no returns = (P − C) ÷ P × 100

The calculator shows USD by default but works with any currency.

The principle

Each term is an expected value across all orders. On a returned order you refund the price but get the item back, so you lose the margin P − C. Every return also costs handling and shipping H. Returned items that cannot be resold are written off, losing their cost C as well. Multiplying each loss by the probability that it happens (R, and R × (1 − S)) and subtracting from the normal margin gives the average profit per order. The margin is then expressed against the full price of every order shipped.

Worked example

1. Inputs: price $50, cost $18, return rate 15%, cost per return $9, 70% resellable.
2. Margin with no returns: 50 − 18 = $32, which is 32 ÷ 50 = 64%.
3. Lost margin on returns: 0.15 × 32 = $4.80.
4. Return handling: 0.15 × 9 = $1.35.
5. Write-offs: 0.15 × 0.30 × 18 = $0.81.
6. Profit per order: 32 − 4.80 − 1.35 − 0.81 = $25.04.
7. Net margin: 25.04 ÷ 50 = 50.08%.

How to read the result

The gap between the two margins, here about 14 percentage points, is what returns cost you. Use it to decide whether better sizing guides, photos, packaging or quality checks are worth the investment: lowering the return rate from 15% to 10% here raises profit per order by about $2.32. If net margin approaches the costs this calculator leaves out (advertising, outbound shipping, payment fees), the product may not be profitable.

Common mistakes

• Treating returned orders as lost revenue only, without the handling cost.
• Assuming every returned item can be resold at full price.
• Comparing net margin after returns with a gross margin that includes different costs.

Frequently asked questions

What is a typical ecommerce return rate?

It varies widely by category. Clothing and footwear usually see much higher rates than electronics accessories or consumables, so use your own data.

Why is margin divided by the price of all orders?

The result is per order shipped, so it shows what each order you send out earns on average.

Should I charge for returns?

A fee lowers H and may discourage some returns, but it can also reduce conversion. Test the effect on both.

Sources: C. T. Horngren, S. M. Datar and M. V. Rajan, Cost Accounting: A Managerial Emphasis, Pearson