CMS Case Study
5 Year NII Simulation - 12M Ramps YOY Comparison - 12/31/2020
Base Simulation as of 12/31/2020
Base Simulation as of 12/31/2019
Quarterly Net Interest Income (NII) Projections
Quarterly Net Interest Income (NII) Projections
6,425
YEAR 1
YEAR 2
YEAR 3
YEAR 4
YEAR 5
YEAR 1
YEAR 2
YEAR 3
YEAR 4
YEAR 5
5,650
4,875
4,100
3,325
2,550
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,702 19,997 20,839 21,627 22,386 18,789 17,151 16,317 15,631 15,242 18,619 16,629 15,584 14,762 14,302
2,162 2,619 2,465 2,278 2,248 17,540 17,378 18,374 19,348 20,138 11 -509 -934 -1,078 17,642 17,140 16,827 16,564 16,320
1,146 1,125
BASE
DOWN 100BP
253
379
506
789 17,494 16,377 15,205 14,256 13,512
DIFFERENCE
Cloyd Bank & Trust - Page 21
Made with FlippingBook PDF to HTML5