CMS Case Study
Historical Balance Sheet & NII - 12/31/2020
HISTORICAL BALANCE SHEET COMPARISON 12/31/2020
12/31/2020 vs. 9/30/2020
12/31/2020 vs. 12/31/2019
% of Assets
% of Assets Balance Δ Rate Δ
% of Assets Balance Δ Rate Δ
% of Assets Δ
Balance Rate
Balance Rate
Balance Rate
Investments
263,690 1.30% 37% 405,939 4.38% 56% 50,239 0.00% 7% 719,869 2.94% 100% 495,426 0.26% 69% 111,654 0.75% 16% 41,996 0.62% 6% 4,347 0.00% 1% 66,446 0.00% 9%
234,112 1.54% 34% 29,578 -0.24% 402,243 4.37% 59% 3,696 0.00% 49,736 0.00% 7% 503 0.00% 686,092 3.09% 100% 33,777 -0.15% 455,936 0.26% 66% 39,490 0.00% 114,469 0.98% 17% -2,816 -0.23% 46,321 0.68% 7% -4,325 -0.06% 3,556 0.00% 1% 791 0.00% 65,809 0.00% 10% 637 0.00% 686,092 0.38% 100% 33,777 -0.05%
157,569 2.80% 28% 106,121 -1.50% 8% 354,060 5.16% 63% 51,879 -0.78% -7% 47,972 0.00% 9% 2,268 0.00% -2% 559,601 4.05% 100% 160,268 -1.11% 0% 347,796 0.62% 62% 147,630 -0.35% 7% 128,795 1.81% 23% -17,142 -1.06% -8% 23,105 0.86% 4% 18,891 -0.24% 2% 3,982 0.00% 1% 365 0.00% 0% 55,923 0.00% 10% 10,524 0.00% -1% 559,601 0.84% 100% 160,268 -0.50% 0%
Loans & Derivatives
Other Assets Total Assets
Non-Maturity Deposits
Time Deposits
Borrowings & Derivatives
Other Liabilities
Equity
Total Liabilities & Equity 719,869 0.33% 100%
Balance Sheet Spread
2.61%
2.70%
-0.09%
3.22%
-0.61%
Net Interest Income Sensitivity
12/31/2020
12/31/2020 vs. 9/30/2020
12/31/2020 vs. 12/31/2019
% Δ 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
19,702 18,789 18,619
4.9%
19,285 18,727 18,608
3.0% 418 1.9%
17,540 17,642 17,494
-0.6% 2,162
5.4%
62
1,146
BASE
DOWN 100BP
-0.9%
-0.6% 12 -0.3%
-0.8% 1,125 -0.1%
% Δ from Yr 1 Base
% Δ from Yr 1 Base
% Δ from Yr 1 Base
Year 2 NII Projections
UP 200BP
19,997 17,151
6.4% -8.7%
19,355 17,560 17,200
3.4% 642 3.1% -6.2% -409 -2.5% -8.2% -571 -3.3%
17,378 17,140 16,377
-1.5% 2,619
7.9%
-2.8% 11 -5.9% -7.2% 253 -4.3%
BASE
DOWN 100BP
16,629 -11.5%
2 Year Cumulative NII Projections
% Δ from Base
% Δ from Base
% Δ from Base
UP 200BP
39,700 10.5%
38,639 36,287 35,808
6.5% 1,060 4.0%
34,918 34,782 33,871
0.4% 4,781 10.1%
35,940 35,249
-347
1,158
BASE
DOWN 100BP
-1.9%
-1.3% -559 -0.6%
-2.6% 1,378
0.7%
Cloyd Bank & Trust - Page 7
Made with FlippingBook PDF to HTML5