Roll Rate Analysis: How Credit Portfolios Deteriorate Before Default

Entimema
Editorial artwork for Roll Rate Analysis showing deterioration, persistence and cure across five suspended portfolio states.
Contents

Default is the end of the story. Roll rates show how the story develops. Two portfolios can report the same default stock and carry materially different near-term risk: one may be curing upstream arrears while the other is feeding them rapidly into deeper delinquency.

Default rates are necessary, but inherently late. Roll-rate analysis changes the unit of attention from stock to movement and from terminal outcome to transition process. The practical chain is state → transition → baseline deviation → persistent pattern → diagnosis → decision → monitored result.

State architecture comes before matrix mathematics

A migration system begins by assigning every eligible observation to one—and only one—state at each observation date. An illustrative monthly architecture is:

S₀=CurrentS₁=1–30 DPDS₂=31–60 DPDS₃=61–90 DPDSᴅ=Default

These buckets are not universal. Product, payment frequency, default definition, collections process and modelling objective determine a defensible architecture. A weekly-pay product may need shorter intervals; revolving facilities may need utilisation or over-limit signals; closure may require a distinct SC state.

Definitions determine what a transition means

Days past due depends on due-date logic, payment allocation, grace periods and data cut-off. Cure rules, write-off, restructuring and closure must be explicit. Multiple facilities raise a unit-of-analysis decision: does one defaulted facility move the borrower into default, or is migration measured facility by facility? A matrix built on inconsistent states can be mathematically correct and analytically misleading.

The terminal state must inherit the governed boundary developed in Default Definition: The Boundary That Shapes Every PD Model. Changing that boundary changes transition counts, absorption, cure, cumulative default probability and historical comparability.

A roll rate is a conditional transition probability

pij = P(St+1 = j | St = i)
Probability of moving from state i at t to state j at t+1
ij = Nij / ∑j Nij
Empirical transition probability

Nij is the number of eligible accounts beginning in state i and ending in state j. The denominator is all eligible accounts that began the period in i—not the total portfolio and not the destination population. Thus p23 asks: among accounts that were 31–60 DPD at opening, what fraction were 61–90 DPD one month later?

ROLL FORWARD →
Current1–30 DPD31–60 DPD61–90 DPDDefault
← ROLL BACK / CURE PATH
Forward movement measures deterioration velocity. Backward movement records improvement, which is not automatically formal cure.
FORWARD

Deterioration

Current → 1–30, 1–30 → 31–60 and 31–60 → 61–90 reveal the velocity with which risk deepens.

BACK

Improvement

Backward migration can reflect payment recovery, collections, temporary delinquency or restored liquidity. It is an observed state change—not necessarily cure.

i → i

Persistence

Remaining in 61–90 DPD is severe unresolved risk. No migration does not mean no economic risk change.

A formal cure may require a sustained cure period, exit from default status and treatment of re-default under policy. A one-month improvement cannot silently override those rules. Similarly, setting P(Default → Default) = 1 creates a useful absorbing-state model, but operational portfolios may later cure, recover, restructure or close. Permanent absorption is a modelling choice, not universal reality.

Denominator discipline determines the economic question

A roll rate is only interpretable when its origin population, eligibility rules and weight are fixed. The conventional account-count rate divides transitions from i to j by every eligible account that started in i. A surviving-population rate removes closures or missing observations; an eligible-only rate may remove hardship or restructure cases. Each can be internally correct and still answer a different question.

RRi→j = N(St=i, St+1=j) / N(St=i)
Account-count roll rate from opening state i
RREADi→j = ∑ EADt I(St=i,St+1=j) / ∑ EADt I(St=i)
Opening-exposure-weighted roll rate
The same portfolio can support different valid denominators
Design choiceQuestion answeredPrimary risk
Opening account countHow broadly did borrowers move?Small and large balances count equally
Opening EADHow much opening exposure moved?Balance changes after t are not represented
Surviving populationHow did accounts still observed at t+1 move?Exit can disappear from the story
Eligible accounts onlyHow did the governed analytical population move?Eligibility changes can create false trends

Two analysts can therefore produce different, mathematically correct roll rates from the same extract because one measures behavioural breadth and the other measures capital at risk. A production pack should publish the denominator beside every rate, retain the raw cell count and reconcile exclusions. Unlabelled denominator changes are methodology changes, not presentation choices.

An original 100,000-account one-month portfolio

This fictional consumer lending portfolio contains no institutional data. Opening populations are 80,000 current, 9,000 at 1–30 DPD, 5,000 at 31–60 DPD, 3,000 at 61–90 DPD and 3,000 already in default. Every row reconciles to its opening population.

Illustrative transition counts; rows are opening states and columns are month-end destinations
State at tCurrent1–30 DPD31–60 DPD61–90 DPDDefaultOpening total
Current76,0003,20048016016080,000
1–30 DPD2,7003,6002,2502701809,000
31–60 DPD5001,2501,5001,2505005,000
61–90 DPD601506001,2909003,000
Default00003,0003,000
↙ Improve● Stable↗ Deteriorate■ Default
t ↓ / t+1 →Current1–30 DPD31–60 DPD61–90 DPDDefaultCurrent95%stable4%deteriorate0.6%deteriorate0.2%deteriorate0.2%default1–30 DPD30%improve40%stable25%deteriorate3%deteriorate2%default31–60 DPD10%improve25%improve30%stable25%deteriorate10%default61–90 DPD2%improve5%improve20%improve43%stable30%defaultDefault0%improve0%improve0%improve0%improve100%default
Illustrative account-weighted one-month matrix. Rows sum to 100%; labels preserve meaning without reliance on colour.
P = [ [ .950, .040, .006, .002, .002 ], [ .300, .400, .250, .030, .020 ], [ .100, .250, .300, .250, .100 ], [ .020, .050, .200, .430, .300 ], [ 0, 0, 0, 0, 1.000 ] ]
The actual illustrative one-month transition matrix

Read the rows as competing destinations

  • Current is highly persistent: 95.0% remain current. Yet 5.0% leave current, including 4.0% into early delinquency; at this scale, a small percentage is operationally meaningful.
  • 1–30 DPD is a leverage point: 30.0% return current, 40.0% persist, and 30.0% deteriorate. Intervention can be valuable before deeper arrears become entrenched.
  • 31–60 DPD is balanced on divergent paths: 35.0% improve, 30.0% persist and 35.0% worsen, including 10.0% directly to default.
  • 61–90 DPD is severe: only 27.0% improve, 43.0% remain unresolved and 30.0% default within the month.
  • Default is absorbing here: the 100% diagonal is an analytical convention, not evidence that recovery is impossible.

Stock reports position; flow explains its formation

STOCKt

How many exposures occupy each state now?

FLOWt→t+1

How do those exposures move between states?

A rising delinquency stock can reflect more deterioration inflow, lower cure, slower exit, or all three. Each mechanism implies a different management question. A stock measure alone cannot separate them.

ENTIMEMA FRAMEWORKThe Risk Stock–Flow IdentityA portfolio accounting identity for any consistently defined risk state.
  1. Opening risk stock
  2. + Deterioration inflow
  3. − Cure / recovery outflow
  4. − Closure / exit
  5. = Closing risk stock

The identity forces reconciliation. If closing 31–60 DPD rises, the analyst can attribute the movement to inflows from better states, outflows to cure or worse states, and legitimate exits. It also exposes missing statuses: an unexplained residual is often a population, snapshot or closure problem before it is a credit insight.

Stable default can conceal an upstream shock

Illustrative flow deterioration before the 90+ stock responds
MetricBaseline monthCurrent monthInterpretation
90+ / default stock3.0%3.1%Headline appears approximately stable
Current → 1–304.0%5.6%New delinquency inflow is 40% above baseline
1–30 → 31–6025.0%32.0%Early arrears are deepening faster
31–60 → Current cure10.0%6.5%Full one-period cure capacity has weakened
31–60 persistence30.0%38.0%Unresolved arrears are accumulating

The 90+ stock barely moves because exits, write-offs and recoveries still offset new entries. That balance can persist temporarily even while the pipeline feeding default worsens. The correct response is not to declare a default increase inevitable; it is to diagnose whether the upstream changes are persistent, material and concentrated in specific vintages, products or strategies.

Observation frequency changes the transition being measured

Weekly transitions are responsive and useful for operational collections, but can be noisy and sensitive to payroll calendars. Monthly transitions align naturally with many payment cycles and portfolio packs. Quarterly transitions are smoother but compress intervening paths. None is intrinsically superior: cadence must match contractual behaviour, decision latency and data reliability.

An observed endpoint transition Currentt → 31–60t+1 does not prove a direct jump. The account may have passed through 1–30 DPD between snapshots. Endpoint matrices describe where accounts were observed, not their complete behavioural paths. Event-level data is required when sequence, duration and treatment timing matter.

Cure is a path, not a single backward movement

61–90 → 31–60 is roll-back, not full cure. 31–60 → Current is an observed cure under a one-period state definition, but it may be temporary. Separate partial recovery, full cure, sustained cure and re-default after cure.

Sustained Cureh = P(St+h=Current | Curet)
Probability that an observed cure remains current h periods later

Collections teams should compare treatment groups on sustained cure and re-default, not only one-month roll-back. Otherwise a strategy that briefly resets arrears can appear effective while failing to restore durable payment behaviour.

One-period movement compounds into a default path

P(2) = P²    and    P(n) = Pⁿ
Multi-period migration under a time-homogeneous transition system

Matrix multiplication sums every feasible intermediate path. The two-month probability of moving from 31–60 DPD to default includes direct default followed by absorption and indirect routes through every state. Using the illustrative matrix, it is 21.02%: (10% × 0.2%) + (25% × 2%) + (30% × 10%) + (25% × 30%) + (10% × 100%).

The one-month roll-to-default from 31–60 is 10.0%; the two-month cumulative probability of occupying default is 21.02%. These answer different horizon questions. In general, P(St+n = Default | St = i) is the i-to-default element of Pⁿ when default is absorbing.

The Markov assumption is useful—and restrictive

P(St+1 | St, St−1, …) = P(St+1 | St)
First-order Markov assumption

This assumes the current state contains all information needed for the next transition and that one matrix remains applicable through time. Real behaviour may depend on prior delinquency, number of cures, borrower characteristics, vintage, macro conditions, collections actions, product and seasonality. Simple matrices are powerful descriptive and scenario tools; they are not automatically complete behavioural models or forecasts.

Early warning requires deviation, persistence and diagnosis

The transition system should be written as Pt, not assumed permanent. Comparing rolling monthly or quarterly matrices—or P2025 with P2026—shows whether the mechanism is changing. If P(Current → 1–30) rises and, later, P(1–30 → 31–60) rises, default may not yet have changed materially. The portfolio is nevertheless accelerating toward worse states.

Signalij,t = RRij,t − Baseline(RRij)
Transition signal relative to a governed baseline
ENTIMEMA FRAMEWORKTransition → Baseline → Deviation → Persistence → Diagnosis → ActionA single rate becomes an early-warning indicator only when it is interpreted against context and connected to an owned response.
  1. Measure the transition
  2. Select comparable history
  3. Quantify change
  4. Confirm persistence
  5. Locate the driver
  6. Assign a decision

Before escalation, test statistical noise, seasonality, vintage mix, rapid portfolio growth, policy changes, treatment allocation and macroeconomic conditions. A single monthly deviation should normally create an investigation, not an automatic intervention. Repetition, exposure materiality, cross-signal confirmation and downstream emergence strengthen the case.

Collections can respond to state and trajectory

Early delinquency may support low-cost reminders or contact, intermediate delinquency more intensive engagement, and severe delinquency specialised treatment. These are conceptual treatment tiers, not institution-specific prescriptions. The methodological principle is that collections strategy should respond not only to current state but also to transition probability.

BORROWER A1–30 DPD

High probability of returning current

BORROWER B1–30 DPD

High probability of rolling to 31–60

The observed state is identical; the expected trajectory differs. Combining state + transition risk can support prioritisation, provided any borrower-level estimate is separately developed, validated, monitored and governed. An aggregate matrix alone is not a borrower prediction model.

Transition patterns create decision hypotheses, not universal treatment rules
Observed patternDecision hypothesisEvidence to validate
High Current → 1–30Reduce payment friction; test reminders or autopayFailure reason, due-date timing, contactability, experiment lift
High 1–30 → 31–60Challenge early collections and affordability stressContact strategy, promise-to-pay, income shock, channel and vintage
High 31–60 persistenceRe-segment treatment and assess restructuringDuration, prior cures, treatment history, sustainable affordability
High 61–90 → DefaultReview late-stage recovery economics and provisioning impactExpected recovery, legal cost, restructuring viability, EAD
ENTIMEMA FRAMEWORKObserve → Compare → Diagnose → Segment → Test → Intervene → MonitorAnalytics becomes risk management only when every observation has a route to a testable, owned decision.
  1. Observe
  2. Compare
  3. Diagnose
  4. Segment
  5. Test
  6. Intervene
  7. Monitor

Vintage and segment views separate mix from deterioration

Aggregate roll rates mix borrowers originated under different underwriting policies, scorecards, pricing regimes, channels and macroeconomic environments. Estimate RR(v)i→j for vintage v at comparable months on book. If every vintage is worsening, the evidence supports a portfolio-wide diagnosis; if one recent vintage diverges, the first investigation should focus on its origination and early-life conditions.

Credit Vintage Analysis establishes the cohort view; roll rates explain the transition mechanism beneath each cumulative vintage curve.

Account flow and exposure flow can disagree

RollRateaccountsij = Nij/N    |    RollRateEADij = EADij/EAD
Count-weighted and exposure-weighted roll rates

Each account contributes equally to an account-weighted matrix; exposure weighting gives influence in proportion to balance or EAD. Neither is universally superior. Counts describe behavioural breadth and workload; EAD better describes capital at risk and balance concentration.

Compact weighting example: ten accounts begin in 1–30 DPD
DestinationAccountsOpening EADAccount roll rateEAD roll rate
Current / improve8£8,00080%28.6%
31–60 / deteriorate2£20,00020%71.4%
Total10£28,000100%100%

Most accounts cure, yet the two large exposures deteriorate. Count-level migration improves while exposure-level risk worsens. Reports must label weighting explicitly and reconcile the EAD basis—opening, closing or average—rather than mixing it across periods.

Segment only where structure can be distinguished from noise

Product, vintage, risk grade, acquisition channel, customer type, geography where relevant, and secured versus unsecured status can conceal genuine heterogeneity. But every split reduces cell counts. Minimum denominators, uncertainty intervals, pooling rules and economic rationale are needed to prevent sparse-state instability from becoming false precision.

Entry, exit and contract changes belong in the architecture

New business and seasoning

New originations, acquisitions and portfolio transfers have no previous observed state. Inserting them into an existing-state denominator manufactures transitions. Use a new-entry state or exclude them until two comparable snapshots exist; report seasoning separately where early-life behaviour differs.

Closure and prepayment

Contractual maturity, prepayment, refinancing and closure remove accounts without default. Closure is not automatically cure. A separate closed state can preserve row reconciliation and distinguish repayment exit from credit improvement.

Restructuring

Changed contractual terms can reset DPD and make an account appear to improve without genuine economic recovery. Operational status and economic risk state can diverge; restructuring flags and original delinquency history should remain available.

Time interval

Consistent observation dates are essential. Monthly and quarterly pij have different meanings and should not be casually combined. The temporal discipline in PD Model Observation and Performance Windows applies equally here: define snapshots, eligibility and interval before estimating movement.

Migration is related to PD—not identical to it

A borrower-level PD asks P(Default within horizon | X). Migration asks P(St+1 = j | St = i). State transitions can enrich PD monitoring, scenario analysis and collections, while PD can differentiate borrowers within the same state. Conflating the two discards either horizon or borrower information.

A practical portfolio monitoring architecture

Stock metrics

Current, delinquent and default stock

Flow metrics

Roll-forward, roll-back, cure and default entry

Transition metrics

Full matrix probabilities and state persistence

Segmentation

Vintage, product, risk grade and channel

Exposure

Account-weighted and EAD-weighted views

Time

Current matrix, rolling history and baseline comparison

Production monitoring should retain counts beneath rates, row totals, missing-state reconciliation, definition versions and action chronology. Compare both level and change: a 25% roll-forward rate may be normal for one state, while a move from 10% to 16% may be material even if its absolute level remains below another state.

Every review should answer five questions: What changed? Where did it change? Is it persistent? Why might it have changed? What decision should follow? The pack should include account and EAD transitions, cure and persistence, vintage and segment views, historical level and volatility, alert thresholds, economic materiality, and later default emergence.

Thresholds need named owners, escalation paths and evidence requirements. Without decision ownership, monitoring becomes an increasingly elaborate description of the past.

The Entimema Migration Diagnostic

Plot deterioration inflow against cure capacity using portfolio-specific, empirically justified baselines. The quadrants are a diagnostic language—not a universal regulatory classification or fixed-threshold score.

CURE CAPACITY ↑DETERIORATION INFLOW →
Low deterioration / High cure

Healthy dynamics; test whether improvement is broad and sustainable.

High deterioration / High cure

High churn; diagnose inflow sources and treatment dependence.

Low deterioration / Low cure

Persistent stock; resolution capacity may be constrained.

High deterioration / Low cure

Strong deterioration; both inflow and weak recovery require attention.

Interpret both dimensions relative to a documented portfolio baseline. Movement between quadrants is often more informative than a single placement.

Production begins with a reproducible account-state spine

ENTIMEMA FRAMEWORKAccount data → state assignment → transitions → segmentation → baseline → anomaly → diagnosis → recommendation → monitoringA production chain that preserves reconciliation from raw account observations to an owned decision.
  1. Account snapshots
  2. Governed states
  3. Paired transitions
  4. Segment views
  5. Comparable baseline
  6. Material anomaly
  7. Diagnostic evidence
  8. Decision recommendation
  9. Outcome monitoring

The minimum data spine includes a persistent account identifier, observation date, delinquency status or sufficient payment fields to derive it, opening balance or EAD, product, origination date, risk grade or score band, and closure/default/restructure flags. Collections diagnosis also needs treatment, contact, promise-to-pay and outcome history. Definition versions and data lineage are control data, not optional metadata.

Build transitions by pairing consecutive eligible snapshots at the chosen cadence. Preserve unmatched openings, entries and exits as reconciliation categories. Store numerator, denominator and weight beside each rate. Baselines should be comparable by season, months on book and policy regime; alert logic should combine statistical departure with business materiality.

Failure modes that invalidate interpretation

Migration analysis controls
Failure modeAnalytical consequenceControl
Stocks mixed with flowsPosition is mistaken for movementReconcile opening, inflow, outflow and closing stock
Inconsistent DPD logicArtificial movement between statesVersion due-date and payment-allocation rules
Inconsistent observation datesDifferent transition horizonsFix cut-off cadence and snapshot timing
Mixed count and EAD weightingRates answer different questionsLabel and reconcile parallel matrices
Closure ignoredRows fail or exits resemble cureModel closure explicitly where material
Roll-back treated as cureRecovery is overstatedApply governed cure period and re-default rules
Sparse states or segmentsExtreme, unstable probabilitiesShow counts; pool or suppress weak cells
Vintages mixedOrigination-regime deterioration is dilutedCompare at equivalent months on book
Portfolio growth ignoredYoung current accounts dilute aggregate ratesControl for entry and seasoning
Seasonality ignoredCalendar effects resemble structural driftUse comparable seasonal baselines
New accounts in denominatorsNon-transitions dilute ratesRequire a prior eligible state
Restructures reset DPDContract change resembles recoveryRetain economic-risk and restructure flags
One permanent matrixRegime change is hiddenMonitor Pₜ and challenge homogeneity
Default boundary changesHistory becomes incomparableRestate, bridge or mark the definition break
Correlation treated as causeAn association drives an unjustified actionForm hypotheses and test competing explanations
No decision ownerAlerts accumulate without interventionAssign thresholds, owner, evidence and response SLA

Resolve: from backward-looking stock to behavioural system

Migration analysis does not replace delinquency stocks, PD models, vintages or collections judgement. It connects them. Stable state definitions turn two snapshots into transitions; transitions become conditional rates; rates form a matrix; repeated matrices expose default paths and changing portfolio velocity; and those dynamics focus investigation and intervention.

Roll-rate monitoring is a natural candidate for controlled automation

A future Portfolio Migration & Early Warning Agent could ingest periodic portfolio data, reconstruct governed states, calculate count- and exposure-weighted transitions, compare them with historical baselines, and locate abnormal changes by vintage and segment. It could then distinguish isolated noise from persistent deterioration, assemble diagnostic evidence and prioritise cases for human review.

The calculation layer should remain deterministic and reproducible. The Agent’s role is orchestration: selecting approved comparisons, navigating drill-downs, documenting evidence and routing recommendations within explicit permissions. This is valuable because the workflow is repetitive, data-intensive and decision-oriented—not because judgement should be removed.

Related implementation research on automating roll-rate and migration analysis develops the engineering bridge. Entimema’s Credit Risk practice connects portfolio methodology, monitoring design and controlled decision systems.