CMS Case Study

Loan Cap Report 12m Comparison - 03/31/2021

3/31/2021

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.10

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

690

6,339

15

2 28,720 35,766 34,106 69,873

1 Month LIBOR

--

--

--

--

--

--

1,478 1,478

Total

690

6,339

15

2 28,720 35,766 35,584 71,351

3/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.33

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

499

425 38,463 39,388 39,718 79,106

1 Month LIBOR

--

--

--

--

748 748

Total

499

425 38,463 39,388 40,466 79,854

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

0

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

690

6,339

-484

-423

-9,743 -3,621 -5,612 -9,233

1 Month LIBOR

-0.23

--

--

--

--

--

--

731 731

Total

690

6,339

-484

-423

-9,743 -3,621 -4,882 -8,503

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 62

Made with FlippingBook PDF to HTML5