Question Details

Answered: - Dear Dr Fids, Can you please help these questions? It is a


Dear Dr Fids,

Can you please help these questions? It is about MBS cash flow.?


R

 

Generating MBS cash flows can be messy so we are going to write some

 

functions in R that

 

allows us to generate the cash flows to structure and price the asset.

 

1. Using the MBScf function, generate cash flows for the following pool

 

Balance = 25,000,000

 

- WAC = 4.5%

 

- WAM = 355

 

- WALA (Age) = 5

 

- Net = 4%

 

Assuming the following prepayment speeds: 100% PSA, 300% PSA, 500% PSA

 

and 900% PSA.

 

What is the average life of the pool for each speed?

 

Excel sheet

 

2. Consider a pool with a $75,000,000 balance, a WAC of 3.45% and a WAM of

 

325.

 

(a) What is the scheduled balance the next month?

 

(b) Suppose the actual balance next month is 741,250,000, what is the CPR?

 

(c) If the loan is 28 months old, what is the PSA?

 

Excel sheet

 

3. Suppose you purchase a Fannie Mae 30 YR 3.5% MBS (3.5% net coupon) with

 

a $75,000,000

 

balance on March 17. The current WALA = 10, WAM = 350, and WAC = 4.15%

 

(a) What is the accrued interest?

 

(b) The MBS is priced as 135 bps off the 10-year Treasury at 275 PSA. What is the

 

yield you will use to price the MBS if the 10-year is currently yielding 1.86%?

 

(c) Using the yield from (b), what is the price of the MBS taking the actual delay

 

into account? (See slide 5-33, round price to nearest 1/4 tick)

 

(d) What is the invoice amount paid for the purchase of the bond?

 


 

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 18, 2020

PRICE: $15

Solution~0001185025.zip (25.37 KB)

Buy this answer for only: $15

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 18, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.

Order Now