Hedging Excel Online Structured Activity: Hedging biotech company is 13%. However, the firm's financial manager is concerned that interest rates will climb even higher in coming months. The following data are available: Futures Prices: Treasury Bonds - $100,000; Pts. 32 nds of 100% The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet a. Use the given data to create a hedge against rising interest rates. Do not round intermediate calculations. Round your answer to the nearest whole number. The firm must sell contract(s) to cover the planned $10,000,000 June bond issue. sign. Use the rounded number of contracts in your calculations. Do not round other intermediate calculations. Round your answer to the nearest dollar. On net, the firm gained (lost) \$ c. Choose the correct description of the perfect hedge? Are any real-world hedges perfect? Hedging Excel Online Structured Activity: Hedging biotech company is 13%. However, the firm's financial manager is concerned that interest rates will climb even higher in coming months. The following data are available: Futures Prices: Treasury Bonds - $100,000; Pts. 32 nds of 100% The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet a. Use the given data to create a hedge against rising interest rates. Do not round intermediate calculations. Round your answer to the nearest whole number. The firm must sell contract(s) to cover the planned $10,000,000 June bond issue. sign. Use the rounded number of contracts in your calculations. Do not round other intermediate calculations. Round your answer to the nearest dollar. On net, the firm gained (lost) \$ c. Choose the correct description of the perfect hedge? Are any real-world hedges perfect