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