CMS Case Study

Securities Purchased: Stress and Principal Cashflow Tables

Total Securities Purchased

Down 100 11,788,071

Down 50

Down 25

Historical 11,400,514

Up 25

Up 50

Up 300

Market Value

11,642,788

11,534,090

11,246,200

11,071,490

8,871,987 -22.18% 11.61 / 8.66 9.73 / 0.41 1.50 / 4.20 1.50 / 4.20 (2,528,527)

Percent Change Avg Life / Mod Dur Eff Dur / Eff Convx Book / Market Yield Dur Wtd Bk / Mkt Yld Yr 1 (AsOf 11/30/20) Cashflows Year 2 Cashflows Year 3 Cashflows Year 4 Cashflows Year 5 Cashflows Year 6 Cashflows Year 7 Gain (Loss)

3.40%

2.13%

1.17%

0.00%

-1.35%

-2.89%

3.31 / 3.34 2.22 / -1.07 0.58 / -0.43 0.61 / -0.40 2,723,258 2,196,554 1,604,557 1,174,173 387,557

4.87 / 4.73 4.36 / -0.55 0.98 / 0.53 1.00 / 0.55 1,881,451 1,685,409 1,372,462 1,118,167 242,275

5.92 / 5.61 4.60 / -1.09 1.14 / 0.93 1.15 / 0.94 1,531,350 1,430,541 1,216,718 1,034,965 133,576

6.94 / 6.41 4.90 / -1.50 1.25 / 1.25 1.25 / 1.25

7.75 / 7.01 5.71 / -1.31 1.32 / 1.51 1.32 / 1.51 (154,314) 1,108,156 1,089,714

8.36 / 7.41 6.29 / -1.13 1.36 / 1.75 1.36 / 1.75 (329,023) 1,006,355 1,001,435

0

1,273,084 1,227,051 1,077,998

606,599 633,893 606,015 579,307 553,720 529,206 505,721

977,468 876,473 785,611 703,873 630,354

909,520 825,768 749,459 679,940 616,613

946,857 831,470 729,940 640,600

860,705 631,971 464,756

911,393 743,149 606,169

880,421 748,970 637,126

# 1

Description

Cusip

Sector

FH-SE9014 2 10/01/50 FHLMC 55-DAY 30 YR JUMBO/SUPER-CONFORMIN

3133SKAP6

Fixed MBS N/A/N/A

Par

Coupon

Maturity

S&P/Moody Rt

2,189,106 104.3750 2,200,000

2.00

10/01/50

Market Price Original Face Current Factor

Delay Days

24

Historical Speeds

Pool Size Issue Date

Orig/WAM/Seas

71,136,048 10/01/2020

360 / 357 / 3

Gross WAC

0.9950

2.93

1Mo, 3Mo, 6Mo

0.96, Na, Na Na, Na, 0.88

Factor Date

12/01/20

1Yr, 2Yr, Life

Geography

AvgLoanSize / LTV 635,705 / 75% Number of Loans 112

Down 100 2,364,822

Down 50 2,335,050

Down 25 2,313,004

Base

Up 25

Up 50

Up 300

Market Value

2,284,879

2,252,457

2,216,281

1,762,981 -22.84% 12.51 / 9.23 9.91 / 0.51 1.59 / 4.21

Percent Change Avg Life / Mod Dur Eff Dur / Eff Convx Book / Market Yield

3.50%

2.20%

1.23%

0.00%

-1.42%

-3.00%

3.07 / 3.12 2.22 / -1.16 0.51 / -0.61

4.74 / 4.62 4.21 / -0.88 1.01 / 0.53

6.02 / 5.69 4.61 / -1.33 1.21 / 0.99

7.27 / 6.67 5.09 / -1.59 1.33 / 1.33

8.14 / 7.30 5.95 / -1.37 1.40 / 1.59

8.84 / 7.76 6.55 / -1.20 1.44 / 1.83

Gain (Loss) CPR / PSA

79,943

50,171

28,125

0

(32,422)

(68,598)

(521,898)

26.51

16.92

12.73

9.86

8.30

7.22

3.14

Yr1 (AsOf 12/16/20) Cashflows Year 2 Cashflows Year 3 Cashflows Year 4 Cashflows Year 5 Cashflows Year 6 Cashflows Year 7

614,732 443,398 319,521 230,024 165,418 118,822 85,245

409,285 334,414 273,024 222,715 181,513 147,791 120,210

319,523 274,707 236,016 202,627 173,828 148,999 127,605

258,039 229,566 204,119 181,382 161,075 142,944 126,762

224,619 203,583 184,426 166,985 151,111 136,666 123,527

201,482 184,997 169,789 155,761 142,825 130,898 119,905

114,077 110,376 106,792 103,321 99,959 96,703 93,549

# 2

Description

Cusip

Sector

FN-FM4585 2 10/01/50 FNMA CONV 30 YR SF

3140X8CX3

Fixed MBS N/A/N/A

Par

Coupon

Maturity

S&P/Moody Rt

2,181,081 104.5000 2,200,000

2.00

10/01/50

Market Price Original Face Current Factor

Delay Days

24

Historical Speeds

Pool Size Issue Date

Orig/WAM/Seas

209,831,119 10/01/2020

359 / 355 / 4

Gross WAC

0.9914

2.93

1Mo, 3Mo, 6Mo

Na, Na, Na Na, Na, Na

Factor Date

12/01/20

1Yr, 2Yr, Life

Geography

AvgLoanSize / LTV 333,938 / 79% Number of Loans 628

Down 100 2,333,788

Down 50 2,315,525

Down 25 2,300,713

Base

Up 25

Up 50

Up 300

Market Value

2,279,229

2,254,703

2,225,318

1,803,269 -20.88% 10.99 / 8.25 9.54 / 0.31 1.53 / 4.18

Percent Change Avg Life / Mod Dur Eff Dur / Eff Convx Book / Market Yield

2.39%

1.59%

0.94%

0.00%

-1.08%

-2.37%

2.68 / 2.72 1.56 / -0.78 0.26 / -0.62

3.95 / 3.89 3.31 / -0.58 0.79 / 0.38

4.87 / 4.69 3.62 / -1.19 1.01 / 0.81

5.92 / 5.55 3.99 / -1.59 1.17 / 1.17

6.92 / 6.33 4.78 / -1.53 1.28 / 1.45

7.53 / 6.76 5.42 / -1.37 1.33 / 1.69

Gain (Loss) CPR / PSA

54,559

36,296

21,483

0

(24,526)

(53,911)

(475,960)

30.11

20.56

16.39

12.97

10.55

9.33

4.53

Yr1 (AsOf 12/16/20) Cashflows Year 2 Cashflows Year 3 Cashflows Year 4 Cashflows Year 5 Cashflows Year 6 Cashflows Year 7

689,599 472,744 323,768 221,509 151,377 103,326 70,435

485,797 379,117 295,607 230,280 179,212 139,321 108,186

396,808 326,302 268,112 220,115 180,548 147,952 121,115

323,824 277,573 237,762 203,510 174,055 148,738 126,990

272,180 240,144 211,750 186,593 164,312 144,587 127,132

246,145 220,349 197,148 176,287 157,536 140,687 125,553

143,711 136,440 129,511 122,909 116,619 110,626 104,916

12/11/2020

Raymond James

Page 8 of 10

Made with FlippingBook PDF to HTML5