WealthBoy: The WealthBoy Strict ROI for Prosper Lenders
Casey
· 1 year ago
I'm intrigued. Can you run the stats on user:vegibenz (my screenname)?
RateLadder
· 1 year ago
Looks good... I will be adding it to ProProsper, but I am swammped with work...
Thanks for putting in the work and making the calculation open source.
WealthBoy
· 1 year ago
Screen Name: vegibenz Total Bid Count: 56 Total Reinvested Bids: 30 Total Originations (total amount loaned): $2,895.48 Total Investment (total amount loaned excluding reinvested bids): $1,378.58 Total Income (total principal and interest less fees): $1,609.89 Total Profit (total interest less fees and defaults): $100.80 Total ROI: 7.31% Average Loan Age: 23.55 months Annualized ROI: 3.72%
WealthBoy
· 1 year ago
I'm looking forward to seeing the WBSROI on ProProsper. Here are your stats:
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%
Stephen Wilson
· 1 year ago
Hi Wealthboy,
neat computation! I really wish Prosper would put more effort into creating some ROI stats for us. When you have some time, would you mind running it mine: vegasstephen
Thank you!
WealthBoy
· 1 year ago
Screen Name: VegasStephen Total Bid Count: 90 Total Reinvested Bids: 30 Total Originations (total amount loaned): $4,590.09 Total Investment (total amount loaned excluding reinvested bids): $3,090.09 Total Income (total principal and interest less fees): $1,720.40 Total Profit (total interest less fees and defaults): $475.50 Total ROI: 15.39% Average Loan Age: 10.43 months Annualized ROI: 17.71%
Stephen Wilson
· 1 year ago
Thanks, Wealthboy!
It's great to have a computation on ROI that I can work with. One of these days I'm hoping someone produces some standard ROI numbers, such as YTD ROI, quarterly, annual, and eventually 2 year, etc.
I really appreciate you taking the time to do that! It looks like the basic problem that exists for LS and ericss with repurchased loans is still a factor I have to consider. I have 2 loans marked "repurchased" by Prosper that are part of the lawsuit, but they've marked them as defaulted as far as loan losses are concerned. I have $95.81 in losses from 2 loans in this category that make my actual ROI lower.
Thanks, and take care!
Chrisfs
· 1 year ago
Looks good, will it port easily to MySql ? that's what I have access to (no pun intended...)
WealthBoy
· 1 year ago
Chrisfs:
There are some subtle differences in the syntax between MySQL and SQL Server, but it should be doable. You'll need to use regular tables instead of temp tables and table variables as I've done. It may take a bit of work to get the reinvestment cursor coded for MySQL as well.
WealthBoy
· 1 year ago
Stephen:
Interesting... I was looking at one such loan for RateLadder that he told me had been sold to a debt buyer. On the site it appeared it had been marked as a repurchase, I could have sworn that in the data export it showed up as a default. Therefore it behaved as it should have within the ROI calculation. However, I took a look at the detail for your account, and they have indeed been marked as repurchased loans. In fact, none of your loans show up as defaults and according to the data you have three repurchased loans.
I suppose it's something else that needs to be added to the list of issues with my ROI calculation. Of course, this one isn't my fault. :) There's nothing I can do about Prosper flagging them as repurchased loans when in reality they are defaults. Perhaps they might be able to do something in the future to resolve this issue. Perhaps a new status to add (Repurchased by Debt Buyer)? Even if they do want to mark them as repurchased loans, they could at least display the proper NetDefaults value in the LoanPerformance table. Thanks very much for bringing it to my attention.
RateLadder
· 1 year ago
The loan we were looking at was defaulted and had nothing to do with my repurchased loans... I have 6 loans in the lawsuit... so similarly my numbers are also lower.
WealthBoy
· 1 year ago
That's right, it was a defaulted loan that had been bought buy a debt buyer, not one that was in the lawsuit.
All Comments
Thanks for putting in the work and making the calculation open source.
Total Bid Count: 56
Total Reinvested Bids: 30
Total Originations (total amount loaned): $2,895.48
Total Investment (total amount loaned excluding reinvested bids): $1,378.58
Total Income (total principal and interest less fees): $1,609.89
Total Profit (total interest less fees and defaults): $100.80
Total ROI: 7.31%
Average Loan Age: 23.55 months
Annualized ROI: 3.72%
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%
neat computation! I really wish Prosper would put more effort into creating some ROI stats for us. When you have some time, would you mind running it mine: vegasstephen
Thank you!
Total Bid Count: 90
Total Reinvested Bids: 30
Total Originations (total amount loaned): $4,590.09
Total Investment (total amount loaned excluding reinvested bids): $3,090.09
Total Income (total principal and interest less fees): $1,720.40
Total Profit (total interest less fees and defaults): $475.50
Total ROI: 15.39%
Average Loan Age: 10.43 months
Annualized ROI: 17.71%
It's great to have a computation on ROI that I can work with. One of these days I'm hoping someone produces some standard ROI numbers, such as YTD ROI, quarterly, annual, and eventually 2 year, etc.
I really appreciate you taking the time to do that! It looks like the basic problem that exists for LS and ericss with repurchased loans is still a factor I have to consider. I have 2 loans marked "repurchased" by Prosper that are part of the lawsuit, but they've marked them as defaulted as far as loan losses are concerned. I have $95.81 in losses from 2 loans in this category that make my actual ROI lower.
Thanks, and take care!
There are some subtle differences in the syntax between MySQL and SQL Server, but it should be doable. You'll need to use regular tables instead of temp tables and table variables as I've done. It may take a bit of work to get the reinvestment cursor coded for MySQL as well.
Interesting... I was looking at one such loan for RateLadder that he told me had been sold to a debt buyer. On the site it appeared it had been marked as a repurchase, I could have sworn that in the data export it showed up as a default. Therefore it behaved as it should have within the ROI calculation. However, I took a look at the detail for your account, and they have indeed been marked as repurchased loans. In fact, none of your loans show up as defaults and according to the data you have three repurchased loans.
I suppose it's something else that needs to be added to the list of issues with my ROI calculation. Of course, this one isn't my fault. :) There's nothing I can do about Prosper flagging them as repurchased loans when in reality they are defaults. Perhaps they might be able to do something in the future to resolve this issue. Perhaps a new status to add (Repurchased by Debt Buyer)? Even if they do want to mark them as repurchased loans, they could at least display the proper NetDefaults value in the LoanPerformance table. Thanks very much for bringing it to my attention.