Over 1.8 million professionals use CFI to learn accounting, financial analysis, modeling and more. Start with a free account to explore 20+ always-free courses and hundreds of finance templates and cheat sheets.
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.
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.
Formula for the Delinquency Rate
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.
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:
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:
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.
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:
Take your learning and productivity to the next level with our Premium Templates.
Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.
Already have a Self-Study or Full-Immersion membership? Log in
Access Exclusive Templates
Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.