CMS Case Study

Inventory of Liquidity Resources - 3/31/2021

CUMULATIVE AMOUNT

% OF ASSETS

BASIC SURPLUS

% OF ASSETS

BASIC SURPLUS

AMOUNT % OF ASSETS

45%

1. TIER 1 LIQUIDITY (LIQUID ASSETS)

199,710 25.3%

199,710 25.3% 143,750

18.2% (Policy Minimum: 0.0%)

Cash/Equivalents 146,145

48,636

Free Bond Collateral

30%

0

Other Inv. Cash Flow <30 Days

4,929

Other Liquid Assets + Gov't Guaranteed Loans

2. TIER 2 LIQUIDITY (FHLB LOAN BASED CAPACITY)

9,760 1.2%

209,470 26.5% 153,510

19.4% (Policy Minimum: 4.0%)

15%

44,760 35,000

Maximum FHLB Borrowings Capacity

Outstanding Advances/ LOCs

0%

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

3. TIER 3 LIQUIDITY (BROKERED DEPOSITS CAPACITY) 118,553 15.0%

328,023 41.5% 272,063

34.4% (Policy Minimum: 8.0%)

Maximum Brokered Deposits Capacity 118,553 Current Brokered Deposits 0

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

4. OTHER LIQUIDITY

49,541 6.3%

377,564 47.8%

15,500

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 = $215,211 / 27.2% 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

24,760

24,760 118,553 34,086 177,399

24,760 113,311

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% 118,553

OTHER WHOLESALE

34,086

0

TOTAL 20.0% 177,399

138,071

Cloyd Bank & Trust - Page 8