CMS Case Study

Balance Sheet Comparison - 6/30/2021

JUN 21

MAR 21

VARIANCE

Balance Rate

Balance Rate

Balance Rate

CD 36-47 Months Special

107 2.25 748 0.80 7,908 1.00

107 2.25 838 0.85 7,336 1.03

0 --

CD 48-59 Months CD 60+ Months

-90 -0.06 572 -0.03 0 -- 45 0.23 0 -0.05 0 -0.04 183 -0.14 0 0.00 24 0.00 -3 -- 10 -0.02 0 -- 25 -0.04 0 -- 0 -0.07 55 -0.01

CD 60+ Months SPEC

1 2.25 45 0.23

1 2.25

IRA 1-5 Months IRA 6-11 Months

--

--

3,299 0.25

3,299 0.30

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

19 0.29

19 0.33

2,076 0.39

1,892 0.53

55 0.57

55 0.57

2,403 0.56 236 0.85 225 0.87 21 1.00 549 1.25 14 2.25 102 0.74 5,082 1.00 69,568 0.54 595 0.23 9,146 0.26 5,460 0.48 311 0.85 2,730 0.85 5,085 0.59 255 1.00 1,324 1.19 9,363 1.01 301 0.40 291 0.85 34,859 0.64

2,379 0.57 238 0.85 214 0.89 21 1.00 524 1.29 14 2.25 101 0.80 5,027 1.01 70,996 0.57 310 0.85 2,726 0.85 5,077 1.16 255 1.00 1,317 1.99 9,046 1.01 300 0.40 622 0.85 35,977 0.76 335 0.30 10,826 0.30 5,164 0.56

IRA 48-59 Months IRA 60+ Months

Total CD

-1,428 -0.03

Jumbo CD 1-5 Months Jumbo CD 6-11 Months Jumbo CD 12-17 Months Jumbo CD 18-23 Months

260 -0.07

-1,680 -0.04

296 -0.08

1 -- 4 -- 8 -0.57

Jumbo CD 18-23 Month Special

Jumbo CD 24-35 Months

Jumbo CD 24-35 Month Special

--

--

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

7 -0.80

317 -0.01

0 --

-331 -- -1,118 -0.12

Total Jumbo CD

TOTAL TIME DEPOSITS

104,427 0.57

106,973 0.63

-2,546 -0.06

TOTAL DEPOSITS

705,938 0.28

678,340 0.32

27,598 -0.04

Secured Retail - FF

24,493 0.56 24,493 0.56

23,848 0.53 23,848 0.53

645 0.02 645 0.02

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

44,493 0.65

43,848 0.63

645 0.01

OTHER LIABILITIES

2,838 -- 2,838 --

2,430 -- 2,430 --

408 -- 408 --

Total Other Liabilities

Cloyd Bank & Trust - Page 67

Made with FlippingBook PDF to HTML5