RateLadder Loan Performance According to Prosper | P2P Lending, Peer to Peer Lending, People to People Lending

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 periodNet income (accrued)Net defaultsNet gain/lossNo. of
loansPrincipal
loanedAvg.
interest ratePayments
receivedLoan valueAPYAmountAPYAmountAPYAmount149$9,547.1518.35%$2,279.35$7,812.3618.10%$656.421.46%$107.2416.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.

Blog Traffic ExchangeRelated Posts

  • In Defense of Living Off DividendsLiving 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………
  • New Loan Funded — payoff current loan and new invest on business — $25,000 at 29.00% — E Credit — DTI 37%My very first E credit loan… A new loan funded (payoff current loan and new invest on business — $25,000 at 29.00%). I participated via a manual bid (lured by the excellent extended credit and interest rate?). The borrow had E credit and 37% DTI. As a reminder my standing orders only……
  • The WealthBoy Strict ROI for Prosper LendersWealthBoy, 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……
  • Prosper Ordered to Cease and Desist by SEChttp://www.sec.gov/litigation/admin/2008/33-8984.pdf It appears to me that the ruling is that they have been selling unregistered securities without a license.  What does that mean for the lenders?  Doesn’t the board and company officers have some personal liability too? There is some discussion at prospers.org: http://www.prospers.org/forum/prosper_order_to_cease_and_desist_by_sec-t10903.0.html No one seems sure just yet… SEC: UNITED……
  • Prosper.com and Quicken — The workable solution for playmates that don’t get along.Prosper.com and Quicken (or Money) do not play nicely. In fact, they can be downright burdensome to make them bridge the gap. Here I present my workable solution, but this should be addressed by Quicken, Money, and Prosper.com  The heart of the problem is that Quicken doesn’t understand the Prosper.com model… Sure……

blog traffic exchangeRelated WebsitesOnline StoresIf you liked this article, vote for it on del.icio.us and stumbleupon.

Categories:

Tags:

Leave a Reply

Your email address will not be published. Required fields are marked *