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