Do My Homework / Homework Help Answers / Finance Homework Help / I need help solving part a and b in excel

I need help solving part a and b in excel

Need help with this question or any other Finance assignment help task?

You are given the following data on 8/24/2015 settlement date: and the following data on 8/28/2015 settlement date: a) On 8/24/2015, open a repo position using the 8/31/2017 maturity bond and close the position on 8/28/2015. Compute the profit/loss on this transaction. b) On 8/24/2015, open a reverse repo position using the 8/15/2025 maturity bond and close the position on 8/28/2015. Compute the profit/loss on this transaction. Use an annual repo rate of 1.0% and an annual reverse repo rate of 1.5%. Explain why you made a profit/loss in each of the above transactions. Also, make sure to account for accrued interest in your calculations and choose the bid or ask price appropriately. If you are using the Excel function for accrued interest, make up an Issue Date as the coupon payment date just prior to the settlement date.
There are no answers to this question.
Login to buy an answer or post yours. You can also vote on other others

Get Help With a similar task to - I need help solving part a and b in excel

Popular Services
Tutlance Experts offer help in a wide range of topics. Here are some of our top services: