The Aleander Company plans to issue $10,000,000 of 10-year bonds at par next June, with semiannual interest payments. The company's current cost of debt is 10 percent. However, the firm's financial manager is concerned that interest rates will increase in coming months, and has decided to take a short position in U. S. government t-bond futures. See the settlement data below for t-bond futures. (Note: One standard futures contract is $100,000) Please complete solution in excel.

Question 4. (20 points) The Aleander Company plans to issue $10,000,000 of 10-year bonds at par next June, with semiannual interest payments. The company's current cost of debt is 10 percent. However, the firm's financial manager is concerned that interest rates will increase in coming months, and has decided to take a short position in U. S. government t-bond futures. See the settlement data below for t-bond futures. (Note: One standard futures contract is $100,000) Delivery Month (1) Dec Mar June Open (2) 103'14 102'11 101'14 High (3) 103'14 102'23 101'26 Low (4) 102'11 100'28 100'02 Settle (5) 102'17 101'01 100'12 Change (6) -6 -5 -5 Open Interest (7) 678,000 135,855 17,255 a. Calculate the present value of the corporate bonds if rates increase by 2 percentage points. b. Calculate the gain or loss on the corporate bond position. c. Calculate the number of contracts required to cover the bond position. Then calculate the current value of the futures position. d. Calculate the implied interest rate based on the current value of the futures position. e. Interest rates increase as expected, by 2 percentage points. Calculate the present value of the futures position based on the rate calculated above plus the 2 points. f. Calculate the gain or loss on the futures position. g. Calculate the overall net gain or loss. h. Is this problem an example of a perfect hedge or a cross hedge? Is it an example of speculation or hedging? Why