CMS Case Study
Index MMDA to Prime - 12/31/2021
Index MMDA to Prime
Base Simulation as of 12/31/2021
Quarterly Net Interest Income (NII) Projections
Quarterly Net Interest Income (NII) Projections
9,175
YEAR 1
YEAR 2
YEAR 3
YEAR 4
YEAR 5
YEAR 1
YEAR 2
YEAR 3
YEAR 4
YEAR 5
8,175
7,175
6,175
5,175
4,175
Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4
Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4
Up 400BP 24M Flat Up 200BP
Up 200BP
Base
Up 400BP 24M Flat Up 200BP
Up 200BP
Base
NII RESULTS
Y1
Y2
Y3
Y4
Y5
Y1
Y2
Y3
Y4
Y5
Y1
Y2
Y3
Y4
Y5
UP 400BP 24M FLAT UP 200BP
22,743 22,061 23,907 27,789 31,215 22,326 21,550 22,063 23,004 23,816 22,675 22,928 24,467 26,433 28,182 23,280 23,089 22,931 23,118 23,340
432 1,069 1,358 1,356 1,355 22,311 20,991 22,549 26,433 29,861
432 432
724 722
723 721
723 720
723 21,894 20,826 21,340 22,281 23,093 719 22,243 22,206 23,746 25,713 27,463 86 23,196 23,003 22,844 23,031 23,253
UP 200BP
85
86
87
87
BASE
DIFFERENCE
YR 2 % CHANGE FROM YR 1 BASE POLICY
Y1 POLICY
Y2
Y1
Y2
POLICY
Y1 POLICY
Y2
UP 400BP 24M FLAT UP 200BP
-2.3% -4.1%
-5.2% -7.4%
1.5% 1.5% 1.5%
4.3% 2.8% 2.8% 0.0%
-3.8% -5.6%
-9.5%
-10.2%
UP 200BP
-15.0% -2.6% -15.0% -1.5%
-15.0% -4.1% -15.0% -4.3%
-0.8%
-0.8%
BASE
DIFFERENCE 1. Alternative simulation assumes MMDA accounts are indexed as follows: ($0-19K tied to 3% of Prime, $20K-$49K tied to 4% of Prime, $50K-$99K tied to 5% of Prime, $100K-$249K tied to 6% of Prime, $250K+ tied to 7% of Prime). 2. Base simulation assumes all MMDA accounts have a beta of 50% in the rising rate scenarios.
Cloyd Bank & Trust - Page 39
Made with FlippingBook PDF to HTML5