Why does the total market value of the deal exceed the initial pool balance

(f)I very strongly prefer excel, but other formats are permissible if accompanied by a pdf printout of your solutions (or a hard copy at the RE department by the same deadline). Note that I am not currently set up to open any spreadsheet but excel. Also: the more you explain what you do, the likelier you’ll get more partial credit. I’m unlikely to spend too much time trying to figure out where you went wrong. You do not need to annotate cells (since I will be looking at them), but pay attention to the logical structure and presentation of the worksheets. SEND ONLY ONE FILE (e.g. excel) that includes your answers to the questions (use textbox, for example; do not send say an additional file (e.g., Word) with the written answers).

(g) Work with members of your own group only.You may use any source you find useful, except the help of another person outside your group. The latter constitutes “cheating,” and will very likely result, at a minimum, in an F for the class. In particular, do not try to abuse my typing finger by requesting answers to “non-clarifying questions” by email. I will be arranging extra office hours for the exams week.

Final Project [30 points total]

A. [20 points total] Consider the second last (12.7+ million) and last (76.7+ million) “mortgage loans” in loan group 1 in the Countrywide Alternative Trust 2005-J7 (p S-69).

1. Amortize both loans with a 100% PPC assumption as given on p. S-70, and a 100% SDA (this is now the base PP/D assumption; leave the factors open to change).[1] To simplify, assume that any default is realized instantaneously and that there is no recovery.[2] Also make the standard assumption that default happens before mortgage payment, prepayment after.

2. Create a WAC IO and PO tranche to give a 5.75% deal coupon. Assume that these two classes are paid first (before subs and seniors – see below). The WAC PO gets the aggregate (initial PO%) × (total principal cash flow), the WAC IO the aggregate excess interest on outstanding, current premium loan balance.[3]

3. With the remaining assets, create a senior/sub structure with 5% subordination, and a shifting interest structure as given on p S-61, under “shift percentage.” Take a percentage of, for example, 60% to mean that the sub receives only 60% of its prorated prepay principal (provided the sub still exists). The sub will be a single class (called “B”) that absorbs all realized losses first. Once the sub is exhausted, all seniors (see below) are allocated losses on a prorated basis. Assume interest is paid to the aggregate senior classes at 5.75% and any remaining interest is distributed to the sub.

4.Use the senior class to create a sequential pay structure of two classes, with principal A1:A2 :: 3:1. Prorate potential senior losses to A1 and A2 based on pre-default principal; assign each class its interest payment prorated on post-default beginning balance.

5. Assume all classes sold under the base PP/D assumption at: A-1: 102:01; A-2: 99:20; B: 75:04; IO: 0:20 (notional); PO: 81:31.The notation “:nn” means “nn/32nds.”

6. Assume a Treasury term structure given by

z(T) = 0.03 × ln[0.038 × (T+40)]

where T is measured in months.

7.Make reasonable assumptions for any missing information, and justify them. Take care that you may only think the information to be missing.

B. [10 points total] Answer the following questions (on a separate worksheet within your workbook)

  1. [2]      What is the initial principal and cash flow yield for each class? Compare      the total price of the tranches to the principal value. Generally, why      does the total market value of the deal exceed the initial pool balance?
  2. [2]      Compute the WAL, modified duration, and convexity for each tranche at base      PPC/default. For simplicity, assume that a small Δy does not affect the effective prepayment speed.
  3. [2]      Compute the nominal- and Z-spread for each tranche. Does a positive spread      automatically mean that the tranche is a better investment than a      Treasury?
  4. [2]      Keeping the SDA fixed at its baseline value, plot the WAL of each      principal-paying tranche vs the PPC (in the range 0 to 300%).
  5. [2]      Plot the cash flow yield of each tranche vs the SDA percentage, in the      range 0 to 800%, for a PPC of 100%.

[1]Note that these loans are Alt-A, and their default behavior is different from prime mortgages. Nonetheless, we use SDA to simplify the discussion.

[2] A gross simplification.

[3]This means that the IO and PO trance are effectively sharing in losses with trance B (see next), which is uncommon. More typically they are senior tranches.

Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.

Use the order calculator below and get ordering with idealtermpapers.com now! Contact our live support team for any assistance or inquiry.

Type of paper Academic level Subject area
Number of pages Paper urgency Cost per page:
 Total:

Purchase Guarantee

Why ORDER at IdealTermPapers.com?

  • Educated and experienced writers.
  • Quality, Professionalism and experience.
  • Original Content writing.
  • Best customer support.
  • Affordable Pricing on orders.
  • Thorough research.
  • Ontime delivery of finished work.
  • 100% plagiarism free papers.

Reasonable Prices

  • To get the best quality papers isn’t cheap so don’t trust extremely low prices.
  • We can’t claim that we have unreasonably low prices because low prices equal to low quality.
  • Our prices are good and they balance with the quality of our work.
  • We have a Moneyback guarantee.

Original and Quality work

  • Our writers are professionals and they write your paper from scratch and we don’t encourage copy pasting.
  • All writers are assessed and they have to pass our standards for them to work with us.
  • Plagiarism is an offence and it’s never tolerated in our company.

Native Writers plus Researchers

  • Our writers are qualified and excellent and will guarantee the best performance in your order.
  • Our team has writers who have master's and PhD qualifications who can handle any assignment
  • We have the best standards in essay writing.

We have been in business for over 7 syears

  • We have always served our customers from all over the world and they have continued to order with us.
  • We value our customers since they have trusted us to do their assignments.
  • We are competent in our writing gained from experience over the years
  • Our company has 24/7 Live Support.

You will get

  •  Custom Admission Essay written by competent professional English writers.
  •  Free revisions according to our revision policy if required
  •  Paper format:  275 words per page, Times New Roman font and size 12, doublespaced text and1 inch margin
  •  On time delivery and direct order download
  •  Privacy guaranteed

We can help you:

  •  acquire a comprehensive professional presentation.
  •  get a unique and remarkable content as per your instructions.
  •  Get an additional portion that can be included to your existing presentation;
  •  turn your work in to an eyecatching presentation with well communicated ideas.
  •  improve your presentation to acquire the best professional standards.