Please show how to solve in simplest way with work, if needed excel is acceptable:

What is the yield-to-maturity of a 4.0% semi-annual coupon with a $1,000 par value, which matures in 7 years? Assume the current market price of the bond is $927.56 a.) 5.52% b.) 2.55% c.) 5.25% d.) 2.25% e.) 0.52%