I just want the process to put on an excel sheet.

The correct answers are as follows: a) 101.86. b) 7.958%. c) 9.01%. d) 8.01%

Please include an image of the process in an excel spreadsheet and also an image showing the formulas used for each cell.

The yield to maturity on 1-year zero-coupon bonds is currently 7%; the YTM on 2 -year zeros is 8%. The government of Canada plans to issue a 2-year maturity coupon bond, paying coupons once per year with a coupon rate of 9%. The face value of the bond is $100. a) At what price will the bond sell? b) What will the yield to maturity on the bond be? c) If the expectations hypothesis for the yield curve is valid, what is the market expectation of the price that the bond will sell for next year? d) Recalculate your answer to c ) assuming now that there is a liquidity premium of 1%