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