CMS Case Study

Balance Sheet Comparison - 9/30/2020

SEP 20

JUN 20

VARIANCE

Balance Rate

Balance Rate

Balance Rate

ASSETS Fed Funds Sold FFS - SERVISFIRST

60,329 0.10 10,880 0.45 6,064 0.50 77,273 0.18

73,477 0.10 10,880 0.45 6,062 0.50 90,419 0.17 3,731 1.95 90,716 2.00 2,480 2.00 96,927 2.00

-13,148 --

--

--

Centerstate (Int Bearing)

2 --

TOTAL SHORT TERM INVESTMENTS

-13,146 0.01

MBS Fixed GNMA AFS MBS Fixed GSE AFS

4,934 1.73 98,629 1.82

1,202 -0.23 7,913 -0.18 -2,480 -2.00 6,636 -0.19

MBS Adjustment

--

--

TOTAL MBS

103,563 1.81

CMO Fixed GSE AFS

2,290 2.21 2,290 2.21

2,418 2.09 2,418 2.09

-128 0.12 -128 0.12

TOTAL CMO

Muni Fixed AFS

1,064 1.12 28,356 3.58 822 4.25 2,327 3.44 32,569 3.51

--

--

1,064 1.12 -938 -0.02 -1 0.00 503 -0.51 628 -0.13

Muni Fixed Callable Tax Exempt AFS Muni Fixed Callable Tax Exempt AFS (Manu

29,294 3.60 823 4.26 1,823 3.95 31,940 3.64

Muni Fixed Callable AFS

TOTAL MUNI

Corporate Adj 3M (3M LIBOR) Callable AFS

300 4.00 300 4.00

300 4.06 300 4.06

-- -0.06 -- -0.06

TOTAL CORPORATE

Other Liquid Assets Fixed AFS CD Other Liquid Assets Fixed AFS (Manual)

5,174 2.92 250 1.66 5,424 2.86

5,909 2.90

-735 0.02 250 1.66 -485 -0.04

--

--

TOTAL OTHER LIQUID ASSETS

5,909 2.90

SBA-Other Fixed GSE AFS

5,307 3.26 5,307 3.26

5,579 3.26 5,579 3.26

-272 -- -272 --

TOTAL SBA-OTHER

FHLB Stock

1,354 4.00 1,201 -- 4,833 --

1,354 4.35 1,177 -- 4,863 --

-- -0.35 24 -- -30 --

SERP Deferred Compensation Unrealized G/L (ASC 320)

TOTAL INVESTMENTS

234,112 1.54

240,886 1.55

-6,774 -0.01

Res Fixed 10Y

9,415 5.59 3,736 4.91 10,737 4.50 2,375 4.16 15,165 3.74 41,427 4.49

9,970 5.60 3,997 5.25 10,488 4.67 2,006 4.25 9,968 4.03 36,430 4.79

-555 -0.01 -261 -0.34 249 -0.18 369 -0.08 5,196 -0.29 4,998 -0.30

Res Fixed 10Y I/O

Res Fixed 15Y Res Fixed 20Y Res Fixed 30Y

Residential Fixed

Res Adj 1M (Prime) Res Adj 3M (Prime) Residential Adj

11 5.50

12 5.50

-1 --

11,807 4.42 11,818 4.42

12,099 4.48 12,111 4.49

-292 -0.06 -292 -0.06

TOTAL RESIDENTIAL

53,246 4.47

48,540 4.71

4,706 -0.24

Res Const Fixed - I/O

9,102 4.90

8,417 5.12

685 -0.22

Cloyd Bank & Trust - Page 65

Made with FlippingBook PDF to HTML5