Q7 Please show all work or excel functions. Thanks!

Bonds of Z Corp with a par value of $1000 sell for $960, mature in five years and have a 7% annual coupon rate paid semi-annually Calculate the: a current yield b yield to maturity horizon yield [realized compound return] for an investor with a three year holding period and a reinvestment rate of 6% over the period. At the end of three years, the 7% coupon bonds will sell to yield 7%