CMS Case Study

Deposit Surge Runoff - 03/31/2021

Deposit Surge Runoff

Base Simulation as of 03/31/2021

Quarterly Net Interest Income (NII) Projections

Quarterly Net Interest Income (NII) Projections

6,525

YEAR 1

YEAR 2

YEAR 3

YEAR 4

YEAR 5

YEAR 1

YEAR 2

YEAR 3

YEAR 4

YEAR 5

5,800

5,075

4,350

3,625

2,900

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

19,985 18,342 17,661 18,443 20,050

5

30 -568 -926 -926 19,980 18,312 18,229 19,369 20,975

UP 200BP

20,459 19,479 20,192 21,075 21,924 19,985 18,342 17,547 16,889 16,591 19,745 17,467 16,183 15,212 14,696

-121 -819 -928 -926 -926 20,580 20,298 21,120 22,001 22,850

5

30 65

34 73

34 73

34 19,980 18,312 17,513 16,855 16,557 73 19,734 17,402 16,110 15,139 14,623

BASE

DOWN 100BP

12

DIFFERENCE

1. Alt. simulation assumes $50MM in deposit runoff ($20MM in DDA and $30MM in NOW) is covered with cash.

Cloyd Bank & Trust - Page 40