I had a very interesting email exchange with RGF. (I emailed him after using his forum posts in articles last week).
Here is a portion of that email exchange on default rates over time and their affect on yield.
RGF:
Default rate: It’s not just if a loan defaults, but when.
A lot of people, especially early in this game, foolishly took the interest rate and subtracted the annualized expected default rate and thought this would give them their expected return. Some people got little smarter and realized it’s a 3 year loan and multiplied the default rate times three and subtracted that from the loan rate to predict expected return. This is not mathematically correct for several reasons. For one, if a loan has a 2% annual risk of default, the chances of them defaulting over a 3 year period is actually about 5.88% (1-.98^3rd). For another, it assumes a total loan loss which only happens on a first payment default, and it also does not consider the partial recovery on a sale of charged off loans.
Ok, the following is the best way I can think of to analyze this. I’m not convinced I’m doing this right, I’d be curious to see what a real stats person thinks.
If a person were equally likely to default at any point (this is almost certainly not true), you can calculate expected default loss by adding up the return of the 37 potential events times the possibility of that event happening. The 37 events are the default at any payment from1 to 36 plus the event of full payoff (this still is a bit of a cheat, since it doesn’t consider partial payments, early payoff, time value of money, etc). So, let’s take a $1,000 loan at 12% with a 2% annual chance of default, it would have a payment of $33.21. There are 37 possible events, for default at payment 1 through 36 you take the possibility of each event happening (.001666) times the amount you’ve received in payments up to that point (0 to 35 x 33.21). The expected value contribution of a first payment default would be .02/12, or .001666 x $0 in payments made, or zero return. 2nd payment default .001666 x $33.21 in payments made, or $.05535 contribution to expected value. Using a spreadsheet, adding up the contribution to expected return of each event, the expected return on this investment would be $1158.70, while the 36 payments add up to $1195.56. So, the 2% default risk would mean the expected return here is $36.86 lower than a risk free loan. If you figure you get, say, 18% of this $36.86 back in defaulted loan sales, then it’s $30.22, loss, or around 3.0% return reduction due to default risk, so you’re expected return is 9.0%. (there are other tiny considerations that you could get bogged down on here, such as the opportunity cost of waiting months to get your 18% back from a loan sale, reinvestment delay on loans that pay but pay slower than the payment schedule, etc). I did the same calc using a 20% loan rate and 10% default rate (note same default rate loan rate spread of 10%), the expected return was $1131.52, so the same spread at higher risks appears to have lower returns.
Note even if loans were equally likely to default at any point, you’d still have your highest percentage of defaults at the first payment. This is because all loans “make it” to where the first payment is due. Not all loans make it to the next payment, so the pool is smaller, so you’d have the same percentage defaulting out of a smaller pool, so a slightly smaller # of loans defaulting. Note at low default rates this is a very low effect, in the above example .001666 (.1666%) defaulting on the first payment, and 1-(.001666×35) x .001666, or .0015688 (.15688%) defaulting on the last payment (6 percent less). Note in my math above I assumed a steady risk of .001666 for default at every payment, which is technically wrong, but the effect is not significant to the return. It will be more important at higher risk rates.
However, and this is the big problem, people are not equally likely to default at any point. People will probably be dramatically more likely to default early in the loan. There are many reasons for this, but the reasons don’t matter. But it is very important. In the first example above (12% rate 2% default), a full $35 of expected return (3.5%) comes from partial payments on defaulted loans. On the second example (20% rate 10% default) $195 of the expected return was from partial payments on defaulted loans, on an expected gain of $131! If defaults risks are heavily weighted towards the beginning of the loan, the 20% rate 10% default may well have a near zero or even negative expected return. For this example, if the default risk was 20% for the first year, 10% for the second year, and 0% for the third year, the expected return becomes negative.
What will be needed, in the long run, is not default rate, but default rate at each payment by credit grade (you could throw more variables in here such as loan size, autofund, etc). When we have this (and we’ll need at least 3 years of data obviously) you can calculate expected return like I did in the first paragraph, replacing .001666 with the actual default rate by payment number.
RateLadder:
Exactly!!! That is why I am tracking the late curves… When we have enough data then the difference in cumulative default rate at each period provides the default rate during the period.
Again when complete one simply solves the Markov model you are laying out plugging in the correct default rates. But alas at this point in time a completed (without projecting) late curve graph is at least 24 months away (the 1st 6 months of loans are very thin).
So the next question is how would you project those curves out into the future? Linear shows a 100%+ default rate for HR (impossible!). Exponential Decay was my next choice (linear of the remaining loans), which also seems very high.
Check out these posts (in order that I published them):
http://www.rateladder.com/2007/06/03/1-month-late-or-worse-curves-by-credit-grade/
http://www.rateladder.com/2007/06/05/1-month-late-or-worse-curves-clearly-high-for-ehr/
http://www.rateladder.com/2007/07/02/1-month-late-or-worse-curves-by-credit-grade-july-1-update/
Related Posts -
Another Excellent Email from TB on IRR I saw your last comment and wanted to provide you with an Excel sheet showing the implications of not counting the principle payments as cash flows when they are received. In this sheet I have included a situation where there is a hypothetical Prosper account that is made up by...... - Old(ish) Large Prosper Portfolio In Great Shape Last night I went to the Prosper Bay Area meet and greet Organized by Big Gulp. Chris Larsen (CEO), Andrew (Product manager?), and Carin (new employee in creative, job title?) where there from Prosper. I saw several familiar faces, meet some new faces, and heard a number of promises of......
- Rateladder Referral Listing: Guarenteed Money for Simple loan Guarenteed Money for Simple loan This is the cleanest A I have ever seen. I am a little surprised that it is not a AA. Account Verified, DTI 9%, A Credit. CLEAN! Purpose of loan: Supplement stock porfolio for more diversified lending (explain what you will be using this loan......
- 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......
- Avg Rate Minus Default Rate Does Not Equal Expected Return -- L5 Responds Previously I had some additional questions for the Large Lenders on the Prosper Days Panel. L5 Returned my email... Here is his response. If you can't tell L5 is a sharp tack and I knew he was thinking correctly, I just wanted to be sure :) Thanks for your nice comments,......
Related Websites - Borrowing money - Payment protection insurance (PPI): CFEB Moneymadeclear - parents Get Payment Protection Insurance from Happymoneyshopper.com Payment Protection Insurance need not be expensive or misleading - click here to get a quote http://www.happymoneyshopper.com/accident-sickness-and-unemployment-insurance-cover. Protecting your financial commitments against lose of earnings could not be simpler or cheaper - Accident, Sickness, and Unemployment can happen to anyone and with a simple......
-
More Inflation Fighting Weapons All long term investors need core holdings that will protect against the damaging effects of inflation. Traditionally we have been told that equities in general are the answer to the inflation problem. Now we are not so sure. Based on this doubt, mutual fund companies continue to introduce new products...... -
Eagle Valley Golf Course, Carson City, NV Eagle Valley Golf Course is located in: Carson City, NV Phone: 775-887-2380 Website: http://www.eaglevalleygolf.com Course History: This is a truly great course that is actually two courses in one. You'll have your pick of two, and the West Course is by far the most challenging. We'll be focusing on this...... -
Why Certificates of Deposit Are A Good Idea Today's article is written by guest blogger Jim of Bargaineering. If you've saved up a few dollars and aren't sure if you should put them in the stock market or stick them in your mattress, let me give you another suggestion: put your funds into a certificate of deposit (CD)....... - LendingClub vs. Prosper Recently, I had come across an article about zopa.com and it really peaked my interest on peer-to-peer lending. In researching more about Zopa, I also came across two other major peer-to-peer lenders: Prosper and LendingClub. I researched both Prosper and LendingClub a bit and decided I liked LendingClub better, so......
- New Year Holiday, Seasonal Collectibles
- Curves Fitness Equipment Gym, Workout & Yoga Exercise & Fitness
- VI:Return of the Jedi Star Wars Science Fiction Collectibles
- Late Summer Perennials Flower Seeds Plants, Seeds & Bulbs Gardening & Plants Yard, Garden & Outdoor Living Nursery
- 1980-Last Year Calendars Paper Collectibles
Categories:
Prosper.com, Statistics, Strategy
Tags:
1 comment so far ↓
RGF was a smart guy and it be great if he came around more often.
Leave a Comment