Why do I want to calculate my Internal Rate of Return (IRR)? To make sure it is higher than my cost of money – ergo a good investment. I claim that my cost of money is 5% which I can earn in an Internet savings account. So my IRR needs to be higher than 5% plus a risk premium. How does one calculate an IRR?
Well the real answer would require knowing with absolute certainty the default rates over time of Propser loan in your portfolio. Prosper data isn’t as old as the term length of the loans, so any default rate would simply be a guess. Since extended credit isn’t available it isn’t possible to isolate the data the same way you can with standing orders. Hence, any suggested default rate is a pure guess.
If I value the principle in the loans at 0 PV. In which case my entire principle $3,361.60 would have been used to generate $20.63 in interest. IRR clearly negative and clearly meaningless. So what is a better assumption?
My Prosper journey is at least 3 years long and hopefully lifelong. So I am going to define an IRR that I think has meaning and follow it over time.
My IRR is the current cash flows (monthly summary of money into prosper and generated by loans in interest payments) with an additional month in which the current account value minus in arrears loan value is used. My current account value according to Prosper is $3,440.16 and I have 0 late loans. Perhaps seeing the data will explain.
My monthly cash flows are
| Month | Interest Earned | Monies Added | Cash flow |
|---|---|---|---|
| 7/06 | $0.00 | ($200.00) | ($200.00) |
| 8/06 | $1.92 | $0.00 | $1.92 |
| 9/06 | $2.33 | ($200.00) | ($197.67) |
| 10/06 | $2.73 | ($1,231.17) | ($1,228.44) |
| 11/06 | $13.65 | ($1,430.43) | ($1,416.78) |
| 12/06 | $0.00 | ($300.00) | ($300.00) |
| 1/07 | $3,440.16 | $0.00 | $3440.16 |
Which generates an IRR of 1.11%. If my money were fully vested at inflow then this would be a pretty bad IRR. But in my experience money takes at least 3 weeks to turn into a loan, the loan takes 1 month to generate it’s first interest. Hence, my IRR has more meaning over time than at any one instant, particularly so early in the journey. I expect my IRR to increase steadily for at least one year and at most 3 years until it levels out. Propser thinks my historical performance is 15.38% for a net gain of $79.25. I fully expect my IRR to be greater than 10%.
I will be keeping this information on a page My Prosper IRR and revisiting over time.
Questions, comments, screams of anguish?
Related Posts -
8 Listing Strategies to get Best Prosper Loan Rate I have had several bloggers ask for advice on their listings or potential listings... One of them even joined my group and successfully received a $25K loan at an interest rate he was happy with... As a blogger the reputation of your blog has meaning for you both in terms...... -
My Prosper Internal Rate of Return Update (End of Jly 07) = 0.57% This is a RateLadder only IRR update. (An IRR lender âgameâ update is in the works.) I saw a big spike in loan 1 month late or more. Here is my permanent tracking page: http://rateladder.com/my-prosper-irr/ My Prosper IRR is defined as: Monthly cash flows with one extra month using the...... -
My Prosper Internal Rate of Return Update (End of Feb 07) = 12.86% for an Increase of 0.65% This is a RateLadder only IRR update. (An IRR lender "game" update is in the works.) Here is my permanent tracking page: http://rateladder.com/my-prosper-irr/ My Prosper IRR is defined as: Monthly cash flows with one extra month using the current account value minus any loans 1 month or more late. Current...... -
My Prosper Internal Rate of Return Update (End of Apr 07) = 3.57% for an Increase of 0.24% This is a RateLadder only IRR update. (An IRR lender âgameâ update is in the works.) Here is my permanent tracking page: http://rateladder.com/my-prosper-irr/ My Prosper IRR is defined as: Monthly cash flows with one extra month using the current account value minus any loans 1 month or more late. Current...... -
My Prosper IRR Update Normally, I expect to update My Prosper Internal Rate or Return twice a month: last day of the month for account value and the day I get the monthly statement. Since posting My Prosper IRR yesterday, I have gotten my monthly statement; hence, there will be 3 updates this month (yesterday, today,......
Related Websites -
Reader Question -Should I Pay Off My Car Loan With A 0% Interest Credit Card? Got a question yesterday from one of the readers: I currently have about $11,000 left on my car loan at around 7% interest, but was thinking of getting a 0% balance transfer and paying it off. I understand that after the 0% period ends I will have to find another...... -
Peer to Peer Lending Sites: Companies Which Operate P2P Lending Websites The peer to peer lending industry has grown dramatically during the last couple of years and the number of peer to peer lending sites (p2p lending sites) has grown dramatically. Companies such as Prosper.com and Lending Club have gained national media exposure and now these companies are originating tens of......
-
How to Beat the 10% Compounding Myth I had mentioned previously that for a number of reasons, it's very difficult to earn 10% interest on your money. However, I think I found a way to do it. Of course there's some risk involved. For those who get squeamish about the possibility of losing money, you might...... -
Keeping your Prosper.com money working Several people responded to my post on a Prosper.com vs ING return, in which I pitted a 4.25% online savings account return against lending the same amount at 8% on Prosper.com. The 4.25% online savings account outperformed the 8% loan over three years, because the interest in the savings account...... -
A loan of nonsense Kiplinger's Personal Finance, October 2005 issue, page 94, has a one-pager: "Lock in your loan?" The main point of the article is that it's not always a good deal to go from an adjustable-rate home-equity line of credit (HELOC) to a fixed rate one, despite the fact that the prime......
- Data Logging Rain Gauges Garden Dcor Yard, Garden & Outdoor Living Nursery
- The D35 Johnny Cash Commemorative Martin Right-Handed Acoustic Guitar Acoustic Musical Instruments
- Data Logging Infrared Thermometers Garden Decor Yard, Garden & Outdoor Living
- Cash Registers Banks, Registers & Vending Collectibles
- Manuals, Strategy Casino Collectibles
Categories:
Prosper.com, Statistics, Strategy
Tags:

2 comments ↓
Can you elaborate on what these cash flows are?
I added more detail to the cash flow table which might help, but here is a month by month break down…
07/06 — Initial funding of $200 to my prosper account
08/06 — $1.92 in interest
09/06 — $200 in funds added, $2.33 in interest
10/06 — $1,231.17 in funds added, $2.73 in interest
11/06 — $1,430.43 in funds added, $13.65 in interest
12/06 — $300 in funds added
01/07 — My Prosper account value minus 100% of any delinquent loans
Leave a Comment