CMS Case Study

Loan Cap Report 12m Comparison - 6/30/2021

6/30/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

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

1,145

7,523

15

353 28,068 37,104 33,932 71,035

1 Month LIBOR

--

--

--

--

--

--

1,531 1,531

Total

1,145

7,523

15

353 28,068 37,104 35,463 72,566

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

NO CAP TOTAL

3.25 0.16

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

1,464

490

425 35,869 38,249 40,205 78,454

1 Month LIBOR

--

--

--

--

--

873 873

Total

1,464

490

425 35,869 38,249 41,078 79,327

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

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

1,145

6,058

-475

-72

-7,801 -1,146 -6,273 -7,419

1 Month LIBOR

-0.06

--

--

--

--

--

--

658 658

Total

1,145

6,058

-475

-72

-7,801 -1,146 -5,615 -6,760

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 57

Made with FlippingBook PDF to HTML5