CMS Case Study

NII Reconciliation - 12/31/2020

90 DAY LOOKBACK

09/30/2020 - 12/31/2020

06/30/2020 - 09/30/2020

03/31/2020 - 06/30/2020

12/31/2019 - 03/31/2020

VARIANCE

VARIANCE

VARIANCE

VARIANCE

PROJ. ACTUALS

$

% PROJ. ACTUALS

$

% PROJ. ACTUALS

$

% PROJ. ACTUALS

$

%

INVESTMENTS

881

780

100 12.88% 944

912

33 3.57% 950

912

38 4.17% 1,039 1,077 -195 -4.24% 4,568 4,619

-38 -3.52% -51 -1.10%

LOANS

4,405 4,452

-48 -1.07% 4,708 4,756

-48 -1.01% 4,405 4,600

OTHER ASSETS

0

0

0 0.00%

0

0

0 0.00%

0

0

0 0.00%

0

0

0 0.00%

TOTAL INTEREST INCOME

5,285 5,232

53 1.01% 5,652 5,668

-15 -0.27% 5,355 5,512 -157 -2.85% 5,607 5,695

-89 -1.56%

DEPOSITS

NON-MATURITY DEPOSITS TIME DEPOSITS

300 239 539

285 237 522

15 5.27% 295 2 0.97% 372 17 3.32% 668

262 375 638

33 12.62% 365 -3 -0.84% 473 30 4.69% 838

271 465 736

93 34.39% 530

491 543

40 8.05% 23 4.22% 62 6.04% -5 -9.68% 0 0.00% 57 5.25%

9 1.85% 566

TOTAL DEPOSITS BORROWINGS

102 13.85% 1,096 1,034

80

71

9 12.17% 0 0.00%

72

76

-3 -4.11% 0 0.00%

61

66

-5 -7.40% 50

55

ALL OTHER LIABILITIES

0

0

0

0

0

0

0 0.00%

0

0

TOTAL INTEREST EXPENSE NET INTEREST INCOME

619

593

26 4.38% 740

713

27 3.76% 899

802

97 12.11% 1,146 1,089

4,666 4,639

27 0.58% 4,912 4,955

-42 -0.85% 4,456 4,711 -254 -5.40% 4,461 4,607 -146 -3.17%

1. 9/30/2020 - 12/31/2020 lookback excludes PPP related fee income. The investment variance is mainly due to the difference between assumed MBS purchases vs. actual MBS purchases 2. 12/31/2019 - 03/31/2020 variance is due to asset growth and differences in assumed vs. actual rates and balances. 3. 03/31/2020 - 06/30/2020 variance is is due to asset growth. Deposits inflows funded loan demand (including PPP loans).

Cloyd Bank & Trust - Page 50