CECL Methodology – Vintage Analysis Application

Sageworks
February 16, 2017
Read Time: min

The FASB’s guidance on the Current Expected Credit Loss (CECL) model is not prescriptive and allows for a number of methodologies to be used in order to fulfill the requirements. Vintage analysis is an allowance for loan lease losses (ALLL) calculation methodology that has been suggested as being the new minimum standard for CECL compliance. If you are interested in an introduction to Vintage Analysis before looking at how it’s applied, read CECL methodology – introduction to vintage analysis.

According to an Abrigo whitepaper, “The Basics of Vintage Analysis,” vintage analysis accounts for expected losses by allowing an institution to calculate the cumulative loss rates of a given loan pool and in so doing, to determine that loan pool’s lifetime expected loss experience. This includes a reasonable approximation of probable and estimable future losses gleaned by applying historical gross charge-off information to forward-looking qualitative and environmental factors.

Be better equipped to manage the ALLL under CECL; Prepare for CECL with defensible methodologies.

Request More Information »

The table below illustrates the usefulness of vintage analysis as a forecasting tool. The example shows four, four-year loan pools separated into vintages and calculates the life-of-loan loss experience of each group in the cumulative loss rate column. This is done by dividing each year’s net charge-offs by the original principal balance (some may use original principal and interest, for simplicity, principal alone is used below). The respective vintage’s original principal balance remains the denominator in each annual calculation, as it references the specific vintage’s original balance. The loss experience of this original balance is tracked annually and summed over the life of the loan leaving a cumulative, life-of-loan loss rate based on historic averages. For loans originating in 2009, the total life-of-loan loss rate is 3.19% and the 2010 rate is 3.49%. The goal is to use the existing data to forecast future loss rates, denoted in the blue shaded sections of the chart.

In addition to life-of-loan loss data, primary drivers like macroeconomic indicators of qualitative factors can be added to the expected loss calculation to reach a forecast supported by both quantitative and qualitative data points. For example, by identifying the unemployment rate as a primary driver of changes in the international, national, regional and local conditions qualitative risk factor (Q factor), you can look for trends that correlate to historical loss experience. If an increase in the unemployment rate leads to an increase in charge-offs six months later, this information can be factored into forward-looking loss projections. Additionally, identifying correlations between different factors is similar to Q factor adjustments under the current, incurred loss framework.

The goal is to express the impact of changes in external factors while incorporating analysis of where the loan pool is in its loss history. In our example, life-of-loan loss experience shows that a forecasted increase in the unemployment rate, (taken from CBO or Treasury Department estimates, for example), will have a bigger impact on loans in their second and third years than on loans near maturity in year four.

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!