Open calculator ↗

Delinquency roll-rate forecast · Calculation guide

Follow one delinquent cohort through consecutive buckets with no new entrants, cures returning or balance changes.

Calculation guide

ending = balance × Π(roll/100)

Inputs

Starting delinquent balance

Example entry 100000.0 (in the selected currency).

Balance rolling forward (%)

Example entry 50.0 %. Allowed range 0 to 100.

Worked example

InputValue
Starting delinquent balance100,000

Consecutive delinquency stages

Balance rolling forward (%)
50%
40%
25%
ResultValue
Balance reaching final stage5,000

Interpreting the result

The ending balance reaches the last bucket only after every preceding transition.

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Starting delinquent balance100,000110,000Balance reaching final stage5,0005,500
Balance rolling forward (%) (row 1)50%55%Balance reaching final stage5,0005,500
Delinquency roll-rate forecast →

Sources