CMS Case Study

Historical Balance Sheet & NII - 12/31/2020

HISTORICAL BALANCE SHEET COMPARISON 12/31/2020

12/31/2020 vs. 9/30/2020

12/31/2020 vs. 12/31/2019

% of Assets

% of Assets Balance Δ Rate Δ

% of Assets Balance Δ Rate Δ

% of Assets Δ

Balance Rate

Balance Rate

Balance Rate

Investments

263,690 1.30% 37% 405,939 4.38% 56% 50,239 0.00% 7% 719,869 2.94% 100% 495,426 0.26% 69% 111,654 0.75% 16% 41,996 0.62% 6% 4,347 0.00% 1% 66,446 0.00% 9%

234,112 1.54% 34% 29,578 -0.24% 402,243 4.37% 59% 3,696 0.00% 49,736 0.00% 7% 503 0.00% 686,092 3.09% 100% 33,777 -0.15% 455,936 0.26% 66% 39,490 0.00% 114,469 0.98% 17% -2,816 -0.23% 46,321 0.68% 7% -4,325 -0.06% 3,556 0.00% 1% 791 0.00% 65,809 0.00% 10% 637 0.00% 686,092 0.38% 100% 33,777 -0.05%

157,569 2.80% 28% 106,121 -1.50% 8% 354,060 5.16% 63% 51,879 -0.78% -7% 47,972 0.00% 9% 2,268 0.00% -2% 559,601 4.05% 100% 160,268 -1.11% 0% 347,796 0.62% 62% 147,630 -0.35% 7% 128,795 1.81% 23% -17,142 -1.06% -8% 23,105 0.86% 4% 18,891 -0.24% 2% 3,982 0.00% 1% 365 0.00% 0% 55,923 0.00% 10% 10,524 0.00% -1% 559,601 0.84% 100% 160,268 -0.50% 0%

Loans & Derivatives

Other Assets Total Assets

Non-Maturity Deposits

Time Deposits

Borrowings & Derivatives

Other Liabilities

Equity

Total Liabilities & Equity 719,869 0.33% 100%

Balance Sheet Spread

2.61%

2.70%

-0.09%

3.22%

-0.61%

Net Interest Income Sensitivity

12/31/2020

12/31/2020 vs. 9/30/2020

12/31/2020 vs. 12/31/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,702 18,789 18,619

4.9%

19,285 18,727 18,608

3.0% 418 1.9%

17,540 17,642 17,494

-0.6% 2,162

5.4%

62

1,146

BASE

DOWN 100BP

-0.9%

-0.6% 12 -0.3%

-0.8% 1,125 -0.1%

% Δ from Yr 1 Base

% Δ from Yr 1 Base

% Δ from Yr 1 Base

Year 2 NII Projections

UP 200BP

19,997 17,151

6.4% -8.7%

19,355 17,560 17,200

3.4% 642 3.1% -6.2% -409 -2.5% -8.2% -571 -3.3%

17,378 17,140 16,377

-1.5% 2,619

7.9%

-2.8% 11 -5.9% -7.2% 253 -4.3%

BASE

DOWN 100BP

16,629 -11.5%

2 Year Cumulative NII Projections

% Δ from Base

% Δ from Base

% Δ from Base

UP 200BP

39,700 10.5%

38,639 36,287 35,808

6.5% 1,060 4.0%

34,918 34,782 33,871

0.4% 4,781 10.1%

35,940 35,249

-347

1,158

BASE

DOWN 100BP

-1.9%

-1.3% -559 -0.6%

-2.6% 1,378

0.7%

Cloyd Bank & Trust - Page 7

Made with FlippingBook PDF to HTML5