CMS Case Study

Surge Deposit Runoff - 6/30/2021

Surge Deposit Runoff

Base Simulation as of 06/30/2021

Quarterly Net Interest Income (NII) Projections

Quarterly Net Interest Income (NII) Projections

6,500

YEAR 1

YEAR 2

YEAR 3

YEAR 4

YEAR 5

YEAR 1

YEAR 2

YEAR 3

YEAR 4

YEAR 5

5,750

5,000

4,250

3,500

2,750

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

Delayed Flat Up 200BP

Up 200BP

Base

Down 100BP

Delayed Flat Up 200BP

Up 200BP

Base

Down 100BP

NII RESULTS

Y1

Y2

Y3

Y4

Y5

Y1

Y2

Y3

Y4

Y5

Y1

Y2

Y3

Y4

Y5

DELAYED FLAT UP 200BP

20,735 18,328 17,232 17,477 18,756

14

14 -496 -751 -750 20,721 18,315 17,727 18,228 19,506

UP 200BP

20,523 18,871 19,613 20,505 21,341 20,735 18,328 17,479 16,785 16,424 20,427 17,161 15,746 14,763 14,226

-399 -750 -753 -751 -750 20,922 19,621 20,366 21,256 22,091

14 52

14 70

14 70

14 70

14 20,721 18,315 17,466 16,771 16,410 70 20,375 17,091 15,676 14,693 14,156

BASE

DOWN 100BP

DIFFERENCE

1. Alt. simulation assumes $50MM in deposit runoff (evenly between DDA and MMDA) is covered with cash.

Cloyd Bank & Trust - Page 38