CMS Case Study

Historical Balance Sheet & NII - 3/31/2021

HISTORICAL BALANCE SHEET COMPARISON 3/31/2021

3/31/2021 vs. 12/31/2020

3/31/2021 vs. 3/31/2020

% of Assets

% of Assets Balance Δ Rate Δ

% of Assets Balance Δ Rate Δ

% of Assets Δ

Balance Rate

Balance Rate

Balance Rate

Investments

341,923 1.24% 43% 396,557 4.31% 50% 51,872 0.00% 7% 790,352 2.70% 100% 571,366 0.26% 72% 106,973 0.63% 14% 43,848 0.63% 6% 2,430 0.00% 0% 65,734 0.00% 8%

263,690 1.30% 37% 78,232 -0.06% 405,939 4.38% 56% -9,382 -0.07% 50,239 0.00% 7% 1,633 0.00% 719,869 2.94% 100% 70,483 -0.25% 495,426 0.26% 69% 75,940 0.00% 111,654 0.75% 16% -4,680 -0.12% 41,996 0.62% 6% 1,853 0.01% 4,347 0.00% 1% -1,917 0.00% 66,446 0.00% 9% -712 0.00% 719,869 0.33% 100% 70,483 -0.02%

190,628 2.04% 32% 151,295 -0.80% 11% 359,217 4.94% 60% 37,340 -0.63% -10% 49,669 0.00% 8% 2,204 0.00% -2% 599,514 3.61% 100% 190,838 -0.91% 0% 379,789 0.39% 63% 191,578 -0.13% 9% 126,937 1.59% 21% -19,963 -0.96% -8% 33,873 0.71% 6% 9,975 -0.08% 0% 2,969 0.00% 0% -540 0.00% 0% 55,946 0.00% 9% 9,788 0.00% -1% 599,514 0.62% 100% 190,838 -0.31% 0%

Loans & Derivatives

Other Assets Total Assets

Non-Maturity Deposits

Time Deposits

Borrowings & Derivatives

Other Liabilities

Equity

Total Liabilities & Equity 790,352 0.31% 100%

Balance Sheet Spread

2.39%

2.61%

-0.22%

2.99%

-0.60%

Net Interest Income Sensitivity

3/31/2021

3/31/2021 vs. 12/31/2020

3/31/2021 vs. 3/31/2020

% Δ from Yr 1 Base

% Δ from Yr 1 Base NII Δ EAR Δ

% Δ from Yr 1 Base NII Δ EAR Δ

Year 1 NII Projections

NII

NII

NII

UP 200BP

20,580 19,980 19,734

3.0%

19,702 18,789 18,619

4.9% 877 -1.9%

17,780 17,620 17,774

0.9% 2,800

2.1%

1,191

2,360

BASE

DOWN 100BP

-1.2%

-0.9% 1,114 -0.3%

0.9% 1,960 -2.1%

% Δ from Yr 1 Base

% Δ from Yr 1 Base

% Δ from Yr 1 Base

Year 2 NII Projections

UP 200BP

20,298 18,312

1.6% -8.3%

19,997 17,151

6.4% 301 -4.8% -8.7% 1,161 0.4%

17,859 16,981 17,230

1.4% 2,439

0.2%

-3.6% 1,331 -4.7% -2.2% 172 -10.7%

BASE

DOWN 100BP

17,402 -12.9%

16,629 -11.5% 773 -1.4%

2 Year Cumulative NII Projections

% Δ from Base

% Δ from Base

% Δ from Base

UP 200BP

40,878 38,292 37,136

6.8%

39,700 10.5% 1,179 -3.7%

35,639 34,601 35,004

3.0% 5,239

3.8%

35,940 35,249

2,352

3,690

BASE

DOWN 100BP

-3.0%

-1.9% 1,888 -1.1%

1.2% 2,132 -4.2%

Cloyd Bank & Trust - Page 7

Made with FlippingBook PDF to HTML5