Calculation guide
The sum is probability-weighted cash.
Expected collections = Σ bucket balance × expected collection percentage
Inputs
Bucket receivable balance
Example entry 500 (in the selected currency).
Expected collection rate
Example entry 90 %. Allowed range 0 to 100.
Worked example
Aging buckets in increasing age order
| Bucket receivable balance | Expected collection rate |
|---|---|
| 800 | 95% |
| 300 | 60% |
| Result | Value |
|---|---|
| Expected collections | 940 |
| Expected balance uncollected | 160 |
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Bucket receivable balance (row 1) | 800 | 880 | Expected collections | 940 | 1,016 |
| Expected collection rate (row 1) | 95% | 85% | Expected collections | 940 | 860 |
