Hello! Community Page
- wealthboy.com Jump to website »
-
Subscribe -
Community
-
Top Commenters
-
Popular Threads
-
Recent Comments
- You do have to be careful when the stock is well-below your cost basis and you perform covered calls. Many investors write calls as soon as they buy the stock..........
- i agree with "pay down your loans with the highest rates first." cause i have a good experience by doing that
- Many banks are just simply unwilling to take on additional risk right now, even with those that have above average credit.
- There are many factors that the bank will take into consideration when assessing your application for a refinance. Sometimes, your application is rejected, even when you feel that your credit and...
- Even though the conversion will cost that much, I think it will be paid for some time and won't be taking that long. The benefits are great and people will be cool with this.
Jump to original thread »
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
... Continue reading »
1 year ago
1 year ago
Thanks for putting in the work and making the calculation open source.
1 year ago
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%
1 year ago
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%
1 year ago
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!
1 year ago
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%
1 year ago
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!
1 year ago
1 year ago
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.
1 year ago
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.
1 year ago
1 year ago