b. The firm would now pay 13 percent on the bonds. With an 11 percent coupon rate,
the bond issue would bring in only $8,585,447.31:
However, the firm will make money on its futures contracts. The implied yield at the
time the futures contracts were entered is found by inputting N = 40; PMT = 3000;
Now, if interest rates increased by 200 basis points, to 8.399232%, the value of
However, the value of the short futures position began at $95,531.25(105) =
transaction costs.
Thus, the firm gained $1,951,497.45 on its futures position, but lost
c. In a perfect hedge, the gains on futures contracts exactly offset losses due to rising
interest rates. For a perfect hedge to exist, the underlying asset must be identical to
SOLUTION TO SPREADSHEET PROBLEM
23-6 The detailed solution for the spreadsheet problem, Ch23 P06 Build a Model
Solution.xls, is available on the textbook’s Web site.