CMS Case Study

Loan Floor Report 12m Comparison - 9/30/2020

9/30/2020

IN THE MONEY

OUT OF THE MONEY

Floating WSJ Prime

INDEX RATE >200 BP 200-151 BP 150-101 BP 100-51 BP 50-1 BP Total

AT FLOOR 1-50 BP 51-100 BP 101-150 BP 151-200 BP >200 BP Total NO FLOOR TOTAL

3.25 0.13

2,600

3,368

20,236

13,171 12,433 51,807

4,678 1,759

571

411

35

118 2,894

16,123 75,503

1 Month LIBOR

--

--

--

445

--

445

--

--

--

--

--

--

--

459 905

Total

2,600

3,368

20,236

13,616 12,433 52,253

4,678 1,759

571

411

35

118 2,894

16,583 76,407

9/30/2019

IN THE MONEY

OUT OF THE MONEY

Floating WSJ Prime

INDEX RATE >200 BP 200-151 BP 150-101 BP 100-51 BP 50-1 BP Total AT FLOOR 1-50 BP 51-100 BP 101-150 BP 151-200 BP >200 BP Total

NO FLOOR TOTAL

4.75 1.76

13

14

45

2,977 5,081 8,130

3,330 12,133

10,169

7,164

1,888

1,042 32,396

23,335 67,190

1 Month LIBOR

--

--

--

--

--

--

--

--

--

--

437

--

437

--

437

Total

13

14

45

2,977 5,081 8,130

3,330 12,133

10,169

7,164

2,325

1,042 32,833

23,335 67,628

12M VARIANCE

IN THE MONEY

OUT OF THE MONEY

Floating WSJ Prime

RATE VAR. >200 BP 200-151 BP 150-101 BP 100-51 BP 50-1 BP Total

AT FLOOR 1-50 BP 51-100 BP 101-150 BP 151-200 BP >200 BP Total

NO FLOOR TOTAL

-1.50 -1.63

2,587

3,354

20,191

10,194 7,352 43,678

1,348 -10,375

-9,598

-6,753

-1,853

-924 -29,502

-7,211 8,312 459 467 -6,752 8,780

1 Month LIBOR

--

--

--

445

--

445

--

--

--

--

-437

--

-437

Total

2,587

3,354

20,191

10,639 7,352 44,123

1,348 -10,375

-9,598

-6,753

-2,290

-924 -29,940

1. Floating Loans have a repricing frequency 1, 3 or 6 months and reprice within 6 months of the model’s as-of-date. 2. Adjustable loans have repricing frequencies greater than 6 months and reprice within 12 months of the model’s as-of-date. 3. Non-Accrual loans are excluded from the report.

Cloyd Bank & Trust - Page 61