Learn More *Top*

Close

Roll Rates for Lending Club

By Angela Ceresnie
October 21, 2013

What are roll rates and why are they important?

Roll Rates are the percentage of outstanding balances that go from being moderately past due to significantly past due.   At any given time in a portfolio of loans, there are a portion of outstanding balances that are 30 days past due – meaning that the customer has missed more than one payment.  If you understand the roll rates of that population, you can extrapolate what the charge off rates will be in several months.

 

Understanding the basic roll rates of a consumer lending portfolio is important.  With Online Lending today, given that notes are held to maturity, roll rates are mostly used to inform underwriting decisions.  Underwriting models are generally more predictive and applicable if built on reasonably recent data.  The issue is that, if the data is recent, charge offs cannot be modeled well because recently issued loans haven’t matured to the point of charge off.  In this case, you can model to predict a less severe measure of default (e.g. 30 days past due date) and then apply roll rate assumptions to those predictions.

 

How do you calculate roll rates?

First, we will focus on portfolio or “coincidental” roll rates.  This takes the entire loan population at any given time and looks at how many dollars are moderately past due (in this case, 30 days) and then compares that number to how many dollars are charged off 120 days later.  Lending Club’s data is a little difficult to navigate, because they only provide the status of “Late (31-120 days)”, which is pretty broad.  By performing some data manipulation, we were able to identify all the loans at a given time that were just 31-60 days late.

 

For Lending Club originations in 2010 and 2011, we saw a significant amount of fluctuation in the 30 day-charge off roll rates, due to the smaller size of the Lending Club portfolio at that time.  Based on a weighted average, the percentage of 30 day past due balances that ended up charging off was 69%.

roll1

 

On more recent data (Lending Club 2012 – 2013), we see the roll rates increasing a bit, but also stabilizing significantly.  They now hover around 83%.

roll2

The next view is by origination date, or “vintage” roll rates.  This tracks a group of loans that were booked during a specific time period (in this case, Lending Club 2010 and 2011 originations) to see how the roll rates change over the life of the loan.   The calculation is the same – moderately past due dollars in one month (30 days) to the charge off dollars in later months to see how the dollars “rolled”.  We see that, as the portfolio becomes more seasoned, the roll rates become lower and less stable.

 roll3

The lower roll rates at higher tenures are likely due to lower outstanding loan balances to an individual borrower. It is easier for the borrower with a loan near maturity to pay off in full, and they are incentivized to do so in order to protect their credit bureau history (i.e. why charge off now and negatively impact your credit history when you’ve already paid back 75% of the loan?).  The stability of the roll rates has to do with the small balances in general, given that many loans will be paid off by now, and the outstanding balances are smaller.

Conclusion

Roll Rates are an important input for underwriting model strategy and management of a consumer loan portfolio.  For underwriting, models can be developed using recent data to predict credit losses based on an earlier default definition.  Roll Rates also help to give an early indication as to what portfolio credit losses will be in the future.  This is particularly important for large institutions setting aside capital to cover future losses.  While retail investors do not do this, it is important to understand the performance of your portfolio and any adjustments that should be made to make sure you are hitting your target returns.  While roll rate analysis is certainly not an exact science, and there are many different ways to track them, it is important to keep an eye on roll rates so that you are a step ahead of losses in your portfolio.

 

—————————————————————

Interested in how you can invest in P2P just like a credit risk expert? The Orchard team is building something amazing to supercharge your Peer to Peer Lending results. Join the Orchard waiting list, and we’ll save you an invite!

 

  • http://www.lendingmemo.com/ Simon Cunningham

    This is great. You guys are rockstars.

    • VAGuyWithNewName

      It is good info, but what I was hoping for was more of a critique of the 83%. For example, what do banks expect their roll rate to be on unsecured loans? And, how much does the effectiveness/ineffectiveness of the collection of delinquent accounts play into this? Could LC do a better job on collections and reduce the roll rate?

    • aceresnie

      Thank you for the comment. With regard to your collections question, we are actually in the process of analyzing and writing a post related to recovery rates on LC accounts that have charged off. It should be interesting.

      In terms of bank roll rates on unsecured loans, that information is tough to benchmark against as most banks don’t do much installment loan, unsecured lending (most lending to consumers is in the form of credit cards or revolving debt). My guess is that 83% is pretty standard.
      Thanks again,
      Angela

    • VAGuyWithNewName

      That’s great, but as a LC investor, I would be more concerned with the aggressiveness of the collection process for accounts that have not yet been charged off than those that have. Many times, someone who has already gone 120+ days past due is in such financial trouble that they no longer feel like they have the luxury of being concerned about their credit rating. They have given up and have more pressing issues (like food on the table). Someone 30 to 60 days late can be turned around more easily.

  • Pingback: Peer to Peer Lending News Roundup – October 26, 2013

  • Pingback: Recovery Rates for Lending Club « Orchard

  • Pingback: Roll Rates for Lending Club « Orchard Pla...

  • Pingback: Roll Rates for Lending Club | P2P and Social Le...

  • Pingback: Diversification of Online Lending Portfolios: Prosper « Orchard Platform