CMS Case Study

Inventory of Liquidity Resources - 9/30/2020

CUMULATIVE AMOUNT

% OF ASSETS

BASIC SURPLUS

% OF ASSETS

BASIC SURPLUS

AMOUNT % OF ASSETS

30%

1. TIER 1 LIQUIDITY (LIQUID ASSETS)

110,130 16.1%

110,130 16.1% 64,343

9.4% Policy Minimum: 0.0%

77,273 26,508

Cash/Equivalents Free Bond Collateral

20%

925

Other Inv. Cash Flow <30 Days

5,424

Other Liquid Assets + Gov't Guaranteed Loans

2. TIER 2 LIQUIDITY (FHLB LOAN BASED CAPACITY)

3,604 0.5%

113,734 16.6% 67,947

9.9% Policy Minimum: 4.0%

10%

38,604 35,000

Maximum FHLB Borrowings Capacity

Outstanding Advances/ LOCs

0%

Sep-19 Dec-19 Mar-20 Jun-20 Sep-20

3. TIER 3 LIQUIDITY (BROKERED DEPOSITS CAPACITY) 102,914 15.0%

216,648 31.6% 170,861

24.9% Policy Minimum: 8.0%

Maximum Brokered Deposits Capacity 102,914 Current Brokered Deposits 0

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

4. OTHER LIQUIDITY

48,772 7.1%

265,421 38.7%

15,161

Other Investments less Cash flow (< 30 Days)

2,186

Secured Borrowing Lines Unsecured Borrowing Lines

31,425

AVAILABLE WHOLESALE FUNDING CAPACITY

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

AVAILABLE FUNDING

AVAILABLE FUNDING PER POLICY

AVAIL. FUNDING PER TOTAL WHOLESALE POLICY

POLICY

NOTES: 1. Other Investments includes available Municipals and Corporates less cash flow < 30 Days. 2. Liquid Assets for the On Balance Sheet Liquidity figure also excludes Gov't guaranteed loans. 3. Outstanding advances include $15MM in FHLB Letter of Credit.

FHLB

18,604

18,604 102,914 33,611 155,129

18,604 98,614

BROKERED 15.0% 102,914

OTHER WHOLESALE

33,611

0

TOTAL 20.0% 155,129

117,218

Cloyd Bank & Trust - Page 8