---
title: Interest Rate Risk Is A Community Bank Behavioral Problem
description: Interest Rate Risk Is A Community Bank Behavioral Problem
image: https://blog.plansmith.com/hubfs/IRRBehavioralProblem.jpg
---

[CALL TOLL-FREE 1-800-323-3281](https://www.plansmith.reachproductions.net/project/call-toll-free-1-800-323-3281/)

[![Plansmith](https://blog.plansmith.com/hs-fs/hubfs/Plansmith-Logo.png?width=764&height=135&name=Plansmith-Logo.png "Plansmith")](https://www4.plansmith.com)

- Solutions 
    - [Budgeting](https://www4.plansmith.com/budgeting/)
    - [ALM](https://www4.plansmith.com/alm) 
          - [ALM Advisory Services](https://www4.plansmith.com/alm/advisory-services/)
    - [CECL](https://www4.plansmith.com/cecl/)
    - [Strategy](https://www4.plansmith.com/strategy/) 
          - [Market Intelligence](https://www4.plansmith.com/market-intelligence/)
- Products 
    - [StrategyGPS](https://www4.plansmith.com/strategygps/)
    - [Compass](https://www4.plansmith.com/compass/)
    - [BankersGPS](https://www4.plansmith.com/bankersgps/)
- Resources 
    - [Blog](https://blog.plansmith.com/)
    - [Videos](https://plansmith.wistia.com/projects/7qemazkqii)
    - [Compass Tutorials](https://info.plansmith.com/compass-tutorials)
    - [Lunch N’ Learn](https://info.plansmith.com/lunch-n-learns)
    - [Webinars](https://www4.plansmith.com/webinars/)
    - [About](https://www4.plansmith.com/about/)
- [Schedule A Discovery Call](https://www4.plansmith.com/contact-us/)
- [CALL TOLL-FREE 1-800-323-3281](tel:8003233281)

# Plansmith Blog

# Interest Rate Risk Is A Community Bank Behavioral Problem

Posted by [Craig Hartman](https://blog.plansmith.com/author/craig-hartman) on 1/20/15 2:00 PM

- [Tweet](https://twitter.com/share)

Gap, beta-adjusted gap, duration and even basic budgeting models only frustrate, confuse and even mislead the financial institution’s asset liability management committee (ALCO). Detailed gap analysis, fiddling with the distribution of savings balances and even calculating the duration of equity does not lead to better margins, nor do they mitigate rate risk.

Even more extensive full simulation models only perform three or four scenarios at a time, and some of these take hours to execute. Entrenched in traditional time-based methods, margin managers persist in the belief that more data is better, reports must always foot and graphs always have time as the X-axis.

My purpose here is to suggest a more useful tool with which to measure, control margin behavior, and mitigate your interest rate risk. Current hardware and software technology can provide a better analytical method that clearly communicates the extent of the financial institution’s rate risk and simultaneously suggest a successful strategy without the expense in time and energy of more primitive techniques.

**Factors Affecting Margin Behavior**

If interest rate risk is a behavioral problem, then the purpose of the ALCO is to control the behavior of the margin. The behavior of the financial institution’s margin, however, is itself a function of other factors, including the financial institution’s behavior in pricing loans and deposits and customer behavior.

These factors are dependent variables because they respond to another variable that is not controllable by the financial institution, i.e. market rates. Here we use the term market rates to mean the national rates such as prime, the Treasury yield curve and LIBOR. The challenge is to determine the behavior of the net interest margin as these rates changes.

**Rate Shock: Rate Change, Not Timing**

In order to standardize the measurement of margin behavior over a range of market rate changes, we must remove the timing issue from our analysis. Clearly, timing is important, but the rate changes up or down only clouds the issue.

Our purpose is to understand behavior, not predict margin. We remove the time factor by shocking the market rates, i.e. moving market rates immediately and holding them constant over the analysis period. Typically rate shock yields plotted against shock increments, can express margin behavior. However, irregular behavior is caused by customer behavior, prepayments, and the financial institution’s own pricing behavior as rates change.

**Information Requirements**

The data requirements for rate shocks are typical for all rate risk analysis, i.e. maturity and repricing data. However, we must also include both prepayment models, and a spread model of each account. These are not features found in all simulation models, so let’s review the methods for building them.

**Prepayment Models**

While prepayment models are a part of every mortgage-backed security and CMO analysis, many community bankers fail to apply the same logic to their in-house mortgage portfolios. These are, in fact customer behavior models and have market rates as their independent variable.

As market rates rise and fall, mortgage prepayments decrease and increase. Clearly, this has a significant impact on yield. The information needed to construct prepayment models is available by either examining the most recent prepayment information from the financial institution’s records, or from a securities broker who can use the prepayment characteristics of a MBS from your trade area.

**Spread Models**

Spread models reflect financial institution’s pricing as market rates change. It is common that community bankers widen spreads between prime and new loan rates as prime falls and the narrow them as prime rises. On the deposit side, it is common to lower rates quickly on savings and money market accounts as rates fall, but delay rate changes as rates rise.

Whether he or she is aware of it or not, the banker is expressing a pricing behavior model. Beta-adjusted gaps are a simplistic application of this concept translated into balance repricing, then carried to the gap report.

**Shock Calculations**

Putting these all together, we are ready to perform rate shocks on each category on the balance sheet and produce behavior graphs that describe our risk.

What happens within the rate shock model? First, the driver rate is changed by the shock amount. Next, the pricing model is used to determine the rate on new balances. Then cash flows, maturities, prepayments and interest payments, are computed for the next 12 (or 24) months. Finally, these cash flows are reinvested at the new rates and blended with the unchanging portion of the portfolio to determine a new blended yield.

Accounts that reprice immediately such as Fed Funds, of course, do not use maturities, and so the entire category changes. The average yield is computed for the entire time period analyzed.

Finally, these are combined into total asset yields and liability costs to produce the margin for the shock increment, the time required to perform these computations varies within the complexity of the balance sheet, but typically 1-2 minutes at most.

Once we have computed all of the information we can use EIS, Executive Information System, techniques such as drill-down to view information in different ways. One example would be in comparing the yield behavior of loans, investments, and deposits identifying potential strengths and weaknesses within your margin.

**Spread Behavior Useful for Loan Pricing**

Other uses for this information include loan pricing, where we can compare the yield behavior of a loan to that of its funding counterpart. Among other factors, as part of your price building function, the rate risk identified would be added to the loan rate determination.

In conclusion, current asset-liability management techniques are only extensions of the community bank budgeting process. Of the methods available, simulation provides the greatest benefit when it includes all of the factors that affect margin and income.

Rate shock, however, offers the benefits of simulation, with the added advantage of removing the timing issue, and performing many more scenarios automatically. This computational power, coupled with its descriptive graphic presentation is a strong analytical to that translates into a more productive ALCO process.

 Topics: [interest rate risk](https://blog.plansmith.com/topic/interest-rate-risk), [community bank](https://blog.plansmith.com/topic/community-bank), [community bank strategy](https://blog.plansmith.com/topic/community-bank-strategy), [community bank interest rate risk](https://blog.plansmith.com/topic/community-bank-interest-rate-risk), [community bank budget](https://blog.plansmith.com/topic/community-bank-budget), [community bank budget software](https://blog.plansmith.com/topic/community-bank-budget-software), [community bank budgeting](https://blog.plansmith.com/topic/community-bank-budgeting), [fintech](https://blog.plansmith.com/topic/fintech)

### Subscribe Now!

### Posts by Tag

- [community bank planning (52)](https://blog.plansmith.com/topic/community-bank-planning)
- [community bank strategy (52)](https://blog.plansmith.com/topic/community-bank-strategy)
- [community bank (49)](https://blog.plansmith.com/topic/community-bank)
- [community bank budget software (45)](https://blog.plansmith.com/topic/community-bank-budget-software)
- [credit union planning (44)](https://blog.plansmith.com/topic/credit-union-planning)
- [community bank budgeting (42)](https://blog.plansmith.com/topic/community-bank-budgeting)
- [budgeting (39)](https://blog.plansmith.com/topic/budgeting)
- [interest rate risk (35)](https://blog.plansmith.com/topic/interest-rate-risk)
- [community bank interest rate risk (33)](https://blog.plansmith.com/topic/community-bank-interest-rate-risk)
- [community bank budget (30)](https://blog.plansmith.com/topic/community-bank-budget)
- [strategic planning (28)](https://blog.plansmith.com/topic/strategic-planning)
- [asset liability management (27)](https://blog.plansmith.com/topic/asset-liability-management)
- [interest rate risk management (27)](https://blog.plansmith.com/topic/interest-rate-risk-management)
- [community bank marketing strategy (26)](https://blog.plansmith.com/topic/community-bank-marketing-strategy)
- [fintech (26)](https://blog.plansmith.com/topic/fintech)
- [community bank ALCO (25)](https://blog.plansmith.com/topic/community-bank-alco)
- [social media for community banks (24)](https://blog.plansmith.com/topic/social-media-for-community-banks)
- [strategy (24)](https://blog.plansmith.com/topic/strategy)
- [IRR (22)](https://blog.plansmith.com/topic/irr)
- [bank strategy (21)](https://blog.plansmith.com/topic/bank-strategy)
- [social media (20)](https://blog.plansmith.com/topic/social-media)
- [strategic thinking (20)](https://blog.plansmith.com/topic/strategic-thinking)
- [ALCO (19)](https://blog.plansmith.com/topic/alco)
- [community bank forecasting (17)](https://blog.plansmith.com/topic/community-bank-forecasting)
- [strategic planning for banks (17)](https://blog.plansmith.com/topic/strategic-planning-for-banks)
- [ceo (16)](https://blog.plansmith.com/topic/ceo)
- [Strategic Plan (12)](https://blog.plansmith.com/topic/strategic-plan)
- [bank strategic planning software (12)](https://blog.plansmith.com/topic/bank-strategic-planning-software)
- [community bank planning software (12)](https://blog.plansmith.com/topic/community-bank-planning-software)
- [leadership (12)](https://blog.plansmith.com/topic/leadership)
- [CECL (11)](https://blog.plansmith.com/topic/cecl)
- [Customer Service (9)](https://blog.plansmith.com/topic/customer-service)
- [playbook (9)](https://blog.plansmith.com/topic/playbook)
- [alm (8)](https://blog.plansmith.com/topic/alm)
- [bank budget (8)](https://blog.plansmith.com/topic/bank-budget)
- [bank irr reporting (8)](https://blog.plansmith.com/topic/bank-irr-reporting)
- [liquidity (8)](https://blog.plansmith.com/topic/liquidity)
- [credit union interest rate risk (7)](https://blog.plansmith.com/topic/credit-union-interest-rate-risk)
- [crisis planning (7)](https://blog.plansmith.com/topic/crisis-planning)
- [forecasting (7)](https://blog.plansmith.com/topic/forecasting)
- [budget playbook (6)](https://blog.plansmith.com/topic/budget-playbook)
- [compass (6)](https://blog.plansmith.com/topic/compass)
- [Outsource IRR (5)](https://blog.plansmith.com/topic/outsource-irr)
- [banker education (5)](https://blog.plansmith.com/topic/banker-education)
- [surge deposits (5)](https://blog.plansmith.com/topic/surge-deposits)
- [bank mission vision core values (4)](https://blog.plansmith.com/topic/bank-mission-vision-core-values)
- [continuing education (4)](https://blog.plansmith.com/topic/continuing-education)
- [credit union budgeting (4)](https://blog.plansmith.com/topic/credit-union-budgeting)
- [millennials (4)](https://blog.plansmith.com/topic/millennials)
- [reforecasting (4)](https://blog.plansmith.com/topic/reforecasting)
- [IRR Assumptions (3)](https://blog.plansmith.com/topic/irr-assumptions)
- [board training (3)](https://blog.plansmith.com/topic/board-training)
- [branch budgeting (3)](https://blog.plansmith.com/topic/branch-budgeting)
- [decay rate (3)](https://blog.plansmith.com/topic/decay-rate)
- [millennial employees in banking (3)](https://blog.plansmith.com/topic/millennial-employees-in-banking)
- [rising rates (3)](https://blog.plansmith.com/topic/rising-rates)
- [what-ifs (3)](https://blog.plansmith.com/topic/what-ifs)
- [AI (2)](https://blog.plansmith.com/topic/ai)
- [FDIC (2)](https://blog.plansmith.com/topic/fdic)
- [backtesting (2)](https://blog.plansmith.com/topic/backtesting)
- [bank brand marketing (2)](https://blog.plansmith.com/topic/bank-brand-marketing)
- [board of directors (2)](https://blog.plansmith.com/topic/board-of-directors)
- [compliance (2)](https://blog.plansmith.com/topic/compliance)
- [cost center budgeting (2)](https://blog.plansmith.com/topic/cost-center-budgeting)
- [deposit study (2)](https://blog.plansmith.com/topic/deposit-study)
- [deposit trends (2)](https://blog.plansmith.com/topic/deposit-trends)
- [funds transfer pricing (2)](https://blog.plansmith.com/topic/funds-transfer-pricing)
- [market intelligence (2)](https://blog.plansmith.com/topic/market-intelligence)
- [millennials in banking (2)](https://blog.plansmith.com/topic/millennials-in-banking)
- [modern human resources strategy for banks (2)](https://blog.plansmith.com/topic/modern-human-resources-strategy-for-banks)
- [peer analysis (2)](https://blog.plansmith.com/topic/peer-analysis)
- [stress testing (2)](https://blog.plansmith.com/topic/stress-testing)
- [Insider (1)](https://blog.plansmith.com/topic/insider)
- [asset prepayments (1)](https://blog.plansmith.com/topic/asset-prepayments)
- [baby boomers (1)](https://blog.plansmith.com/topic/baby-boomers)
- [brand (1)](https://blog.plansmith.com/topic/brand)
- [client spotlight (1)](https://blog.plansmith.com/topic/client-spotlight)
- [contingency funding plan (1)](https://blog.plansmith.com/topic/contingency-funding-plan)
- [credit union strategic planning software (1)](https://blog.plansmith.com/topic/credit-union-strategic-planning-software)
- [employee human resources for banks (1)](https://blog.plansmith.com/topic/employee-human-resources-for-banks)
- [event (1)](https://blog.plansmith.com/topic/event)
- [financial institution succession planning (1)](https://blog.plansmith.com/topic/financial-institution-succession-planning)
- [funding (1)](https://blog.plansmith.com/topic/funding)
- [loan prepayments (1)](https://blog.plansmith.com/topic/loan-prepayments)
- [market analysis (1)](https://blog.plansmith.com/topic/market-analysis)
- [negative rates (1)](https://blog.plansmith.com/topic/negative-rates)
- [policy (1)](https://blog.plansmith.com/topic/policy)
- [ppp loans (1)](https://blog.plansmith.com/topic/ppp-loans)
- [profitability (1)](https://blog.plansmith.com/topic/profitability)
- [sensitivity testing (1)](https://blog.plansmith.com/topic/sensitivity-testing)
- [social video for banks (1)](https://blog.plansmith.com/topic/social-video-for-banks)
- [strategic action plan (1)](https://blog.plansmith.com/topic/strategic-action-plan)
- [trade show (1)](https://blog.plansmith.com/topic/trade-show)

See all

### Recent Posts

- Navigate 
    - [Home](https://www4.plansmith.com/)
    - [Budgeting](https://www4.plansmith.com/budgeting/)
    - [Asset Liability Management](https://www4.plansmith.com/alm/)
    - [CECL](https://www4.plansmith.com/cecl/)
    - [Strategy](https://www4.plansmith.com/strategy/)
    - [Market Intelligence](https://www4.plansmith.com/market-intelligence/)
    - [About](https://www4.plansmith.com/about/)
    - [Contact Us](https://www4.plansmith.com/contact-us/)
- Products 
    - [StrategyGPS](https://www4.plansmith.com/strategygps/)
    - [Compass](https://www4.plansmith.com/compass/)
    - [BankersGPS](https://www4.plansmith.com/bankersgps/)
- Resources 
    - [Blog](https://blog.plansmith.com)
    - [Videos](https://plansmith.wistia.com/projects/7qemazkqii)
    - [Compass Tutorials](https://info.plansmith.com/compass-tutorials)
    - [Lunch n' Learns](https://info.plansmith.com/lunch-n-learns)
    - [Webinars](https://www4.plansmith.com/webinars/)

#### Contact

1827 Walden Office Square, Ste. 350  
Schaumburg IL 60173

Toll Free: 1.800.323.3281  
Local: 1.847.359.4045  
Fax: 1.847.705.8200

info@plansmith.com

Copyright 2018 | Plansmith Corporation

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Craig Hartman",
    "url" : "https://blog.plansmith.com/author/craig-hartman"
  },
  "datePublished" : "2015-01-20T20:00:00.000Z",
  "headline" : "Interest Rate Risk Is A Community Bank Behavioral Problem",
  "image" : [ "https://blog.plansmith.com/hubfs/IRRBehavioralProblem.jpg" ],
  "mainEntityOfPage" : {
    "@id" : "https://blog.plansmith.com/interest-rate-risk-is-a-community-bank-behavioral-problem",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://blog.plansmith.com/hubfs/Plansmith-Logo-Budgeting-ALM-Outsourcing-01.png"
    },
    "name" : "Plansmith"
  }
}
```