CMS Case Study
Historical Balance Sheet & NII - 9/30/2020
HISTORICAL BALANCE SHEET COMPARISON 9/30/2020
9/30/2020 vs. 6/30/2020
9/30/2020 vs. 9/30/2019
% of Assets
% of Assets Balance Δ Rate Δ
% of Assets Balance Δ Rate Δ
% of Assets Δ
Balance Rate
Balance Rate
Balance Rate
Investments
234,112 1.54% 34% 402,243 4.37% 59% 49,736 0.00% 7% 686,092 3.09% 100% 455,936 0.26% 66% 114,469 0.98% 17% 46,321 0.68% 7% 3,556 0.00% 1% 65,809 0.00% 10%
240,886 1.55% 35% -6,774 -0.01% 401,456 4.47% 58% 787 -0.09%
150,851 2.86% 28% 83,261 -1.32% 6% 343,340 5.16% 63% 58,903 -0.79% -5% 47,559 0.00% 9% 2,177 0.00% -2% 541,750 4.07% 100% 144,342 -0.98% 0% 337,509 0.60% 62% 118,427 -0.34% 4% 127,755 1.82% 24% -13,286 -0.83% -7% 19,019 0.79% 4% 27,301 -0.11% 3% 3,039 0.00% 1% 517 0.00% 0% 54,427 0.00% 10% 11,382 0.00% 0% 541,750 0.83% 100% 144,342 -0.45% 0%
Loans & Derivatives
Other Assets Total Assets
49,730 0.00% 7%
6 0.00%
692,073 3.13% 100% -5,981 -0.04%
Non-Maturity Deposits
457,988 0.26% 66% -2,051 0.01% 125,331 1.40% 18% -10,862 -0.42% 40,743 0.70% 6% 5,578 -0.02% 64,477 0.00% 9% 1,332 0.00% 692,073 0.47% 100% -5,981 -0.08% 3,534 0.00% 1% 22 0.00%
Time Deposits
Borrowings & Derivatives
Other Liabilities
Equity
Total Liabilities & Equity 686,092 0.38% 100%
Balance Sheet Spread
2.70%
2.66%
0.04%
3.24%
-0.53%
Net Interest Income Sensitivity
9/30/2020
9/30/2020 vs. 6/30/2020
9/30/2020 vs. 9/30/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,285 18,727 18,608
3.0%
19,989 19,335 19,329
3.4% -704 -0.4%
16,909 16,962 16,794
-0.3% 2,375
3.3%
-608
1,765
BASE
DOWN 100BP
-0.6%
0.0% -722 -0.6%
-1.0% 1,814
0.4%
% Δ from Yr 1 Base
% Δ from Yr 1 Base
% Δ from Yr 1 Base
Year 2 NII Projections
UP 200BP
19,355 17,560 17,200
3.4% -6.2% -8.2%
20,453 18,558 18,382
5.8% -1,099 -2.4% -4.0% -998 -2.2% -4.9% -1,181 -3.2%
16,671 16,500 15,761
-1.7% 2,684
5.1%
-2.7% 1,059 -3.5% -7.1% 1,439 -1.1%
BASE
DOWN 100BP
2 Year Cumulative NII Projections
% Δ from Base
% Δ from Base
% Δ from Base
UP 200BP
38,639 36,287 35,808
6.5%
40,442 37,893 37,711
6.7% -1,803 -0.2%
33,580 33,462 32,555
0.4% 5,059
6.1%
-1,606
2,825
BASE
DOWN 100BP
-1.3%
-0.5% -1,903 -0.8%
-2.7% 3,253
1.4%
Cloyd Bank & Trust - Page 7
Made with FlippingBook PDF to HTML5