CMS Case Study

Loan Cap Report 12m Comparison - 12/31/2020

12/31/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 CAP 1-50 BP 51-100 BP 101-150 BP 151-200 BP >200 BP Total

NO CAP TOTAL

3.25 0.12

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

149

4,796

16

7 31,559 36,527 40,330 76,857

1 Month LIBOR

--

--

--

--

--

--

1,108 1,108

Total

149

4,796

16

7 31,559 36,527 41,438 77,966

12/31/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 CAP 1-50 BP 51-100 BP 101-150 BP 151-200 BP >200 BP Total

NO CAP TOTAL

4.75 1.66

-- -- --

-- -- --

-- -- --

-- -- --

506 506

-- -- --

416

1,273

757

803 40,383 43,632 30,226 74,363

1 Month LIBOR

--

--

--

--

--

--

--

--

458 458

Total

506 506

416

1,273

757

803 40,383 43,632 30,684 74,822

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 CAP 1-50 BP 51-100 BP 101-150 BP 151-200 BP >200 BP Total

NO CAP TOTAL

-1.50 -1.54

-- -- --

-- -- --

-- -- --

-- -- --

-506 -506

-- -- --

-267

3,524

-741

-796

-8,823 -7,104 10,104 2,494

1 Month LIBOR

--

--

--

--

--

--

--

--

650 650

Total

-506 -506

-267

3,524

-741

-796

-8,823 -7,104 10,754 3,144

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

Cloyd Bank & Trust - Page 60

Made with FlippingBook PDF to HTML5