WealthBoy, whom I met at Prosper Days, has just released The WealthBoy Strict ROI for Prosper Lenders – an open source, sql based ROI calculation for Prosper Lenders.  His calculation makes use of the public and private data files from Prosper.  He was inspired by his Prosper Blog post: The Rule of 72 on Prosper.

TotalROI = (Total Interest Received – Fees – Losses on Defaults) / (Total Loan Originations – Reinvested Loans) 

For RateLadder that equates to

Screen Name: RateLadder_com
Total Bid Count: 324
Total Reinvested Bids: 115
Total Originations (total amount loaned): $16,296.50
Total Investment (total amount loaned excluding reinvested bids): $10,500.92
Total Income (total principal and interest less fees): $6,067.12
Total Profit (total interest less fees and defaults): $1,138.48
Total ROI: 10.84%
Average Loan Age: 11.81 months
Annualized ROI: 11.02%

For the initial release he made no assumptions about the value of late loans. But… 

It is an open source, sql based ROI calculation for Prosper Lenders…  With the calculation being open source it is clear (assuming you can read through about 250 lines of SQL exactly how the calculation is performed…  As his sounding board during development I can confirm that WealthBoy put a lot of work into this project.  I think this is a great addition to the Prosper tools.

At the moment it takes about 45 seconds to perform the calculation for the largest lenders at ProProsper…  It will only take longer as more payments are made.  This performance issue is the main reason I have yet to implement it at ProProsper as it will take some back-end engineering on my part to calculate the values in an efficient way in terms of server resources. I expect to add it to ProProsper, but currently I am not able to find the time to do so…  Hopefully soon… Or maybe Eric or LendingStats can add it first…

Anyway, I encourage you to check it out.  Well Done WealthBoy!

Related Posts

• Prosper Corrects Mistake With Refunds to Lenders and Group Leaders Back in January we told you how Travler505 had brought it to Prosper's attention that Prosper was not operating according to the lender and group leader agreements (Prosper Honors Agreements And Pays Interest)... Yesterday, they finished the work and released the last of the refunds: Completion of Refunds to Lenders......
• Another Error in a National Newspaper on P2P Lending Apparently this is fact checking Wednesday. In the USA today is the article: peer-to-peer lending hits its stride In this article a Prosper Lender is quoted... Default rates are lower for peer-to-peer loans than for other consumer loans. Cory Moore became a lender on Prosper.com this year. To hedge against defaults,......
• Why Would a Lender Want to Join a Group? -- Prosper Group Analysis Part 2 Previously I posed several questions on prosper groups.  Here is the second installment of answers.  Why would a lender join a group?  I think that the answer must be you are getting a higher ROI and/or that you are supporting some ethical, political, collegiate, or ??? value.  Given that I......
• Major Prosper Update -- Just in Time for Prosper Days  Prosper's First Anniversary First of all, let's take a moment to celebrate. On Feb 5, Prosper turned one year old. In our first year, exactly 7048 loans with a value of $35,166,711 were made on the Prosper marketplace. If you're coming from the perspective of a massive bank, $35M might......
• Quicken vs Prosper -- ROI Accounting It took a little tinkering, but I finally hit upon the perfect way to integrate Prosper (or LendingClub or ...) with Quicken (or Money or ...) given the current lack of integration between the services (see here if interested.) Since implementing that solution I have had defaulted debt sold. With enough......

Related Websites

• The Debate - Renting Vs Owning Currently, there are two different sides emerging in the debate over the benefits of homeownership to the general public.  The housing crisis of 2008 has challenged conventional wisdom and has changed the way that many view homeownership.  On one side of the debate are the individuals that claim homeownership is......
• What Is Social Capital? When I was at Prosper's annual conference, there was a lot of buzz around the term "social capital." I thought I was alone in wondering what it was. However, when I caught up with Wealth Boy, I found that he hadn't heard the term used before. I'm going to go......
• Are Hidden Fees Keeping You From Meeting Your Financial Goals? Hidden fees are nasty little critters that can eat away at your credit card balances, or your checking accounts and you may never be the wiser. If you are stuck wondering where it all goes at the end of the money, it's time to do some investigating to find out......
• "Avatar" rules box office for seventh weekend LOS ANGELES - "Avatar" edged closer to the record North American haul of "Titanic" after earning $30 million during its seventh chart-topping weekend, distributor 20th Century Fox said on Sunday James Cameron's 3-D sci-fi spectacular has grossed $594.5 million to date and should surpass the $601 million tally of the......
• Cooper in Florida Returning for His Senior Season Riley Cooper, a receiver from Florida, who has made plans to play baseball for the Rangers in Texas has decided to return to the football field for a senior playing season. Urban Meyer, coach for the Florida Gators, made the announcement regarding Cooper's decision on this past Tuesday. This was......

Online Stores

• Ghs Open G Tuning Bright Bronze Slide Acoustic Guitar Strings Acoustic Musical Instruments
• Open Pit BBQ Sauces Outdoor Cooking & Eating Yard, Garden & Outdoor Living Nursery
• Open Shelf Greenhouses & Terrariums Garden Structures & Fencing Yard, Garden & Outdoor Living
• Open Back Banjo String Acoustic Musical Instruments
• Open G Slides Acoustic Musical Instruments

If you liked this article, vote for it on del.icio.us and stumbleupon.


Categories:

Statistics, Tools