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