CMS Case Study

Stress Test: Non-Maturity Deposit Migration - 9/30/2021

Stress Test: Non-Maturity Deposit Migration

Base Simulation as of 09/30/2021

Quarterly Net Interest Income (NII) Projections

Quarterly Net Interest Income (NII) Projections

8,100

YEAR 1

YEAR 2

YEAR 3

YEAR 4

YEAR 5

YEAR 1

YEAR 2

YEAR 3

YEAR 4

YEAR 5

7,075

6,050

5,025

4,000

2,975

Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4

Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4

Up 400BP 24M Up 200BP

Base

Up 400BP 24M Up 200BP

Base

NII RESULTS

Y1

Y2

Y3

Y4

Y5

Y1

Y2

Y3

Y4

Y5

Y1

Y2

Y3

Y4

Y5

UP 400BP 24M

21,008 17,591 16,451 19,115 21,754 20,928 18,524 19,040 20,303 21,472 21,499 20,401 19,800 19,416 19,297

-244 -2,635 -5,273 -5,572 -5,571 21,252 20,227 21,724 24,687 27,324 -244 -2,280 -2,861 -2,851 -2,851 21,172 20,805 21,900 23,154 24,323

UP 200BP

0

0

0

0

0 21,499 20,401 19,800 19,416 19,297

BASE

DIFFERENCE 1. In the Up 200bps and Up 400bps scenarios, 25% of non-maturity deposits shift into a 1 Year FHLB advance evenly over months 7-18. 2. Please refer to the Stress Test Methodology page for additional documentation.

Cloyd Bank & Trust - Page 44