CMS Case Study
Loan Cap Report 12m Comparison - 12/31/2020
12/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.12
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
149
4,796
16
7 31,559 36,527 40,330 76,857
1 Month LIBOR
--
--
--
--
--
--
1,108 1,108
Total
149
4,796
16
7 31,559 36,527 41,438 77,966
12/31/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.66
-- -- --
-- -- --
-- -- --
-- -- --
506 506
-- -- --
416
1,273
757
803 40,383 43,632 30,226 74,363
1 Month LIBOR
--
--
--
--
--
--
--
--
458 458
Total
506 506
416
1,273
757
803 40,383 43,632 30,684 74,822
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.54
-- -- --
-- -- --
-- -- --
-- -- --
-506 -506
-- -- --
-267
3,524
-741
-796
-8,823 -7,104 10,104 2,494
1 Month LIBOR
--
--
--
--
--
--
--
--
650 650
Total
-506 -506
-267
3,524
-741
-796
-8,823 -7,104 10,754 3,144
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 60
Made with FlippingBook PDF to HTML5