CMS Case Study
Wholesale Funding Maturities - 12/31/2021
LIABILITIES
Q1Y1 Q2Y1 Q3Y1 Q4Y1 Q1Y2 Q2Y2 Q3Y2 Q4Y2
Y3
Y4
Y5 >Y5 CASH FLOW
37.5MM
FHLB
35,000
0
0
0
0
0
0
0
0
0
0
0
30MM
NATIONAL & BROKERED DEPOSITS
0
0
0
0
0
0
0
0
0
0
0
0
22.5MM
15MM
OTHER WHOLESALE
0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
7.5MM
TOTAL
35,000
0
CUMULATIVE
35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 0
Y1
Y2
Y3
Y4
Y5
>Y5
UP 200BP RATE SCENARIO
CML Δ FROM BASE
LIABILITIES
Q1Y1 Q2Y1 Q3Y1 Q4Y1 Q1Y2 Q2Y2 Q3Y2 Q4Y2
Y3
Y4
Y5 >Y5 CASH FLOW
37.5MM
FHLB
0
0
0
0
0
0
0
0
0
0
0 35,000
30MM
NATIONAL & BROKERED DEPOSITS
22.5MM
0
0
0
0
0
0
0
0
0
0
0
0
15MM
OTHER WHOLESALE
0
0
0
0
0
0
0
0
0
0
0
0
7.5MM
0
TOTAL
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 35,000 0 35,000
BASE RATE SCENARIO
Y1
Y2
Y3
Y4
Y5
>Y5
CUMULATIVE
LIABILITIES
Q1Y1 Q2Y1 Q3Y1 Q4Y1 Q1Y2 Q2Y2 Q3Y2 Q4Y2
Y3
Y4
Y5 >Y5 CASH FLOW
37.5MM
FHLB
0
0
0
0
0
0
0
0
0
0
0 35,000
30MM
NATIONAL & BROKERED DEPOSITS
0
0
0
0
0
0
0
0
0
0
0
0
22.5MM
15MM
OTHER WHOLESALE
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0
0
7.5MM
TOTAL
0 35,000 0 35,000
0
CUMULATIVE
Y1
Y2
Y3
Y4
Y5
>Y5
CML Δ FROM BASE
0
0
DOWN 100BP RATE SCENARIO
Cloyd Bank & Trust - Page 15
Made with FlippingBook PDF to HTML5