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. Use market data taken from the cmegroup.com, WSJ and$/$or WSJ online that reflects closing prices from Tuesday, May $14.$

$3.$ Hedging the Risk in a Bond Flotation Assume you are assisting the CFO of your firm in planning an upcoming debt financing. Your firm, which is of medium grade quality, anticipates raising $$15,000,000$ in funds through the issuance of fixed rate notes. The notes will have a $10-$year maturity, will be priced at par, and you anticipate that the notes will have an initial yield set at $150$ basis points over the yield of a treasury instrument having the same maturity as of the time of issuance. $($Because of this you can use the implied futures rate on the appropriate $10-$year T$-$Note futures as a benchmark for this expected treasury yield.$)$ The anticipated issuance date of the notes is around the upcoming September $2024$ time frame. Due to the current uncertainty in markets, you have decided it may be prudent to hedge the interest rate risk associated with this debt financing. To not do so could leave you with a funds shortfall if interest rates were to unexpectantly change.

A$.$ If you were not to hedge, what is the economic impact of rates unexpectantly rising $100$ basis points? In other words, compute the total present value cost to the firm of a $100$ basis point increase in rates $($use an exact method as shown in class using present value techniques rather than the approximate modified duration method that we have also discussed$).$

B$.$ Describe how you would hedge the risk in this situation with futures contracts $($e$.$g$.,$ which contract and maturity, how many futures, long or short$).$