Investor tips and P2P lending: Investing with LendingClub

The skills I demoed here can be learned through taking Data Science with Machine Learning bootcamp with NYC Data Science Academy.

Executive Summary

Online Peer-to-peer (P2P) lending is an innovative channel that connects borrowers who need money with lenders who seek competitive returns on investment. In this blog post, we will discuss the P2P lending business model, focusing on LendingClub which is a leading player in the industry. Furthermore, we will introduce data science techniques such as classification models to help investors generate higher returns by identifying high-risk loans. For low-grade loans (grade D or below), the classifiers are able to improve the average return from -1.4% to 7.6%.

The Meteoric Rise of P2P Lending

P2P lending uses technology to operate an online lending marketplace and provide match-making between lenders and borrowers. Its technology-based business model allows it to operate more efficiently and provide service at a lower cost than traditional financial institutes such as banks. As a result, borrowers can get money faster and cheaper while lenders can receive higher returns on investment.

Since its existence in 2005, P2P’s growth has been nothing short of meteoric. In the five-year period from 2009 to 2014, its market size exploded from $26 million to $1.7 billion.[1] Then from 2015 to 2019, the digital lenders doubled their market share again to the point where, by March 2019, a staggering half of unsecured personal loans were provided by these financial technology firms.[2]  

LendingClub is the world’s largest internet-based P2P lending company. The company enables borrowers to take out uncollateralized personal loans between $1,000 and $40,000. Borrowers pay back the loans in either 36 or 60 monthly payments with no penalty for prepayment. LendingClub charges origination fees between 1% and 6% of the loan amount.

Fixed interest rates for loans through the company range from 6.95% to 35.89%, depending on applicants’ risk profile. The interest rates are often lower than those from banks or credit cards. As of the end of 2018, two-thirds of LendingClub loans are either “debt consolidation” or “paying off credit card loans”(see Figure 1).

LendingClub rose to fame in 2013, when they received a $125 million investment from Google. In the same year, former Morgan Stanley CEO John Mack and former Treasury Secretary Larry Summers joined LendingClub’s board.[3]  Since its founding in 2007, LendingClub has facilitated over $50 billion of loans for more than three million borrowers.[4] 

In addition to consumer lending, LendingClub is also an SEC-registered firm that offers loan-backed securities to not only institutional investors but also retail investors. This unique offering presents an opportunity for non-accredited investors to invest in consumer credits which historically were only accessible to accredited investors (e.g., high-net-worth individuals) or institutional investors (e.g., banks or investment firms). The company charges investors a service fee of 1%. 

LendingClub's proprietary algorithm to determine a borrower’s creditworthiness is rather prudent and rigorous.  It approves only ~10% of loan applications and assigns interest rates proportionally to credit risk based on credit score, payment history, requested loan size, debt-to-income ratio, and other factors. LendingClub allows retail investors to buy fractions of loans that are issued by the platform. This gives investors the flexibility to better manage risk and reward by investing in a mixed range of interest rates and in different loans. 

How to Invest on LendingClub

Investors can choose which loans to invest in on LendingClub’s website just like the way they shop online. To enable investors to make better investment decisions, LendingClub allows investors to select loans based on 29 features, including the grade of the loan, the term of the loan, the borrower’s debt-to-income ratio, among others.

Among these dozens of factors, are there any filters for investors to quickly find winners among the available loans to invest in? It turns out the answer is not as clear-cut as one would have hoped. To start, loan grade is a critically important feature because it determines the interest rate of the loan. About 80% of the loans fall under the top three tiers: A, B, and C, while more speculative tiers D and E make a minority. The riskiest tiers F and G account for less than three percent of the loan universe.

While it is tempting for investors to lend money to lower-grade borrowers at higher interest rates, the probability of default (and loss of principal as a result) for the lower-quality loans is also much higher. For example, grade F and G loans have default rates that are greater than 30%. This is a classic risk-reward trade-off: higher interest rates come with higher risk.

Loan Term

Loan term, or the length of a loan, is another key factor investors should consider because it determines how long it takes for investors to get back their investment. At a glance, 36-month loans seem to outperform 60-month ones as the 36-month loans generate a similar median return on investment (ROI) with more consistency. However, the difference in ROI expectation is driven by the fact that 36-month loans consist of a higher proportion of high-grade (A, B, and C) loans. 

As illustrated by the loan grade and loan term examples above, loan features are interconnected; there is no magic bullet for investing on the LendingClub platform. As a matter of fact, even if an investor invests only in high-grade loans, he or she may still lose up to 100% of the investment. It is apparent that univariate and bivariate analyses are not enough to create a sound investment strategy. 

Use of Machine Learning to Improve Investment 

Due to the interconnectivity of known features, we employed machine learning classification algorithms to predictively categorize high-risk and low-risk loans, as defined by a loss of 20% on the principal. Loss on investments can be expected no matter what the venture, however our primary investment strategy is risk aversion and avoidance of high-risk loans.

As such, it would be advantageous to be able to predict low-risk loans (ROI > -20%) and high-risk loans (ROI < -20%). Although seemingly arbitrary, The cutoff of -20% ROI was selected based on the 25th percent quartiles shown in Figure 8. For Grades A-C, more than 75% of all loans resulted in a profit (+ROI), whereas losses were more frequent in Grade D-G, the more profitable loans. 

Classification algorithms used in the present case-study included logistic regression and eXtreme gradient boosting (XGBoost) tree-based models. Logistic regression was used because it is efficient, highly interpretable (doesn't require input scaling), and is easy to regularize and train.

However, the model is limited to linear problems, which is unknown in the current study. Alternatively, the tree-based XGBoost model was implemented as it is more robust when solving a nonlinear problem, however, this flexibility comes at a great cost computationally as multiple hyperparameters require tuning. 

The ultimate goal of our classification algorithm was to avoid false positives, ie. misclassifying high-risk loans as low-risk. False negatives were considered less harmful as they represented a loss of potential profit, not actual investment loss.

Key Metrics

Therefore, two key metrics were used to evaluate the accuracy of our models: (1) precision, the fraction of actual positives of all true and false positives; and (2) false discovery rate (FDR), the fraction of incorrectly predicted positives of all true and false positives. Based on the selected -20% ROI threshold, low-risk loans constituted a majority of the loans (83.8%) - high-risk loans made up only 16.2% - creating an imbalanced classification problem. 

While multiple techniques are available to address data imbalance such as down-sampling the majority class, or up-sampling the minority class, both classification packages in SKLEARN possess parameters within the algorithms that address imbalance instead of tweaking the data fed into the models  (Logistic: class_weight; and XGBOOST: scale_pos_weight).

The implementation of these parameters improved the False Discovery Rate (Table 1). The null model, assuming all loans were low-risk loans, would produce an FDR of 16.2%. Without addressing data imbalance, logistic regression and XGBoost models resulted in FDRs of 16.2% and 15.9% respectively; while tuning the class_weight and scale_pos_weight dramatically improved the FDR to 9.3% and 9.2%, respectively.

Following hyperparameter tuning of both Logistic Regression and XGBoost, both models improved the precision from 83.8% (null model) to 90.7% and 90.8%, respectively; indicating that approximately 90% of the loans identified as a low-risk loan (ROI > -20%) were, in fact, a low-risk loan (Table 2). 

Gain

Finally, feature importance as defined by the gain, ie. the improvement in accuracy brought by the specific feature to the branches the feature is on is presented (Figure 9).

Across all features available to the investor, the top five features contributing to the accuracy of the model include (1) grade; (2) whether or not the loan term limit is 60mo; (3) interest rate; (4) whether the borrower rents their home; and (5) whether the income of the borrower is non-verified.

Despite the interconnectivity of the features available to the investor, grade, loan-term length, and interest rate appear to overwhelmingly contribute to the outcome of the loan. This is reassuring as it indicates the proprietary LendingClub grading system provides some indication about the performance of a loan. However, a real-world case study would better articulate the utility of machine learning. 

CASE STUDIES

Case Study 1 - Power of Diversity:

Despite the overwhelming contribution of loan grade on the outcome of the loan, not only is a profit not guaranteed, but it is possible to lose 100% of the principal regardless of the grade, as noted in Figure 8. Nobel-prize winning economist Harry Markowitz developed a heuristic, the Modern Portfolio Theory (MPT), to minimize the effect of risk.

The central thesis of MPT is allocating financial risk across multiple investments in an effort to sufficiently reduce such risk, perhaps captured best by the idiom ‘do not put all your eggs in one basket’. Take stocks, for example, a collection of multiple stocks have a lower risk than a single stock does. 

Regarding the available LendingClub data set, diversification can occur by (1) increasing the number of loans, and (2) diversifying the grade of the loan. To assess the baseline approach of diversification by the number of loans, simulated portfolios of 20 and 100 completed Grade A loans were randomly selected, repeating 1,000 times.

The distribution of the ROI of the portfolios is found in Figure 10. In this example, increasing the number of loans stabilized the ROI of the investment (Mean ROI: 5.2%±1.4% vs. 5.2%±3.3%), and minimizing the loss of the worst performing portfolio (-1.0% vs. -8.5%).  

Risk Diversification

Alternatively, risk diversification across loan grades had, on average, a deleterious effect on ROI of the simulated portfolios when comparing 100 grade A loans, and 100 mixed grade loans. While the best performing mixed grade portfolio saw a 12.7% ROI compared to just 9.3% of the grade A portfolio, on average, the grade A portfolio outperformed the mixed grade counterpart (Mean ROI: 5.2%±1.4% vs. 1.0%±3.5%) and minimized the loss of the worst performing portfolio (-1.0% vs. -8.7%).

Case Study 2 - Attempt to maximize ROI with the use of XGBoost Classifier:

The previous case study found that diversification across loan grades did not minimize risk, and in fact likely increased risk; this result is possibly due to the high rates of charge off of high-risk loans (Grade D-G) as noted in Figure 5, despite the higher interest rates.

Therefore, it may be advantageous to use machine learning techniques to predict profitable high-risk loans. As such, the second case study sought to compare simulated portfolios (n=1000) of the following loan structures: (1) 100 grade A loans; (2) 100 mixed grade loans; and (3) 100 mixed grade loans randomly selected from predicted low-risk loans (ROI > -20%).  Table 3 and Figure 12 highlights the observed differences.

Our predictive classification algorithm improved risk diversification across loan grades such that it improved portfolio ROI compared to grade A portfolios by, on average, 1.5%; the best performing portfolio outperformed the grade A portfolio by 6.3% while nearly eliminating the downside risk (worst portfolio: -2.0% vs .-1.0%, respectively). Compared to the original mixed grade portfolios, the use of the classifier improved the mean portfolio ROI by 5.5% while improving the worst-case scenario ROI by 6.7%. 

Case Study 3 - Where is the Benefit of the Classification Model Observed:

We performed a third case study to better understand the effectiveness of the predictive classifier across grades, and how that might have contributed to the results seen in the second case study. As such, we compared simulated portfolios (n=1000) of the following loan structures: (1) 100 low-risk loans (Grade A-C), with and without the use of the classifier; and (2) 100 high-risk loans (Grade <C), both with and without the use of the classifier.

Results from the present case study are found in Table 4, Figures 13 and 14. For low-risk loans, the use of the classifier had negligible results when compared across average ROI, and ROI of the worst- and best-performing portfolios. However, improvements in ROI with the use of the classifier are largely observed in the lower grade loans. Most significantly, while investing in high-risk loans resulted in a loss of principal on average, our predictive classifier produced a mean portfolio ROI of 7.9%, a 9% increase. 

Future Work

One area we would like to improve in the future is to back-test our models. For example, we can train the models using 2007 to 2015 data and observe how accurate they are at predicting outcomes of the loans that were issued in 2016.  In addition, the lending club dataset has its inherent limitation because almost all loans were issued during an economic expansion post-2008 financial crisis. To make our models robust enough to predict loan outcomes under any economic conditions, we would need data for at least a full business cycle. 

About Authors

Jamie Anderson: LinkedIn

Jon Harris: LinkedIn

Vincent Ji: LinkedIn

Joe Lu: LinkedIn

About Authors

Vincent Ji

Vincent is a data scientist and a former research data associate at Bridgewater Associates. Prior to that, he was an associate at BlackRock, focusing on data analytics, business strategy, and implementation. He started his career as a management...
View all posts by Vincent Ji >

Jon Harris

Jon is a certified Data Scientist and accomplished quantitative healthcare researcher with real-world experience in research methodologies, interpreting experimental results data, statistical and machine learning modeling, and creating data-driven narratives for multi-level stakeholders. Looking to utilize my strong...
View all posts by Jon Harris >

Joe Lu

Joe Lu is a NYC Data Science Fellow with a double bachelor’s in mathematics and economics from Cornell University, and a master’s in computational finance from Carnegie Mellon University. He also worked in the financial industry for several...
View all posts by Joe Lu >

Leave a Comment

No comments found.

View Posts by Categories


Our Recent Popular Posts


View Posts by Tags

#python #trainwithnycdsa 2019 2020 Revenue 3-points agriculture air quality airbnb airline alcohol Alex Baransky algorithm alumni Alumni Interview Alumni Reviews Alumni Spotlight alumni story Alumnus ames dataset ames housing dataset apartment rent API Application artist aws bank loans beautiful soup Best Bootcamp Best Data Science 2019 Best Data Science Bootcamp Best Data Science Bootcamp 2020 Best Ranked Big Data Book Launch Book-Signing bootcamp Bootcamp Alumni Bootcamp Prep boston safety Bundles cake recipe California Cancer Research capstone car price Career Career Day citibike classic cars classpass clustering Coding Course Demo Course Report covid 19 credit credit card crime frequency crops D3.js data data analysis Data Analyst data analytics data for tripadvisor reviews data science Data Science Academy Data Science Bootcamp Data science jobs Data Science Reviews Data Scientist Data Scientist Jobs data visualization database Deep Learning Demo Day Discount disney dplyr drug data e-commerce economy employee employee burnout employer networking environment feature engineering Finance Financial Data Science fitness studio Flask flight delay gbm Get Hired ggplot2 googleVis H20 Hadoop hallmark holiday movie happiness healthcare frauds higgs boson Hiring hiring partner events Hiring Partners hotels housing housing data housing predictions housing price hy-vee Income Industry Experts Injuries Instructor Blog Instructor Interview insurance italki Job Job Placement Jobs Jon Krohn JP Morgan Chase Kaggle Kickstarter las vegas airport lasso regression Lead Data Scienctist Lead Data Scientist leaflet league linear regression Logistic Regression machine learning Maps market matplotlib Medical Research Meet the team meetup methal health miami beach movie music Napoli NBA netflix Networking neural network Neural networks New Courses NHL nlp NYC NYC Data Science nyc data science academy NYC Open Data nyc property NYCDSA NYCDSA Alumni Online Online Bootcamp Online Training Open Data painter pandas Part-time performance phoenix pollutants Portfolio Development precision measurement prediction Prework Programming public safety PwC python Python Data Analysis python machine learning python scrapy python web scraping python webscraping Python Workshop R R Data Analysis R language R Programming R Shiny r studio R Visualization R Workshop R-bloggers random forest Ranking recommendation recommendation system regression Remote remote data science bootcamp Scrapy scrapy visualization seaborn seafood type Selenium sentiment analysis sentiment classification Shiny Shiny Dashboard Spark Special Special Summer Sports statistics streaming Student Interview Student Showcase SVM Switchup Tableau teachers team team performance TensorFlow Testimonial tf-idf Top Data Science Bootcamp Top manufacturing companies Transfers tweets twitter videos visualization wallstreet wallstreetbets web scraping Weekend Course What to expect whiskey whiskeyadvocate wildfire word cloud word2vec XGBoost yelp youtube trending ZORI