Capital Markets School - Case Study
Cloyd Bank & Trust
CONTINGENCY PLANNING PROGRAM LIQUIDITY - CASH FLOW AND FUNDS AVAILABILITY ANALYSIS AS OF 9/30/2021 STRESS 1 - STRESS CASE
DEC-21 MAR-22
JUN-22 SEP-22
DEC-22 MAR-23
JUN-23
SEP-23
TOTAL
Loans Loan Cash Flow (Inc. Estimated Prepayments)
59,512
25,129
28,788
29,963
19,333
15,839
16,229
15,517 210,311
Agricultural
0
0
0
0
0
0
0
0
0
Adj. Agricultural
-1.70%
0
0
0
0
0
0
0
0
0
Auto
0
0
0
0
0
0
0
0
0
Adj. Auto
-3.10%
0
0
0
0
0
0
0
0
0
Commercial & Industrial
8,912
6,388
7,940
10,899
3,984
3,654
3,067
3,196
48,040
Adj. Commercial & Industrial
-4.50% (401)
(287)
(357)
(490)
(179)
(164)
(138)
(144)
(2,162)
Commercial Real Estate
30,204
10,853
14,220
15,015
11,012
8,550
9,797
8,972 108,623
Adj. Commercial Real Estate
-1.70% (513)
(185)
(242)
(255)
(187)
(145)
(167)
(153)
(1,847)
Construction
4,926
2,666
2,092
70
118
253
0
0
10,125
Adj. Construction
-9.40% (463)
(251)
(197)
(7)
(11)
(24)
0
0
(952)
Home Equity
1,788
1,104
1,050
971
889
1,042
753
937
8,534
Adj. Home Equity
-3.10%
(55)
(34)
(33)
(30)
(28)
(32)
(23)
(29)
(265)
Residential
4,161
3,060
2,537
2,852
2,916
2,027
2,340
2,154
22,047
Adj. Residential
-1.80%
(75)
(55)
(46)
(51)
(52)
(36)
(42)
(39)
(397)
Other Loans
11,382
1,930
1,881
1,021
900
738
663
642
19,157
Adj. Other Loans
-3.10% (353)
(60)
(58)
(32)
(28)
(23)
(21)
(20)
(594)
Loan Cash Flow Reinvested
(61,373)
(26,001)
(29,720)
(30,828)
(19,819)
(16,264)
(16,620)
(15,901)
(216,526)
Agricultural
0
0
0
0
0
0
0
0
0
Auto
0
0
0
0
0
0
0
0
0
Commercial & Industrial
(8,912)
(6,388)
(7,940)
(10,899)
(3,984)
(3,654)
(3,067)
(3,196)
(48,040)
Commercial Real Estate
(30,204)
(10,853)
(14,220)
(15,015)
(11,012)
(8,550)
(9,797)
(8,972)
(108,623)
Construction
(4,926)
(2,666)
(2,092)
(70)
(118)
(253)
0
0 (10,125)
Home Equity
(1,788)
(1,104)
(1,050)
(971)
(889)
(1,042)
(753)
(937)
(8,534)
Residential
(4,161)
(3,060)
(2,537)
(2,852)
(2,916)
(2,027)
(2,340)
(2,154)
(22,047)
Other Loans
(11,382)
(1,930)
(1,881)
(1,021)
(900)
(738)
(663)
(642)
(19,157)
Loan Sales
0
0
0
0
0
0
0
0
0
Agricultural
0
0
0
0
0
0
0
0
0
Auto
0
0
0
0
0
0
0
0
0
Commercial & Industrial
0
0
0
0
0
0
0
0
0
Commercial Real Estate
0
0
0
0
0
0
0
0
0
Construction
0
0
0
0
0
0
0
0
0
Home Equity
0
0
0
0
0
0
0
0
0
Residential
0
0
0
0
0
0
0
0
0
Other Loans
0
0
0
0
0
0
0
0
0
Loan Originations/Purchases
0
0
0
0
0
0
0
0
0
Agricultural
0
0
0
0
0
0
0
0
0
Auto
0
0
0
0
0
0
0
0
0
13
© Darling Consulting Group 2021
12/13/2021 - 2:11 PM
Made with FlippingBook flipbook maker