Question

In: Finance

Calculate the following items for a newly issued, $400 million outstanding balance mortgage pool that is...

Calculate the following items for a newly issued, $400 million outstanding balance mortgage pool that is comprised of 30-year mortgages. The pass-through rate is 7.5% and the WAC is 8.125%. Prepayment speed is 100 PSA.

a. Find the SMM for Month 1:

b. What is the scheduled monthly mortgage payment for Month 1 paid by homeowners? (hint: use your calculator's TVM buttons)

c. What is the interest payment to the MBS pass-through holders (overall) for Month 1?

d. What is the estimated principal prepayment for Month 1?

Solutions

Expert Solution

a. SMM = 1 - ((1-CPR)^(1/12))

CPR for PSA of 100 and 30 year mortgages is assumed to be 6%*30/30 or 6%. Hence SMM = 1 - ((1-0.06)^(1/12))

= 0.00514 or 0.514%

b. Scheduled monthly mortgage payment for Month 1 paid by homeowners is the total of Interest + Principal calculated on the mortgage amount of $400M and at the rate of WAC of 8.125%. Total payments can be calculated by using the excel formula of PMT, which is $2,969,988.72.

c. Interest payment to MBS holders (overall and without prepayment) is calculated using the pass through rate only:

7.5%/12*400,000,000 = $2,500,000.

d. Estimated Principal prepayment for Month 1 is SMM * (Total outstanding mortgage - Scheduled Principal payment for Month 1)

Scheduled Payment for the first month = $2,969,988.72, Principal payment for Month 1 = $261,655.39 (which can be derived using formula PPMT in excel). Hence Total amount available for Prepayment = Total bal - First Principal payment

or $400M - $0.261M = $399,738,344.61

Estimated Principal prepayment for Month 1 = 0.514% * $399,738,344.61 = $2,054,655.09


Related Solutions

Consider a mortgage pool with principal of $20 million. The maturity is 30 years a monthly...
Consider a mortgage pool with principal of $20 million. The maturity is 30 years a monthly mortgage payments and the interest rate of 10 per cent per annum. (Assume no prepayments). What is the monthly mortgage payment (100 per cent amortising) on the pool of mortgage? A.$193,004.33   B.$182,236.25   C.$175,514.31   D.$176,798.75 If the mortgage-backed security insurance fee is 60 basis points and servicing fee is 40 basis points, what is the monthly payment on the pass-through security issued from this pool...
Consider a GNMA mortgage pool with principal of $20 million. The maturity is 30 years with...
Consider a GNMA mortgage pool with principal of $20 million. The maturity is 30 years with a monthly mortgage payment of 10 percent per year. Assume no prepayments. (LG 24-4) A) What is the monthly mortgage payment (100 percent amortizing) on the pool of mortgages? B) If the GNMA insurance fee is 6 basis points and the servicing fee is 44 basis points, what is the yield on the GNMA pass-through? C) What is the monthly payment on the GNMA...
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...
25-5 Consider a GNMA mortgage pool with principal of $11 million. The maturity is 15 years...
25-5 Consider a GNMA mortgage pool with principal of $11 million. The maturity is 15 years with a monthly mortgage payment of 10 percent per year. Assume no prepayments. a. What is the monthly mortgage payment (100 percent amortizing) on the pool of mortgages? (Do not round intermediate calculations. Round your answer to 2 decimal places. (e.g., 32.16))   Monthly mortgage payment $    b. If the GNMA insurance fee is 4 basis points and the servicing fee is 46 basis points,...
When is it possible to fund a million dollar balance in a newly established IRA?
When is it possible to fund a million dollar balance in a newly established IRA?
Hansen Corporation's balance sheet reported the following:             Common stock issued and outstanding - 10,000...
Hansen Corporation's balance sheet reported the following:             Common stock issued and outstanding - 10,000 shares $80,000          Paid-in capital in excess of par – common stock                                                     120,000          Retained earnings                                                                                                      300,000 Prepare the journal entry for the following transactions that occurred this year: (a)   Purchased 200 shares of capital stock to be held as treasury stock, paying $75 per share. (b)   Sold 80 of the shares of treasury stock at $80 per share. (c)   Sold 70 shares of...
Calculate the mortgage balance 25 days after the 45th payment on a mortgage loan of $200,000,...
Calculate the mortgage balance 25 days after the 45th payment on a mortgage loan of $200,000, amortised over 15 years at an interest rate of 5.75%.
Given the following information of the mortgage pool that backs a MPT, what is the regular...
Given the following information of the mortgage pool that backs a MPT, what is the regular scheduled payment in month 1 of the security? Use WAC as the mortgage rate and WAM as the number of periods for your calculations. Round your final answer to two decimals. (Answer is NOT 1231650.17) • 30 year FRM, fully amortizing, monthly payments • Loans seasoned for 3 months before entering pool • WAM: 357 • WAC: 4% • Servicer/Guarantee fee: 0.55% • Starting...
Amarindo, Inc.​ (AMR), is a newly public firm with 10.5 million shares outstanding. You are doing...
Amarindo, Inc.​ (AMR), is a newly public firm with 10.5 million shares outstanding. You are doing a valuation analysis of AMR. You estimate its free cash flow in the coming year to be​ $14.84 million, and you expect the​ firm's free cash flows to grow by 4.1​% per year in subsequent years. Because the firm has only been listed on the stock exchange for a short​ time, you do not have an accurate assessment of​ AMR's equity beta.​ However, you...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT