Historical Loss Rates for ALLL Calculation

Sageworks
November 4, 2013
Read Time: min

Historical loss rates significantly impact the reserve amount, as they determine the reserve needed for impairment in FAS 5 loan pools. Often these pools of loans make up a substantial portion of the bank's or credit union’s portfolio and reserve calculation, so gathering and accessing data for historical loss rates is vital to the success of the ALLL calculation.

Most institutions will utilize one of two methods to calculate historical loss rates for their FAS 5 pools: the traditional historical loss rate calculation or migration analysis.

Spend 80% less time on your ALLL each quarter.
Learn More

Traditional Historical Loss Rates

Loss Rate = (Charge-offs – Recoveries) / Average Loan Balance

A traditional historical loss rate calculation is the more commonly used methodology for identifying FAS 5 pools’ loss rates at community banks. These loss rates are typically assessed on a quarterly basis, often using an 8- or 12-quarter look-back period, although this will vary bank to bank, depending on what time horizon they deem to be appropriate.

Data needed for this assessment includes the total charge-offs and recoveries for each quarter that is incorporated into the bank’s reserve. Banks and credit unions must ensure the person responsible for the ALLL can access accurate information that ties to the general ledger when calculating loss rates and verifying accuracy. The charge-offs and recoveries for each pool should be outlined for each time period and tied to loan level detail as illustrated in the following example.

Migration Analysis

Migration analysis is a more granular and analytical process for calculating FAS 5 loss rates than the traditional historical loss rate analysis.

This loss rate calculation uses loan-level metrics to track the migration of loans to charge-off from different classifications in order to generate the estimated loss. Consequently, migration analysis can provide a more accurate and appropriate FAS 5 loss rate, but the data collection required for migration analysis is more data intensive and requires the bank to keep accurate risk ratings for each loan. See a poll showing why some institutions avoid migration analysis.

Below is an example of data needed for migration analysis. In this example, when examining the C&I Pass-rated loans in Q3 2010, we start with a loan balance of $150 with no net charge-offs. The next quarter shows $2 charged off. The calculation extends through 8 quarters, and we can assess that $12 of net charge-offs are experienced against the original $150 loan portfolio balances beginning in Q3 2010, giving us our 8 percent loss rate through the migration analysis. The idea here is to measure the migration to loss for a static group of loans in each risk classification and to use that measurement to apply a loss rate to the current balance of loans in that risk classification.

About the Author

Sageworks

Raleigh, N.C.-based Sageworks, a leading provider of lending, credit risk, and portfolio risk software that enables banks and credit unions to efficiently grow and improve the borrower experience, was founded in 1998. Using its platform, Sageworks analyzed over 11.5 million loans, aggregated the corresponding loan data, and created the largest real-time database of private-company financial information in the United States. The company was acquired in 2018 and is now part of Abrigo.

Full Bio

About Abrigo

Abrigo is a leading technology provider of compliance, credit risk, and lending solutions that community financial institutions use to manage risk and drive growth. Our software automates key processes — from anti-money laundering to fraud detection to lending solutions — empowering our customers by addressing their Enterprise Risk Management needs.

Make Big Things Happen.

 

Looking for Banker’s Toolbox? You are in the Right Place!

Banker’s Toolbox is now Abrigo, giving you a single source for all your enterprise risk management needs. Use the login button here, or the link in the top navigation, to log in to Banker’s Toolbox Community Online.

Make yourself at home!