Non Maturity Deposit Assumptions And Critical Thinking

OBSERVATIONS FROM ALM MODEL VALIDATIONS: DO DECAY RATES MATTER?

February 18, 2016

Yes. Decay rates do matter, but they are often not appropriately applied in the asset/liability management (ALM) process. Decay rates are essential for capturing the risk of evolving member behavior, namely deposit migration, as rates change. This blog will focus on using decay rates when simulating net economic value (NEV).

Model validations typically reveal two common issues as it pertains to the setup and implementation of deposit decay rates.

1) Decay rates are not being incorporated

Model users are often surprised to find out decay rates are not being incorporated. Common reasons for this include the fact that input fields can be hard to locate or reports summarizing key assumptions are not reported effectively (sometimes assumptions reported in a summary are not actually the assumptions in the model). To better illustrate, lack of decay rates from a recent model validation were organized by c. myers in the table below.

The risk of decay rates not being incorporated in NEV can be dramatic, especially in the various rate shocks. If decay rates are not included, it will result in longer deposit cash flows, an unrealistic market valuation of deposits and, ultimately, an understatement of interest rate risk in a rising rate environment.

Credit unions should check their ALM models to make sure reasonable decay rates are appropriately applied and coincide with key assumption reporting.

2) Decay Rates Do Not Change As Market Rates Change

The issue of decay rates not changing as the world around us changes was discussed during a blog in September 2014. Back then, we pointed out that,

[Assuming decay rates don’t change as market rates change] is like saying non-maturity deposit cash flows will remain constant and unchanging regardless of what rates do. History shows that this is not a valid assumption and, if used, can provide a false sense of security regarding NEV results.

In the table below, c. myers organized decay rates from a recent model validation we performed.

Notice that while decay rates are unique for the three different deposit products, decay rates remain constant regardless of changes in market rates. Said differently, this model assumes members will not consider the evolving advantage they might have to withdraw funds as rates change. However, as demonstrated in the chart below, history does not support the assumption that member behavior does not change as rates change.

The following graph shows when market rates increased from roughly 1% to 5% in 2004 and 2005, the industry experienced a material decrease in the concentration of regular shares and increase in member CDs. However, over the past 8 years, that trend has reversed as member certificates have declined while regular shares have experienced significant growth.

Keep in mind as you review decay rates, it is not about getting the “right” assumption, because that is virtually impossible. It is about reasonably representing changes in consumer behavior in your base-case risk analysis, then stress testing a range of assumptions to understand the impact.

While the focus of this blog has been on NEV, deposit behavior is a material component of income simulations as well. Ignoring deposit and member behavior will understate the cost of funds in higher rate environments and likewise hide risk. This is an issue that shows up with the static balance sheet approach and has been discussed frequently in previous blogs. To learn more, refer to the links below.

Observations from ALM Model Validations: Cost of Funds Back Testing
Observations from ALM Model Validations: Extremely Profitable New Business ROA in Static Balance Sheet Simulations
Isolating Interest Rate Risk with a Static Balance Sheet

Kruskal Hewitt, a Senior Associate in our ALM practice, has prepared a document below outlining approaches to the calculation of estimated average life on non-maturity deposit (NMD) accounts using an institution’s internal historical data. Because the assumptions made on NMD average life are a, if not the, critical driver of EVE (economic value of equity) rate-sensitivity, we thought it would be worthwhile sharing this document. Please refer this to whoever in your organization has responsibility for managing your IRR/ALM modeling. The document contains Kruskal’s contact information for those who have questions or would like additional information. Thank you.

Estimating NMD Average Life From Bank Data

This note will describe in detail four methods for estimating historical average life of non-maturity deposits (NMDs) using bank-specific data.  There are many approaches for estimating this; while all are valid, some methods are easier and/or more accurate than others.

What follows is a discussion of NMD average life and its significance, followed by the four methods.  The knowledgeable reader should proceed directly to the methods.

Average Life Assumptions in EVE Simulations

NMD historical average life is important because it represents a key model assumption used in interest rate risk models’ estimation of economic value of equity (EVE).  EVE is calculated as the net present value (NPV) of assets minus the NPV of liabilities.

NMD for many banks, especially smaller banks, is the largest component of liabilities, which explains large the impact that these assumptions have.  They determine what point on the discount curve will be used to discount cash flows associated with NMDs.  In a positive yield curve environment, the longer the assumed average life, the higher the assumed discount rate, the lower the resulting NPV of NMDs, and the higher the calculated EVE.

In other words, all other things held constant, in a positive yield curve environment (which is typically though certainly not always the case), increasing the assumed NMD average life has the effect of increasing EVE asset-sensitivity (or decreasing liability-sensitivity) under rising rate scenarios.  Higher average life is equivalent to slower decay (or run-off) rates on NMD accounts.

Given the high sensitivity of EVE results to the NMD assumptions, regulators have stressed the importance of analyzing internal bank data to help formulate those assumptions.  In our experience, banks that have done so typically find longer estimated life for NMD accounts as compared to the earlier default assumptions provided by FDICIA 305 (or the OTS), particularly for community banks.

Setting Average Life Assumptions

There are three elements that should be considered by a bank in setting average life assumptions:

  • Historic experience
  • Management’s judgement of the future behavior of their NMD depositors
  • Peer banks’ assumptions

The most important thing is that a bank clearly document what they choose and why.

Estimating Average Life From Bank Data

Estimating average life is problematic!  Even with great data, how one measures – i.e., which technique is employed – will give different answers.  There are further complications.  What one measures, the number of accounts or account balances, will give different answers.  Account balances can vary significantly over time.  Transaction account balances, for example, can move up and down without it having any run-off implications.  Another consideration:  A bank cannot have accounts with a longer life than the bank’s existence, which complicates the estimation exercise for a younger bank.

The interaction of account balances and account life can have a meaningful impact on true (as opposed to modeled) EVE.  Consider two accounts that have been open for ten years, one with a balance of $1 for the first nine years and $999,995 in the tenth, the other with a constant balance of $100,000.  The first account has had little value for the bank (i.e., in discounted terms), while the second had a great deal of value.  But both have had an average balance of $100,000.

It may seem that the easiest approach is to measure account balances.  However, unless there is detailed data available to calculate the daily average balance by account, account balances are problematic.  They can be affected by a variety of external and internal factors that have nothing to do with “decay”.  They can be skewed by individual large accounts, as well as by transaction activity as noted above.

The number of accounts open, and how long they have been open, is more straightforward to measure, but it has the drawback of either assuming today’s balance is a good proxy for the average balance (method B below) or that every account has the same value to the bank (method C below).

Because average life estimates are limited by a bank’s historical data, it can limit the choices of estimation technique.

What follows is a discussion of various techniques, the required data resources, the strengths and weaknesses, and a detailed how-to.

METHODS

A. Current Average Account Life

Data required.  The account opening date and current account balance.

Pros/Cons.  If a bank has the data, this is a very accurate and easy to calculate measure of the current average life.  If a bank recalculates each month or quarter, predictive trends will be identifiable. However, there are two drawbacks.  First is the reliance on the current balance as a proxy for average balance.  This may or may not be reasonable; some accounts have monthly cycles, or other seasonality.  Second, if a bank is relatively young with accounts that have been open since the start of the bank, this technique will understate the true average life.  The amount of understatement is related to the proportion of accounts open since day one.

How to calculate.

For all accounts Sumproduct(Account Life : Account Balance) / Sum(Account Balance)

B. Open-Close Technique to Estimate Decay

Data required.  The ability to identifywhich specific accounts are open at various past dates.

Pros/Cons.  This technique is the default methodology, as virtually every bank can identify the individual open accounts at specific dates in the past.  It is simple to calculate and to update.  The problem is that the account balance has no role in the estimation.  As a result, every account is assumed to be of the same value to the bank.

How to calculate.  The discussion below is for annual cohorts, but other periods (monthly, quarterly, semi-annually) can be substituted.

For each NMD type (DDA, Savings, NOW, MMA), segment historical data according to the accounts on the books (open) at the start of each year (or quarter, etc).
E.g., As of December 31, 2012, count how many accounts were open, Act12(O).  As of December 31, 2013, count how many of the Act12(O) closed during the year, Act12(C).
Act12(C) / Act12(O) = AnnualDecayRate(12)
Repeat for five years, and average the Annual Decay Rate:
1 / AverageAnnualDecayRate = AverageLife (in years)

C. Tail Analysis

Data required.  The account opening date and current account balance.

Pros/Cons.  The open-close technique assumes a constant decay rate.  If one assumes a constant decay rate, then in theory there is always something left – i.e., the “tail”.  An average life of four years means that after eight years, 10% will remain.  An average life of six years means that after 12 years, 11% will remain.  An average life of ten years predicts after twenty years 12% will remain.  This technique can be used to estimate the expected life of accounts for a young bank where more than 10% of accounts have been open for as long as the bank.

How to calculate.  Build an excel spread sheet. 
In cell A1 put the number of years the bank has been open.
In cell A3 put 0, A4 put 1… A53 put 50
In cell B2 put the formulae =1/A1
In cell B3 put 1.
In cell B4 put the formulae =(1-$B$2)*B3, copy this formulae to all the cells until cell B53.
In column C place the percentage of accounts open since the beginning of the bank in the cell that corresponds to the number of years the bank has been open (if the bank has been open seven years put the percentage in cell C10)
Change the value in cell A1, until the value in B, adjacent to the percentage in C, is as close as possible.
The final value in A1 is the average life of the sample.

D. Average Life of Time Weighted Average Balance

Data required.  The daily balance of each account since the day the account was opened.

Pros/Cons.  Arguably this is the Cadillac of measures, as it would account for both the account balance and the balance average life.  There is one significant drawback: banks generally won’t have the required data.

How to calculate.  For each account, calculate the average balance (remembering to account for weekends and holidays).  For all accounts: Sumproduct(Account Life : Account Average Balance) / Sum(Account Average Balance)

CONCLUSION

There are different ways to calculate the average life of NMDs.  If the bank has the account opening date, then technique A offers advantages; otherwise, B may be a more sensible option.  Remember that calculating historical average life is an intermediate step in setting the model average life assumption; management must then look into its crystal ball and assess whether average life in the future will be longer or shorter than the data shows it has been in the past.

Remember, too, that if rates are expected to go higher (as is presently the case), then shading to the shorter side is more conservative; upward movements in rates don’t produce as big an increase (or as small a decrease) in EVE.  Conversely, if rates can only go lower, biasing to the longer side is more conservative.  Of course, we always recommend accuracy over bias, and hopefully this write-up will help in that regard.

If you have questions on the content, please contact Kruskal Hewitt, Senior Associate, at 914-341-2697.

0 Replies to “Non Maturity Deposit Assumptions And Critical Thinking”

Lascia un Commento

L'indirizzo email non verrà pubblicato. I campi obbligatori sono contrassegnati *