6-17. The State Pension System wants to sell a 20-year original maturity General Industries' bond that it purchased 10 years ago. The bond pays interest twice each year. The par value of the bond is $100 million. The coupon rate is 8.6 percent. If the current market interest rate is 4.5 percent and there are exactly 10 years left until maturity, how much will the pension plan be paid for the bond? (Be sure to show all your work, including the factors you used to determine the value of the bond.) Input Par value of Bond Coupon Rate Interest Payments per year Rate per coupon = coupon rate/#payments per year Years to maturity Periods to maturity = years * # payments per year Market Rate at time of offering Market Rate per coupon = coupon rate / #payments per year #DIV/0! 0 #DIV/0! #DIV/0! 1. Coupon = par value * coupon rate / #payments per year =pv(rate,nper,pmt,fv,type) 2-b Bond value at market rate #DIV/0