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