CMS Case Study
5 Year NII Simulation - 12M Ramps - 12/31/2021
Base Simulation as of 12/31/2021
Base Simulation as of 09/30/2021
Quarterly Net Interest Income (NII) Projections
Quarterly Net Interest Income (NII) Projections
8,125
YEAR 1
YEAR 2
YEAR 3
YEAR 4
YEAR 5
YEAR 1
YEAR 2
YEAR 3
YEAR 4
YEAR 5
7,075
6,025
4,975
3,925
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
22,243 22,206 23,746 25,713 27,463 23,196 23,003 22,844 23,031 23,253 22,662 20,959 19,580 18,743 18,176
1,072 1,401 1,846 2,559 3,140 21,172 20,805 21,900 23,154 24,323 1,697 2,601 3,043 3,615 3,956 21,499 20,401 19,800 19,416 19,297 1,650 2,333 2,373 2,434 2,350 21,012 18,626 17,207 16,309 15,825 DIFFERENCE
BASE
DOWN 100BP
1. This quarter's NII model includes $2.6MM of PPP loans of which 100% will be forgiven in Q1 2022, Accordingly, 100% of PPP loan cash flows are assumed to be parked in short-term cash (@ 0.15%). 2. The NII model also includes PPP fee income totaling $37K (following the same schedule as PPP forgiveness).
Cloyd Bank & Trust - Page 20
Made with FlippingBook PDF to HTML5