CMS Case Study

NII Reconciliation - 9/30/2021

3 MONTH LOOKBACK

06/30/2021 - 09/30/2021

03/31/2021 - 06/30/2021

12/31/2020 - 03/31/2021

09/30/2020 - 12/31/2020

VARIANCE

VARIANCE

VARIANCE

VARIANCE

PROJ. ACTUALS 1,442 1,360 4,846 5,075

$

% PROJ. ACTUALS

$

% PROJ. ACTUALS

$

% PROJ. ACTUALS

$

%

INVESTMENTS

82 6.02% 1,261 1,137 -229 -4.51% 4,582 4,759

124 10.89% 858

861

-2 -0.27% 881

780

100 12.88% -48 -1.07% 0 0.00% 53 1.01% 15 5.27% 2 0.97% 17 3.32% 9 12.17% 0 0.00% 26 4.38% 27 0.58%

LOANS

-176 -3.71% 4,365 4,381

-16 -0.37% 4,405 4,452

OTHER ASSETS

0

0

0 0.00%

0

0

0 0.00%

0

0

0 0.00%

0

0

TOTAL INTEREST INCOME

6,288 6,435 -147 -2.29% 5,843 5,896

-52 -0.89% 5,223 5,242

-19 -0.36% 5,285 5,232

DEPOSITS

NON-MATURITY DEPOSITS TIME DEPOSITS

349 142 491

319 141 460

29 9.16% 342 1 1.03% 156 31 6.68% 498

367 156 523

-25 -6.74% 324 0 0.04% 177 -25 -4.71% 501

316 178 494

8 2.62% 300

285 237 522

-1 -0.59% 239 7 1.46% 539 -3 -3.89% 80

TOTAL DEPOSITS BORROWINGS

73

77

-4 -5.29% 0 0.00%

70

71

-1 -1.74% 0 0.00%

65

68

71

ALL OTHER LIABILITIES

0

0

0

0

0

0

0 0.00%

0

0

TOTAL INTEREST EXPENSE NET INTEREST INCOME

564

537

27 4.96% 568

594

-26 -4.36% 566

561

5 0.82% 619

593

5,724 5,898 -174 -2.95% 5,275 5,302

-27 -0.50% 4,657 4,680

-23 -0.50% 4,666 4,639

12 MONTH LOOKBACK

09/30/2020 - 09/30/2021

06/30/2020 - 06/30/2021

03/31/2020 - 03/31/2021

12/31/2019 - 12/31/2020

VARIANCE

VARIANCE

VARIANCE

VARIANCE

PROJ. ACTUALS 3,342 4,138

$

% PROJ. ACTUALS

$

% PROJ. ACTUALS

$

% PROJ. ACTUALS

$

%

INVESTMENTS

-796 -19.23% 3,679 3,690

-11 -0.29% 3,657 3,465 -293 -1.60% 17,270 18,189

192 5.55% 4,110 3,681 -920 -5.06% 18,074 18,427

429 11.66% -353 -1.91%

LOANS

17,619 18,666 -1,048 -5.61% 18,055 18,348

OTHER ASSETS 0 1,310 -1,310 -100.00% TOTAL INTEREST INCOME 20,961 22,804 -1,843 -8.08% 21,734 22,037 -304 -1.38% 20,927 21,654 -727 -3.36% 22,184 23,417 -1,233 -5.27% DEPOSITS NON-MATURITY DEPOSITS 1,193 1,287 -93 -7.27% 1,174 1,230 -56 -4.56% 1,464 1,134 329 29.05% 2,133 1,310 823 62.87% TIME DEPOSITS 725 712 13 1.85% 937 946 -9 -0.95% 1,599 1,255 344 27.41% 2,209 1,620 589 36.39% TOTAL DEPOSITS 1,918 1,998 -80 -4.02% 2,111 2,176 -65 -2.99% 3,063 2,389 673 28.19% 4,342 2,929 1,413 48.23% BORROWINGS 316 287 29 10.27% 288 285 2 0.85% 244 280 -36 -12.80% 200 267 -68 -25.29% ALL OTHER LIABILITIES 0 0 0 0.00% 0 0 0 0.00% 0 0 0 0.00% 0 0 0 0.00% TOTAL INTEREST EXPENSE 2,234 2,285 -51 -2.22% 2,398 2,461 -63 -2.55% 3,307 2,669 638 23.89% 4,542 3,196 1,345 42.09% NET INTEREST INCOME 18,727 20,519 -1,792 -8.73% 19,335 19,576 -241 -1.23% 17,620 18,985 -1,365 -7.19% 17,642 20,221 -2,579 -12.75% 0 0 0 0.00% 0 0 0 0.00% 0 0 0 0.00%

1. 12/31/2020 - 03/31/2021 NII recon. excludes PPP related fee income (as of 3/31/21, $535K in actual PPP fee income was realized over the quarter vs. $285K projected). 2. 09/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

Cloyd Bank & Trust - Page 51