CMS Case Study
Balance Sheet Comparison - 9/30/2020
SEP 20
JUN 20
VARIANCE
Balance Rate
Balance Rate
Balance Rate
CD 27 Month Special CD 36-47 Months
779 1.03 1,325 1.20 107 2.25 708 0.83 6,158 1.10
777 1.03 1,359 1.19 107 2.25 736 0.84 4,904 1.20
2 0.00
-33 0.00
CD 36-47 Months Special
0 --
CD 48-59 Months CD 60+ Months
-28 -0.01 1,253 -0.10
CD 60+ Months SPEC CD Special 8 Months
1 2.25
1 2.25
0 --
--
--
1,527 1.85 877 0.61
-1,527 -1.85 1,381 -0.23 -1 -0.10 205 -0.28 -8 0.03 431 -0.13 -869 -0.06
IRA 6-11 Months
2,259 0.38
IRA 11 Month Special IRA 12-17 Months IRA 13 Months Special IRA 18-23 Months IRA 18 Month Special IRA 24-35 Months IRA 27 Month Special IRA 36-47 Months IRA 36-47 Months Special
51 0.50
52 0.60
1,642 0.63
1,437 0.91
55 0.64
63 0.61
1,643 0.70 1,896 2.07 258 0.96 21 1.00 526 1.28 14 2.25 102 0.80 3,952 1.08
1,212 0.83 2,765 2.13 259 0.96 21 1.00 524 1.32 14 2.25 102 0.81 2,724 1.14 166 1.85 83,277 1.32 419 0.60 5,752 0.94 10,160 1.78 5,342 1.46 3,735 2.12 6,302 1.39 2,236 2.10 255 1.00 2,695 1.94 250 1.25 4,156 1.36 934 1.85 42,236 1.56
-1 0.00 0 -- 2 -0.04 0 -- 0 -0.01
IRA 48-59 Months IRA 60+ Months IRA Special 8 Months
1,228 -0.05 -166 -1.85 -5,986 -0.36
--
--
Total CD
77,291 0.96
Jumbo CD 1-5 Months Jumbo CD 6-11 Months
419 0.60
0 --
10,521 0.52 1,356 1.77 7,001 1.07 309 0.85 3,799 1.28 5,047 1.16 255 1.00 2,708 1.94
4,770 -0.42 -8,805 -0.01 1,659 -0.39 -3,426 -1.27 -2,503 -0.11 2,811 -0.95
Jumbo CD 6-11 Months Special
Jumbo CD 12-17 Months Jumbo CD 18-23 Months
Jumbo CD 18-23 Month Special
Jumbo CD 24-35 Months
Jumbo CD 24-35 Month Special Jumbo CD 36-47 Months Jumbo CD 48-59 Months Jumbo CD 60+ Months Jumbo CD Special 8 Months
--
--
13 0.00
--
--
-250 -1.25 1,608 -0.23 -934 -1.85 -5,057 -0.53
5,764 1.13
--
--
Total Jumbo CD
37,178 1.04
CD ADJUSTMENT
--
--
-182 --
182 --
TOTAL TIME DEPOSITS
114,469 0.98
125,331 1.40
-10,862 -0.42
TOTAL DEPOSITS
570,406 0.41
583,319 0.50
-12,913 -0.10
Secured Retail - FF
26,321 0.62 26,321 0.62
20,743 0.65 20,743 0.65
5,578 -0.03 5,578 -0.03
TOTAL SECURED RETAIL
FHLB Callable
20,000 0.76 20,000 0.76
20,000 0.76 20,000 0.76
-- --
-- --
Total FHLB Adv - Structured
TOTAL FHLB ADVANCES
20,000 0.76
20,000 0.76
--
--
Cloyd Bank & Trust - Page 69
Made with FlippingBook PDF to HTML5