CMS Case Study
5 Year NII Simulation - 12M Ramps - 6/30/2021
Base Simulation as of 06/30/2021
Base Simulation as of 03/31/2021
Quarterly Net Interest Income (NII) Projections
Quarterly Net Interest Income (NII) Projections
6,500
YEAR 1
YEAR 2
YEAR 3
YEAR 4
YEAR 5
YEAR 1
YEAR 2
YEAR 3
YEAR 4
YEAR 5
5,750
5,000
4,250
3,500
2,750
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,922 19,621 20,366 21,256 22,091 20,721 18,315 17,466 16,771 16,410 20,375 17,091 15,676 14,693 14,156
342 -677 -754 -745 -758 20,580 20,298 21,120 22,001 22,850
742
3
-48
-84 -147 19,980 18,312 17,513 16,855 16,557
BASE
DOWN 100BP 641 -311 -434 -446 -467 19,734 17,402 16,110 15,139 14,623 DIFFERENCE 1. This quarter's NII model includes $22MM of PPP loans of which 90% will be forgiven in Q3/Q4 2021, with the remaining 10% amortized off evenly over the following 6 months. 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 $1.3MM (following the same schedule as PPP forgiveness).
Cloyd Bank & Trust - Page 20
Made with FlippingBook PDF to HTML5