Monday, October 08, 2012

Lending Club Loan Length and Interest Rate: Bad-Loan Experience Index

After reviewing the loan purpose with the Bad-Loan Experience Index (BLE Index) methodology in my last post Lending Club Loan Purpose: Default Rate and Bad-Loan Experience Index, I am very excited about the potential of this Index. I believe it will help me in further improving my understanding of Lending Club loans and what factors influence the credit risk of such loans.

On PeerCube, I started a peer filter for Bad-Loan Experience Index that I will continue to enhance as I review BLE Index for different loan parameters. In this post, I will review the two loan parameters that I had previously analyzed using default rate: Loan Length and Interest Rate.

How much is your time worth? Are you spending too much time selecting loans on Lending Club? Try PeerCube: Smart Lending with Peer Insights. PeerCube focuses on quick and collaborative decisions.


BLE Index for Loan Length

The table below shows the calculated BLE Index according to loan length. While reviewing the table, we need to keep in mind that 60 month loans were only started to be issued in 2010. The green color represents loan length that has BLE index less than 0.90 and light red color represents loan length that has  BLE index greater than 1.10. As a refresher, the smaller the BLE index, the better it is in reducing the credit risk.


It appears that loans with 36 month loan length are better loans with reduced credit risk than loans with 60 month loan length. This observation is consistent with general tendency of shorter loan length with better credit risk mentioned in 1940 study in NBER publication [PDF]. I also reviewed the BLE index for loan length for year 2010 through 2012 as shown in table below. The trend consistently shows 36 month loans having better credit risks but the gap is closing over past three years.


BLE Index for Interest Rate

The table below shows the BLE Index according to interest rate buckets. Each bucket is 3.00% interest rate wide. The BLE index ranges from 0.35 for loans with interest rate of 3 - 6% to 3.09 for loans with interest rate of 21 - 24%. It appears that interest rate is significantly related to credit risk. The rising BLE index pattern with rising interest rate is also very consistent. Logically, it makes sense: the higher the return, the greater the risk.


The table below shows the BLE index for interest rate for year 2007 through 2012. The BLE index pattern is pretty consistent: the higher the interest rate, the higher the risk.


BLE Index Caveats

No measurement is perfect and BLE Index has its own caveats that we need to consider.

Finding tendencies and not certainties

The following quote from the NBER publication sums it up nicely. It was true in 1940 and, in my opinion, it is true in 2012, too.
"Statistical analysis of the kind we are here attempting are necessarily based on averages and probabilities, and therefore can reveal only tendencies, not certainties."
Weigh the advantage of eliminating X% of bad loans  against the disadvantage of eliminating Y% of good loans

Let's take a hypothetical scenario of  deciding whether to eliminate loans with interest rate between 15 and 18% from consideration. Your decision to review this class of loans is driven by the findings above. The BLE index of 1.91 is much higher than your benchmark of 1.10, so you are deciding not to invest in such loans.

Instead of using a redline approach to eliminate all classes of loan that have BLE index higher than 1.10, weigh the advantage of eliminating, for example in this case, 21.59% of bad loans against the disadvantage of eliminating 11.28% of good loans.

Let's assume there were total 2,000 bad loans and 10,000 good loans and loans with 15 - 18% interest rate have 22% bad loans and 12% good loans. These number are approximate from above and previous post for easier calculations. If you decided to eliminate loans with 15 - 18% interest rate, you will be eliminating 440 bad loans and 1,200 good loans.

You are the only one who can decide whether missing out on 1,200 good loans in order to avoid 440 bad loans is worth or not. Once I finish reviewing all parameters for default rate and BLE index, I will review another measure that may help in this aspect.

Key Takeaways

  • To reduce credit risk, lenders may consider avoiding loans with 60 month term.
  • Though BLE Index indicates loans with interest rate less than 12% are better, lenders looking for higher yield may need to consider the advantage of eliminating X% of bad loans against disadvantage of eliminating Y% of good loans.


$1.99/mo Web Hosting

2 comments:

  1. Anil, I am glad you mentioned missing out on the good loans. What I think needs to be added to the BLE is some kind of reward metric. Your new index provides an excellent analysis of risk but does not inform us about reward. Is it better to invest in 2,000 good loans and take the hit on 440 bad loans? That depends. If it means a likely net return of 3% then the answer is probably no. But if it means a likely net return of 11-12% then many investors will take that return every time.

    ReplyDelete
    Replies
    1. Peter,

      Thanks for your comment and suggestion. Actually, there is another index "efficiency index" to go along with BLE index that shows relative merits of loan parameters as risk indicators. I plan to cover that later as it is much more explanatory once we have BLE index for different parameters.

      Also, the reward portion can be addressed by determining BLE index when loans lost money overall (Bad Loans) versus loans that made money (Good Loans) . Or using your definition of Bad loans when return less that 3% and good loan when return greater than 11%. I think BLE and Efficiency Index are very flexible.

      Thanks.

      Anil

      Delete