CMS Case Study
Core Funding Utilization - 12/31/2020
30%
35%
51%
54%
DOWN 100BP
UP 200BP
UP 400BP 24M
BASE
% UTILIZATION
BASE
DOWN 100BP
UP 200BP
UP 400BP 24M
ASSETS > 60 MONTHS
122,346
104,529
164,540
176,158
CORE FUNDING VOLUME
EXCESS
VOLUME
EXCESS
VOLUME
EXCESS
VOLUME
EXCESS
EQUITY
66,446
0 0
66,446
0 0
66,446
0 0
66,446
0 0
OTHER LIABILITIES
4,347
4,347
4,347
4,347
DDA NOW
163,236 65,948 25,052
111,683 177,631 202,683 202,683
163,236 65,948 25,052
129,501 195,449 220,501 220,501
163,236 65,948 25,052
69,490 135,438 160,490 160,490
163,236 65,948 25,052
57,871 123,820 148,872 148,872
SAVINGS
OTHER DEPOSITS
0
0
0
0
222,683
240,501
160,490
148,872
BORROWINGS
20,000
20,000
0
0
TOTAL CORE FUNDING 345,030
345,030
325,030
325,030
ASSETS >60M 122,346 109,040 98,240 102,346 107,473
CORE FUNDING
ASSETS >60M 104,529 97,278 89,951 87,086 91,346
CORE FUNDING
ASSETS >60M 164,540 150,193 143,285 143,915 150,615
CORE FUNDING
ASSETS >60M 176,158 162,475 152,726 148,127 154,254
CORE FUNDING
% UTIL
% UTIL
% UTIL
% UTIL
DEC-20 SEP-20 JUN-20 MAR-20
345,030 312,186 308,316 266,830 243,955
35% 35% 32% 38% 44%
345,030 312,186 308,316 266,830 243,956
30% 31% 29% 33% 37%
325,030 292,186 288,316 246,830 233,956
51% 51% 50% 58% 64%
325,030 292,186 288,316 246,830 233,956
54% 56% 53% 60% 66%
DEC-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