CMS Case Study

Core Funding Utilization - 6/30/2021

38%

53%

70%

75%

 DOWN 100BP

 UP 200BP

 UP 400BP 24M

BASE

% UTILIZATION

BASE

 DOWN 100BP

 UP 200BP

 UP 400BP 24M

ASSETS > 60 MONTHS

219,349

157,685

273,792

292,007

CORE FUNDING VOLUME

EXCESS

VOLUME

EXCESS

VOLUME

EXCESS

VOLUME

EXCESS

EQUITY

77,126

0 0

77,126

0 0

77,126

0 0

77,126

0 0 0

OTHER LIABILITIES

2,838

2,838

2,838

2,838

DDA NOW

201,448 77,615 32,182

62,064 139,679 171,860 171,860

201,448 77,615 32,182

123,728 201,342 233,524 233,524

201,448 77,615 32,182

7,620

201,448 77,615 32,182

85,235 117,417 117,417

67,020 99,202 99,202

SAVINGS

OTHER DEPOSITS

0

0

0

0

191,860

253,524

117,417

99,202

BORROWINGS

20,000

20,000

0

0

TOTAL CORE FUNDING 411,209

411,209

391,209

391,209

ASSETS >60M 219,349 164,589 122,346 109,040 98,240

CORE FUNDING

ASSETS >60M 157,685 131,222 104,529 97,278 89,951

CORE FUNDING

ASSETS >60M 273,792 206,102 164,540 150,193 143,285

CORE FUNDING

ASSETS >60M 292,007 217,988 176,158 162,475 152,726

CORE FUNDING

% UTIL

% UTIL

% UTIL

% UTIL

JUN-21 MAR-21 DEC-20 SEP-20 JUN-20

411,209 386,017 345,030 312,186 308,316

53% 43% 35% 35% 32%

411,209 386,017 345,030 312,186 308,316

38% 34% 30% 31% 29%

391,209 366,017 325,030 292,186 288,316

70% 56% 51% 51% 50%

391,209 366,017 325,030 292,186 288,316

75% 60% 54% 56% 53%

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