First, you have to do problem 4-9 using a financial calculator

Now, go back to the excel case and answer all the questions. Problem a. Because the bond is semiannual, so periods to maturity has to equal number of years to maturity times periods per year. Similarly to periods till callable. You have to calculate the yield to maturity (YTM). To do that, use the rate function in Excel ................
................