Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. create a dollar roll matrix of breakeven rates for

Create a dollar roll matrix of breakeven rates for an agency MBS with gross and...

50.1K

Verified Solution

Question

Accounting

Create a dollar roll matrix of breakeven rates for an agency MBS with gross and deal coupons of 8.035% and 7.5%, respectively, and settlement dates 6/14/18 and 8/15/18. Assume standard fully amortizing fixed rate mortgages with a term of 30:0, a WAM of 29:5 and an immediate price of 96-16. MBS CFs are due the owner of record on the first of each month, but are paid on the 25th of that month. Assume standard PSA benchmarks.

The spreadsheet should correctly calculate the dollar advantage for any input above (though only for a two-month roll - not 1, or 3 or more). I do suggest you try to recreate the 1 month dollar roll in the lecture pdfs first, to get a feel for how its done (and you can submit this test run on a separate worksheet along with your 2-month answer for partial credit if warranted). Do not hardcode inputs in formulae, e.g., rates/coupons, dates, terms or WAMs, prices, reinvestment rates (though you can stick to act/360), balances, PSA, etc.

Calculate the breakeven matrix for PSAs of 100, 150, and 1200, and forward drops of -40, -35, and -30 (32s) for the inputs listed in the first paragraph (these, or course, will be fixed numbers).

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students