CMS Case Study
Loan Growth (funded w/ Cash) - 03/31/2021
Loan Growth (funded w/ Cash)
Base Simulation as of 03/31/2021
Quarterly Net Interest Income (NII) Projections
Quarterly Net Interest Income (NII) Projections
6,925
YEAR 1
YEAR 2
YEAR 3
YEAR 4
YEAR 5
YEAR 1
YEAR 2
YEAR 3
YEAR 4
YEAR 5
6,100
5,275
4,450
3,625
2,800
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
Delayed Flat Up 200BP
Up 200BP
Base
Down 100BP
Delayed Flat Up 200BP
Up 200BP
Base
Down 100BP
NII RESULTS
Y1
Y2
Y3
Y4
Y5
Y1
Y2
Y3
Y4
Y5
Y1
Y2
Y3
Y4
Y5
DELAYED FLAT UP 200BP
21,170 19,926 19,261 20,200 21,967
1,190 1,614 1,033
831
991 19,980 18,312 18,229 19,369 20,975
UP 200BP
21,478 21,295 22,223 23,196 24,117 21,170 19,926 19,132 18,476 18,179 20,924 19,005 17,705 16,725 16,199
898 996 1,103 1,195 1,267 20,580 20,298 21,120 22,001 22,850 1,190 1,614 1,618 1,621 1,622 19,980 18,312 17,513 16,855 16,557 1,190 1,602 1,595 1,586 1,576 19,734 17,402 16,110 15,139 14,623 DIFFERENCE
BASE
DOWN 100BP
1. Alt. simulation assumes $50MM in loan growth (Res 30Y Fixed – $10MM @ 2.875%, 5Y Commercial – $15MM @ 2.875%, 5/1 Commercial - $15MM @ 4.00%, 10Y Commercial – $10MM @ 4.00%).
Cloyd Bank & Trust - Page 41
Made with FlippingBook PDF to HTML5