Schlitz Brewery Inc. bonds are trading today for a price of $961.29. The bond currently has 10 years until maturity and has a yield to maturity of 5%. The bond pays annual coupons and the next coupon is due in one year. What is the coupon rate of the bond?

Please show the spread sheet function work or the financial calculator steps ? how did you get the FV as $1000 on the solution posted before?