CMS Case Study

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

12/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.12

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

2,310

8,680

-- -- --

1,014 29,544 41,548 23,009 64,557

1 Month LIBOR

--

--

--

--

--

1,521 1,521

Total

2,310

8,680

1,014 29,544 41,548 24,530 66,078

9/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.09

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

1,957

8,358

-- -- --

401 29,359 40,075 24,709 64,783

1 Month LIBOR

--

--

--

--

--

1,526 1,526

Total

1,957

8,358

401 29,359 40,075 26,235 66,309

3M 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

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

353

321

-- -- --

613

186 1,473 -1,700 -226

1 Month LIBOR

0.03

--

--

--

--

--

-5

-5

Total

353

321

613

186 1,473 -1,705 -231

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 61

Made with FlippingBook PDF to HTML5