As I was writing my Rule of 72 on Prosper article for the official Prosper Blog, I began to think about developing my own ROI calculation based on what I had written. I had attempted creating an ROI calculation once before that was based on actual payments received, but I became frustrated with the lack of the detail payment data in the LoanPerformance table of the private export. I took another crack at developing an ROI calculation based on actual payments, and think I’ve come up with something that’s reasonable. If you’re interested in the actual implementation, you may want to check out the technical details and link to the SQL code here:
Once I’ve constructed the tables necessary to calculate the payments that a lender has received, I have all of the information necessary to calculate the WealthBoy Strict ROI. The WBSROI performs two return calculations: TotalROI and AnnualizedROI. The TotalROI calculation is calculated by dividing the total profit (interest less servicing fees) by the total amount invested (which excludes reinvested loans). The calculation does not take into account the declining balances, hence the “strict” designation. If you have been lending successfully for a long time, it is certainly possible to have a TotalROI more than 100%. Here is the formula in a nutshell:
TotalROI = (Total Interest Received – Fees – Losses on Defaults) / (Total Loan Originations – Reinvested Loans)
The AnnualizedROI is calculated by dividing the TotalROI by the weighted average loan age and multiplying by 12. The weight for each bid is the amount lent as a percentage of the total originations. This may not be the best way to perform the AnnualizedROI calculation, but it was the best I could come up with. I believe the TotalROI is relatively indisputable, barring the errors in the payment calculations. The AnnualizedROI could probably use some enhancements.
I like the idea of having a strict ROI calculation that doesn’t account for the declining balances. Many lenders on Prosper may not even be aware of what a declining balance is. Others may know about declining balances, but they just want to know what kind of return they’ve received on the total amount they’ve invested. That is what the WealthBoy Strict ROI attempts to do, and I believe it does it reasonably well. If you are reinvesting loans, your strict ROI should be reasonably close to your average interest rate less fees and your default rate.
So what about late loans? Why aren’t they part of the calculation? Well, one of the nice things about of my calculation is that it really doesn’t take much more effort to account for the probability of late loans eventually defaulting. With the information provided in the calculation, you know the total investment and you know the total profit. All you need to do to account for late loans is to incorporate the loss estimation into the profit and presto! You have your new ROI including the probability of late loans defaulting.
I decided to exclude any default projections from the initial announcement of my ROI calculation. Although it probably wouldn’t take much more effort to incorporate it, I think there is something to be said for an ROI calculation that doesn’t make any kind of suppositions. The WealthBoy Strict ROI calculates how much went in and how much came out. It makes no assumptions about the future value of loans. I have left it to others to make whatever assumptions they wish to make about estimating defaults.
I do realize that not everyone has the expertise and/or resources to put together a Microsoft SQL Server database for analyzing Prosper data. Unfortunately, I don’t have a web application connected to my database so that people can see their WBSROI. If you would like me to provide you with your WBSROI, just post your screen name into a comment here. I’ll post the data in a responding comment. If I become overwhelmed with responses to the post, I may not be able to respond to requests any longer. If it does become a popular metric, perhaps someone with a popular stats site may be willing to add my calculations to their site. Here is what the WBSROI on my account looks like:
Total Bid Count: 45
Total Reinvested Bids: 3
Total Originations (total amount loaned): $2,250
Total Investment (total amount loaned excluding reinvested bids): $2,100
Total Income (total principal and interest less fees): $209.22
Total Profit (total interest less fees and defaults): $60.53
Total ROI: 2.88%
Average Loan Age: 1.76 months
Annualized ROI: 19.62%