CMS Case Study

2 Year Net Interest Income (NII) Simulation - 12M Ramps - 3/31/2021

Base Simulation as of 03/31/2021

Base Simulation as of 12/31/2020

Monthly Net Interest Income (NII) Projections

Monthly Net Interest Income (NII) Projections

1,950

YEAR 1

YEAR 2

YEAR 1

YEAR 2

1,800

1,650

1,500

1,350

1,200

M1 M2 M3 M4 M5 M6 M7 M8 M9

M1 M2 M3 M4 M5 M6 M7 M8 M9

M1 M2 M3 M4 M5 M6 M7 M8 M9

M1 M2 M3 M4 M5 M6 M7 M8 M9

M10

M11

M12

M10

M11

M12

M10

M11

M12

M10

M11

M12

Up 200BP

Base

Down 100BP

Up 200BP

Base

Down 100BP

NII RESULTS

Y1

Y2

2Y CML

NII

$Δ %Δ

NII

$Δ %Δ

NII

$Δ %Δ

Base Simulation as of 03/31/2021 UP 200BP

20,580 19,980

600 3.0%

20,298

318 1.6%

40,878 2,586 6.8%

18,312 -1,668 -8.3% 17,402 -2,578 -12.9%

38,292

BASE

DOWN 100BP

19,734 -246 -1.2%

37,136 -1,156 -3.0%

Base Simulation as of 12/31/2020 UP 200BP

19,702 18,789

914 4.9%

19,997 1,208 6.4% 17,151 -1,638 -8.7% 16,629 -2,160 -11.5%

39,700 3,760 10.5%

35,940

BASE

DOWN 100BP

18,619 -169 -0.9%

35,249 -691 -1.9%

Difference UP 200BP

877

-1.9%

301

-4.8% 0.4% -1.4%

1,179 2,352 1,888

-3.7%

1,191 1,114

1,161

BASE

DOWN 100BP -1.1% 1. This quarter's NII model includes $22.4MM of PPP loans of which 85% will be forgiven in Q2/Q3 2021, with the remaining 15% amortized off evenly over the following 9 months. Accordingly, 100% of PPP loan cash flows are assumed to be parked in short-term cash (@ 0.10%). 2. The NII model also includes PPP fee income totaling $819K (following the same schedule as PPP forgiveness). -0.3% 773

Cloyd Bank & Trust - Page 19

Made with FlippingBook PDF to HTML5