CMS Case Study
Core Funding Utilization - 3/31/2021
34%
43%
56%
60%
DOWN 100BP
UP 200BP
UP 400BP 24M
BASE
% UTILIZATION
BASE
DOWN 100BP
UP 200BP
UP 400BP 24M
ASSETS > 60 MONTHS
164,589
131,222
206,102
217,988
CORE FUNDING VOLUME
EXCESS
VOLUME
EXCESS
VOLUME
EXCESS
VOLUME
EXCESS
EQUITY
65,734
0 0
65,734
0 0
65,734
0 0
65,734
0 0
OTHER LIABILITIES
2,430
2,430
2,430
2,430
DDA NOW
186,988 81,755 29,110
90,563 172,318 201,428 201,428
186,988 81,755 29,110
123,929 205,684 234,794 234,794
186,988 81,755 29,110
49,050 130,805 159,915 159,915
186,988 81,755 29,110
37,164 118,919 148,029 148,029
SAVINGS
OTHER DEPOSITS
0
0
0
0
221,428
254,794
159,915
148,029
BORROWINGS
20,000
20,000
0
0
TOTAL CORE FUNDING 386,017
386,017
366,017
366,017
ASSETS >60M 164,589 122,346 109,040 98,240 102,346
CORE FUNDING
ASSETS >60M 131,222 104,529 97,278 89,951 87,086
CORE FUNDING
ASSETS >60M 206,102 164,540 150,193 143,285 143,915
CORE FUNDING
ASSETS >60M 217,988 176,158 162,475 152,726 148,127
CORE FUNDING
% UTIL
% UTIL
% UTIL
% UTIL
MAR-21 DEC-20 SEP-20 JUN-20 MAR-20
386,017 345,030 312,186 308,316 266,830
43% 35% 35% 32% 38%
386,017 345,030 312,186 308,316 266,830
34% 30% 31% 29% 33%
366,017 325,030 292,186 288,316 246,830
56% 51% 51% 50% 58%
366,017 325,030 292,186 288,316 246,830
60% 54% 56% 53% 60%
1. Core funding utilization measures the long term structural position of the balance sheet (i.e. EVE simulation) and quantifies the degree to which the Bank utilizes long-term (i.e. >5-years) funding sources to support long-term assets. The cumulative excess may be used as an indicator of the Bank's capacity to add additional long-term assets.
Cloyd Bank & Trust - Page 30
Made with FlippingBook PDF to HTML5