CMS Case Study
Balance Sheet Comparison - 9/30/2020
SEP 20
JUN 20
VARIANCE
Balance Rate 9,102 4.90
Balance Rate 8,417 5.12
Balance Rate
Total Res Const Fixed
685 -0.22
TOTAL RESIDENTIAL CONSTRUCTION
9,102 4.90
8,417 5.12
685 -0.22
C&I Fixed -
38,671 4.94
41,506 5.01
-2,835 -0.07 -35 0.53 1,527 -0.30 -158 -0.34 672 -- -830 -0.19 -17 -0.12 -1 0.03 2,936 -0.04 -768 0.05
C&I Fixed - LOC C&I Fixed - I/O
38 7.36
73 6.83
8,150 4.67 1,103 5.50 1,697 -- 49,659 4.74
6,623 4.97 1,261 5.84 1,025 -- 50,488 4.93
C&I Fixed - I/O LOC C&I Non-Accrual
Total C&I Fixed
C&I Adj 1M (Prime)
2,658 4.91
2,675 5.03
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
45 7.00
46 6.97
12,631 4.37 5,780 4.56
9,695 4.42 6,547 4.50 181 3.75 19,144 4.53
180 3.75
-1 --
Total C&I Adj
21,294 4.49
2,149 -0.04
TOTAL COMMERCIAL & INDUSTRIAL
70,952 4.67
69,633 4.82
1,319 -0.15
CRE Fixed -
145,817 4.83 18,438 4.91
154,323 4.90 20,908 5.06 -10,698 3.91 164,534 4.98
-8,506 -0.07 -2,471 -0.16 10,698 -3.91 -279 -0.14
CRE Fixed - I/O
CRE Participation (Manual)
--
--
Total CRE Fixed
164,254 4.84
CRE Adj 1M (Prime) CRE Adj 1M (Prime) I/O CRE Adj 1M (1M LIBOR) CRE Adj 1M (1M LIBOR) I/O
11,270 4.19 26,200 4.22
9,220 4.32 31,886 3.91
2,051 -0.14 -5,686 0.32
445 3.75 459 2.53
449 3.75 424 2.53
-3 -- 35 --
Total CRE Adj
38,375 4.19
41,978 3.98
-3,604 0.21
TOTAL COMMERCIAL RE
202,629 4.72
206,512 4.78
-3,883 -0.06
HE Adj 1M (Prime) I/O LOC
19,848 4.31 19,848 4.31
20,818 4.30 20,818 4.30
-970 0.01 -970 0.01
Total HE Adj
TOTAL HOME EQUITY
19,848 4.31
20,818 4.30
-970 0.01
Install Fixed -
7,499 6.64 650 5.20
7,713 6.76 495 5.99
-214 -0.11 155 -0.79 -1 -- -61 -0.18 -12 0.00 -495 0.04 -13 0.01 -519 0.19
Install Fixed - I/O
Install Fixed - I/O LOC Total Install Fixed
3 5.75
5 5.75
8,152 6.53
8,213 6.71
Install Adj 1M (Prime) Install Adj 1M (Prime) I/O Install Adj 1M (Prime) I/O LOC
830 3.57 257 3.31 1,023 4.98 2,109 4.22
841 3.57 752 3.27 1,036 4.97 2,629 4.04
Total Install Adj
Cloyd Bank & Trust - Page 66
Made with FlippingBook PDF to HTML5