OverviewThere are lot of different type of crowdfunding sites online where people come together to support non-profits (Kiva), projects (Kickstarter), and borrow and lend money (Lending Club, Prosper). With the crowdfunding portion of JOBS act, I believe crowdfunding will become more popular in a year or two.
Last year, while discussing the negligible interest rate on savings, an EMBA classmate brought my attention to Lending Club where lenders can earn attractive returns on their notes while borrowers can get unsecured loans, similar to credit cards, at attractive interest rates. In fact, LC loan statistics show that 68.50% of borrowers use the loan to consolidate debt or pay off their credit cards and 91.73% of lenders with 800+ notes earn returns between 6% and 18%.
Lending ClubAs I looked more into Lending Club, it appeared to be a very attractive alternative investment option. Having participated in equity market for almost two decades, it was my first opportunity to participate directly in debt market specially in consumer loans. LC also provides the export of their historical loan database and I saw the opportunity to use it to refine my knowledge of statistical and data mining tools and techniques.
One of the main risk from lenders' perspective is the risk borrower may not repay their loans. As there is no collateral for the loan (unsecured), there is very little recourse in such events other than relying on LC's recovery process. Though LC claims the overall annualized default rate is below 3%, objective of most lenders is to identify parameters that influence higher default rate or minimize default rate.
GoalsRecently, I thought why not share with my blog readers my analysis of the LC historical loan data, as analysis progresses. This may enable instant feedback and improvement in analysis and techniques.
The specific goals of historical loan data analysis are:
- Identify parameters that influence higher default rate or minimize default rate.
- Identify lending strategies that result in greater return compared to a randomly selected lending portfolio.
- Compute excess return versus excess risks in comparison to a benchmark.
I plan to use Microsoft Excel, Python, R, Google Fusion Tables, and Tableau Public as the basic tools for analysis and visualization. Any tips and tricks in using these tools are welcome.
In the next post, I will review the data contained in the loan database and define the default rate.
--- Promotion --- Send Large Files Up to 2GB - Free 14 Day Trial!