7 Minute Read – Why You Should Be Using Static Pool Analysis for Performance Based Analytics

7 Minute Read – Why You Should Be Using Static Pool Analysis for Performance Based Analytics

Ataira Business Intelligence Ataira - Updated Jun 15, 2022

TwitterFacebookLinkedInRequest Info


Static pool or “vintage” analysis has long been used by the financial services industry to evaluate lifetime losses of lending pools and provide, to an extent, the probability of future trends of expected losses. The term “vintage” is sometimes used as an analogy to the wine industry and the rating or quality of wines based on their harvest year. This type of analysis is especially useful when you can identify a large specific group of entities, be it customers, loans, widgets, and can track the key metrics at specific points in time. Though this has been leveraged heavily in the finance industry, it is rarely seen in other industries and could be a new tool in your toolbox to better track your organization’s performance over time.

Let’s take a high-level example to illustrate the basics. Say I’m a lending analyst at a bank and I would like to monitor the risk ranking decisions over time.

Setting Up the Analysis

First let’s discuss how to read the table above. The origination year is a specific set of loan attributes that we wish to track. This could be a certain demographic, risk rating, interest rate or other sub segment of the pool. The important point is for the segments to represent an action, decision or strategic direction that is important and key to the organization’s goals. In the columns, the actual and cumulative percent charge-offs are tracked by year and origination-to-date. In year one, the charge off values are for the first year of that pool. Then for every year we take each value and sum year over year.

In this example, the chart visualizes the trajectory of the health of the portfolio. If we read the chart from left to right, it shows that Risk Pool A for 2011 started off pretty good but quickly gained charge-off momentum and is now fairly stable. In 2012 apparently, some changes were made to how lending is originated and serviced and those numbers are much lower as of year four. For the loans that were originated in 2013 there needs to be immediate action on the servicing side since they are on track to be very badly performing. However, this may be expected and may still be profitable depending on the interest rate and other factors.

Understanding the Trajectories

Remember, since we are talking about cumulative values, the trajectories of the pools will never go down, only up. Meaning, in our example, it’s doubtful the cumulative charge-offs for Risk Pool A of 2013 will ever be as good as say, Risk Pool A of 2011. Another point to note is how this type of analysis reaches across the full lifecycle of the business process and in this case, is also cross functional as it touches marketing, sales, origination and servicing. A drill down into the individual processes that support the chart might show how to improve campaigns, terms and customer service.

How can you take advantage of static pool analysis? Always start with your organization’s strategic goals and determine the different processes and points of measurement along the line. This can be done with a strategy mapping exercise. Often these metrics will be percentages, indexes or rates since these can be normalized over time. You will want to identify at least two date data points and their periodicity. In our example above it might be more useful for our origination dates to be more granular such as the month level and then the cumulative metrics at the three month, 6 month and then yearly after that. It really depends on the metrics being tracked and how often tweaks to actions or decisions are intended to be made to affect change.

Technical Perspective

From a technical perspective, the origination pools are represented by a snapshot fact copy of the data created every month. In this way, the loan pools can be temporally (time) shifted and compared based on their age or vintage. This approach words best when balances are kept for every end-of-period whether it be monthly or quarterly. If you are using OLAP data source it becomes especially easy to aggregate your metrics like profitability, risk ranking and cost load.

Static pool analysis can be used for many other processes and industries. It could be used to track cumulative hotel guest satisfaction based on monthly marketing campaigns, patient bad debt or charity care for healthcare, or customer scheduled maintenance for auto dealerships. Not to say the list is endless, however, the important point is static pool analysis is not only not just for financial services but for all industries including leading and lagging indicators.

Click here to see how Power BI analytics development can improve performance in your organization