Act on the result
Use net refund profit impact and cash exposure before recovery to set the refund reserve or revise the return policy.
Educational only: Business decision support, not accounting, tax or legal advice.
Privacy: No account is required. Tool inputs and results stay in this browser. Anonymous categorical usage analytics send only governed page, tool, cluster and action identifiers; tool inputs and results are never sent. Error monitoring is disabled. Optional saved state stays only on this device.
Update policy: Reviewed when formulas or official dependencies change.
Scope: Market-neutral small-business planning using your own assumptions.
What this planner helps you decide
Best for
Ecommerce operators measuring how refunds affect cash and retained contribution.
Outputs
Refund cash outflow, recovered costs, net cash impact and contribution impact.
Start here
Enter refunds, recovery rates and timing from the same order cohort.
Use a different tool when: Do not use this to test period contribution after returns and recovery assumptions; use Returns Profit Impact Planner for that decision. Use this tool to plan refund cash exposure and recoverable value.
Commerce & operations
Refund Cash & Profit Impact: refund cash outflow
Refund cash outflow, recovered costs, net cash impact and contribution impact.
Amounts use the same currency as your inputs. No currency conversion is performed.
Refund Cash & Profit Impact
Separate refund cash timing, retained fees and recoverable product value.
Your numbers stay in this browser
Orders in the cohort.
Refundable order revenue. Enter the amount on one consistent ex-tax market-currency basis.
Refunded share.
Payment and platform fees. Enter the amount on one consistent ex-tax market-currency basis.
Fee share recovered.
Product cost per order. Enter the amount on one consistent ex-tax market-currency basis.
Product value recoverable after refund.
Return handling cost per refund. Enter the amount on one consistent ex-tax market-currency basis.
Days before recovery assumptions resolve.
Decision result
Each output is bound to its registered ecommerce engine formula.
- Refunded Orders
- 80
- Refund Cash Outflow
- 8,000.00
- Recovered Fees
- 128.00
- Recovered Product Cost
- 2,240.00
- Net refund profit impact
- 6,272.00
- Cash Exposure Before Recovery
- 8,640.00
- Cash Exposure Days
- 7 days
Scenario comparison
Each row names the assumption axis changed from the baseline.
ScenarioResultDifference
Current scenario6,272.00Baseline
Lower Refund rate5,488.00-784.00
Higher Refund rate7,056.00784.00
Save these results, change an input, then compare the updated figures with this baseline.
The baseline is temporary in this tab and is not added to shared scenario links or generated reports.
Calculation details
View calculation detailsView the formulas and inputs used for these results.
Refunded Orders
Refunded Orders
orders × refund rate80 unitsResult80
Reports units for the entered planning period using the declared ex-tax cost and revenue basis. The engine retains full precision; presentation rounding does not feed calculation.
Refund Cash & Profit Impact Planner formulas →Inputs used by these formula steps
- Refunded OrdersOrders
- 1,000
- Refunded OrdersRevenue Per Order
- 100
- Refunded OrdersRefund Rate
- 0.08
- Refunded OrdersFee Per Order
- 3.2
- Refunded OrdersRefundable Fee Rate
- 0.5
- Refunded OrdersProduct Cost Per Order
- 35
- Refunded OrdersRecoverable Product Cost Rate
- 0.8
- Refunded OrdersReverse Logistics Per Refund
- 8
- Refunded OrdersRefund Cash Delay Days
- 7
Refund Cash Outflow
Refund Cash Outflow
refunded orders × revenue8,000.00Result8,000.00
Reports money for the entered planning period using the declared ex-tax cost and revenue basis. The engine retains full precision; presentation rounding does not feed calculation.
Refund Cash & Profit Impact Planner formulas →Inputs used by these formula steps
- Refund Cash OutflowOrders
- 1,000
- Refund Cash OutflowRevenue Per Order
- 100
- Refund Cash OutflowRefund Rate
- 0.08
- Refund Cash OutflowFee Per Order
- 3.2
- Refund Cash OutflowRefundable Fee Rate
- 0.5
- Refund Cash OutflowProduct Cost Per Order
- 35
- Refund Cash OutflowRecoverable Product Cost Rate
- 0.8
- Refund Cash OutflowReverse Logistics Per Refund
- 8
- Refund Cash OutflowRefund Cash Delay Days
- 7
Recovered Fees
Recovered Fees
refunded orders × fee × refundable share128.00Result128.00
Reports money for the entered planning period using the declared ex-tax cost and revenue basis. The engine retains full precision; presentation rounding does not feed calculation.
Refund Cash & Profit Impact Planner formulas →Inputs used by these formula steps
- Recovered FeesOrders
- 1,000
- Recovered FeesRevenue Per Order
- 100
- Recovered FeesRefund Rate
- 0.08
- Recovered FeesFee Per Order
- 3.2
- Recovered FeesRefundable Fee Rate
- 0.5
- Recovered FeesProduct Cost Per Order
- 35
- Recovered FeesRecoverable Product Cost Rate
- 0.8
- Recovered FeesReverse Logistics Per Refund
- 8
- Recovered FeesRefund Cash Delay Days
- 7
Recovered Product Cost
Recovered Product Cost
refunded orders × product cost × recovery share2,240.00Result2,240.00
Reports money for the entered planning period using the declared ex-tax cost and revenue basis. The engine retains full precision; presentation rounding does not feed calculation.
Refund Cash & Profit Impact Planner formulas →Inputs used by these formula steps
- Recovered Product CostOrders
- 1,000
- Recovered Product CostRevenue Per Order
- 100
- Recovered Product CostRefund Rate
- 0.08
- Recovered Product CostFee Per Order
- 3.2
- Recovered Product CostRefundable Fee Rate
- 0.5
- Recovered Product CostProduct Cost Per Order
- 35
- Recovered Product CostRecoverable Product Cost Rate
- 0.8
- Recovered Product CostReverse Logistics Per Refund
- 8
- Recovered Product CostRefund Cash Delay Days
- 7
Net refund profit impact
Net Profit Impact
refund cash − recoveries + reverse logistics6,272.00Result6,272.00
Reports money for the entered planning period using the declared ex-tax cost and revenue basis. The engine retains full precision; presentation rounding does not feed calculation.
Refund Cash & Profit Impact Planner formulas →Inputs used by these formula steps
- Net Profit ImpactOrders
- 1,000
- Net Profit ImpactRevenue Per Order
- 100
- Net Profit ImpactRefund Rate
- 0.08
- Net Profit ImpactFee Per Order
- 3.2
- Net Profit ImpactRefundable Fee Rate
- 0.5
- Net Profit ImpactProduct Cost Per Order
- 35
- Net Profit ImpactRecoverable Product Cost Rate
- 0.8
- Net Profit ImpactReverse Logistics Per Refund
- 8
- Net Profit ImpactRefund Cash Delay Days
- 7
Cash Exposure Before Recovery
Cash Exposure Before Recovery
refund cash + reverse logistics8,640.00Result8,640.00
Reports money for the entered planning period using the declared ex-tax cost and revenue basis. The engine retains full precision; presentation rounding does not feed calculation.
Refund Cash & Profit Impact Planner formulas →Inputs used by these formula steps
- Cash Exposure Before RecoveryOrders
- 1,000
- Cash Exposure Before RecoveryRevenue Per Order
- 100
- Cash Exposure Before RecoveryRefund Rate
- 0.08
- Cash Exposure Before RecoveryFee Per Order
- 3.2
- Cash Exposure Before RecoveryRefundable Fee Rate
- 0.5
- Cash Exposure Before RecoveryProduct Cost Per Order
- 35
- Cash Exposure Before RecoveryRecoverable Product Cost Rate
- 0.8
- Cash Exposure Before RecoveryReverse Logistics Per Refund
- 8
- Cash Exposure Before RecoveryRefund Cash Delay Days
- 7
Cash Exposure Days
Cash Exposure Days
entered refund delay7 daysResult7 days
Reports days for the entered planning period using the declared ex-tax cost and revenue basis. The engine retains full precision; presentation rounding does not feed calculation.
Refund Cash & Profit Impact Planner formulas →Inputs used by these formula steps
- Cash Exposure DaysOrders
- 1,000
- Cash Exposure DaysRevenue Per Order
- 100
- Cash Exposure DaysRefund Rate
- 0.08
- Cash Exposure DaysFee Per Order
- 3.2
- Cash Exposure DaysRefundable Fee Rate
- 0.5
- Cash Exposure DaysProduct Cost Per Order
- 35
- Cash Exposure DaysRecoverable Product Cost Rate
- 0.8
- Cash Exposure DaysReverse Logistics Per Refund
- 8
- Cash Exposure DaysRefund Cash Delay Days
- 7
Inputs used
- Orders
- 1,000
- Revenue per order
- 100.00
- Refund rate
- 8%
- Fee per order
- 3.20
- Refundable fee share
- 50%
- Product cost
- 35.00
- Recoverable product cost share
- 80%
- Reverse logistics
- 8.00
- Refund cash delay
- 7
Open this calculator with preset values
This calculator supports documented, shareable scenario URLs. Compatible assistants and applications can construct links using the parameters below.
Scenario links contain only allowlisted numeric and closed-choice inputs shown in the URL; Margin101 excludes free text and identifying fields. Anyone you share the URL with can read those numbers, so do not include private or identifying data.
| Parameter | Meaning | Unit | Allowed values | Presence | Default |
|---|---|---|---|---|---|
| feePerOrder | Payment and platform fees. Enter the amount on one consistent ex-tax market-currency basis. | currency units/order, ex tax | 0 to 100000000 | Required | 3.2 |
| orders | Orders in the cohort. | whole orders/planning period | 0 to 100000000 | Required | 1000 |
| productCostPerOrder | Product cost per order. Enter the amount on one consistent ex-tax market-currency basis. | currency units/event, ex tax | 0 to 100000000 | Required | 35 |
| recoverableProductCostRate | Product value recoverable after refund. | proportion of returned product cost recovered | 0 to 1 | Required | 0.8 |
| refundableFeeRate | Fee share recovered. | proportion of provider fees refunded | 0 to 1 | Required | 0.5 |
| refundCashDelayDays | Days before recovery assumptions resolve. | days | 0 to 3650 | Required | 7 |
| refundRate | Refunded share. | proportion of orders refunded | 0 to 1 | Required | 0.08 |
| revenuePerOrder | Refundable order revenue. Enter the amount on one consistent ex-tax market-currency basis. | currency units/order, ex tax | 0 to 100000000 | Required | 100 |
| reverseLogisticsPerRefund | Return handling cost per refund. Enter the amount on one consistent ex-tax market-currency basis. | currency units/refund, ex tax | 0 to 100000000 | Required | 8 |
Refund Cash & Profit Impact: refund cash outflow
Net refund profit impact separates the refund outflow from fee recovery, product recovery and reverse-logistics cost.
Formula summary
- Primary formula
- net impact = refund cash − recovered fees − recovered product cost + reverse logistics
Data used here
- The estimate uses your inputs and the general business formula documented in the methodology.
Decision checks
Stress-test the decision
Retest refund rate as a percentage of the order cohort and recoverable product cost share as a percentage of refunded product cost.
When this estimate can be misleading
- All provider fees, exchange rates, returns, demand and operating rates are user-entered scenarios.
- Use one consistent ex-tax currency and planning period across compared inputs.
- This is educational business decision support, not accounting, tax, legal or financial advice.
- Net refund profit impact separates the refund outflow from fee recovery, product recovery and reverse-logistics cost.
Educational estimate, not advice. See all assumptions & limitations →
Related reading
Guides to interpret the decision and its assumptions.
- Refund Guarantees and Course Economics
Separate refund cash timing from contribution impact and capacity before changing a course guarantee.
Read guide
Frequently asked questions
How do I plan refund cash exposure and recoverable value?
Use net refund profit impact and cash exposure before recovery to set the refund reserve or revise the return policy.
Which planning assumptions should I stress-test?
Compare a plausible alternative scenario and verify the decision-critical assumption that changes the plan most.