In this post, I will analyze the defaults based on principal paid back by the borrowers before default. For earlier posts in the series, please refer to Lending Club Loans - Defaults with Loan Age, Lending Club Loans - Months of Payment before Default, and Lending Club Loans - Principal Paid Back and Months of Payment.
One interesting observation from this chart is that 2.7% of 36 month loans that default pay back less than 0.04% of principal, i.e. borrower only makes one or two payments on the loan. A few other interesting observations for 36 month defaulted loans are:
Loan Length
The chart below shows the percentage of loans defaulted as a function of principal paid back for 36 and 60 months loans. Similar to previous methodologies, the curve for 60 month loan is exaggerated, i.e. higher defaults at lower principal paid back because all of 60 month loans are less than 3 years old.One interesting observation from this chart is that 2.7% of 36 month loans that default pay back less than 0.04% of principal, i.e. borrower only makes one or two payments on the loan. A few other interesting observations for 36 month defaulted loans are:
- About 44% of defaulted loans pay back less than 20% of principal.
- About 80% of defaulted loans pay back less than 50% of principal.
- About 95% of defaulted loans pay back less than 80% of principal.
Credit Grade
The chart below shows the percentage of loans defaulted as a function of principal paid back for various credit grades. There are no surprises here.- The defaults with principal paid back for loans with credit grades E, F, and G behave very similar to each other. The similar trend is also seen for loans with credit grades B, C, and D. This may suggest that better returns to be have by investing in the loans with higher interest rate within each group.
- As expected the defaults of higher quality loans, i.e. credit grade A loans, tend to pay back larger portion of original principal. The open question is whether the lower interest payments for such loans cover the principal loss.
Interesting information, thank you for posting!
ReplyDeleteI noticed that graph 2 combines 36 and 60 month loans. With 34 months of data for 60 month notes available, is it possible to compare, for instance, the last 30 months of data for 60 month loans with the corresponding past 30 months of 36 month loans to examine the changes in the shapes of those curves over that time frame?
That may shed more light on trends between the two maturities.
Your analysis abilities definitely trump my Excel pivot table work, but I found that about 80% of loans default within the first 20% of their payments (so 48 months for 60s, and 28/29 for 36s. Thanks for supporting my findings as I use my work extensively (as in automated evaluation of each individual loan) to pick loans which I sort by highest probability of return. Helps to have accurate data when doing that! :-)
ReplyDelete