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 -
New Prosper Changes Digested My apologies for the verbatim post last night... But it was late... Here are the changes that affect me as a lender and 3rd party developer... On the Lender screen in the active loan summary there has been added a break down of payments received as well as a summary...... -
Track Prosper Referrals with ProProsper Followup Just a quick followup to the Prosper referral tracking with ProProsper. Here is the email sent to me this morning detailing my active listings... Referral bepmike48   Listing: Guarenteed Money for Simple loan Amt=5000.0000(25.00) CG=A DTI=0.09 Open For Duration Lender Rate=0.0625 Referral bigdog1   Listing: deck and bills...... -
Big Prosper Changes -- 2nd Loans, Authenticated API, 0% on AA, 36% Max Rate, and Portfolio Plans Big changes for Prosper today in new release... Borrowers can now have second loans Authenticated API for access to extended credit and a lender's loans for lenders 0% servicing fee on AA credit In states where rates aren't capped the new maximum is 36% Portfolio Plans might be the biggest change of...... - Prosper Bid Sniping -- The Only Way Large Lenders Don't Move the Market Bid sniping is watching a loan until the last possible moment and stepping in a bidding. This can be done on both loans that are fully funded and loans that are not yet fully funded. This is the only optimal strategy for large lenders bidding on non auto funding loans. ......
- 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......
Related Websites -
Marriage and Money: Roth IRAs and 401ks This series was inspired by the recent marriage in the family. I organized some information with my brother in law and new sister in law in mind, though the information can apply to others looking at their finances. If you find these tips to be useful, please share them. Seeing...... - My Mortgage Closing and Effects of the Credit Crisis After a long and tiring weekend of closing, moving and unpacking I finally have my wireless internet set up and I'm ready to get back to my personal finance blogging. I imagine most of my posts will be looking forward towards my financial future as a home owner, but first......
- Prosper and high-risk loans Jonathan over at My Money Blog posted on the possibility that returns on Prosper.com will drop as defaults increase. (Prosper.com is a site that facilitates person-to-person lending, giving borrowers a competitive rate by pitting lenders against each other auction-style.)Up until a couple of months ago my loans were performing well,......
- Revealing the Keys to Prosper Success Earlier this week, I defended the Prosper's business viability. I spent two posts rebutting the idea that it might not be a good investment. Just yesterday, I discussed the Prosper mistakes I've made. Today, I will share with you what I've learned. Hopefully 5 minutes from now you'll be......
- 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......
Categories:
0 comments ↓
There are no comments yet...Kick things off by filling out the form below.
Leave a Comment