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