Case 068Structured finance and securitisationCore
Build a simple delinquency model for a mortgage pool using monthly roll rates between arrears buckets, project the 90+ bucket for three months, and say which borrower factors you would add.
1The situation
Sundhara Housing Finance holds a Rs 10,000 crore pool of home loans that it may securitise. Today Rs 9,500 crore is current, Rs 300 crore is 30 days past due, Rs 120 crore is 60 days past due and Rs 80 crore is 90 or more days past due.
Monthly roll rates from recent history: 3% of current loans miss a payment and move to 30 days; 30% of 30-day loans move to 60 days; 50% of 60-day loans move to 90+. Loans that do not roll forward cure back to current. Treat 90+ as a final state for this exercise, and ignore scheduled repayments, prepayments and new loans.
2Your task
Project the 90+ bucket for three months, explain what drives it, and name the borrower factors you would add to make the model useful.
Quick check
About how much reaches 90+ in the first month?
Worked solution
Try it on paper, then open one step at a time.
30-second answerThe answer to give first
The 90+ bucket grows from Rs 80 crore to about Rs 140, 185 and 228 crore over three months, from 0.8% to about 2.3% of the pool. Each month about 3% x 30% x 50% of current loans, roughly Rs 43 crore, completes the journey. Borrower factors such as loan-to-value, income cover, credit score and employment type turn the single roll rates into loan-level probabilities.
Step 1How does a roll-rate model work?
Think of a queue of students who have missed homework. Most who miss one hand it in next week; a few miss two; some of those miss three and are sent to the principal. A roll-rate model tracks how much of each arrears bucket moves one step worse each month, so today's early misses become a forecast of tomorrow's defaults. Loans move at most one bucket a month. With a roll rateThe share of loans in one arrears bucket that move to the next, worse bucket in the following month. of 3% from current, 30% from 30 days and 50% from 60 days, only 0.45% of current loans reach 90+ three months later, but on Rs 9,500 crore that is about Rs 43 crore every month.
| Rs crore | Today | Month 1 | Month 2 | Month 3 |
|---|---|---|---|---|
| Current | 9,500.0 | 9,485.0 | 9,444.9 | 9,403.5 |
| 30 days past due | 300.0 | 285.0 | 284.6 | 283.3 |
| 60 days past due | 120.0 | 90.0 | 85.5 | 85.4 |
| 90+ days past due | 80.0 | 140.0 | 185.0 | 227.8 |
| 90+ as % of pool | 0.80% | 1.40% | 1.85% | 2.28% |
Step 2What does the projection tell you, and what does it miss?
The early buckets are the forecast: today's Rs 300 crore at 30 days and Rs 120 crore at 60 days already determine most of the next two months of new defaults. That is why investors watch 30-day arrears closely; they move first. The limits are worth saying. Roll rates are averages that change with the economy, rising when rates reset upward or jobs are lost. One rate for the whole pool treats a new loan at 90% loan-to-value the same as a ten-year-old loan at 40%. And the model ignores cures from 90+, write-offs, prepayments and new lending, each of which changes the balances.
Step 3Which borrower factors would you add, and how would you train the model?
Add the factors that explain why one borrower misses a payment and another does not. Loan-to-value, because a borrower with equity in the home fights to keep paying; the share of income taken by loan payments; credit score and past arrears; employment type, salaried against self-employed; and loan age, because missed payments tend to cluster in the early years. Add rate resets for floating loans, geography, and property type. To build it, take loan-level monthly history, estimate the probability of each transition as a function of those factors, for example with a logistic regression per bucket, and validate on a later period the model did not see. Then run it forward under stress: raise the current-to-30 rate from 3% to 5% and watch what happens to the 90+ bucket in month 3.
Where candidates lose it
The common error is letting loans jump buckets, for example applying 3% x 30% x 50% to current loans and adding it to 90+ in month 1. A loan can only move one bucket a month, so month 1 depends only on the 60-day bucket.
The second is presenting one pool-wide roll rate as a model. Interviewers want the borrower factors that make the roll rate differ from loan to loan, and a word on how you would test it.
What the interviewer asks next
- The current-to-30 roll rate doubles to 6%. What happens to the 90+ bucket by month 3?
- How would you add cures from 90+ back to current, and why do they matter for a securitisation?
- How would you use this model to size credit enhancement on a securitised pool?
Asked at Neuberger Berman, Risk, Chicago, 2024 (Wall Street Oasis): This involved showing knowledge of the factors that contribute to mortgage loans failing to make a payment.
Company names and figures are illustrative.
