Ecommerce return cohort profitability calculator

Calculate net contribution by cohort and total net contribution with your own figures.

Your numbers

Use the units shown. Results update as you change valid inputs.

Choose the currency for these amounts. Changing it keeps your numbers and does not convert exchange rates.

Use net contribution by cohort and total net contribution to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Cohorts: name, sold units, returned units, original revenue $, refunds $, shipped item cost $, fees $, fulfillment $, return handling $, realized resale cash $
Q1,10,2,1000,200,500,40,50,20,60
Net contribution by cohort ($)
Q1: 250.00
Total net contribution ($)
$250.00
Sales less refunds plus realized resale cash ($)
$860.00
Returned units / sold units (%)
20
Contribution / those net cash receipts (%)
29.069767

Try another scenario

Cohorts: name, sold units, returned units, original revenue $, refunds $, shipped item cost $, fees $, fulfillment $, return handling $, realized resale cash $
Q1,10,1,1000,100,500,40,50,10,30
Net contribution by cohort ($)
Q1: 330.00
Total net contribution ($)
$330.00
Sales less refunds plus realized resale cash ($)
$930.00
Returned units / sold units (%)
10
Contribution / those net cash receipts (%)
35.483871
Calculation method

Calculation method

Net contribution by cohort ($)

Original revenue−refunds+realized resale cash−all shipped item cost−fees−fulfillment−return handling.

Total net contribution ($)

Sum signed cohort contributions.

Sales less refunds plus realized resale cash ($)

Sum original revenue−refunds+realized resale cash. Resale cash is actual supplied cash, not unsold inventory value.

Returned units / sold units (%)

Total returned/total sold×100; undefined at zero sold units.

Contribution / those net cash receipts (%)

Contribution/net receipts×100; undefined at zero net receipts.

Symbols and units
a
Cohorts: name, sold units, returned units, original revenue $, refunds $, shipped item cost $, fees $, fulfillment $, return handling $, realized resale cash $

Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.

Assumptions & limits

Assumptions & limits

  • A closed-record cohort cash/contribution illustration in one currency. Item costs cover all originally shipped units; only separately realized resale cash is added back. Tax, inventory valuation and causal return forecasts are excluded.
Are these inputs private?

These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.

Further reading

Google Merchant Center: product-data terminology and consistency background ↗

Background reading; this does not imply endorsement or independent review of SumFizz.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.