Answer:
6.71%
Explanation:
Nper = 10
PMT = ($1000*8%) = 80
PV = -1,091.96
FV = 1000
Coupon rate for new bond issue = Rate(Nper, PMT, -PV, FV)
Coupon rate for new bond issue = Rate(10, 80, -1091.96, 1000)
Coupon rate for new bond issue = 0.067082953
Coupon rate for new bond issue = 6.71%