Skip to main content

Methodology

Refund Cash & Profit Impact Planner methodology

Separate refund cash timing, retained fees and recoverable product value.
Duc Nguyen X.By Duc Nguyen X.· Founder, Margin101Last reviewed: View update historyMethodology

Educational only: Business decision support, not accounting, tax or legal advice.

Privacy: Calculations run locally; Margin101 does not receive your commercial inputs.

Update policy: Reviewed when formulas or official dependencies change.

Scope: Market-neutral small-business planning using your own assumptions.

1. Formulas and units

Refunded Orders
refundedOrders = orders × refund rate

Where

orders
Orders (operational units)Source: Business record
refundRate
Refund rate (decimal rate)Source: Business record
refundedOrders
Refunded Orders (units)Source: Calculated output
Refund Cash Outflow
refundCashOutflow = refunded orders × revenue

Where

orders
Orders (operational units)Source: Business record
refundedOrders
Refunded Orders (units)Source: Calculated output
refundCashOutflow
Refund Cash Outflow (currency units, ex tax)Source: Calculated output
Recovered Fees
recoveredFees = refunded orders × fee × refundable share

Where

orders
Orders (operational units)Source: Business record
refundableFeeRate
Refundable fee share (decimal rate)Source: Business record
refundedOrders
Refunded Orders (units)Source: Calculated output
recoveredFees
Recovered Fees (currency units, ex tax)Source: Calculated output
Recovered Product Cost
recoveredProductCost = refunded orders × product cost × recovery share

Where

orders
Orders (operational units)Source: Business record
productCostPerOrder
Product cost (currency units, ex tax)Source: Business record
refundedOrders
Refunded Orders (units)Source: Calculated output
recoveredProductCost
Recovered Product Cost (currency units, ex tax)Source: Calculated output
Net Profit Impact
netProfitImpact = refund cash − recoveries + reverse logistics

Where

reverseLogisticsPerRefund
Reverse logistics (currency units, ex tax)Source: Business record
netProfitImpact
Net Profit Impact (currency units, ex tax)Source: Calculated output
Cash Exposure Before Recovery
cashExposureBeforeRecovery = refund cash + reverse logistics

Where

reverseLogisticsPerRefund
Reverse logistics (currency units, ex tax)Source: Business record
cashExposureBeforeRecovery
Cash Exposure Before Recovery (currency units, ex tax)Source: Calculated output
Cash Exposure Days
cashExposureDays = entered refund delay

Where

refundCashDelayDays
Refund cash delay (operational units)Source: Business record
cashExposureDays
Cash Exposure Days (days)Source: Calculated output

Money inputs and outputs use the currency selected in the scenario without changing the canonical methodology. Rates, margins, utilisation and buffers are entered as percentages and converted to decimal values for calculation.

2. Worked example

Input assumptions

The worked rows below come directly from the registered engine and visible default fixture.

Calculation and outputs

Example

The worked rows below come directly from the registered engine and visible default fixture.

Refunded Orders
80
Refund Cash Outflow
8,000 currency units
Recovered Fees
128 currency units
Recovered Product Cost
2,240 currency units
Net Profit Impact
6,272 currency units
Cash Exposure Before Recovery
8,640 currency units
Cash Exposure Days
7 days

The exact engine-derived outputs are shown in the labelled rows below.

Interpretation

Net refund profit impact separates the refund outflow from fee recovery, product recovery and reverse-logistics cost.

3. Validation and boundary checks

  • All values must be finite and inside the visible validation boundaries.
  • Rates are entered as percentages and calculations retain decimal precision.
  • Money uses one consistent ex-tax currency and planning period.

4. Assumptions and source classification

  • Provider fees, exchange rates, return behaviour and operating performance are user-entered scenarios.
  • No provider plan, jurisdiction, tax rate or market benchmark is embedded.
  • The engine retains full precision and display formatting never feeds back into calculation.

This planner has no current policy-data dependency. Its commercial assumptions are user supplied. Registered family-level regression suites exercise the shared business-logic engine and worked-result reconciliation.

5. Limitations

  • The model does not forecast demand, provider changes, exchange rates or operational performance.
  • It does not replace accounting, tax, legal or financial advice.

This is educational decision support, not tax, accounting, legal or financial advice. Check the treatment of your actual transactions under the rules that apply to your business and seek qualified advice where appropriate.

6. Update and evidence policy

Registered family-level suites test formula invariants and example reconciliation; the release ledger records that coverage without claiming a separate oracle for every line of public copy. There is no official threshold or benchmark to refresh for this planner. Commercial inputs remain user-supplied because they vary by business and contract.

Change history

  1. : Initial public release of the planner and methodology after pre-launch calculation, content, source and interaction review.

Related reading

Guides to interpret the decision and its assumptions.

Return to the planner