Lending Club By Loan Purpose And Months Since Last Delinquency
Update: Now that Lending Club has raised their loan limit, these numbers have all changed. So, please don't rely on these results. You can follow the methodology to perform your own analysis on the new data.
I changed the text values to numerical values: 1= vehicle (repair or purchase) 2=moving 3=consolidation/refinancing 4=Home Improvement 5=Small Business (includes: investing money in business, real estate, stock market, get rich quick schemes, funding for existing business, etc) 6=Education 7=Medical expenses 8=Wedding 9=Major purchase (RV, furniture, etc.) 10=Vacation 11=Misc. Other 12=Relending on Lending Club 13=Green/renewable. Swapping was easy for most of the data, I just used FIND/REPLACE, but loans with OTHER as the purpose were a problem and after sifting through 14,000 records, I'm not really happy with people who chose it to describe their loan.
I had to swap out the OTHER category by HAND. It took me several days to re-code all those OTHER loans (you're welcome). When reviewing stuff that was designated OTHER, if I couldn't tell in seconds what it was it got an 11. If it didn't have any information it got an 11. I probably should have added a "Taxes" category and an "Attorney" category because I encountered them a lot...but I didn't.
LOAN PURPOSE
Fully Paid Count | ChargeOff/Default | Purpose | % |
529 | 26 | 1 | 4.68% |
226 | 15 | 2 | 6.22% |
7320 | 381 | 3 | 4.95% |
1100 | 81 | 4 | 6.86% |
797 | 123 | 5 | 13.37% |
456 | 39 | 6 | 7.88% |
255 | 17 | 7 | 6.25% |
361 | 14 | 8 | 3.73% |
775 | 27 | 9 | 3.37% |
149 | 3 | 10 | 1.97% |
667 | 20 | 11 | 2.91% |
24 | 0 | 12 | 0% |
20 | 0 | 13 | 0% |
The percent column was calculated this way: ChargeOff&Default Count / (ChargeOff&Default Count + Fully Paid&Current Count).
I've been on Lending Club for awhile and I have never put money into a loan designated Small Business and I never will. I've co-founded two businesses so you'd think I'd be sympathetic to the plight of the entrepreneur, but lending money for a small business on Lending Club is just too risky with very little upside. As the data shows, a large percentage of these loans will be charged-off.
The MONTHS SINCE LAST DELINQUENCY data is not very reliable, roughly 20% of the cells do not have a value. It's been left blank. When looking through the data, it's not as simple as adding zero's in the blank spots. Some of those loans have had several delinquencies listed in the past 24 months column, but no value listed in the months since last delinquency column. Also, I believe if the borrower has never had a delinquency it shows up as a blank cell. Here's what the data looks like:
MONTHS SINCE LAST DELINQUENCY
Fully Paid Count | ChargeOff/Default | Months | % |
2951 | 276 | blank | 8.55% |
1771 | 184 | 0 | 9.41% |
808 | 36 | 10 | 4.27% |
1253 | 48 | 20 | 3.69% |
1391 | 49 | 30 | 3.40% |
1312 | 37 | 40 | 2.74% |
996 | 52 | 50 | 4.96% |
782 | 23 | 60 | 2.86% |
667 | 26 | 70 | 3.75% |
676 | 16 | 80 | 2.31% |
73 | 1 | 90 | 1.35% |
3 | 0 | 100 | 0% |
I'm at the point where I can start putting together a picture of the loans I'd like to fund.