CMS Case Study
Alt. CD Cash Flow Assumption - 12/31/2020
Alt. CD Cash Flow Assumption
Base Simulation as of 12/31/2020
Quarterly Net Interest Income (NII) Projections
Quarterly Net Interest Income (NII) Projections
6,375
YEAR 1
YEAR 2
YEAR 3
YEAR 4
YEAR 5
YEAR 1
YEAR 2
YEAR 3
YEAR 4
YEAR 5
5,675
4,975
4,275
3,575
2,875
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 200BP
Base
Down 100BP
Up 200BP
Base
Down 100BP
NII RESULTS
Y1
Y2
Y3
Y4
Y5
Y1
Y2
Y3
Y4
Y5
Y1
Y2
Y3
Y4
Y5
UP 200BP
19,607 19,556 20,344 21,131 21,891 18,796 17,163 16,330 15,643 15,254 18,634 16,649 15,604 14,782 14,322
-96 -441 -495 -495 -495 19,702 19,997 20,839 21,627 22,386
7
12 20
12 20
12 20
12 18,789 17,151 16,317 15,631 15,242 20 18,619 16,629 15,584 14,762 14,302
BASE
DOWN 100BP
14
DIFFERENCE
1. Alternative simulation assumes 9/30's CD assumption where maturities replace 50/50 into 6/12 month CDs. 2. 12/31 simulation assumes 50% of CD maturities in year 1 will replace in to NOW Cloyd Prime (tied to 12% of Prime).
Cloyd Bank & Trust - Page 39
Made with FlippingBook PDF to HTML5