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

You have to calculate the yield to maturity (YTM). To do that, use the rate function in Excel. Either you click on function icon in Tool Bar or go to Insert in the top bar, choose function. The function box will come up, choose Financial in Function Category and choose RATE in function name. RATE function has the following form. RATE(Nper, pmt ... ................
................