CMS Case Study

Alt. Cash Extension - $40MM MBS/DUS Purchases - 12/31/2020

Alt. Cash Extension

Base Simulation as of 12/31/2020

Quarterly Net Interest Income (NII) Projections

Quarterly Net Interest Income (NII) Projections

6,375

YEAR 1

YEAR 2

YEAR 3

YEAR 4

YEAR 5

YEAR 1

YEAR 2

YEAR 3

YEAR 4

YEAR 5

5,675

4,975

4,275

3,575

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

Delayed Yield Curve Twist

Yield Curve Twist

Up 200BP

Delayed Yield Curve Twist

Yield Curve Twist

Up 200BP

Base

Base

Down 100BP

Down 100BP

NII RESULTS

Y1

Y2

Y3

Y4

Y5

Y1

Y2

Y3

Y4

Y5

Y1

Y2

Y3

Y4

Y5

DELAYED YIELD CURVE TWIST

19,087 17,490 17,615 18,923 20,421

299

297

215

59

-52 18,789 17,193 17,400 18,864 20,473

YIELD CURVE TWIST

19,470 18,976 19,829 20,822 21,784 19,870 20,015 20,759 21,474 22,182 19,087 17,449 16,616 15,929 15,541 18,934 16,965 15,932 15,119 14,665

250 167 299 315

127

-7 -98 -163 19,221 18,848 19,836 20,920 21,947 -80 -152 -204 19,702 19,997 20,839 21,627 22,386

UP 200BP

18

299 335

299 349

298 358

299 18,789 17,151 16,317 15,631 15,242 363 18,619 16,629 15,584 14,762 14,302

BASE

DOWN 100BP

DIFFERENCE 1. Alternative simulation assumes $40MM in bond purchases @ a weighted average rate of 1.50% ($20MM in 30Y MBS @ 1.55% and $20MM in 10Y DUS @ 1.47%) funded with cash. 2. 12/31 model assumes $35MM of cash will be redeployed in to 15Y MBS @ 0.85% in month 1 of the model.

Cloyd Bank & Trust - Page 41

Made with FlippingBook PDF to HTML5