answer in excel please

Remember our $1,000 par bond with a 10% annual-pay coupon and five years to maturity? Suppose that the yield on similar-risk bonds is 15%. The market price for this bond will be $832.39 (check for yourself). Suppose you bought the bond for $832.39 and held it for one year, and during that time the interest rate remained 15%. How did your investment perform