Question: I need help constructing a spreadsheet to answer the question below with step by step instructions, and explanations of what s being done, and why.

I need help constructing a spreadsheet to answer the question below with step by step instructions, and explanations of whats being done, and why. Use market data taken from the cmegroup, WSJ and/or WSJ online that reflects closing prices from Tuesday, May 14.(Please be sure to show ALL CELLS in your solution. Someone keeps posting similar solutions that reference column J, but J isnt included in the screenshot )
4. Active Bond Portfolio Management Using Futures You are a fixed income fund manager running a $100 million portfolio of a large pension client. According to your client agreement, you are performance benchmarked against the return on the S&P U.S. Aggregate Bond Index. Your portfolio modified duration currently matches that of the Index, which you should assume is a modified duration of 5.53 years. Importantly, your client agreement provides you the discretion to actively vary your modified duration from 80 to 120% of that of the benchmark. Your forecast of market interest rates reveals an imminent decline in rates within the upcoming 3-4 months or so. To position your portfolio according to your view, you have decided to rebalance, but you do not have time to identify individual issues for purchase or sale nor do you wish to incur the liquidity costs of trading private placement holdings within your portfolio. Instead, you have decided to trade the appropriate September 5-year T-note futures contract. Describe specifically what action you should take (e.g., number of contracts, contract maturity, long or short).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!