We valued an RMBS in class using Monte Carlo simulation. The RMBS has a par value of $1 million, a WAM of 10 years, a WAC of 8%, a pass-through rate of 8%, annual cash flows, a balloon payment at the...

1 answer below »

We valued an RMBS in class using Monte Carlo simulation. The RMBS has a par value of $1 million, a WAM of 10 years, a WAC of 8%, a pass-through rate of 8%, annual cash flows, a balloon payment at the end of the fourth year, and zero default risk. Figure 4.3 provides the binomial tree for the spot rates and the refinancing rates. Table 4.2 defines the 8 interest rate paths in terms of the refinancing rates. Table 4.4 provides the prepayment model.


(a) Calculate the cash flows for years 1, 2, 3, and 4 along path 6.


(b) The zero-coupon rates for years 1, 2, 3, and 4 along path 6 are 8.00%, 8.2996%, 8.1996%, and 8.2996%, respectively. Calculate the value of the RMBS for path 2.




Simulation Problem Homework Due at the beginning of class November 18. We valued an RMBS in class using Monte Carlo simulation. The RMBS has a par value of $1 million, a WAM of 10 years, a WAC of 8%, a pass-through rate of 8%, annual cash flows, a balloon payment at the end of the fourth year, and zero default risk. Figure 4.3 provides the binomial tree for the spot rates and the refinancing rates. Table 4.2 defines the 8 interest rate paths in terms of the refinancing rates. Table 4.4 provides the prepayment model. 1. Calculate the cash flows for years 1, 2, 3, and 4 along path 6. 1. The zero-coupon rates for years 1, 2, 3, and 4 along path 6 are 8.00%, 8.2996%, 8.1996%, and 8.2996%, respectively. Calculate the value of the RMBS for path 2. “London” — 2006/9/12 — 22:22 — page 171 — #193 C H A P T E R 4 MORTGAGE-BACKED SECURITIES SECTIONS 4.1 Prepayment Models 4.2 Numerical Example of Prepayment Model 4.3 MBS Pricing and Quoting 4.4 Prepayment Risk and Average Life of MBS 4.5 MBS Pricing Using Monte Carlo in C++ 4.6 Matlab Fixed-Income Toolkit for MBS Valuation 4.7 Collateralized Mortgage Obligations (CMOs) 4.8 CMO Implementation in C++ 4.9 Planned Amortization Classes (PACS) 4.10 Principal- and Interest-Only Strips 4.11 Interest Rate Risk 4.12 Dynamic Hedging of MBS Endnotes Mortgage-backed securities (MBSs) and mortgage pass-throughs (PT) are claims on a portfolio of mortgages. MBSs are created when a federal agency, mortgage banker, bank, or investment company buys up mortgages of a certain type—i.e., FHA (Federal Home Administration) or VA (Veterans’ Administration) insured—and then sells claims on the cash flows from the portfolio as MBSs, with the proceeds of the MBS sale being used to fi- nance the purchase of the mortgages. There are two types of MBS: agency and conventional (private-label).1 Agency MBS, such as a GNMA pass-through, are securities with claims on a portfo- lio of mortgages insured against default risk by FHM, VA, or FmHA (Farmers Mortgage Home Administration). A mortgage banker, bank, or investment company presents a pool of FHA, VA, or FmHA mortgages of a certain type (30-year fixed, 15-year variable rate, etc.) to GNMA (Ginnie Mae). If the mortgage pool is in order, GNMA will issue a separate guarantee that allows the MBSs on the mortgage pool to be issued as a GNMA PT. Other agency MBSs include the Federal Home Loan Mortgage Corporation (FHLMC) MBSs, which are claims on a portfolio of conventional mortgages. The FHLMC issues agency MBSs, whereby the FHLMC buys mortgages from the mortgage originator, and then cre- ates an MBS referred to as a participation certificate, which it issues through a network 171 “London” — 2006/9/12 — 22:22 — page 172 — #194 172 Mortgage-Backed Securities Chapter 4 of dealers. FHLMC has a swap program whereby FHLMC swaps MBSs for a savings and loan’s or commercial bank’s portfolio of mortgages of a certain type. Other government agencies such as FNMA (Fannie Mae) issue several types of MBS: participation certifi- cates, swaps, and PTs. With these certificates, homeowners’ mortgage payments pass from the originating bank through the issuing agency to the holds of the certificates. Conventional types, also known as private-label types, are issued by commercial banks (via their holding companies), S&Ls, mortgage bankers, and investment companies. Con- ventional issued MBSs include those issued by Prudential Home, Chase Mortgage, Citi- Corp Housing, Ryland/Saxon, GE Capital, and Countrywide. Conventional PTs must be registered with the SEC. These PTs are often insured with external insurance in the form of a letter of credit (LOC) of the private-label issuer, as well as internal insurance through the creation of senior and junior classes of the PT structured by the private-label issuer. There is both a primary and a secondary market for MBS. In the primary market, in- vestors buy MBSs issued by agencies or private-label investment companies either directly or through dealers. Many of the investors are institutional investors. Thus, the creation of MBS has provided a tool for having real estate financed more by institutions. In the pri- mary market, MBS issue denominations are typically between $25,000 to $250,000 (with some as high as $1M) and some have callable features. In the secondary market, MBSs are traded over-the-counter (OTC). OTC dealers are members of the Mortgage-Backed Secu- rities Dealer Association (MSDA). MBSs are some of the most complex securities to model and value due to their sensitiv- ity to prepayment and interest rates, which affects the timing, frequency, and size of cash flows to investors. Cash flows (CFs) from MBSs are the monthly CFs from the portfolio of mortgages (referred to as the collateral). Cash flows include interest on principal, sched- uled principal, and prepaid principal. Cash flow analysis is essential in the valuation of any MBS given their impact by the underlying features of the MBS, including weighted aver- age maturity (WAM), weighted average coupon rate (WAC), pass-through rate (PT rate), and prepayment rate or speed. The WAM is effectively the duration, or weighted length of time, of all the payment of MBS cash flows to be paid out to investors. The WAC is the rate on a portfolio of mortgages (collateral) that is applied to determine scheduled principal. The PT rate is the interest on principal and is lower than the WAC, with the difference go- ing to the MBS issuer. The prepayment rate or speed is the assumed prepayment rate made by homeowners of mortgages in the pool. In this chapter, we discuss MBS pricing and modeling in detail. In §4.1, we discuss prepayment and PSA models for MBS pricing. In §4.2, we give numerical examples us- ing Excel of how the prepayment models work. In §4.3, we discuss MBS pricing, quoting, and the value and return to investors based on different prepayment and interest rate as- sumptions. In §4.4, we discuss prepayment risk and the average life of MBS. In §4.5, we review in detail a numerical implementation in C++ and Excel for valuation and cash flow analysis of MBS using Monte Carlo simulation. In §4.6, we give numerical examples using the Fixed-Income Toolbox in Matlab. In §4.7, we discuss MBS derivatives, including col- lateralized mortgage obligations (CMOs) and sequential-pay tranche structures. We give examples using Excel. In §4.8, we give an implementation of a CMO in C++. In §4.9, we discuss planned amortization classes (PAC) and their structures. In §4.10, we review stripped MBS, including interest-only (IO) and principal-only (PO) securities. In §4.11, “London” — 2006/9/12 — 22:22 — page 173 — #195 Section 4.1 Prepayment Models 173 we discuss interest rate risk of MBSs. Finally, in §4.12, we discuss hedging MBS and using MBS for balance sheet asset-liability management. 4.1 PREPAYMENT MODELS MBS valuation models typically assume a prepayment rate or speed. Investors and issuers apply different prepayment models in analyzing MBS. Most models, though, are compared to a benchmark model or rate. The benchmark model is the one provided by the Public Securities Association (PSA). PSA measures speed by the Conditional Prepayment Rate (CPR). CPR is the proportion of the remaining mortgage balance that is prepaid each month and is quoted on an annual basis. The monthly rate is referred to as the Single- Monthly Mortality rate (SMM) and is given by: SMM = 1 − (1 − CPR)1/12 (4.1) The estimated monthly prepayment is: Monthly prepayment = SMM · [Beginning of month balance− Sched. prin. for month] For example, if CPR = 6%, beginning-of-the-month balance = $100M, and scheduled principal for month = $3M, then the estimated prepaid principal for the month would be $0.499M: SMM = 1 − [1− .06]1/12 = .005143 Monthly prepaid principal = .005143[$100M − $3M ] = $0.499M In the PSA model, CPR depends on the maturity of the mortgages. PSA’s standard model assumes that for a 30-year mortgage (360 months), the CPR is equal to .2% the first month, grows at that rate for 30 months to equal 6%, and stays at 6% for the rest of the mortgage’s life. This model is referred to as the 100% PSA model. Figure 4.1 shows the prepayment rate as a function of time in months. The estimation of CPR for month t is: CPR = { 0.06 ( t 30 ) , if t ≤ 30 0.06, if t > 30 (4.2) As an example, the CPR for month five is: CPR = .06 ( 5 30 ) = .01 SMM = 1 − [1− .01]1/12 = .000837 PSA’s model can be defined in terms of different speeds by expressing the standard model (100% PSA) in terms of a higher or lower percentage, such as 150% or 50%. In a period of lower rates, the PSA model could be 150%, and in a period of higher rates, it “London” — 2006/9/12 — 22:22 — page 174 — #196 174 Mortgage-Backed Securities Chapter 4 CPR (%) 6.0 0.2 0 30 360 Month Figure 4.1 100% PSA Model could be 50%. For the 100% PSA model, the average time a 30-year mortgage is held is 17 years; for a 225% PSA model, it is 8 years. Figure 4.2 shows the different prepayment rates as a function of time in months. CPR (%) 6.0 9.0 0.2 3.0 0 30 360 150 PSA 100 PSA 50 PSA Month Figure 4.2 PSA Models “London” — 2006/9/12 — 22:22 — page 175 — #197 Section 4.2 Numerical Example of Prepayment Model 175 Suppose we want to compute the CPR and SMM for month five with 165 PSA speed. Then we compute the following based on (4.1) and (4.2): CPR = .06 ( 5 30 ) = .01 165CPR = 1.65(.01) = .0165 SMM = 1 − [1 − .0165]1/12 = .0001386 4.2 NUMERICAL EXAMPLE OF PREPAYMENT MODEL Let p = monthly scheduled mortgage payment, F0 = the face value of the underlying mortgage pool of the MBS, M = WAM = weighted average of the number of months remaining until maturity, I = interest rate payment, SP = scheduled principal payment, PP = prepaid principal, RA = annual interest rate (WAC), Bi, i = 1, . . . , 360, the remain- ing mortgage balance in month i, and CFi, i = 1, . . . , 360 , the cash flow in the ith month. Note that the balance in month 1 is
Answered Same DayNov 17, 2021

Answer To: We valued an RMBS in class using Monte Carlo simulation. The RMBS has a par value of $1 million, a...

Himanshu answered on Nov 18 2021
119 Votes
Cash Flow 1
        1
        Par    $ 1,000,000.00
        Weighted Average Maturity    10    120    months
        Weighted Average Coupon    8%
        P    82.42    Interest Payment         Scheduled Payment        Estimated Period        First Year Cash Flow        The Beginning balacne for the second month is
            $ 12,133    I    $ 6,667    SP    $ 5,466    CPR    0.006    CF1    p+pp+I    B2 = B1-SP-PP    $ 994,035.27
                                SMM    0.0005013803        $ 19,298
                                PP    $ 498.64
        2
        Par    $ 994,035.27
        Weighted Average Maturity    10    119    months
        Weighted Average Coupon    8%
        P    81.97    Interest Payment         Scheduled Payment        Estimated Period        First Year
Cash Flow        The Beginning balacne for the second month is
            $ 12,127    I    $ 6,627    SP    $ 5,500    CPR    0.012    CF1    p+pp+I    B2 = B1-SP-PP    $ 987,541.48
                                SMM    0.0010055425        $ 19,748
                                PP    $ 994.01
        3
        Par    $ 987,541.48
        Weighted Average Maturity    10    118    months
        Weighted Average Coupon    8%
        P    81.52    Interest Payment         Scheduled Payment        Estimated Period        First Year Cash Flow        The Beginning balacne for the second month is
            $ 12,114    I    $ 6,584    SP    $ 5,531    CPR    0.018    CF1    p+pp+I    B2 = B1-SP-PP    $ 980,525.30
                                SMM    0.0015125192        $ 20,183
                                PP    $ 1,485.31
        4
        Par    $ 980,525.30
        Weighted Average Maturity    10    117    months
        Weighted Average Coupon    8%
        P    81.06    Interest Payment         Scheduled Payment        Estimated Period        First Year Cash Flow        The Beginning balacne for the second month is
            $ 12,096    I    $ 6,537    SP    $ 5,559    CPR    0.024    CF1    p+pp+I    B2 = B1-SP-PP    $ 972,994.26
                                SMM    0.0020223433        $ 20,605
                                PP    $ 1,971.72
        5
        Par    $ 972,994.26
        Weighted Average Maturity    10    116    months
        Weighted Average Coupon    8%
        P    80.60    Interest Payment         Scheduled Payment        Estimated Period        First Year Cash Flow        The Beginning balacne for the second month is
            $ 12,072    I    $ 6,487    SP    $ 5,585    CPR    0.03    CF1    p+pp+I    B2 = B1-SP-PP    $ 964,956.76
                                SMM    0.0025350486        $ 21,011
                                PP    $ 2,452.43
        6
        Par    $ 964,956.76
        Weighted Average Maturity    10    115    months
        Weighted Average Coupon    8%
        P    80.14    Interest Payment         Scheduled Payment        Estimated Period        First Year Cash Flow        The Beginning balacne for the second month is
            $ 12,041    I    $ 6,433    SP    $ 5,608    CPR    0.036    CF1    p+pp+I    B2 = B1-SP-PP    $ 956,422.05
                                SMM    0.0030506693        $ 21,401
                                PP    $ 2,926.66
        7
        Par    $ 956,422.05
        Weighted Average Maturity    10    114    months
        Weighted Average Coupon    8%
        P    79.67    Interest Payment         Scheduled Payment        Estimated Period        First Year Cash Flow        The Beginning balacne for the second month is
            $ 12,004    I    $ 6,376    SP    $ 5,628    CPR    0.042    CF1    p+pp+I    B2 = B1-SP-PP    $ 947,400.23
                                SMM    0.0035692401        $ 21,774
                                PP    $ 3,393.61
        8
        Par    $ 947,400.23
        Weighted Average Maturity    10    113    months
        Weighted Average Coupon    8%
        P    79.20    Interest Payment         Scheduled Payment        Estimated Period        First Year Cash Flow        The Beginning balacne for the second month is
            $ 11,962    I    $ 6,316    SP    $ 5,646    CPR    0.048    CF1    p+pp+I    B2 = B1-SP-PP    $ 937,902.19
                                SMM    0.0040907968        $ 22,130
                                PP    $ 3,852.53
        9
        Par    $ 937,902.19
        Weighted Average Maturity    10    112    months
        Weighted Average Coupon    8%
        P    78.73    Interest Payment         Scheduled Payment        Estimated Period        First Year Cash Flow        The Beginning balacne for the second month is
            $ 11,913    I    $ 6,253    SP    $ 5,660    CPR    0.054    CF1    p+pp+I    B2 = B1-SP-PP    $ 927,939.64
                                SMM    0.0046153754        $ 22,468
                                PP    $ 4,302.65
        10
        Par    $ 927,939.64
        Weighted Average Maturity    10    111    months
        Weighted Average Coupon    8%
        P    78.26    Interest Payment         Scheduled Payment        Estimated Period        First Year Cash Flow        The Beginning balacne for the second month is
            $ 11,858    I    $ 6,186    SP    $ 5,671    CPR    0.06    CF1    p+pp+I    B2 = B1-SP-PP    $ 917,525.07
                                SMM    0.0051430128        $ 22,787
                                PP    $ 4,743.24
        11
        Par    $ 917,525.07
        Weighted Average Maturity    10    110    months
        Weighted Average Coupon    8%
        P    77.78    Interest Payment         Scheduled Payment        Estimated Period        First Year Cash Flow        The Beginning balacne for the second month is
            $ 11,797    I    $ 6,117    SP    $ 5,680    CPR    0.066    CF1    p+pp+I    B2 = B1-SP-PP    $ 906,671.70
                                SMM    0.0056737466        $ 23,087
                                PP    $ 5,173.58
        12
        Par    $ 906,671.70
        Weighted Average Maturity    10    109    months
        Weighted Average Coupon    8%
        P    77.30    Interest Payment         Scheduled Payment        Estimated Period        First Year Cash Flow        The Beginning balacne for the second month is
            $ 11,730    I    $ 6,044    SP    $ 5,685    CPR    0.072    CF1    p+pp+I    B2 = B1-SP-PP    $ 895,393.52
                                SMM    0.0062076148        $ 23,367
                                PP    $ 5,592.98
Cash Flow 2
        13
        Par    $ 895,393.52
        Weighted Average Maturity    10    108    months
        Weighted Average Coupon    8%
        P    76.81    Interest Payment         Scheduled Payment        Estimated Period        Second Year Cash Flow        The Beginning balacne for the second month is
            $ 11,657    I    $ 5,969    SP    $ 5,688    CPR    0.078    CF2    p+pp+I    B2 = B1-SP-PP    $ 883,705.17
                                SMM    0.0067446566        $ 23,627
                                PP    $ 6,000.76
        14
        Par    $ 883,705.17
        Weighted Average Maturity    10    107    months
        Weighted Average Coupon    8%
        P    76.32    Interest Payment         Scheduled Payment        Estimated Period        Second Year Cash Flow        The Beginning balacne for the second month is
            $ 11,578    I    $ 5,891    SP    $ 5,687    CPR    0.084    CF2    p+pp+I    B2 = B1-SP-PP    $ 871,622.00
                                SMM    0.0072849116        $ 23,866
                                PP    $ 6,396.29
        15
        Par    $ 871,622.00
        Weighted Average Maturity    10    106    months
        Weighted Average Coupon    8%
        P    75.83    Interest Payment         Scheduled Payment        Estimated Period        Second Year Cash Flow        The Beginning balacne for the second month is
            $ 11,494    I    $ 5,811    SP    $ 5,683    CPR    0.09    CF2    p+pp+I    B2 = B1-SP-PP    $ ...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here