CMS Case Study
Year 1 Investment Cashflow into Loans - 12/31/2021
Year 1 Investment Cashflow into Loans
Base Simulation as of 12/31/2021
Quarterly Net Interest Income (NII) Projections
Quarterly Net Interest Income (NII) Projections
9,075
YEAR 1
YEAR 2
YEAR 3
YEAR 4
YEAR 5
YEAR 1
YEAR 2
YEAR 3
YEAR 4
YEAR 5
8,100
7,125
6,150
5,175
4,200
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 400BP 24M Flat Up 200BP
Up 200BP
Base
Up 400BP 24M Flat Up 200BP
Up 200BP
Base
NII RESULTS
Y1
Y2
Y3
Y4
Y5
Y1
Y2
Y3
Y4
Y5
Y1
Y2
Y3
Y4
Y5
UP 400BP 24M FLAT UP 200BP
22,602 21,636 23,365 27,410 30,960 22,216 21,527 22,074 23,043 23,876 22,535 22,827 24,416 26,421 28,200 23,196 23,003 22,844 23,031 23,253
290 322 292
645 700 621
816 734 670
977 1,100 22,311 20,991 22,549 26,433 29,861 782 21,894 20,826 21,340 22,281 23,093 737 22,243 22,206 23,746 25,713 27,463 761 708
UP 200BP
0
0
0
0
0 23,196 23,003 22,844 23,031 23,253
BASE
DIFFERENCE
YR 2 % CHANGE FROM YR 1 BASE POLICY
Y1 POLICY
Y2
Y1
Y2
POLICY
Y1 POLICY
Y2
UP 400BP 24M FLAT UP 200BP
-2.6% -4.2%
-6.7% -7.2%
1.3% 1.4% 1.3%
2.8% 3.0% 2.7% 0.0%
-3.8% -5.6%
-9.5%
-10.2%
UP 200BP
-15.0% -2.8% -15.0% -1.6%
-15.0% -4.1% -15.0% -4.3%
-0.8%
-0.8%
BASE
DIFFERENCE 1. Alternative simulation assumes 100% of first year investment cashflows are utilized to fund loans in the rising rate scenarios. Base simulation assumes 100% of all investment cashflows are replaced with 20Yr MBS (yielding 2.36%). 2. Year 1 investment cashflows are replaced 40% into C+I 4Yr Fixed loans @ 3.75%, 40% into CRE 5Yr Fixed loans @ 3.95%, and 20% into Resi 30Yr Fixed loans @ 3.00%.
Cloyd Bank & Trust - Page 38
Made with FlippingBook PDF to HTML5