CMS Case Study

5 Year NII Simulation - 12M Ramps - 12/31/2021

Base Simulation as of 12/31/2021

Base Simulation as of 09/30/2021

Quarterly Net Interest Income (NII) Projections

Quarterly Net Interest Income (NII) Projections

8,125

YEAR 1

YEAR 2

YEAR 3

YEAR 4

YEAR 5

YEAR 1

YEAR 2

YEAR 3

YEAR 4

YEAR 5

7,075

6,025

4,975

3,925

2,875

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

22,243 22,206 23,746 25,713 27,463 23,196 23,003 22,844 23,031 23,253 22,662 20,959 19,580 18,743 18,176

1,072 1,401 1,846 2,559 3,140 21,172 20,805 21,900 23,154 24,323 1,697 2,601 3,043 3,615 3,956 21,499 20,401 19,800 19,416 19,297 1,650 2,333 2,373 2,434 2,350 21,012 18,626 17,207 16,309 15,825 DIFFERENCE

BASE

DOWN 100BP

1. This quarter's NII model includes $2.6MM of PPP loans of which 100% will be forgiven in Q1 2022, 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 $37K (following the same schedule as PPP forgiveness).

Cloyd Bank & Trust - Page 20

Made with FlippingBook PDF to HTML5