Formula
Total delinquency rate (30+ days) = (Balance 30 to 59 + Balance 60 to 89 + Balance 90+) ÷ Total outstanding balance. Each bucket rate = that bucket's balance ÷ Total outstanding balance.
Delinquent by count = (Count 30 to 59 + Count 60 to 89 + Count 90+) ÷ Number of active loans or advances.
Roll rate 30 → 60 days = Balance 60 to 89 days this month ÷ Last month's 30 to 59 day balance.
Annual net charge-off rate = Net charge-offs in the last 12 months ÷ Total outstanding balance.
Worked examples
Example 1: default inputs, an $8 million book with 10.9 percent delinquent
Inputs: Total outstanding balance $8,000,000, 640 active loans or advances, Balance 30 to 59 days $420,000 with 38 accounts, Balance 60 to 89 days $190,000 with 16 accounts, Balance 90+ days $260,000 with 21 accounts, Net charge-offs in the last 12 months $520,000, Last month's 30 to 59 day balance $380,000. Delinquent balance = 420,000 + 190,000 + 260,000 = $870,000. Total delinquency rate = 870,000 ÷ 8,000,000 = 10.88%, flagged because it is above 8 percent. Bucket rates: 30 to 59 days = 420,000 ÷ 8,000,000 = 5.25%; 60 to 89 = 190,000 ÷ 8,000,000 = 2.38%; 90+ = 260,000 ÷ 8,000,000 = 3.25%, flagged because non-performing balances exceed 3 percent. Delinquent by count = (38 + 16 + 21) ÷ 640 = 75 ÷ 640 = 11.7%. Roll rate = 190,000 ÷ 380,000 = 50%, meaning half of last month's 30-day balance moved to the 60-day bucket rather than curing. Annual net charge-off rate = 520,000 ÷ 8,000,000 = 6.50%. The bars chart shows the 90-plus bucket highlighted; at $260,000 it is the balance most likely to be the next quarter's charge-offs, and with a 50 percent roll from 30 to 60, the pipeline behind it is full.
Example 2: a smaller book in better shape
Inputs: total $2,000,000, 400 accounts, 30 to 59 days $60,000 and 14 accounts, 60 to 89 days $30,000 and 6 accounts, 90+ days $40,000 and 7 accounts, net charge-offs $90,000, last month's 30-day balance $75,000. Delinquent balance = 60,000 + 30,000 + 40,000 = $130,000; total rate = 130,000 ÷ 2,000,000 = 6.50%. Buckets: 3.00%, 1.50%, 2.00%. By count = 27 ÷ 400 = 6.8%. Roll rate = 30,000 ÷ 75,000 = 40%. Annual net charge-off rate = 90,000 ÷ 2,000,000 = 4.50%. Nothing is flagged: total delinquency is under 8 percent and non-performing balances under 3 percent. The roll rate is the figure to improve. Forty percent of early delinquencies migrating to 60 days is a collections problem as much as a credit one; a funder that reaches a merchant in the first week of a missed debit and restructures or re-dates typically rolls a smaller share. Delinquency by count, 6.8 percent, is close to the balance figure of 6.5 percent, which indicates that delinquent accounts are of average size rather than concentrated in a few large exposures.
Example 3: a stressed book where large accounts are failing
Inputs: total $15,000,000, 900 accounts, 30 to 59 days $900,000 and 40 accounts, 60 to 89 days $600,000 and 25 accounts, 90+ days $1,100,000 and 35 accounts, net charge-offs $1,400,000, last month's 30-day balance $800,000. Delinquent balance = 900,000 + 600,000 + 1,100,000 = $2,600,000; total rate = 17.33%, flagged. Buckets: 6.00%, 4.00%, and 90+ = 7.33%, flagged. By count = 100 ÷ 900 = 11.1%. Roll rate = 600,000 ÷ 800,000 = 75%. Annual net charge-off rate = 1,400,000 ÷ 15,000,000 = 9.33%. Two features mark this as a deteriorating book rather than a seasonally noisy one. First, delinquency by balance, 17.3 percent, is far above delinquency by count, 11.1 percent: the average delinquent account is $26,000 against an average account of $16,667, so the larger exposures are the ones failing. Second, the roll rate of 75 percent means three quarters of early delinquencies are migrating rather than curing, so the $900,000 in the 30-day bucket today is on course to add roughly $675,000 to the 60-day bucket next month. Reserves built on the historical 9.33 percent charge-off rate will be short.