can you please solve the question in excel

Currently the yield curve (the term structure) is flat. The current yield to maturity on Government of Canada bonds is 5%. You expect the yield to maturity to drop by 1% tomorrow. Therefore tomorrow the yield to maturity will be 4%. Which one of the following Government of Canada bonds will you purchase today? x20 year, regular bond, coupon rate of 5% and coupons paid annually 30 year, zero coupon bond 20 year, zero coupon bond 30 year, regular bond, coupon rate of 5% and coupons paid annually