Saturday, May 2, 2009

Prosper.com - 05/01/09 late loan stats update

Here's the May 1, 2009 update to to my Prosper.com late loan statistics charts.

These charts show statistics for the performance of all prosper.com loans. Each curve represents the set of loans that were created in one calendar month. The vertical axis is the fraction of those loans that have "gone bad", in other words are 1 month late or worse (up to and including default). The horizontal axis is the observation date. All data comes from Prosper.com's performance web page.

Click on the chart to see a larger clearer version.


Here's a chart of the same data in which each curve has been slid to the left to a common origin. The horizontal axis is now days since loan origination month.



Explanation of methodology can be found in my prior postings in this blog, and in forum discussions on the old prosper forum, now archived at www.prosperreport.com

For the "big picture" you can just look at that last chart. From the point of view of these performance statistics, Prosper.com loans run about 1150 days. (1 month before the first payment is due, 36 months during which payments are due, and another month before that last payment is declared 1 month late) The numbers aren't final for another 2 months, because it is possible for loans to recover during the next three months before the loan is charged off at the 4 month late point. Therefore about 1250 days is the final point. Look at the curves, and extend them to where you believe they will be at 1250 days.

Looking at the first year of Prosper.com loans, it is pretty clear that they're headed toward something like 42% bad. Loans that originated later (the shorter curves) are doing a bit better. They might end up around 35% bad. Big picture: On the average, these are junk loans. Caveat emptor. Any investor who doesn't realize this will do very poorly loaning money to folks who about 40% of the time don't pay you back!

This month, after a several month hiatus, Prosper has done more "unoriginations". For those of you who haven't followed these statistics for a long time, this requires some explanation. On the Prosper performance web page, they show a number labelled "loans originated". One might assume that this is the number of loans that were originated. It is not. This number goes down over time. Loans are from time to time removed from the set of loans described by these statistics. I track this, and count loans that are removed as having gone bad. (The name "unoriginated" comes from a word I learned in the third grade. In the old Sovient Union, people who were an embarassement to the government became "unpeople". Record of their existance was simply removed.) It is important to understand that these unoriginated loans are not loans that paid off, or are late, or have been charged off. Those categories are explicitly shown. The unoriginated loans are never explicitly shown. They just disappear.

The numbers I chart above are ratios. The numerator is the number of loans that have gone bad, and the denominator is the number of loans originally created (originated). Although Prosper reduces the number "originated" in their display over time, I keep the number constant, the original number of loans made. A ratio with a constant denominator is easy to understand as it evolves over time.

Lets look at an example. Consider the loans Prosper originated in October 2006. Initially there were 743 loans in this cohort. That's the number I use as a denominator. Starting in April '07, Prosper showed that there were only 742 loans originated in Oct '06. History changed. Starting in August '07, Prosper showed that only 740 loans had originated in Oct '06. Starting in March '08, Prosper showed only 736 loans originated in Oct '06. History keeps changing. In July '08, Prosper changed the number back to 740. Some unoriginated loans suddenly un-unoriginated themselves. I couldn't make this stuff up. In May '09 Prosper changed the number to 738. Here and there a few loans seem to come and go from the database. Nevertheless, I hold the denominator constant at 743, the number of loans actually created in October 2006. The latest statistic for Oct'06 is then calculated like this: The numberator is 16 loans in the 1-3 month late category + 281 loans charged off + 5 loans unoriginated = 302 bad loans. The denominator is (of course) 743 total loans. Finally 302/743 = 40.65% of the Oct'06 loans have gone bad so far.

Oct'06 is not the only month to have recent unoriginations.

Nov'06 originally 701 loans, in Apr'09 they showed 698, in May'09 they show 697.
Dec'06 originally 969 loans, in Apr'09 they showed 965, in May'09 they show 964.
Mar'07 originally 1161 loans, in Apr'09 they showed 1160, in May'09 they show 1159.
Apr'07 originally 1101 loans, in Apr'09 they showed 1098, in May'09 they show 1097.
Jun'07 originally 951 loans, in Apr'09 they showed 950, in May'09 they show 947.
Jul'07 originally 935 loans, in Apr'09 they showed 934, in May'09 they show 932.
Sep'07 originally 758 loans, in Apr'09 they showed 758, in May'09 they show 757.
Oct'07 originally 928 loans, in Apr'09 they showed 928, in May'09 they show 927.

I could go on, but I'm sure you get the idea. What causes these loans to be removed from the data? In the early days of Prosper, there were some cases where the loan origination numbers went down like this, and we were told that it was due to loans where identity fraud had been discovered. Prosper decided to treat those loans as if they never existed. There was some merit to their position, because at that time Prosper repaid the lenders (investors, note purchasers) in full for these loans. However, in later years, although I have been in discussion with a large number of lenders, I have never heard of Prosper repaying a lender in full for any loan. Therefore, I doubt that admitted identity theft is the reason now. (Prosper employees, feel free to add a comment to this blog explaining where these loans have gone.) Whatever the reason, this is a detail that adds complexity to the task of understanding loan performance. I wish they wouldn't rewrite history.

A few days ago Prosper ended their self-imposed quiet period, and has started originating loans again. They've changed the credit score limits, and a few other things that seem likely to change the statistics a bit, but it doesn't look like they've done anything to fix the structural problems which I have often discussed. Therefore I expect that as in the past, a large fraction of the loans will go bad.

The best discussion among P2P and Prosper.com lenders always found on prospers.org.

9 comments:

  1. "Therefore, I doubt that admitted identity theft is the reason now."

    There's a word for the place where these loans magically disappeared to, but I can't recall . It think it's called... Embez... Embezul, uh... Embezzal.... I gee I can't recall the name.

    ReplyDelete
  2. A little playing with the numbers suggests that a pretty steady about 1.65% of the previous month's good loans go bad each month. That would give 18% bad after 1 year, 33% after 2, and 45% after 3. Ouch.

    I'm glad to say that at close to a year and a half for my oldest loan and a year for my average loan age, I haven't had any go bad, but I have to wonder how well my luck will hold out.

    ReplyDelete
  3. Rather than saying "un-unoriginated," don't you think "re-originated" "or perhaps without the hyphen as "reoriginated?"

    Not that I can find either in a dictionary.

    ReplyDelete
  4. This isn't very interesting w/o accounting for credit grades. At 40% losses nobody is going to lend money on Prosper, except ignorant newbies and that's not enough to keep them in business.

    I have not had a good experience at Prosper, I'm essentially breaking even over the course of 3 years and 40 loans ($35 in loans still being paid down). But the A stuff can't possibly be going bad at at a rate of 40%, can it?

    ReplyDelete
  5. Matt, Different ways of breaking out the loans show different things. If you want curves broken out by credit grade, Rateladder publishes such curves from time to time. He calls them "vintage curves". Latest one is here ... http://www.rateladder.com/category/prosper/statistics/

    ReplyDelete
  6. Why hasn't this news been published in major outlets? Prosper.com a failure with 40% default rate?
    I see press today bemoaning restrictions on Prosper's activity in an atmosphere of already constricted credit markets. Where is the Prosper-as-fraud side of the story?

    ReplyDelete
  7. I don't see how prosper is still in business. @ $178m in loans, assuming a 2% fee for prosper, they've only made $3.5m. For the several years they've been in business, and now with all of their SEC fees, they have to be losing money quicker than we are.

    ReplyDelete
  8. I really hope Prosper gets itself up and running soon...
    It would be great to cash out at near-par. Although I've made good money, this thing is a tax hassle, and not really worth the time.

    ReplyDelete