CMS Case Study

Alt. Cash Extension - 12/31/2020

Alt. Cash Extension

Base Simulation as of 12/31/2020

Quarterly Net Interest Income (NII) Projections

Quarterly Net Interest Income (NII) Projections

6,350

YEAR 1

YEAR 2

YEAR 3

YEAR 4

YEAR 5

YEAR 1

YEAR 2

YEAR 3

YEAR 4

YEAR 5

5,650

4,950

4,250

3,550

2,850

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,727 20,145 20,919 21,654 22,370 18,633 16,995 16,161 15,475 15,086 18,455 16,474 15,439 14,626 14,173

25

148

80

27

-16 19,702 19,997 20,839 21,627 22,386

-156 -156 -156 -156 -156 18,789 17,151 16,317 15,631 15,242 -164 -156 -144 -136 -129 18,619 16,629 15,584 14,762 14,302 DIFFERENCE

BASE

DOWN 100BP

1. Alternative simulation assumes $15MM in MBS purchases are made in month 1 of the model (which reflects actual purchases made YTD). 2. 12/31 model assumes 33% of cash will be redeployed in to 15Y MBS in month 1 of the model (totaling $35MM).

Cloyd Bank & Trust - Page 40

Made with FlippingBook PDF to HTML5