Pembroke Co. wants to issue new 17-year bonds for some much-needed expansion projects. The company currently has 10 percent coupon bonds on the market that sell for $1,050, make semiannual payments, and mature in 17 years. What coupon rate should the company set on its new bonds if it wants them to sell at par?

I would like to be able to see the work and understand it. Maybe an excel formula????