Open calculator ↗

Receivable aging collection scenario · Calculation guide

Enter each mutually exclusive aging bucket once with its expected collection percentage over one common horizon.

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 balanceExpected collection rate
80095%
30060%
ResultValue
Expected collections940
Expected balance uncollected160

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Bucket receivable balance (row 1)800880Expected collections9401,016
Expected collection rate (row 1)95%85%Expected collections940860
Receivable aging collection scenario →

Sources