PeerCube Thoughts

Opinions and analysis of Marketplace Lending, Online Lending, and Peer to Peer Lending.

Early Repayment of Loans and Impact on Lenders' Yield at Lending Club

Mad Rush at Lending Club Loan Release Time: Part I

Lending Club Loan Listings, Issuance, and Impact on Yield from Non-performing Period

Posted by Anil Gupta | Saturday May 31, 2014, 2:49 pm | Categories: Lending Club

Objective

I am sure you may have heard lot of discussion along the lines “Lending Club takes too long to issue loans” or “while Lending Club is deciding to issue loan, lender commitment to that loan is locked up without earning any return” or something similar.

The objective of this study is to investigate the loans on Lending Club platform that are finally issued after being listed. The findings of this study can help lenders determine the ratio of their investment that may not result in being lent to borrowers and the period for which their investment are non-performing, i.e. not earning return. We also put forward a process to estimate the cost of such non-performing periods and the potential reduction in expected yield.

Data Collection

The loans listed between July 10th and October 2nd, 2013 (about 3 months) were used for this analysis. The loan listing and historical data used for this study was captured by PeerCube. The historical loan data file was downloaded on May 25th, 2014. The historical loan data file was used to determine the loans that were actually issued after being listed between July 10th and October 2nd, 2013 and the performance of those loans.

Loan Listings and Issuance by Credit Grade

Between July 10th and October 2nd, 37,456 loans were listed requesting $560,977,550 in funding, as detected by PeerCube. Table 1 below shows the distribution of listings and associated median interest rate by credit grade. Less than 15% of loans listed carried E to G credit grade. 85% of loans listed carried A to D credit grade. It appears Lending Club continues to focus, source and list high quality grade loans.

Table 1: Loan Listings by Credit Grade between July 10th and October 2nd, 2013
Credit Grade A B C D E F G Total
Listing Volume 3,379 12,576 10,522 5,574 3,065 1,814 526 37,456
Listing Volume % 9.02% 33.58% 28.09% 14.88% 8.18% 4.84% 1.40% 100%
Interest Rate (Median) 7.62% 11.55% 15.22% 18.85% 21.60% 24.50% 25.83% 14.33%

Historical loan data file shows 23,938 (63.91%) of loans listed in this period were issued. Table 2 below shows the issued volume and the percentage of listed loans that were finally issued by credit grades. The data clearly shows that over 45% of low quality loans that carry E to G credit grades are never issued.

Table 2: Loan Issued by Credit Grade for loans listed between July 10th and October 2nd, 2013
Credit Grade A B C D E F G Total
Issued Volume 2,344 8,571 6,767 3,327 1,710 968 251 23,938
Issued as % of Listing 69.37% 68.15% 64.31% 59.69% 55.79% 53.36% 47.72% 63.91%

Table 3 below shows the number of days Lending Club takes to issue loans after being listed by Credit Grade. Most loans take between 1 and 36 days to be issued with 90% of loans are issued within 15 days of being listed. There is very little variability between the credit grades.

Table 3: Days to Issue Loans by Credit Grade for loans listed between July 10th and October 2nd, 2013
Credit Grade A B C D E F G Total
Days to Issue (Median) 8 7 7 7 7 7 8 7
Days to Issue (90 Percentile) 15 15 15 15 15 16 15 15
Days to Issue (Range) 1 - 33 1 - 33 1 - 35 1 - 32 1 - 36 1 - 31 2 - 27 1 - 36

Cost of Non-performing Period

Lenders can approximately estimate the cost of non-performing period of their investment by using the interest rate, % of listings not issued, and days to issue.

For example, assuming a lender is investing $10,000 in G grade loans with 25.83% interest rate (median). During the first investment cycle of investing $10,000, because only 47.72% of G grade loans are issued, $5,228 will be returned to lender after 15 days (90 percentile) while $4,772 will be invested after 8 days (median). Based on these numbers, in first investment cycle, lender will miss out on return of:

($5,228 * 15 days + $4,772 * 8 days) * (25.83% / 365 * 100) = (78,420 + 38,176) * 0.0007077 = $82.512

During the second investment cycle, the returned amount $5,228 will be invested. Because only 47.72% of G grade loans are issued, $2,495 will be invested after 8 days and $2,773 will be returned to lender after 15 days. Based on these numbers, in second investment cycle, lender will miss out on return of:

($2,773 * 15 days + $2,495 * 8 days) * (25.83% / 365 * 100) = (41,595 + 19,960) * 0.0007077 = $43.562

Similarly, we can estimate the missed return for third investment cycle and so on.

Similar estimates can be made for other credit grades. Table 4 shows the summary of calculations performed for all credit grades. A shared Google Spreadsheet can be accessed here if you want to play with these numbers. The annual cost of non-performing period can be between 0.31% to 1.73% depending on the credit grade.

Table 4: Cost of Non-performing Period with Credit Grade for $10,000 investment
Credit Grade A B C D E F G Total
Cost for first investment cycle $21.18 $30.21 $41.10 $52.81 $62.36 $75.16 $82.51 $38.82
Annual Cost $30.53 $44.33 $63.90 $88.47 $111.77 $140.86 $172.91 $60.74

Overall, lenders should consider subtracting 0.31% to 1.73% for non-performing periods from their expected yield to arrive at a more realistic yield expectation.

Key Takeaways

  • Lending Club continues to focus on listing loans of high quality credit grade.
  • Over 45% of low quality loans are never issued after being listed.
  • No return during the investment lockup while Lending Club deciding on issuing loans reduces expected yield by 0.31% to 1.73% for the investment portfolio.

Download PDF Abstract and Share

PeerCube provides custom analytics services in peer to peer lending domain. Please contact us to discuss how we can help meet your needs.

Comments: (1)

MB | Monday January 5, 2015, 12:57 pm

I've got to say, coming from my normal activities of trading stocks, options, and futures... Lending Club is KILLING me with how slow they are. I put $100 into my account two weeks ago and I'm still waiting for these stupid loans to get "approved." Two weeks of "dead money" is so *NOT* ok for me. I'll stick with this batch and see what happens, but I'm most likely not putting any more cash in. It's just too boring.

Join the Conversation

Trading Delinquent Notes, Part 2: Needle in the Haystack

September 5, 2016, 3:20 pm

Selling Delinquent Notes on Lending Club Folio Secondary Market, Part 1: Loss Aversion

August 27, 2016, 1:56 pm

Six Steps to Automated Selling on Lending Club Folio Secondary Market

August 7, 2016, 2:00 pm

Enhancements to Automated Note Selling on Lending Club Folio Secondary Market

July 31, 2016, 6:59 pm

Reading List: Securitization, Forecasting, and Food

July 24, 2016, 4:26 pm

Predicting Demand on Lending Club Retail Platform from Loan Availability Data

July 8, 2016, 9:25 am

Loan Supply and Demand Information for Lending Club Retail Platform

July 5, 2016, 10:58 am

What is your Loan Selection Strategy?

June 21, 2016, 3:13 pm

Automated Buying of Notes on Lending Club Folio Secondary Market

June 12, 2016, 7:05 pm

How to automate Note Selling on Lending Club Secondary Market with PeerCube?

April 2, 2016, 9:55 am

Chart of the Day: Seasonal Trend in Lending Club Charge Off Rate

December 16, 2015, 2:50 pm

Chart of the Day: Lending Club Charge Off Rate with 2015 Payment Month by Credit Grade

December 7, 2015, 11:25 am

A Decision Tree Approach to determining allocation to P2P Lending in your Portfolio

October 12, 2015, 11:14 am

Lending Club FOLIOfn Secondary Market: Penny Note Strategy based on Lowest Ask Price

March 5, 2015, 10:16 am

Lending Club FOLIOfn Secondary Market: Distribution of Available Attributes for Listed Notes

February 23, 2015, 10:39 am

Lending Club Secondary Market: Profitability of Trade and Recovery Rate with Loan Status at Listing

February 16, 2015, 11:04 am

Best Practices for Automated Lending on Lending Club and Prosper Platforms through PeerCube

February 9, 2015, 10:40 am

Prosper Loans Historical Listings: Prosper Ratings, Charge Offs and Performance

February 2, 2015, 11:57 am

Lending Club Secondary Market: Loan Vintage and Loan Status at Listing

January 26, 2015, 2:11 pm

Prosper Loans Historical Listings: Default Rate, Originations, Rating and Days Past Due

January 19, 2015, 1:39 pm

Credit Scoring and Models: Decision Trees

October 2, 2014, 11:35 pm

Lending Club Portfolio Analysis: Updated for Trading Notes

September 26, 2014, 1:03 pm

Cognizant Report on Marketplace Lending: A Critical Review of the Study

August 18, 2014, 11:52 pm

A Conversation with PeerCube User: Getting Started, Experience, and Strategy

August 10, 2014, 9:47 pm

Guest Post: Statistics and Emotions in Selling Lending Club Notes

August 3, 2014, 10:24 pm

Introducing Self-service Past Performance Data Analysis Tool

July 28, 2014, 10:45 pm

Mad Rush at Lending Club Loan Release Time: Part V - Loan Term with Time to Fund

July 14, 2014, 12:01 am

Mad Rush at Lending Club Loan Release Time: Part IV - Interest Rate with Time to Fund

June 30, 2014, 12:59 am

Mad Rush at Lending Club Loan Release Time: Part III - Delinquency Rate and FICO Score Change

June 22, 2014, 10:09 pm

Mad Rush at Loan Release Time: Part II - Loan Performance with Time to Fund

June 15, 2014, 11:20 am

Mad Rush at Lending Club Loan Release Time: Part I

June 8, 2014, 10:11 pm

Lending Club Loan Listings, Issuance, and Impact on Yield from Non-performing Period

May 31, 2014, 2:49 pm

Early Repayment of Loans and Impact on Lenders' Yield at Lending Club

April 28, 2014, 12:00 am

Lending Club Loan Default Rate and Returns: Two Years is a long time in the life of a Loan

March 24, 2014, 9:43 am

My prosperous Prosper experience

March 4, 2014, 10:35 am

FICO Score Trends and Defaults for Lending Club Loans

February 17, 2014, 10:43 am

Lending Club Loan Availability in Second Half of 2013

January 5, 2014, 11:53 am

PeerCube Update

December 2, 2013, 9:36 pm

Lending Club Loans - Positive ROI for Two-third of All Loans

July 7, 2013, 6:54 pm

Impact of Changes in Lending Club Credit Criteria on Credit Grade - Six Months After

June 30, 2013, 11:11 pm

Is Lending Club still self-funding loans?

June 23, 2013, 10:49 pm

Lending Club Loans - What difference a year of maturity makes?

June 16, 2013, 6:32 pm

Lending Club Loans and Credit Cards Default Rate

June 9, 2013, 3:31 pm