Bucketwise Join waitlist

Learn / Portfolio

Roll rate analysis: how to read a roll-rate matrix

A roll rate is the share of loans in one bucket this month that are in another bucket next month. Put every bucket against every other and you get a matrix. It answers a simple question: are loans getting better or worse, and how fast?

How the matrix is built

Take the same loans at two month-ends. Rows are the bucket last month, columns are the bucket this month. Each cell is the share of that row that landed in that column. Each row adds up to 100%, once you include a 'closed' column for loans that paid off.

Illustrative month, 200 loans in 1-30 at the start
Moved to Current (cured)90 loans, 45%
Stayed in 1-3060 loans, 30%
Moved to 31-60 (rolled forward)50 loans, 25%

The 25% in the last line is the flow rate from 1-30 to 31-60. The 45% is the cure rate.

Why it is useful

Flow rates multiply. Suppose, for illustration, the rates are: Current to 1-30 is 4%, 1-30 to 31-60 is 25%, 31-60 to 61-90 is 50%, and 61-90 to 90+ is 70%. A loan that is current today ends up in 90+ four months later with probability 0.04 x 0.25 x 0.50 x 0.70 = 0.35%. That is a rough estimate of future bad loans from today's buckets, before any model.

If the 1-30 to 31-60 rate rises from 25% to 30%, you can see the effect on 90+ before it arrives.

Mistakes to avoid

How to read it in practice

Try it on your own tables

The free tools give you the prompt, the checks and how to present the result. You enter table names only.

See the free tools

Frequently asked questions

What is a roll rate in credit risk?

The share of loans (or balance) in one delinquency bucket that move to a worse bucket by the next month-end.

What is the difference between a roll rate and a flow rate?

Many teams use them as the same thing. Some reserve 'flow rate' for movement to the next worse bucket only, and 'roll rate' for any bucket-to-bucket movement. State which you mean.

How many months of data do I need?

At least six, and twelve is better. One month shows what happened. Several months show whether it is a pattern.

Keep reading