Start with the partial model in the file Ch$04$ P$24$ Build a Model.xIsx. A $15-$year, $6\%$ semiannual coupon bond with a par value of $$1,000$ may be called in $6$ years at a call price of $$1,020.$ The bond sells for $$1,110.($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 ro

und intermediate calculations.