Start with the partial model in the file Ch$04$ P$24$ Build a Model.xIsx. A $25-$

year, $6\%$ semiannual coupon bond with a par value of $$1,000$ may be called

in $5$ years at a call price of $$1,010.$ The bond sells for $$1,060.($Assume that

the bond has just been issued.$)$

The data has been collected in the Microsoft Excel file below. Download the

spreadsheet and perform the required analysis to answer the questions

below. Do not round intermediate calculations.e$.$ Assume that the bond will be called if and only if the going rate of interest falls below the coupon rate.

Conducting a sensitivity analysis of price to changes in the going market interest rate for the bond