Richer by the Day
Ongoing ramblings about personal finance, and all related topics. If it has to do with money, it will be covered here eventually.

Filed under Calculations, Investing, Lending Club, P2P Lending

Simulation Results

To get a better handle on the effect of historical default rates on P2P loan portfolios, I performed a monte carlo simulation on portfolios lending $100, $500, $1000, $2000, and $5000.  Since I assumed that the money was spread across investments of $25 each, those dollar amounts correlate to 4, 20, 40, 80, and 200 loans respectively.  For each test case, I simulated investing in all A1, C1, E1, or G1 loans (using Lending Club grading terminology) as well as an equal mix of those 4 grades, which I called Div for diversified.  I used the following historical yearly default and corresponding loan interest rates (again from Lending Club’s site):

Grade Historical Yearly Default Rate Loan Interest Rate
A1 0.16% 7.37%
C1 1.74% 11.28%
E1 3.32% 14.43%
G1 4.90% 17.59%

Since loans on Lending Club have 36 month terms, I calculated payments across each of these months, accounting for the appropriate probability of default. Using 36 months is more accurate that defaults/year since borrowers can default at any time and although month 1 and month 12 are both in year 1, the difference of those two default scenarios is significant. The overall results wouldn’t have meant much for one instance of each test case, so I instead ran each case 1000 times.  The results show the total value of all of the payments made.

Let me explain the $100 results as an example and then present the others for you to analyze.

$100 Investment

$100 Results

For this small investment amount, you can see that most cases of each portfolio had the same result, which is why you see prominent bands around the max expected returns for $112 $118 $121 $124  and $129.  We would expect the number of cases at the maximum to decrease as more money is invested, though the minimum result would also be expected to rise.  To read this graph, assume that you had $100 to invest.  If you invested in all A1 loans, using the historical default rates and corresponding loan interest rate, the total payments received would be one of the dark blue dots.  Had you invested in C1 loans, you’d be a pink dot, and so on.  The other dots of the same color (other than the one that is “you”) can be thought of as other people who also invested in the same number and grades of loans.  Remember that this simulation gives hypothetical returns using historical default rates and the payments you receive could be worse.  It’s just a matter of probability.  Now that we’ve looked at the $100 investment results, you can probably guess how the rest will look and analyze them yourself.  Here they are:

$500 Investment

$500 Results

$1000 Investment

$1000 Results

$2000 Investment

$2000 Results

$5000 Investment

$5000 Results

General Conclusions;
As more money is invested, the likelihood of getting the full expected return declines, as the occurrence of default becomes more prevalent.  Investing $1000 or more always (at least in these simulations) resulted in a profit, whereas investing smaller amount sometimes resulted in a loss.  The average return of the riskiest (All G1) portfolio was always the highest.

The results of these simulations indicate two things to me:
1) Investing more money seems to be safer
2) If you do invest more money (in as many loans as possible) the higher returns of riskier grade loans seem worth it.  This is likely due to the fact that while the individual loans do carry more risk, the fact that you’re diversifying by investing in so many of them tends to moderate the risk.




If you enjoyed this post, subscribe to my feed via RSS or email.

You can support Richer by the Day by visiting our advertisers and sponsors. A thumbs up from any StumbleUpon users would also be greatly appreciated.



Related Posts

P2P Lending Default Considerations (Part 1)
P2P Lending Blog Carnival #4
Lending Club Quiet Period Has Ended
My Lending Club Posts
Get Better Rates with Lending Club

4 Responses to “P2P Lending Default Considerations (Part 2)”

  1. P2P-Banking.com Says:

    >The average return of the riskiest (All G1) portfolio was always the highest.

    This is true for the current data. But remember all loans are still running, so that might change over the loan term.
    And do remember that those who invested in the highest rates/risks at Prosper in general did worse than those investing in AA or A loans there.(I am NOT suggesting that Lending Club and Prosper are comparable; just saying that it might be too early for conclusions like that.

    Wiseclerk
    http://www.p2p-banking.com

  2. Mike Says:

    @Wiseclerk: I meant that the average return of the All G1 return was always the highest in my simulations. Though I used the rates and historical defaults from Lending Club’s site, these simulation results are in no way correlated the the actual loans or default rates you might get there. Availability of loans may also prevent implementing these methods, i.e. you might not be able to find sufficient loans at the desired grade to invest in at any given time.

  3. P2P-Banking.com Says:

    @Mike: I know what you meant. But it is still based on performance so far, since you based it on the past default and interest rates of Lending Club: “I used the following historical yearly default and corresponding loan interest rates (again from Lending Club’s site):”

    I appreciate the work you did, my point was that it was a bit early for conclusions. Do this again in 2 years when a part of the loans have completed their loan term.

    Wiseclerk
    http://www.p2p-banking.com

  4. Mike Says:

    @Wiseclerk: Now I see the disconnect between how we were interpreting what I said. The historical default rates on the Lending Club site are not from its own history, but rather rates established by the banking industry from years (maybe decades) of performance on more traditional loans. If I were to have used actual performance data, my results surely would have the “too early for conclusions” bias you suggest. G Grade loans for the first year (June 1, 2007-May 31,2008) had zero defaults, for example. Sorry for the confusion.

Trackbacks

Leave a Reply




Subscribe to Richer by the Day

  

 Subscribe via RSS

  

 Subscribe via Email

  Add to Technorati Favorites