CMS Case Study
Historical Balance Sheet & NII - 6/30/2021
HISTORICAL BALANCE SHEET COMPARISON 6/30/2021
6/30/2021 vs. 3/31/2021
6/30/2021 vs. 6/30/2020
% of Assets
% of Assets Balance Δ Rate Δ
% of Assets Balance Δ Rate Δ
% of Assets Δ
Balance Rate
Balance Rate
Balance Rate
Investments
384,663 1.44% 46% 390,119 4.25% 47% 55,614 0.00% 7% 830,396 2.66% 100% 601,511 0.23% 72% 104,427 0.57% 13% 44,493 0.65% 5% 2,838 0.00% 0% 77,126 0.00% 9%
341,923 1.24% 43% 42,740 0.20% 396,557 4.31% 50% -6,438 -0.06% 51,872 0.00% 7% 3,742 0.00% 790,352 2.70% 100% 40,044 -0.04% 571,366 0.26% 72% 30,145 -0.03% 106,973 0.63% 14% -2,546 -0.06% 43,848 0.63% 6% 645 0.01% 2,430 0.00% 0% 408 0.00% 65,734 0.00% 8% 11,392 0.00% 790,352 0.31% 100% 40,044 -0.04%
240,886 1.55% 35% 143,777 -0.11% 12% 401,456 4.47% 58% -11,337 -0.22% -11% 49,730 0.00% 7% 5,884 0.00% 0% 692,073 3.13% 100% 138,323 -0.47% 0% 457,988 0.26% 66% 143,523 -0.03% 6% 125,331 1.40% 18% -20,904 -0.83% -6% 40,743 0.70% 6% 3,751 -0.06% -1% 3,534 0.00% 1% -696 0.00% 0% 64,477 0.00% 9% 12,649 0.00% 0% 692,073 0.47% 100% 138,323 -0.19% 0%
Loans & Derivatives
Other Assets Total Assets
Non-Maturity Deposits
Time Deposits
Borrowings & Derivatives
Other Liabilities
Equity
Total Liabilities & Equity 830,396 0.27% 100%
Balance Sheet Spread
2.39%
2.39%
0.00%
2.66%
-0.27%
Net Interest Income Sensitivity
6/30/2021
6/30/2021 vs. 3/31/2021
6/30/2021 vs. 6/30/2020
% Δ from Yr 1 Base
% Δ from Yr 1 Base NII Δ EAR Δ
% Δ from Yr 1 Base NII Δ EAR Δ 3.4% 933 -2.4%
Year 1 NII Projections
NII
NII
NII
UP 200BP
20,922 20,721 20,375
1.0%
20,580 19,980 19,734
3.0% 342 -2.0%
19,989 19,335 19,329
742
1,386
BASE
DOWN 100BP
-1.7%
-1.2% 641 -0.4%
0.0% 1,046 -1.6%
% Δ from Yr 1 Base
% Δ from Yr 1 Base
% Δ from Yr 1 Base
Year 2 NII Projections
UP 200BP
19,621
-5.3%
20,298 18,312
1.6% -677 -6.9%
20,453 18,558 18,382
5.8% -832 -11.1% -4.0% -243 -7.6% -4.9% -1,290 -12.6%
18,315 -11.6% 17,091 -17.5%
-8.3%
3 -3.3%
BASE
DOWN 100BP
17,402 -12.9% -311 -4.6%
2 Year Cumulative NII Projections
% Δ from Base
% Δ from Base
% Δ from Base
UP 200BP
40,543 39,036 37,466
3.9%
40,878 38,292 37,136
6.8% -335 -2.9%
40,442 37,893 37,711
6.7% 101 -2.9%
744
1,143
BASE
DOWN 100BP
-4.0%
-3.0% 330 -1.0%
-0.5% -245 -3.5%
Cloyd Bank & Trust - Page 7
Made with FlippingBook PDF to HTML5