CMS Case Study

Balance Sheet Comparison - 9/30/2021

SEP 21

JUN 21

VARIANCE

Balance Rate 13,937 4.20 14,214 4.20

Balance Rate 12,831 4.29 13,109 4.29

Balance Rate 1,107 -0.09 1,105 -0.09

Res Adj 3M (Prime) Residential Adj

TOTAL RESIDENTIAL

64,632 3.91

61,147 3.99

3,485 -0.08

Res Const Fixed -

--

--

478 4.25 7,250 4.34 7,728 4.34

-478 -4.25 2,876 -0.04 2,398 -0.04

Res Const Fixed - I/O Total Res Const Fixed

10,126 4.30 10,126 4.30

TOTAL RESIDENTIAL CONSTRUCTION

10,126 4.30

7,728 4.34

2,398 -0.04

C&I Fixed -

44,200 4.30

42,064 4.44 101 6.29 7,294 4.31 1,337 4.80 1,224 -- 52,021 4.33

2,135 -0.15

C&I Fixed - LOC C&I Fixed - I/O

101 6.29

0 0.00

13,664 3.91 1,293 4.78 1,206 -- 60,464 4.14

6,370 -0.40 -44 -0.02 -18 -- 8,443 -0.20

C&I Fixed - I/O LOC C&I Non-Accrual

Total C&I Fixed

C&I Adj 1M (Prime)

5,888 3.87

4,146 4.20

1,742 -0.34

C&I Adj 1M (Prime) LOC C&I Adj 1M (Prime) I/O C&I Adj 1M (Prime) I/O LOC C&I Adj 3M (Prime) I/O LOC C&I Adj 3M (Prime) Non-Accrual

57 5.94

56 5.75

1 0.18

4,792 4.21 8,778 4.10

5,966 3.95 8,105 4.12 470 3.75

-1,174 0.27 672 -0.02 -470 -3.75 -85 -- 687 0.00

-- --

-- --

85 --

Total C&I Adj

19,516 4.06

18,829 4.06

TOTAL COMMERCIAL & INDUSTRIAL

79,979 4.12

70,850 4.26

9,129 -0.14

CRE Fixed -

154,338 4.50 24,629 4.69 178,967 4.53 11,163 4.02 16,837 4.04 426 3.75 1,100 2.46 728 4.95 30,254 3.99

147,940 4.60 18,362 4.79 166,302 4.62 12,842 4.13 24,132 3.92 431 3.75 1,100 2.51 731 4.95 39,236 3.97

6,398 -0.10 6,267 -0.10 12,665 -0.09

CRE Fixed - I/O Total CRE Fixed

CRE Adj 1M (Prime) CRE Adj 1M (Prime) I/O CRE Adj 1M (1M LIBOR) CRE Adj 1M (1M LIBOR) I/O

-1,678 -0.11 -7,295 0.11

-5 -- -- -0.06 -4 --

CRE Adj 3M (Prime)

Total CRE Adj

-8,981 0.02

TOTAL COMMERCIAL RE

209,221 4.45

205,538 4.50

3,683 -0.05

HE Adj 1M (Prime) I/O LOC

17,856 4.22 17,856 4.22

17,478 4.26 17,478 4.26

378 -0.04 378 -0.04

Total HE Adj

TOTAL HOME EQUITY

17,856 4.22

17,478 4.26

378 -0.04

Install Fixed -

7,264 6.13 588 4.76

7,066 6.31 620 4.56

197 -0.19 -32 0.21

Install Fixed - I/O

Cloyd Bank & Trust - Page 68

Made with FlippingBook PDF to HTML5