CMS Case Study

Alt. CD Cash Flow Assumption - 12/31/2020

Alt. CD Cash Flow Assumption

Base Simulation as of 12/31/2020

Quarterly Net Interest Income (NII) Projections

Quarterly Net Interest Income (NII) Projections

6,375

YEAR 1

YEAR 2

YEAR 3

YEAR 4

YEAR 5

YEAR 1

YEAR 2

YEAR 3

YEAR 4

YEAR 5

5,675

4,975

4,275

3,575

2,875

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 200BP

Base

Down 100BP

Up 200BP

Base

Down 100BP

NII RESULTS

Y1

Y2

Y3

Y4

Y5

Y1

Y2

Y3

Y4

Y5

Y1

Y2

Y3

Y4

Y5

UP 200BP

19,607 19,556 20,344 21,131 21,891 18,796 17,163 16,330 15,643 15,254 18,634 16,649 15,604 14,782 14,322

-96 -441 -495 -495 -495 19,702 19,997 20,839 21,627 22,386

7

12 20

12 20

12 20

12 18,789 17,151 16,317 15,631 15,242 20 18,619 16,629 15,584 14,762 14,302

BASE

DOWN 100BP

14

DIFFERENCE

1. Alternative simulation assumes 9/30's CD assumption where maturities replace 50/50 into 6/12 month CDs. 2. 12/31 simulation assumes 50% of CD maturities in year 1 will replace in to NOW Cloyd Prime (tied to 12% of Prime).

Cloyd Bank & Trust - Page 39

Made with FlippingBook PDF to HTML5