CMS Case Study

Balance Sheet Comparison - 12/31/2020

DEC 20

SEP 20

VARIANCE

Balance Rate

Balance Rate

Balance Rate

CD 27 Month Special CD 36-47 Months

781 1.03 920 1.07 107 2.25 744 0.81 7,361 1.05

779 1.03 1,325 1.20 107 2.25 708 0.83 6,158 1.10

2 0.00

-405 -0.13

CD 36-47 Months Special

0 -- 36 -0.02

CD 48-59 Months CD 60+ Months

1,203 -0.05

CD 60+ Months SPEC

1 2.25

1 2.25

0 --

IRA 6-11 Months

3,325 0.30

2,259 0.38

1,066 -0.07

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.47

51 0.50

0 -0.04

1,894 0.58

1,642 0.63

253 -0.05

55 0.64

55 0.64

0 0.00

2,061 0.62 888 1.87 243 0.92 21 1.00 527 1.28 14 2.25 101 0.80 4,780 1.03 72,294 0.72 7,159 0.93 310 0.85 2,982 0.97 5,062 1.16 255 1.00 1,311 1.99 8,519 1.05 300 0.40 290 0.85 39,360 0.81 500 0.15 12,673 0.32 -- --

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 77,291 0.96 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 5,764 1.13 419 0.60

418 -0.08

-1,009 -0.20

-15 -0.04 0 -- 1 0.00 0 -- -1 0.00 828 -0.05

IRA 48-59 Months IRA 60+ Months

Total CD

-4,997 -0.24

Jumbo CD 1-5 Months Jumbo CD 6-11 Months

81 -0.45

2,151 -0.20 -1,356 -1.77

Jumbo CD 6-11 Months Special

Jumbo CD 12-17 Months Jumbo CD 18-23 Months

158 -0.14

1 --

Jumbo CD 18-23 Month Special

-816 -0.30

Jumbo CD 24-35 Months

15 0.00

Jumbo CD 24-35 Month Special

--

--

Jumbo CD 36-47 Months Jumbo CD 60+ Months Jumbo IRA 12-17 Months Jumbo IRA 60+ Months

-1,397 0.05 2,755 -0.07 300 0.40 290 0.85 2,182 -0.22

-- --

-- --

Total Jumbo CD

37,178 1.04

TOTAL TIME DEPOSITS

111,654 0.75

114,469 0.98

-2,816 -0.23

TOTAL DEPOSITS

607,080 0.35

570,406 0.41

36,674 -0.06

Secured Retail - FF

21,996 0.50 21,996 0.50

26,321 0.62 26,321 0.62

-4,325 -0.12 -4,325 -0.12

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

--

--

TOTAL BORROWINGS

41,996 0.62

46,321 0.68

-4,325 -0.06

Cloyd Bank & Trust - Page 70

Made with FlippingBook PDF to HTML5