CMS Case Study
2 Year Net Interest Income (NII) Simulation - 12M Ramps - 6/30/2021
Base Simulation as of 06/30/2021
Base Simulation as of 03/31/2021
Monthly Net Interest Income (NII) Projections
Monthly Net Interest Income (NII) Projections
2,375
YEAR 1
YEAR 2
YEAR 1
YEAR 2
2,125
1,875
1,625
1,375
1,125
M1 M2 M3 M4 M5 M6 M7 M8 M9
M1 M2 M3 M4 M5 M6 M7 M8 M9
M1 M2 M3 M4 M5 M6 M7 M8 M9
M1 M2 M3 M4 M5 M6 M7 M8 M9
M10
M11
M12
M10
M11
M12
M10
M11
M12
M10
M11
M12
Up 200BP
Base
Down 100BP
Up 200BP
Base
Down 100BP
NII RESULTS
Y1
Y2
2Y CML
NII
$Δ %Δ
NII
$Δ %Δ
NII
$Δ %Δ
Base Simulation as of 06/30/2021 UP 200BP
20,922 20,721
200 1.0%
19,621 -1,100 -5.3% 18,315 -2,407 -11.6% 17,091 -3,630 -17.5%
40,543 1,507 3.9%
39,036
BASE
DOWN 100BP
20,375 -347 -1.7%
37,466 -1,570 -4.0%
Base Simulation as of 03/31/2021 UP 200BP
20,580 19,980
600 3.0%
20,298
318 1.6%
40,878 2,586 6.8%
18,312 -1,668 -8.3% 17,402 -2,578 -12.9%
38,292
BASE
DOWN 100BP
19,734 -246 -1.2%
37,136 -1,156 -3.0%
Difference UP 200BP
342 742 641
-2.0%
-677
-6.9% -3.3% -4.6%
-335
-2.9%
3
744 330
BASE
DOWN 100BP -1.0% 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). -0.4% -311
Cloyd Bank & Trust - Page 19
Made with FlippingBook PDF to HTML5