please solve in excel with formulas showed please

1) A semi-annual coupon paying bond with 6 years remaining until maturity is currently trading at an effective annual yield (EAY) of 7%. The bond promises to pay the annual coupon rate of 7%. What will be the price of the bond? Assume that the bond's face value is $1,000. Group of answer choices 1,007.19 1,005.74 1,000.00 1,054.23 2) A bond with 20 years remaining until maturity is currently trading for 111 per 100 of face value. The bond offers a 5% coupon rate with interest paid semi-annually. The bond's annual yield-to-maturity is: Group of answer choices 3.840% 4.183% 4.178% 4.157%