CMS Case Study
Time Deposit Migration - 9/30/2020
MATURITY PROJECTED JUL 20-SEP 20
CDS MATURING OCT 20-DEC 20
SEP 20
JUN 20
RATE CHANGE
BALANCE
RATE
BALANCE
RATE $ CHANGE
BALANCE
RATE RETAINED % RUNOFF %
BALANCE
RATE
REGULAR
<12 MONTHS 12-23 MONTHS 24-59 MONTHS 60+ MONTHS
45,172 40,332 13,090 15,876
0.67 1.19 1.27 1.11 0.00 0.98 0.00 0.00 0.00 0.00 0.00
57,485 43,144 10,470 11,786
1.28 1.56 1.50 1.24 0.00 1.39 1.85 0.00 0.00 0.00 1.85
-12,314 -2,812
-0.60 -0.37 -0.24 -0.13
33,970 11,736
1.48 2.00 1.53 1.40 0.00 1.60 1.85 0.00 0.00 0.00 1.85
64% 76%
36% 24%
23,086
0.99 1.89 1.73 1.22 0.00 1.25 0.00 0.00 0.00 0.00 0.00
7,634 1,960
2,620 4,089
1,028 2,253
100% 100%
0% 0%
642
OTHER TOTAL
0
-182
182
0.00
0
0%
100%
0
114,469
122,703
-8,234
-0.41
48,987
83%
17%
33,323
SPECIAL
<12 MONTHS 12-23 MONTHS 24-59 MONTHS 60+ MONTHS
0 0 0 0 0
2,628
-2,628
-1.85
2,628
0% 0% 0% 0% 0%
100%
0 0 0 0 0
0 0 0
0 0 0
0.00 0.00 0.00 0.00
0 0 0
0% 0% 0%
TOTAL
2,628
-2,628
2,628
100%
TOTAL
114,469
0.98
125,331
1.40
-10,862
-0.42
51,614
1.61
79%
21%
33,323
1.25
Cloyd Bank & Trust - Page 16
Made with FlippingBook PDF to HTML5