Question

In: Finance

Consider the mortgage pool data below for a Mortgage Backed Security (MBS). Beginning balance $800,000,000 WAC...

Consider the mortgage pool data below for a Mortgage Backed Security (MBS). Beginning balance $800,000,000 WAC 5.750% WAM 354 Passthrough rate 5.250% PSA schedule 150% Please answer the questions below about the first scheduled payment to the investors of this MBS. SHOW YOUR WORK Dollar amounts may be rounded to the nearest dollar. (a) What is the CPR for this payment? (b) What is the SMM for this payment? (c) For this payment, what is the amount of the total scheduled mortgage payment, the gross interest paid with that payment, and the scheduled principal repaid with that payment? (You can use your BA II Plus to calculate this data. Show what you would enter into your calculator to obtain this data.) (d) What is the net interest payment available to the MBS investors after servicing fees have been paid? (e) What is the forecasted prepayment amount based on the SMM calculated in (b) above? (f) What will be the total principal repayment to the MBS investors in the first payment? (g) What will be the total payment made to the MBS investors?

Solutions

Expert Solution

100 PSA assumes following graduated CPR for a 30 years Mortgage:

- CPR= 0.2%, for the first month of origination. It gradually increases each month 0.2% till 30 month. Hence, on 20th month, CPR would be (0.2%)* 20 = 4%

- CPR : 6% from 30th month till 360th month

(a). WAM : 354. Hence, 6 months have elapsed. The CPR would be 6*(0.2%) = 1.2% (Answer)

(b) SMM would be = 1- (1-CPR)^(1/12) = 1- (1-0.012)^(1/12) = 1- 0.9989 = 0.001 (Answer)

(c) Following values are entered into the financial calculator (Assuming yearly coupon payment)

PV= -800,000,000 ; FV= 0; I/Y= (5.75/12)%= 0.4791%, N=30*12= 360, monthly PMT=4,668,582 (approx)

So, in the 6 months, total scheduled mortgage payments are = 6*4,668,582 = 28,011,497 (approx) (Answer)

Net interest payment in 6 months = (5.75/2)% * 800,000,000 = 23,000,000 (Answer)

Net Principal payment in 6 months = 28,011,497- 23,000,000 = 5,011,497. This excludes the principal prepayment, which will be done based on CPR.

Prepayment for 6 months = 800000000 * (1+2+3+4+5+6) * (1.2%)/12 = 16,800,000

Hence, total principal payment = 5,011,497 + 16,800,000 =21,811,497 (Answer)

(d) Net interest payment available to MBS investors after paying the servicing fee = (5.25% / 2) * 800,000,000 = 21,000,000 (Answer)

(e) Forecasted prepayment in first 6 months = 16,800,000 (as calculated in answer C) (Answer)

(f) First interest payment= (5.75/12)% * 800000000 = 3833333

total payment (monthly) = 4,668,582 (as calculated before)

hence, principal paid = 835248 (Answer)


Related Solutions

Explain what it is a mortgage backed security (MBS) and how it is functions. Discuss how...
Explain what it is a mortgage backed security (MBS) and how it is functions. Discuss how these securities caused 2008 USA financial crisis?
Introduction to Mortgage Mathematics and Mortgage-Backed Securities 2 (Mortgage Pass-Throughs) Consider a $400 million pass-through MBS...
Introduction to Mortgage Mathematics and Mortgage-Backed Securities 2 (Mortgage Pass-Throughs) Consider a $400 million pass-through MBS that has just been created (so the 'seasoning' of the pass-through is equal to 0). The underlying pool of mortgages each has a maturity of 20 years and an annual mortgage coupon rate of 6%. The pass-through rate of the mortgage pool is 5%. Assuming a prepayment multiplier of 100 PSA what is the total amount of interest paid to the pass-through investors? Submission...
Introduction to Mortgage Mathematics and Mortgage-Backed Securities 2 (Mortgage Pass-Throughs) Consider a $400 million pass-through MBS...
Introduction to Mortgage Mathematics and Mortgage-Backed Securities 2 (Mortgage Pass-Throughs) Consider a $400 million pass-through MBS that has just been created (so the 'seasoning' of the pass-through is equal to 0). The underlying pool of mortgages each has a maturity of 20 years and an annual mortgage coupon rate of 6%. The pass-through rate of the mortgage pool is 5%. Assuming a prepayment multiplier of 100 PSA what is the total amount of interest paid to the pass-through investors? Submission...
Consider the GFC of 2008 a/ Why were mortgage backed securities (MBS) considered toxic. Explain your...
Consider the GFC of 2008 a/ Why were mortgage backed securities (MBS) considered toxic. Explain your working and answer in words. b/ What caused MBS to rapidly lose value? Explain your working and answer in words.
Prior to the Financial Crisis, rating agencies mistakenly rated Mortgage Backed Securities (MBS) too high because:...
Prior to the Financial Crisis, rating agencies mistakenly rated Mortgage Backed Securities (MBS) too high because: Historically, mortgages have very low default rates. The payments on the MBS’s were “insured” by credit default swaps. The agencies didn’t account for the increase in sub-prime mortgages. All of the above. Fund from operations (FFO) of Pay Handle Ltd. Increased in 2011. In 2011 the total debt of the company remained unchanged, while additional common shares were issued. Pay Handle Ltd.’s ability to...
What is a mortgage-backed security, how it functions, and how it contributed to the financial crisis...
What is a mortgage-backed security, how it functions, and how it contributed to the financial crisis of 2007 & 2009. (1000 words)
BRIEFLY explain the process by which a standard mortgage backed security is created and sold by...
BRIEFLY explain the process by which a standard mortgage backed security is created and sold by connecting in order the following groups: big Wall Street banks, homeowners, institutional investors, ratings agencies, and mortgage originators.Briefly explain the process by which a standard mortgage backed security is created and sold by connecting in order the following groups: big Wall Street banks, homeowners, institutional investors, ratings agencies, and mortgage originators.
1:Why is the duration of a mortgage-backed security not well-represented by the maturity date of the...
1:Why is the duration of a mortgage-backed security not well-represented by the maturity date of the security?
what is the difference between a Mortgage Backed Security and a Collateralized Debt Obligation? Explain with...
what is the difference between a Mortgage Backed Security and a Collateralized Debt Obligation? Explain with reference to the source of the funds from which investors will be repaid.
IV. Securities   Pass-through mortgage securities Mortgage-backed bonds Collateralized mortgage obligations (CMO) 1. Which security above is...
IV. Securities   Pass-through mortgage securities Mortgage-backed bonds Collateralized mortgage obligations (CMO) 1. Which security above is established where principal and interest payments flow to the owner of the security? 2. Which security above may have a varying exposure to defaults? 3. Which security above is secured by the mortgages? 4. Three tranches of a CMO are established. Tranche A will receive all payments until the monthly coupon payment is satisfied. Tranche B will receive payments ONLY after Tranche A’s coupon...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT