CMS Case Study

Inventory of Liquidity Resources - 6/30/2021

CUMULATIVE AMOUNT

% OF ASSETS

BASIC SURPLUS

% OF ASSETS

BASIC SURPLUS

AMOUNT % OF ASSETS

45%

1. TIER 1 LIQUIDITY (LIQUID ASSETS)

221,069 26.6%

221,069 26.6% 163,229

19.7% (Policy Minimum: 0.0%)

Cash/Equivalents 91,220 Free Bond Collateral 125,600

30%

0

Other Inv. Cash Flow <30 Days

4,249

Other Liquid Assets + Gov't Guaranteed Loans

2. TIER 2 LIQUIDITY (FHLB LOAN BASED CAPACITY)

10,333 1.2%

231,402 27.9% 173,562

20.9% (Policy Minimum: 4.0%)

15%

45,333 35,000

Maximum FHLB Borrowings Capacity

Outstanding Advances/ LOCS

0%

Jun-20 Sep-20 Dec-20 Mar-21 Jun-21

3. TIER 3 LIQUIDITY (BROKERED DEPOSITS CAPACITY) 124,559 15.0%

355,961 42.9% 298,121

35.9% (Policy Minimum: 8.0%)

Maximum Brokered Deposits Capacity 124,559 Current Brokered Deposits 0

BASIC SURPLUS CALCULATION Cumulative Amount - Volatile Liabilities Coverage = Basic Surplus VOLATILE LIABILITIES COVERAGE Coverage = $57,840 7% of Assets

4. OTHER LIQUIDITY

46,062 5.5%

402,024 48.4%

12,021

Other Investments less Cash flow (< 30 Days)

2,616

Secured Borrowing Lines Unsecured Borrowing Lines

31,425

AVAILABLE WHOLESALE FUNDING CAPACITY

ON BALANCE SHEET LIQUIDITY = $233,091 / 28.1% of Assets Liquid Assets (excl. Cash flow <30 Days)+ Available Other Inv.

AVAILABLE FUNDING

AVAILABLE FUNDING PER POLICY

AVAIL. FUNDING PER TOTAL WHOLESALE POLICY

POLICY

FHLB

25,333

25,333 124,559 34,041 183,933

25,333 120,746

NOTES: 1. Other Investments includes available Municipals and Corporates less cash flow < 30 Days. 2. Outstanding advances include $15MM in FHLB Letter of Credit.

BROKERED 15.0% 124,559

OTHER WHOLESALE

34,041

0

TOTAL 20.0% 183,933

146,079

Cloyd Bank & Trust - Page 8