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

Once you have done that, you use Excel to do the case and compare the results. Problem. A 10 year, 12 percent semiannual coupon bond with a par value of $1000 may be called in 4 years at a call price of $1060. The bond sells for $1,100 (assume the bond has just been issued) What is the bond’s yield to maturity. What is the bond’s current yield ................
................