CMS Case Study

5 Year NII Simulation - 12M Ramps - 9/30/2021

Base Simulation as of 09/30/2021

Base Simulation as of 06/30/2021

Quarterly Net Interest Income (NII) Projections

Quarterly Net Interest Income (NII) Projections

7,100

YEAR 1

YEAR 2

YEAR 3

YEAR 4

YEAR 5

YEAR 1

YEAR 2

YEAR 3

YEAR 4

YEAR 5

6,200

5,300

4,400

3,500

2,600

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

21,172 20,805 21,900 23,154 24,323 21,499 20,401 19,800 19,416 19,297 21,012 18,626 17,207 16,309 15,825

250 1,183 1,534 1,898 2,231 20,922 19,621 20,366 21,256 22,091 777 2,086 2,335 2,645 2,887 20,721 18,315 17,466 16,771 16,410

BASE

DOWN 100BP 638 1,535 1,530 1,616 1,669 20,375 17,091 15,676 14,693 14,156 DIFFERENCE 1. This quarter's NII model includes $9.5MM of PPP loans of which 90% will be forgiven in 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 $0.4MM (following the same schedule as PPP forgiveness).

Cloyd Bank & Trust - Page 20

Made with FlippingBook PDF to HTML5