PLEASE SHOW ANSWER IN EXCEL WITH FORMULA THANKS

Question 1 - Calculate the price of the following bond with a par value of $1,000 that pays a 5.1% coupon semiannually. The bond was settled on Jan 1, 2002 and matures on Jan 1, 2014. The current yield is 4.6%. (5 points) Is the bond trading at a discount, a premium, or par? (5 points) Coupon Bond - Price Settlement date Maturity date Coupon rate Coupons per year Face value % of par) Yield to maturity Par value $ 1/1/02 1/1/14 5.10% 2 100% 4.60% 1,000.00 Bond Price $ 47.21 Trading