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