Search Ctrl K
Home / Tools
THE FEUTEX TOOLKIT

Receivables Aging Loss Scenario

Apply user-defined loss assumptions to three aging buckets for a planning estimate.

Finance workspace● Runs in your browser
01 Your input
02 Your result
View or copy raw result data
FormulaGross receivables = v.current+v.late+v.old ; Estimated loss = v.current*v.current_loss/100+v.late*v.late_loss/100+v.old*v.old_loss/100 ; Net expected collection = v.current*(1-v.current_loss/100)+v.late*(1-v.late_loss/100)+v.old*(1-v.old_loss/100)
Sources and model references

Worked example

Inputs

Current
100000 currency
Late
30000 currency
Old
10000 currency
Current loss
1 %
Late loss
10 %
Old loss
50 %

Expected results

Gross receivables
140000 currency
Estimated loss
9000 currency
Net expected collection
131000 currency

Load the example in the workspace to reproduce these results. Display rounding does not change the underlying calculation.

How to use this tool

  1. Enter your own assumptions using a consistent currency and period.
  2. Review the scenario outputs and compare alternative inputs.
  3. Check the stated model limits before using the result in an operating plan.

Try this example

{
  "current": 100000,
  "late": 30000,
  "old": 10000,
  "current_loss": 1,
  "late_loss": 10,
  "old_loss": 50
}

Accuracy and scope

User-defined planning losses, not a financial-reporting or regulatory impairment calculation.

Is my data uploaded?

This tool runs locally in your browser. Input and output are not sent to a processing server. Copy or download your result before leaving the page.