CMS Case Study

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

NO CAP TOTAL

3.25 0.13

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

-- -- --

4,299

498

4 32,794 37,595 37,907 75,503

1 Month LIBOR

--

--

--

--

--

905 905

Total

4,299

498

4 32,794 37,595 38,812 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 CAP 1-50 BP 51-100 BP 101-150 BP 151-200 BP >200 BP Total

NO CAP TOTAL

4.75 1.76

-- -- --

-- -- --

-- -- --

7

513 521

-- -- --

416

1,290

759

1,488 40,150 44,103 22,567 67,190

1 Month LIBOR

--

--

--

--

--

--

--

--

--

437 437

Total

7

513 521

416

1,290

759

1,488 40,150 44,103 23,004 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 CAP 1-50 BP 51-100 BP 101-150 BP 151-200 BP >200 BP Total

NO CAP TOTAL

-1.50 -1.63

-- -- --

-- -- --

-- -- --

-7 -- -7

-513 -521

-- -- --

-416

3,010

-261

-1,485

-7,355 -6,508 15,340 8,312

1 Month LIBOR

--

--

--

--

--

--

--

--

467 467

Total

-513 -521

-416

3,010

-261

-1,485

-7,355 -6,508 15,808 8,780

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 59

Made with FlippingBook PDF to HTML5