CMS Case Study

Historical Balance Sheet & NII - 12/31/2021

HISTORICAL BALANCE SHEET COMPARISON 12/31/2021

12/31/2021 vs. 9/30/2021

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

% of Assets

% of Assets Balance Δ Rate Δ

% of Assets Balance Δ Rate Δ

% of Assets Δ

Balance Rate

Balance Rate

Balance Rate

Investments

480,911 1.60% 50% 425,286 4.20% 44% 58,662 0.00% 6% 964,860 2.65% 100% 709,653 0.22% 74% 100,664 0.46% 10% 64,465 0.51% 7% 4,414 0.00% 0% 85,663 0.00% 9%

445,239 1.54% 50% 35,672 0.06% 395,619 4.30% 44% 29,667 -0.10% 55,974 0.00% 6% 2,688 0.00% 896,832 2.66% 100% 68,027 -0.01% 663,677 0.22% 74% 45,976 0.00% 102,141 0.51% 11% -1,477 -0.05% 46,929 0.66% 5% 17,537 -0.15% 3,692 0.00% 0% 722 0.00% 80,393 0.00% 9% 5,269 0.00% 896,832 0.25% 100% 68,027 -0.01%

263,690 1.30% 37% 217,221 0.30% 13% 405,939 4.38% 56% 19,347 -0.18% -12% 50,239 0.00% 7% 8,423 0.00% -1% 719,869 2.94% 100% 244,991 -0.29% 0% 495,426 0.26% 69% 214,226 -0.04% 5% 111,654 0.75% 16% -10,990 -0.29% -5% 41,996 0.62% 6% 22,470 -0.11% 1% 66,446 0.00% 9% 19,216 0.00% 0% 719,869 0.33% 100% 244,991 -0.09% 0% 4,347 0.00% 1% 68 0.00% 0%

Loans & Derivatives

Other Assets Total Assets

Non-Maturity Deposits

Time Deposits

Borrowings & Derivatives

Other Liabilities

Equity

Total Liabilities & Equity 964,860 0.24% 100%

Balance Sheet Spread

2.40%

2.41%

0.00%

2.61%

-0.21%

Net Interest Income Sensitivity

12/31/2021

12/31/2021 vs. 9/30/2021

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

% Δ from Yr 1 Base

% Δ from Yr 1 Base NII Δ EAR Δ -1.5% 1,072 -2.6%

% Δ from Yr 1 Base NII Δ EAR Δ 4.9% 2,541 -9.0%

Year 1 NII Projections

NII

NII

NII

UP 200BP

22,243 23,196 22,662

-4.1%

21,172 21,499 21,012

19,702 18,789 18,619

1,697

4,407

BASE

DOWN 100BP

-2.3%

-2.3% 1,650 0.0%

-0.9% 4,043 -1.4%

% Δ from Yr 1 Base

% Δ from Yr 1 Base

% Δ from Yr 1 Base

Year 2 NII Projections

UP 200BP

22,206 23,003 20,959

-4.3% -0.8% -9.6%

20,805 20,401

-3.2% 1,401 -1.0% -5.1% 2,601 4.3%

19,997 17,151

6.4% 2,209 -10.7%

-8.7% 5,852

7.9% 1.9%

BASE

DOWN 100BP

18,626 -13.4% 2,333 3.7%

16,629 -11.5% 4,330

2 Year Cumulative NII Projections

% Δ from Base

% Δ from Base

% Δ from Base

UP 200BP

44,449 46,198 43,621

-3.8%

41,976 41,900 39,638

0.2% 2,473 -4.0%

39,700 10.5% 4,749 -14.2%

4,298

35,940 35,249

10,258

BASE

DOWN 100BP

-5.6%

-5.4% 3,983 -0.2%

-1.9% 8,372 -3.7%

Cloyd Bank & Trust - Page 7

Made with FlippingBook PDF to HTML5