CMS Case Study
Securities Purchased: Stress and Principal Cashflow Tables
# 3
Description
Cusip
Sector
FN-FM4870 2 11/01/50 FNMA CONV 30 YR SF
3140X8MU8
Fixed MBS N/A/N/A
Par
Coupon
Maturity
S&P/Moody Rt
2,194,008 104.8750 2,200,000
2.00
11/01/50
Market Price Original Face Current Factor
Delay Days
24
Historical Speeds
Pool Size Issue Date
Orig/WAM/Seas
169,668,839 11/01/2020
358 / 356 / 2
Gross WAC
0.9973
2.89
1Mo, 3Mo, 6Mo
1.14, Na, Na Na, Na, 1.15
Factor Date
12/01/20
1Yr, 2Yr, Life
Geography
AvgLoanSize / LTV 355,663 / 75% Number of Loans 478
Down 100 2,385,026
Down 50 2,353,578
Down 25 2,329,176
Base
Up 25
Up 50
Up 300
Market Value
2,300,966
2,267,971
2,230,115
1,780,293 -22.63% 11.98 / 8.88 9.78 / 0.46 1.53 / 4.22
Percent Change Avg Life / Mod Dur Eff Dur / Eff Convx Book / Market Yield
3.65%
2.29%
1.23%
0.00%
-1.43%
-3.08%
3.92 / 3.94 2.33 / -1.19 0.69 / -0.24
5.52 / 5.33 4.87 / -0.38 1.05 / 0.62
6.56 / 6.17 5.02 / -1.00 1.19 / 0.99
7.63 / 6.99 5.19 / -1.53 1.29 / 1.29
8.35 / 7.49 6.02 / -1.32 1.35 / 1.54
8.91 / 7.84 6.62 / -1.09 1.38 / 1.78
Gain (Loss) CPR / PSA
84,060
52,612
28,209
0
(32,995)
(70,851)
(520,673)
20.76
14.16
11.35
9.14
7.92
7.08
3.57
Yr1 (AsOf 12/16/20) Cashflows Year 2 Cashflows Year 3 Cashflows Year 4 Cashflows Year 5 Cashflows Year 6 Cashflows Year 7
493,083 383,784 298,454 231,882 179,980 139,548 108,075
351,411 296,906 250,671 211,472 178,254 150,122 126,310
291,093 254,370 222,137 193,858 169,056 147,315 128,265
243,654 218,589 195,996 175,638 157,298 140,783 125,916
217,466 197,959 180,116 163,800 148,883 135,248 122,790
199,435 183,392 168,568 154,874 142,227 130,548 119,766
124,092 119,319 114,719 110,286 106,013 101,896 97,928
# 4
Description
Cusip
Sector
FN-CA8249 1.5 12/01/50 FNMA CONV 30 YR SF
3140QGEX1
Fixed MBS N/A/N/A
Par
Coupon
Maturity
S&P/Moody Rt
2,200,000 101.7188 2,200,000
1.50
12/01/50
Market Price Original Face Current Factor
Delay Days
24
Historical Speeds
Pool Size Issue Date
Orig/WAM/Seas
64,728,228 12/01/2020
359 / 358 / 1
Gross WAC
1.0000
2.47
1Mo, 3Mo, 6Mo
-2.29, Na, Na Na, Na, -2.29
Factor Date
12/01/20
1Yr, 2Yr, Life
Geography
AvgLoanSize / LTV 337,724 / 75% Number of Loans 192
Down 100 2,340,030
Down 50 2,297,609
Down 25 2,269,890
Base
Up 25
Up 50
Up 300
Market Value
2,237,814
2,201,701
2,161,906
1,714,778 -23.37% 11.43 / 8.61 9.92 / 0.45 1.33 / 4.19
Percent Change Avg Life / Mod Dur Eff Dur / Eff Convx Book / Market Yield
4.57%
2.67%
1.43%
0.00%
-1.61%
-3.39%
3.98 / 3.99 3.08 / -1.29 1.03 / -0.12
5.98 / 5.74 5.66 / -0.25 1.18 / 0.71
7.10 / 6.65 5.76 / -0.83 1.23 / 1.01
7.79 / 7.17 5.90 / -1.33 1.25 / 1.25
8.35 / 7.55 6.71 / -1.03 1.27 / 1.48
8.93 / 7.93 7.14 / -0.87 1.28 / 1.71
Gain (Loss) CPR / PSA
102,217
59,795
32,077
0
(36,113)
(75,908)
(523,036)
20.32
12.70
10.07
8.75
7.81
6.93
3.98
Yr1 (AsOf 12/16/20) Cashflows Year 2 Cashflows Year 3 Cashflows Year 4 Cashflows Year 5 Cashflows Year 6 Cashflows Year 7
487,270 380,884 297,467 232,104 180,923 140,879 109,573
323,477 277,761 238,337 204,357 175,083 149,875 128,182
266,945 236,513 209,423 185,317 163,875 144,809 127,864
238,571 214,717 193,143 173,636 156,005 140,075 125,685
218,366 198,750 180,807 164,399 149,398 135,687 123,160
199,450 183,466 168,690 155,032 142,411 130,751 119,981
136,040 129,861 123,940 118,266 112,830 107,622 102,632
# 5
Description
Cusip
Sector
FN-FM5265 2 01/01/51 FNMA CONV 30 YR SF
3140X8Z75
Fixed MBS
Par
Coupon
Maturity
2,200,000 104.4375 2,200,000
2.00
1/01/51
Market Price Original Face Current Factor
Delay Days
24
Historical Speeds
Pool Size Issue Date
Orig/WAM/Seas
70,178,076 12/01/2020
359 / 359 / 0
1.0000
1Mo, 3Mo, 6Mo
Na, Na, Na Na, Na, Na
Factor Date
12/01/20
1Yr, 2Yr, Life
Geography
AvgLoanSize / LTV 340,879 / 79% Number of Loans 206
Down 100 2,364,404
Down 50 2,341,026
Down 25 2,321,307
Base
Up 25
Up 50
Up 300
Market Value
2,297,625
2,269,368
2,237,870
1,810,665 -21.19% 11.15 / 8.33 9.55 / 0.32 1.54 / 4.21
Percent Change Avg Life / Mod Dur Eff Dur / Eff Convx Book / Market Yield
2.91%
1.89%
1.03%
0.00%
-1.23%
-2.60%
2.90 / 2.95 1.90 / -0.93 0.41 / -0.58
4.17 / 4.10 3.77 / -0.64 0.87 / 0.41
5.06 / 4.86 4.02 / -1.08 1.05 / 0.84
6.09 / 5.69 4.38 / -1.47 1.20 / 1.20
7.02 / 6.40 5.13 / -1.30 1.30 / 1.49
7.58 / 6.78 5.72 / -1.11 1.35 / 1.73
Gain (Loss) CPR / PSA
66,779
43,401
23,682
0
(28,257)
(59,755)
(486,960)
27.97
19.44
15.71
12.56
10.40
9.29
4.44
Yr1 (AsOf 12/16/20) Cashflows Year 2 Cashflows Year 3 Cashflows Year 4 Cashflows Year 5 Cashflows Year 6 Cashflows Year 7
649,198 458,861 324,025 228,582 161,080 113,380 79,707
465,548 368,576 291,561 230,434 181,949 143,521 113,085
385,241 319,472 264,730 219,191 181,330 149,870 123,747
317,422 273,442 235,398 202,502 174,071 149,510 128,305
270,917 239,465 211,539 186,752 164,760 145,255 127,963
247,019 221,241 198,045 177,180 158,417 141,550 126,392
142,599 135,528 128,784 122,351 116,215 110,364 104,783
12/11/2020
Raymond James
Page 9 of 10
Made with FlippingBook PDF to HTML5