Project Assignment: Fixed Income
Mechanics
1. Create a dollar roll calculator in Excel (use the Dollar Roll Template spreadsheet pro¬vided). You will use the input assumptions from the roll analysis screen shot emailed to you. Note: You will need to reduce the WAM by 1 month if factor date is 10/19 and by 2 months if factor date is 11/19 (find this in the Remaining Term cell). If your calculations are correct, you will agree with your Bloomberg screen to the penny! What is the Dollar Advantage, and is it for the mortgage roll or continued holding?
Understanding Dollar Roll Valuation
2. Now add 0-03 to the drop you used above on the assumption that the roll is hot. What is the dollar advantage on $100 million of MBS?
3. Assume you decide to roll $100 million of your MBS, how much do you receive at the beginning of the roll?
4. How much interest do you earn during the roll period?
5. How much do you pay to buy back the MBS at the end of the roll?
6. Now suppose you immediately sell the MBS on the forward settlement date (i.e., the later date listed) for a price that is 0-04 higher than the price you received at the beginning of the roll (i.e., IMM. Price).
(a) What is the total return in dollars?
(b) What is the cost basis for this trade? (You need this to answer following question.)
(c) What is the annualized total return? Use 360/actual to annualize return.
(d) What is the annualized total return if you had decided to hold the $100 million MBS and then sell on that same date for 0-04 higher than the IMM. price?
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.
Attachment:- Dollar-Roll-Template.rar