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