CMS Case Study
Sub Activity Removal - 03/31/2021
Sub Activity Removal
Base Simulation as of 03/31/2021
Quarterly Net Interest Income (NII) Projections
Quarterly Net Interest Income (NII) Projections
6,575
YEAR 1
YEAR 2
YEAR 3
YEAR 4
YEAR 5
YEAR 1
YEAR 2
YEAR 3
YEAR 4
YEAR 5
5,800
5,025
4,250
3,475
2,700
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
20,216 20,530 21,244 22,016 22,768
-364
232
124
15
-81 20,580 20,298 21,120 22,001 22,850
18,942 17,274 16,476 15,817 15,519 -1,038 -1,038 -1,038 -1,038 -1,038 19,980 18,312 17,513 16,855 16,557 18,714 16,496 15,321 14,432 13,973 -1,020 -906 -789 -707 -650 19,734 17,402 16,110 15,139 14,623 DIFFERENCE
BASE
DOWN 100BP
1. Alt. simulation assumes $75MM in bond purchase (made/modeled subsequent to qtr-end) is removed.
Cloyd Bank & Trust - Page 39
Made with FlippingBook PDF to HTML5