MUST BE ANSWERED USING EXCEL!!! I will happily up vote if the answer is detailed and ONLY IF IT IS DONE USING EXCEL!!!! Please explain if possible.

2. The 7.9%, ten-year bond yields 5.9%. If this yield to maturity remains unchanged, what will be its price one year hence? Assume annual coupon payments and a face value of $1,000. What is the total return to an investor who held the bond over this year