Answer:
Coupon rate is 5.70%
Step-by-step explanation:
The coupon rate the company should set if it wants to sell the bond at par should be the coupon rate equal to yield to maturity,hence by by calculating the yield to maturity ,we have indirectly calculated the coupon rate on the bond.
The formula for yield to maturity is given by :=rate(nper,pmt,-pv,fv)
the nper is the time to maturity of 15 years multiplied by 2 since it a semi-annual interest paying bond
pmt is the semi-annual coupon interest which:6%/2*$1000=$30
pv is the current market price of the bond which is $1030
fv is the value of the bond at redemption which is $1000
=rate(30,30,-1030,1000)
rate=2.85%
Annual rate=2.85%*2
=5.70%