CMS Case Study

NII Reconciliation - 9/30/2020

90 DAY LOOKBACK

06/30/2020 - 09/30/2020

03/31/2020 - 06/30/2020

12/31/2019 - 03/31/2020

09/30/2019 - 12/31/2019

VARIANCE

VARIANCE

VARIANCE

VARIANCE

PROJ. ACTUALS

$

% PROJ. ACTUALS

$

% PROJ. ACTUALS

$

% PROJ. ACTUALS

$

%

INVESTMENTS

944

912

33 3.57% 950

912

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

-38 -3.52% 1,008 1,026 -51 -1.10% 4,437 4,573

-19 -1.80% -136 -2.98%

LOANS

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,652 5,668

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

-89 -1.56% 5,444 5,599 -155 -2.77%

DEPOSITS

NON-MATURITY DEPOSITS TIME DEPOSITS

295 372 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% 487 23 4.22% 590

502 585

-15 -3.03%

9 1.85% 566

4 0.72%

TOTAL DEPOSITS BORROWINGS

102 13.85% 1,096 1,034

62 6.04% 1,076 1,087

-11 -1.01% -8 -16.69%

72

76

-3 -4.11% 0 0.00%

61

66

-5 -7.40% 0 0.00%

50

55

-5 -9.68% 38

45

ALL OTHER LIABILITIES

0

0

0

0

0

0

0 0.00%

0

0

0 0.00%

TOTAL INTEREST EXPENSE NET INTEREST INCOME

740

713

27 3.76% 899

802

97 12.11% 1,146 1,089

57 5.25% 1,114 1,133

-19 -1.64%

4,912 4,955

-42 -0.85% 4,456 4,711 -254 -5.40% 4,461 4,607 -146 -3.17% 4,330 4,466 -136 -3.05%

1. 9/30/2019 - 12/31/2019 variance is due to asset growth. Deposits inflows and borrowings funded loan demand. 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 49