Files 10:28 AM Thu 2 Jul AIN Home In: Times New Roma 14 BI U fx Problem 6-12 Suppose a 10-year $1,000 bond with an 8 coupon rate and semiannual coupons is trading for $1.034.74 Complete the steps below wsing college to give data or pro calculate de come cases, asiple cell reference is all you need to copy paste formulacres erward www. an absolute cell reference aramed cell reference may be preferred is specific Excel function is to be used the directions will specify the use of that function. De net ape la crise date tuto a call ar funslow. Bestead, make a references se cell be which the dans la fund Make your companions only in the cell lighted below. In all cases, unless these directed use the earliest part of the date your las calles Dua What is the band's yield to maturity expressed as an APR with semanal compounding? b. If the band's yield te maturity changes to 9% APR what will the band's price be? Maturity (years) Face value Coupon rute 89 Bend price 1.034.74 What is the band's yield to maturity (expressed as an APR with emisnual compounding Coupon Number of pris Yield to maturity b. If the band's yield to maturity changes to APR what will the band's price he Yield to maturity Semiannual yield Bond price Requirements In cell DIS by using cell references, callate the payment of the band) In cell D16. by using cell references, calculate the number of periods until maturity 3 In cell D17. by using cell references, calculate the yield to maturity of the band (1) Note: Omit the (type) and guess) arguments in the RATE function In cell D23, by using cell references, calculate the semiannual yield so manarity of the bead (1 In cell D24. by using cell references, calculate the new price of the bond (pl.) Note: The cutput of the expression or function you typed in this cell is expected as a positivember