I regularly write about the 2 methods of tracking my Prosper performance that I use: Quicken and IRR. It occurs to me that I haven’t said why I need to use these methods; which is to say, why is the Prosper tracking page inadequate.
To start with the easy, Prosper lacks integration with Quicken. This lack of integration forces me to manually enter transactions into Quicken. I have simplified my Prosper account in Quicken by rolling all loans together. Also, Prosper reports accrued interest (see example later) in the account balance. This creates an inflated account value from a pure Quicken tracking model..
To better understand why I use an IRR calculation let’s take a look at what Prosper claims is my loan performance…
| Loans starting during this period | Net income (accrued) | Net defaults | Net gain/loss | |||||||
| No. of loans |
Principal loaned |
Avg. interest rate |
Payments received |
Loan value | APY | Amount | APY | Amount | APY | Amount |
| 149 | $9,547.15 | 18.35% | $2,279.35 | $7,812.36 | 18.10% | $656.42 | 1.46% | $107.24 | 16.64% | $549.19 |
As previously stated, net income includes accrued interest. I think from Quicken and personal accounting perspective accrued interest has no place. After all, I don’t get to write off loss of accrued interest when a loan defaults.
Use of accrued interest on the performance page is speculative. It is the best possible assumption from a performance perspective. To be slightly facetious, all accrued interest will be paid and only the currently defaulted loans will default… leading to a net gain/loss that is completely unrealistic. It is only because accrued interest in included on the performance page that this hyperbole is valid. If it were only the net income actually received then it would be what has actually happened, but as is it is speculating as to future performance.
This is were my IRR calculation comes into play. It is my speculative look into the future trying to maintain an even (maybe even slightly negative) perspective. My IRR calculation takes actual cashflows and then uses the account balance (which includes accrued interest) as an outflow (as if you could liquidate your Prosper account on the spot) and the sum of all loans 1 month late or more as an inflow (as if all loans one month late or more are worthless). I then track this number through time to watch my Prosper performance.
I use Quicken to track exactly what has happened. I use the IRR calculation to speculate as to what will happen. I ignore the current RateLadder performance according to Prosper as it is a mixed picture.
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...... -
Adam Nash Merged with RateLadder to form the Ideal Quicken Solution (without Prosper integration)  I have found what I think is the most complete solution to the Quicken and Prosper dilemma, but that doesn't mean it is the best solution... Let me start with the negative and work to the positive... The problem with his solution is that it is too much work... I...... - In Defense of Living Off Dividends Living Off Dividends (aka WealthBuildingLessons (WAB) on Prosper) wrote a guest post on the Prosper Blog: Why I Love Prosper.com. The blog post has generated some heated comments due to one aspect of the post. WAB claimed "over 13% annualized returns". When questioned what his calculation actually was he said.........
- November 2007 Prosper Marketplace Survey with Commentary from Kirk Inglis CFO November 2007 Prosper People-to-People Lending Market Survey Membership and Loan Volume Statistics --------------------------------------------- 2007 2006 November November Year-to- Year-to- Since 2007 2006 Date Date Inception ---------------------------------------------------------------------- New Members 33,917 19,062 368,741 119,294 506,508 ---------------------------------------------------------------------- Funded Loans $6.4 $3.3 $74.9 $23.9 $103.3 million million million million million ---------------------------------------------------------------------- Average Loan Size......
- Prosper Honors Agreements And Pays Interest Just a touch of back story is needed on this one... Travler505 bought it to Prosper's attention that the way they were acting on payments in delinquent accounts was not in line the agreements that were in place at the time... In my opinion, he took an extreme route to......
Related Websites -
Is Your Checking Account A Free Checking Account? When people think about all the ways that they could be saving money, changing their checking account is not typically at the top of the list but it is possible that checking account fees are depleting the checking account by hundreds of dollars each year. In most cases, the checking...... -
Pay off student loan or save? This article is part of the Ask the M-Network series. Leah submitted a question and asked: I'm 28. I have 9% of my income going into a 401k, no credit card debt, a paid-off 9-year-old car, and 5 months expenses in savings (some of that earmarked for the next new-to-me...... -
The Difference Between A Secured Loan And An Unsecured Loan Many people that are attempting to manage their financial future effectively will eventually turn to a loan to obtain additional money for their financial needs. A loan can be used for many different things, such as purchasing expensive items, making costly additions or repairs to the home, or buying personal...... - 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......
- Best of the Rest: ING Direct Black Friday Sale Edition Hopefully most of you did not go out this morning, I think that would have been a big mistake. I have friends who go out early and buy 10 DVDs for "only" $7 each. But in the end, they spend $70 on something they don't really need. My suggestion is......
- New Balance Via Watches & Pedometers Running Deals
- Balance Man New Hit Bg Shoes Running Exercise & Fitness
- Balance New Womens Hit Bg Shoes Running Exercise & Fitness
- Balance New Womens Hit Bg Shoes Running Deals
- 930 Lx Performance Series Benches Strength Training Gym, Workout & Yoga Exercise & Fitness
Categories:
Prosper.com, Strategy, Tools
Tags:
0 comments ↓
There are no comments yet...Kick things off by filling out the form below.
Leave a Comment