CMS Case Study
Core Funding Utilization - 12/31/2021
46%
65%
84%
89%
DOWN 100BP
UP 200BP
UP 400BP 24M
BASE
% UTILIZATION
BASE
DOWN 100BP
UP 200BP
UP 400BP 24M
ASSETS > 60 MONTHS
324,516
231,477
393,319
415,855
CORE FUNDING VOLUME
EXCESS
VOLUME
EXCESS
VOLUME
EXCESS
VOLUME
EXCESS
EQUITY
85,663
0 0 0
85,663
0 0
85,663
0 0 0
85,663
0 0 0
OTHER LIABILITIES
4,414
4,414
4,414
4,414
DDA
210,647
210,647 124,233 42,986
69,247 193,480 236,467 236,467
210,647 124,233 42,986
210,647 124,233 42,986
NOW 124,233
100,441 143,428 143,428
31,638 74,624 74,624
9,102
SAVINGS
42,986
52,088 52,088
OTHER DEPOSITS
0
0
0
0
178,428
271,467
74,624
52,088
BORROWINGS
35,000
35,000
0
0
TOTAL CORE FUNDING 502,943
502,943
467,943
467,943
ASSETS >60M 324,516 278,685 219,349 164,589 122,346
CORE FUNDING
ASSETS >60M 231,477 197,430 157,685 131,222 104,529
CORE FUNDING
ASSETS >60M 393,319 350,617 273,792 206,102 164,540
CORE FUNDING
ASSETS >60M 415,855 373,711 292,007 217,988 176,158
CORE FUNDING
% UTIL
% UTIL
% UTIL
% UTIL
DEC-21 SEP-21 JUN-21 MAR-21
502,943 466,220 411,209 386,017 345,030
65% 60% 53% 43% 35%
502,943 466,220 411,209 386,017 345,030
46% 42% 38% 34% 30%
467,943 446,220 391,209 366,017 325,030
84% 79% 70% 56% 51%
467,943 446,220 391,209 366,017 325,030
89% 84% 75% 60% 54%
DEC-20
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 29
Made with FlippingBook PDF to HTML5