- Home >
- Project with Dollar Roll
Project with Dollar Roll
Question Description
Spring, 2018
Due: See below
I've attached the document that is used in conjunction with the project.
Project
[35pts total] Dollar Rolls. Should there be any missing input data/information use (and justify) any reasonable assumption.
(a) [20] 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 CF’s 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 it’s 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 120, 150, and 180, and forward drops of -40, -35, and -30 (32’s) for the inputs listed in the first paragraph (these, or course, will be fixed numbers).
Hand in your dollar roll for a forward drop of 35/32, a PSA of 150, and a reinvestment rate of 2% (though, of course, I should be able to change these and get the right dollar advantage).
(b) [5] Discuss the risks of roll vs. hold from the perspective of the investor.
(c) [10] Why does the dollar roll market exist? Explain this using all participants in both the primary and secondary markets, from the prospective mortgagor to the dealer and investor in the secondary market.
[1] If accompanied by an annotated pdf printout of your solutions (or a hard copy at the FRL Department by the same deadline).
[2] Make sure there are no links to external files remaining in your submission. No need to hide rows.
This question has not been answered.
Create a free account to get help with this and any other question!
Similar Content
The Scarlet Letter
by Nathaniel Hawthorne
Sounds Like Titanic
by Jessica Chiccehito Hindman
The Splendid and The Vile
by Erik Larson
The Underground Railroad
by Colson Whitehead
Underground A Human History of the Worlds Beneath our Feet
by Will Hunt
The Da Vinci Code
by Dan Brown
Oliver Twist
by Charles Dickens
Into Thin Air
by Jon Krakauer
How to Win Friends and Influence People
by Dale Carnegie
Studypool values your privacy. Only questions posted as Public are visible on our website.
Brown University
1271 Tutors
California Institute of Technology
2131 Tutors
Carnegie Mellon University
982 Tutors
Columbia University
1256 Tutors
Dartmouth University
2113 Tutors
Emory University
2279 Tutors
Harvard University
599 Tutors
Massachusetts Institute of Technology
2319 Tutors
New York University
1645 Tutors
Notre Dam University
1911 Tutors
Oklahoma University
2122 Tutors
Pennsylvania State University
932 Tutors
Princeton University
1211 Tutors
Stanford University
983 Tutors
University of California
1282 Tutors
Oxford University
123 Tutors
Yale University
2325 Tutors