Delinquency Rate

The percentage of loans that are past due

What is the Delinquency Rate?

The delinquency rate refers to the percentage of loans that are past due. It indicates the quality of a lending company’s or a bank’s loan portfolio.

 

Delinquency Rate

 

Understanding the Delinquency Rate

The delinquency rate is commonly used by analysts to determine the quality of the loan portfolio of lending companies or banks. It compares the percentage of loans that are overdue to the total number of loans. A lower rate is always desirable, as it indicates that there are fewer loans in the lender’s loan portfolio that are paying outstanding debt late.

In the industry, lenders typically do not label a loan as being delinquent until the loan is 60 days past due. However, the figure is not absolute and varies from lender to lender. For example, one lender may consider a 30-day overdue loan as delinquent while another lender may only consider a 45-day overdue loan as delinquent.

When a loan is labeled as delinquent, lending companies generally work with third-party collection agencies to recover the loan. If the delinquent loan is unable to be recovered after an extended period of time, it is written off by the lender.

 

Delinquency Rate - How It Works

 

Formula for the Delinquency Rate

 

Delinquency Rate - Formula

 

Where:

  • Number of Delinquent Loans refers to the number of loans that have missed their payments; and
  • Total Number of Loans refers to the total number of loans in the loan portfolio.

 

Practical Example

A loan portfolio currently consists of 45 loans. Of the 45 loans in the portfolio, 15 have payments that are overdue. The following is a schedule outlining the overdue loans:

 

Practical Example

 

If the loan portfolio defines delinquent loans as loans that are overdue by 60 days or more, what is the rate of delinquency of the loan portfolio?

Delinquency Rate = (7 / 45) x 100 = 15.55% = 16%

 

Interpreting the Delinquency Rate

The lower the delinquency rate, the higher the quality of the loan portfolio. The rate should be compared to an industry average or among the loan portfolio of competitors to determine whether the loan portfolio shows an “acceptable” rate.

A major drawback is that the calculation of the rate of delinquency uses the number of loans instead of the value of loans. To analysts, it is important to understand the value of loans that are delinquent before making an assessment regarding the quality of the loan portfolio.

For example, if a portfolio of 100 loans valued at $1,000,000 has ten loans that are delinquent with a value of $1,000, one can argue that the delinquent loans do not have a material impact on the overall loan portfolio. As such, a modification to the rate of delinquency is to use the value of the delinquent loans to the value of the loan portfolio. The modified delinquency rate is shown as follows:

 

Delinquency Rate - Modified Formula

 

In the example above, the modified delinquency rate of the $1 million loan portfolio would be ($1,000 / $1,000,000) x 100 = 0.1%. Had an analyst used the number of delinquent loans instead of the value of delinquent loans, the analyst would generate a rate of delinquency of (10 / 100) x 100 = 10%.

Therefore, the delinquency rate should only be used for a loan portfolio whose underlying loans are of similar value. If the value of the underlying loans varies greatly, the modified version should be used.

 

Additional Resources

CFI offers the Financial Modeling & Valuation Analyst (FMVA)™ certification program for those looking to take their careers to the next level. To keep learning and developing your knowledge base, please explore the additional relevant CFI resources below:

  • Debt Capacity
  • Loan Servicing
  • Probability of Default
  • Recovery Rate

Financial Analyst Training

Get world-class financial training with CFI’s online certified financial analyst training program!

Gain the confidence you need to move up the ladder in a high powered corporate finance career path.

 

Learn financial modeling and valuation in Excel the easy way, with step-by-step training.