CMS Case Study

LIQUIDITY BASIC SURPLUS 2/28/2022

I. LIQUID ASSETS

987,023 TOTAL ASSETS

-

Overnight Funds Sold & Short-Term Investments (avg. balance, if wide daily fluctuations)

MBS / CMOs

UST & Agency

Agency Backed

Private Label

Security Collateral

95%

90%

Collateral Value

100%

- - - - - - - - -

371,413

Total Market Value of Securities Less Securities Pledged to:

38,428

(25,939)

FHLB

- - -

Fed Discount/Other Secured

-

Wholesale Repos Retail Repos/Sweeps Municipal Deposits

(170,579) (29,499)

(3,201)

(990)

Other

-

(2,037)

136,191

Available / Unencumbered Security Collateral

34,237

Jan 192,057

170,428

10,925

Over Collateralized Securities Pledging Position (FHLB, SAFE & REPO)

(9,518)

5,695

Government Guaranteed Loans

5,712

-

Cash flow (< 30 Days) from Securities not listed above

-

12,834

13,029

Other Liquid Assets (Int. Bearing Deposits, MM Mutual Funds, etc.)

TOTAL LIQUID ASSETS

199,882

20.25%

II. SHORT TERM / POTENTIALLY VOLATILE LIABILITIES & COVERAGES

-

Maturing Unsecured Liabilities (< 30 Days)

Deposit Coverages

25%

of Regular CDs Maturing < 30 Days

2,263

Policy Minimums

30%

0.0%

763

of Jumbo CDs Maturing < 30 Days

Well Cap < Well Cap

10%

of Other Deposits

72,372

(Total Deposits less retail & brokered CDs & Public NOW)

TOTAL SHORT TERM / POTENTIALLY VOLATILE LIABILITIES & COVERAGES

75,398

02/28/22 12.61%

01/31/22 12/31/21

BASIC SURPLUS 124,484

13.27% 18.00% 0.0% 2.0%

III. QUALIFYING FHLB LOAN COLLATERAL

246,756 41,847

A. Maximum Borrowing Line at FHLB (Up to 25% of Assets per the FHLB & with board approval)

Jan

B. C.

Qualifying Loan Collateral at the FHLB (net of haircut)

41,920

Excess Loan Collateral (if A < B)

41,847 60,000

Maximum Borrowing Capacity (Lesser of A or B)

41,920 60,000

Collateral Currently Encumbered by Outstanding Advances/Letters of Credit

0

REMAINING FHLB LOAN BASED BORROWING CAPACITY

0

BASIC SURPLUS W/ FHLB 124,484

12.61%

13.27% 18.00% 4.0% 8.0%

IV. BROKERED DEPOSIT ACCESS

148,053 0

Maximum Board Authorized Brokered Deposit Capacity (15% of Total Assets) Current Brokered Deposit Balances

REMAINING CAPACITY TO UTILIZE BROKERED DEPOSITS

148,053

BASIC SURPLUS W/ FHLB & BROKERED DEPOSITS 272,538

27.61%

28.27% 33.00% 8.0%