What is the npv of each tranche

Reference no: EM133633093

Longer exercise 1: CMO Excel spreadsheet

[For this question either create own spreadsheet or use the one provided in Session 4 (Z-class cash flow model)].

Consider an agency CMO with the following characteristics:

Mortgage pool

The mortgage collateral consists of $275 million of 30 year FRMs with a weighted average coupon of 4.2%. Assume that prepayment on the pool is consistent with a 150 PSA assumption. The servicing and guarantee fee on this pool is 70 basis points. Mortgage payments are monthly, as usual.

CMO structure

The pool consists of three classes, an A class of $100m, a B class of $125m, and a Z class of $50m. All three classes pay a 3.5% net coupon rate. The B class is further split into an IO tranche and a PO tranche. (Thus, there are four securities, an A class security, a B class IO security, a B class PO security, and a Z bond).

Given this information, answer the following questions:

Question 1. Build a spreadsheet that builds out the total cashflows generated by this pool over its life. Your spreadsheet should show the cashflows that accrue to investors, and the cashflows paid as servicing and guarantee fees.

Question 2. Based on the structure shown above, calculate how the cashflows of the pool are split between the different types of securities (similar to the Excel spreadsheet example posted on Brightspace Classes). [Hint: To make sure you haven't made any calculation errors, make sure that the principal payments to each of the securities adds up to the total principal (i.e. scheduled principal + prepayment) generated by the underlying mortgage collateral. The same should be true of the interest payments. i.e. everything should add up].

Question 3. Assume that the relevant discount rate for valuing these cashflows is 3.25%. What is the NPV of each tranche? [Hint: As above, if you wanted to check, the NPV of each tranche, plus the NPV of the servicing and guarantee fees, should add up to the NPV of the cash flows from the underlying mortgages].

Question 4. Change the prepayment assumption to 250 PSA. What happens to the NPV of each tranche (including the NPV of the servicing and guarantee fee strip)? Explain why the NPV of each tranche changes as it does.

Reference no: EM133633093

Questions Cloud

Complaints of increased confusion and lethargy : An 84-year-old female is brought in by family with complaints of increased confusion and lethargy.

How would a one-time dividend affect the value : How would a one-time dividend affect the value of amazon stock if it were announced today? A one-time dividend would not affect the stock price A one-time

Improve the patient experience : In the case study demonstrating an early use of the Triple Aim initiative, it outlined creative strategies that might improve the patient experience.

Should you replace the old machine with the new machine : Should you replace the old machine with the new machine? The WACC for both machines is 10% ?and the firm's tax rate is 40%

What is the npv of each tranche : What is the NPV of each tranche? [Hint: As above, if you wanted to check, the NPV of each tranche, plus the NPV of the servicing and guarantee fees

Evidence to improve nursing practice continues : Evidence to improve nursing practice continues to grow in the 21st century. After you select one 21st-century nurse or healthcare event

Discuss the descriptions of transnational model described : Compare the descriptions of the transnational model described in Chapter 6 to the elements of the learning organization described in Chapter 1.

Difference between direct and indirect religious experiences : What's the difference between direct and indirect religious experiences? (Give an example to clarify.)

What would the total debt to total assets ratios : If you owned stock in Just Running what would the total debt to total assets ratios for this year 0.26 and last year 0.25 tell you about the company's leverage

User Account

All Pages