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