CMS Case Study
Historical Balance Sheet & NII - 9/30/2021
HISTORICAL BALANCE SHEET COMPARISON 9/30/2021
9/30/2021 vs. 6/30/2021
9/30/2021 vs. 9/30/2020
% of Assets
% of Assets Balance Δ Rate Δ
% of Assets Balance Δ Rate Δ
% of Assets Δ
Balance Rate
Balance Rate
Balance Rate
Investments
445,239 1.54% 50% 395,619 4.30% 44% 55,974 0.00% 6% 896,832 2.66% 100% 663,677 0.22% 74% 102,141 0.51% 11% 46,929 0.66% 5% 3,692 0.00% 0% 80,393 0.00% 9%
384,663 1.44% 46% 60,576 0.10% 390,119 4.25% 47% 5,500 0.05% 55,614 0.00% 7% 360 0.00% 830,396 2.66% 100% 66,436 0.00% 601,511 0.23% 72% 62,166 -0.01% 104,427 0.57% 13% -2,286 -0.06% 44,493 0.65% 5% 2,436 0.01% 2,838 0.00% 0% 854 0.00% 77,126 0.00% 9% 3,267 0.00% 830,396 0.27% 100% 66,436 -0.02%
234,112 1.54% 34% 211,127 0.00% 16% 402,243 4.37% 59% -6,624 -0.07% -15% 49,736 0.00% 7% 6,238 0.00% -1% 686,092 3.09% 100% 210,741 -0.43% 0% 455,936 0.26% 66% 207,740 -0.05% 8% 114,469 0.98% 17% -12,328 -0.47% -5% 46,321 0.68% 7% 608 -0.02% -2% 3,556 0.00% 1% 136 0.00% 0% 65,809 0.00% 10% 14,584 0.00% -1% 686,092 0.38% 100% 210,740 -0.13% 0%
Loans & Derivatives
Other Assets Total Assets
Non-Maturity Deposits
Time Deposits
Borrowings & Derivatives
Other Liabilities
Equity
Total Liabilities & Equity 896,832 0.25% 100%
Balance Sheet Spread
2.41%
2.39%
0.02%
2.70%
-0.29%
Net Interest Income Sensitivity
9/30/2021
9/30/2021 vs. 6/30/2021
9/30/2021 vs. 9/30/2020
% Δ from Yr 1 Base
% Δ from Yr 1 Base NII Δ EAR Δ
% Δ from Yr 1 Base NII Δ EAR Δ 3.0% 1,887 -4.5%
Year 1 NII Projections
NII
NII
NII
UP 200BP
21,172 21,499 21,012
-1.5%
20,922 20,721 20,375
1.0% 250 -2.5%
19,285 18,727 18,608
777
2,772
BASE
DOWN 100BP
-2.3%
-1.7% 638 -0.6%
-0.6% 2,405 -1.6%
% Δ from Yr 1 Base
% Δ from Yr 1 Base
% Δ from Yr 1 Base
Year 2 NII Projections
UP 200BP
20,805 20,401
-3.2% -5.1%
19,621
-5.3% 1,183 2.1%
19,355 17,560 17,200
3.4% 1,450 -6.6%
18,315 -11.6% 2,086 6.5% 17,091 -17.5% 1,535 4.2%
-6.2% 2,841
1.1%
BASE
DOWN 100BP
18,626 -13.4%
-8.2% 1,426 -5.2%
2 Year Cumulative NII Projections
% Δ from Base
% Δ from Base
% Δ from Base
UP 200BP
41,976 41,900 39,638
0.2%
40,543 39,036 37,466
3.9% 1,433 -3.7%
38,639 36,287 35,808
6.5% 3,337 -6.3%
2,863
5,613
BASE
DOWN 100BP
-5.4%
-4.0% 2,172 -1.4%
-1.3% 3,831 -4.1%
Cloyd Bank & Trust - Page 7
Made with FlippingBook PDF to HTML5