CMS Case Study
Core Funding Utilization - 9/30/2020
31%
35%
51%
56%
DOWN 100BP
UP 200BP
UP 400BP 24M
BASE
% UTILIZATION
BASE
DOWN 100BP
UP 200BP
UP 400BP 24M
ASSETS > 60 MONTHS
109,040
97,278
150,193
162,475
CORE FUNDING VOLUME
EXCESS
VOLUME
EXCESS
VOLUME
EXCESS
VOLUME
EXCESS
EQUITY
65,809
0 0
65,809
0 0
65,809
0 0
65,809
0 0
OTHER LIABILITIES
3,556
3,556
3,556
3,556
DDA NOW
137,512 63,181 22,127
97,838 161,019 183,146 183,146
137,512 63,181 22,127
109,599 172,780 194,907 194,907
137,512 63,181 22,127
56,684 119,865 141,992 141,992
137,512 63,181 22,127
44,402 107,583 129,710 129,710
SAVINGS
OTHER DEPOSITS
0
0
0
0
203,146
214,907
141,992
129,710
BORROWINGS
20,000
20,000
0
0
TOTAL CORE FUNDING 312,186
312,186
292,186
292,186
ASSETS >60M 109,040 98,240 102,346 107,473 111,633
CORE FUNDING
ASSETS >60M
CORE FUNDING
ASSETS >60M 150,193 143,285 143,915 150,615 155,293
CORE FUNDING
ASSETS >60M 162,475 152,726 148,127 154,254 158,432
CORE FUNDING
% UTIL
% UTIL
% UTIL
% UTIL
SEP-20 JUN-20 MAR-20 DEC-19
312,186 308,316 266,830 243,955 240,881
35% 32% 38% 44% 46%
97,278 89,951 87,086 91,346 96,968
312,186 308,316 266,830 243,956 240,881
31% 29% 33% 37% 40%
292,186 288,316 246,830 233,956 230,881
51% 50% 58% 64% 67%
292,186 288,316 246,830 233,956 230,881
56% 53% 60% 66% 69%
SEP-19
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 31
Made with FlippingBook PDF to HTML5