---
title: "Community Banks: Fun with Funds Transfer Pricing, Part II"
description: "Community Banks: Fun with Funds Transfer Pricing, Part II"
image: https://blog.plansmith.com/hubfs/FunWithFTP1.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

# Community Banks: Fun with Funds Transfer Pricing, Part II

Posted by [Tom Parsons](https://blog.plansmith.com/author/tom-parsons) on 3/23/16 12:00 PM

![Tom Parsons](https://blog.plansmith.com/hubfs/SnapDotStipple.png)

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

In the previous post we explored the concept of funds transfer pricing (FTP), but only on the surface level. Now for the good stuff: how should the FTP rate be assigned? Well, in a number of ways from the simple to the complex. Like a lot of things in life, simple means fast, easy, less data, good enough; whereas complex requires lots of patience and data for a little more accuracy.

Methods of FTP can be placed in one of two categories: Pool Pricing and Matched Maturity Pricing. In the pool methods, loans and deposits are summarized, or pooled, into categories. Generally speaking, pool pricing leans towards simple, but there are degrees of simple and are identified as:

| **Single** | **Double** | **Multiple** |
| --- | --- | --- |
| Same rate applied to both loans and deposits | One rate applied to loans | Unique rates for each product category |
| Simplest to implement | Different rate for deposits | Requires decisions, buy-in |
| GL data | As easy as single | GL Data |
|   | GL Data |   |

The table below compares the results you might find in choosing one method over the others. The term of the treasury rate chosen should roughly match the average life of the category or product. In the single term method, we have to compromise by using a term that is likely lower than the average loan life and higher than the deposits. With the double rate method, we start to see a funding center gap, and in the multiple rate method, a more precise result.

| Category/Product | Single Pool | Double Pool | Multiple Pool |
| --- | --- | --- | --- |
| Loans | 1.05 (3 yr Treas) | 1.05 (3 yr Treas) |   |
| Mortgages |   |   | 1.70 (7 yr Treas) |
| Personal |   |   | 1.05 (3 yr Treas) |
|   |   |   | 1.37 avg |
| Deposits | 1.05 (3 yr Treas) | .63 (1 yr Treas) |   |
| DDA/Savings |   |   | .46 (6 mo Treas) |
| Term/CDs |   |   | .63 (1 yr Treas) |
|   |   |   | .55 avg |
| Funding Center | 0 | .42 | .82 |

*Source US Treasury 03/21/2015*

**Matched Maturity Goes to Eleven**

 “Where can you go from there? Where? Nowhere. Exactly. What we do is, if we need that extra push over the cliff, you know what we do? Put it up to eleven.” Nigel Tufnel

Matched Maturity requires a download of all customer accounts at the instrument level. With all of the security concerns, this might not be desirable unless customer account numbers can be masked or changed. In Matched Maturity, each loan and deposit is evaluated and assigned it’s very own funds transfer rate, which stays with it until the account matures or reprices.

**Single Term/Bullet**

A fixed rate loan made on March 21, 2010 would have a different rate from a loan made on March 22, 2016. Assuming this is a 30-year fixed rate mortgage, in a portfolio that has an average life of 7 years, match the average life to a point on the yield curve to find the transfer rate. The 7-year rate on 3/22/2010 was 3.16%. The same rate today is 1.70%. The 30-year Freddie rate in March 2010 was 4.97%, and is 3.73% today. The match funded transfer pricing looks like this:

| Orig. Date | Amount | Avg. Life | Loan Rate | FTP | Spread |
| --- | --- | --- | --- | --- | --- |
| 3/21/2010 | 100,000 | 7 | 4.97 | 3.16 | 1.81 |
| 3/21/2016 | 100,000 | 7 | 3.73 | 1.70 | 2.03 |

If this were an ARM or floating rate loan, the average life used would simply be the next reprice date.  
What this tells you is that loans made today are more profitable by 22 bps.

But loans don’t pay off in one lump sum like a bullet bond. They amortize over time, so we have to introduce Matched Multiple Term/Amortizing.

**Matched Multiple Term/Amortizing**

Simply stated, it treats each contractual payment as its own maturity and matches an interpolated yield curve rate with each payment. This is far too much to illustrate here.

**Comparing Results**

If we look at the results of the different methods, we see a variety of spreads:

| Orig. Date |  Loan Rate | Single Pool Spread | Multi-Pool Spread | Matched Spread |
| --- | --- | --- | --- | --- |
| 3/21/2010 |  4.97 | 3.92 | 3.27 | 1.81 |
| 3/21/2016 |  3.73 | 2.68 | 2.03 | 2.03 |

So depending on your choice of methods, you will have very different results – and that’s where discussions within the organization become a challenge. What will you do with this data? Are loans originated in different locations more profitable and will you take some action as a result? Will you stop offering certain unprofitable products?

Further, if you aren’t careful about the method used, can’t explain it thoroughly, and don’t have agreement from all corners of the organization, then the results are useless. It simply becomes a report for the finance office.

My personal belief, after years of teaching FTP, cost accounting, and profitability, is that keeping it simple allows for an easier discussion of the results and a lot less headaches in implementing and maintaining an FTP system.

There is a lot more to the discussion than allowed by a couple pages in a blog, so feel free to reach out to me with any questions.

 Topics: [interest rate risk](https://blog.plansmith.com/topic/interest-rate-risk), [community bank forecasting](https://blog.plansmith.com/topic/community-bank-forecasting), [funds transfer pricing](https://blog.plansmith.com/topic/funds-transfer-pricing), [community bank](https://blog.plansmith.com/topic/community-bank), [community bank ALCO](https://blog.plansmith.com/topic/community-bank-alco), [community bank interest rate risk](https://blog.plansmith.com/topic/community-bank-interest-rate-risk), [community bank planning software](https://blog.plansmith.com/topic/community-bank-planning-software), [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), [community bank planning](https://blog.plansmith.com/topic/community-bank-planning)

### 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" : "Tom Parsons",
    "url" : "https://blog.plansmith.com/author/tom-parsons"
  },
  "datePublished" : "2016-03-23T17:00:00.000Z",
  "headline" : "Community Banks: Fun with Funds Transfer Pricing, Part II",
  "image" : [ "https://blog.plansmith.com/hubfs/FunWithFTP1.jpg" ],
  "mainEntityOfPage" : {
    "@id" : "https://blog.plansmith.com/community-banks-fun-with-funds-transfer-pricing-part-ii",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://blog.plansmith.com/hubfs/Plansmith-Logo-Budgeting-ALM-Outsourcing-01.png"
    },
    "name" : "Plansmith"
  }
}
```