Explainers  /  8 of 20

Following a dollar: the Markov flow

Chaining monthly roll rates into the path from a missed payment to a charge-off.

A roll-rate table says where a dollar goes in one month. Chaining the months, using each month's output as the next month's input, shows where today's late dollars end up: cured, paid down or charged off.

The rule

Dollars in each status next month = for every status, the dollars there now times that status's roll rate into it, added up. Charged-off and paid-down dollars stay where they land. Repeat once a month.

A made-up roll-rate table

Started the month Current 30-59 days 60-89 days 90+ days Paid down Charged off
Current 95% 1% - - 4% -
30-59 days 30% 40% 25% - 3% 2%
60-89 days 16% 16% 28% 32% 4% 4%
90+ days 4% 4% 4% 40% 4% 44%

$1,000 that is 30-59 days late

Month Current 30-59 days 60-89 days 90+ days Paid down Charged off
0 $0 $1,000 $0 $0 $0 $0
1 $300 $400 $250 $0 $30 $20
2 $445 $203 $170 $80 $64 $38
3 $514 $116 $102 $86 $98 $84
6 $544 $32 $24 $31 $185 $185
12 $441 $10 $4 $3 $316 $226
  • Month 1 is the 30-59 day row applied to $1,000: $300 current again, $400 still 30-59 days late, $250 rolled to 60-89 days, $30 paid down and $20 charged off.
  • Month 2: each of those piles splits by its own row. Charged off: $20 already there + $400 × 2% + $250 × 4% = $38.
  • After 12 months (later months rounded to whole dollars): $226 charged off, $316 paid down, $441 current and $18 still late.

The real numbers

The prime roll-rate table (credit scores 660-900 at origination), every month-to-month move from October 2025 to September 2026, added up in dollars:

Started the month Current 1-29 days 30-59 days 60-89 days 90+ days Paid down Charged off
Current 93.1% 2.2% 0.07% <0.01% <0.01% 4.7% 0.04%
1-29 days 30.3% 53.8% 10.3% 0.15% <0.01% 5.3% 0.08%
30-59 days 14.0% 19.1% 39.3% 22.6% 0.25% 4.3% 0.52%
60-89 days 11.8% 8.6% 14.1% 31.3% 26.9% 3.9% 3.4%
90+ days 8.2% 4.4% 3.0% 6.3% 25.8% 3.7% 48.5%

Chained twelve times, $1,000 of prime balance 30-59 days late ends up $157 charged off (15.7%), $386 paid down, $412 current, $30 1-29 days late and $16 still 30 or more days late. Charge-offs build over time: $53 after three months, $126 after six. The same chain on the subprime table (300-659) gives $226.

Common pitfalls

  • The table has no memory. A chain treats a loan that just caught up like one that never missed a payment. Loans that cure often fall behind again, so a chained loss can come out low.
  • One average year. The table adds up the twelve months from October 2025 to September 2026; a chain assumes the coming months look like that average. The deck's 2- and 3-month scorecards chain each month's own table instead.
  • The direct path is only part of it. Multiplying 30-59 → 60-89 → 90+ → charged off gives only $29 of the $1,000. The chain also counts dollars that cure and slip back, or sit in a lane for a few months.
  • Paid down is not paid off. It counts every dollar of principal repaid, including the regular payments of loans that caught up.

Where to see it

Source: LoanTape, SEC Form ABS-EE loan-level data, through September 2026.