use excel and formulas please. thanks

Bond Y is a premium bond with a coupon rate of 8 percent. Bond Z is a discount bond with a coupon rate of 6.1 percent. Both bonds make annual payments and have a YTM of 7.1 percent, a par value of $1,000, and six years to maturity. Requirement 1: What is the current yield for Bond Y? For Bond Z? Requirement 2: If interest rates remain unchanged, what is the expected capital gains yield over the next year for Bond Y? For Bond Z? (Hint: find the value of the bond 1 year from today)