i am trying to use excel to do these questions, but dont understand what i am typing in incorrectly.

You find the following Treasury bond quotes. To calculate the number of years until maturity, assume that it is currently May 2019 and the bond has a par value of $1,000. Maturity Mo/Yr Ask Yld Rate Bid Asked 103.5514 103.6396 Chg +3067 ?? May 27 2.409 104.5004 5.424 May 32 104.6461 +.4341 ?? 6.183 +.5457 May 42 ?? ?? 4.111 In the above table, find the Treasury bond that matures in May 2027. What is the coupon rate for this bond? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Answer is complete but not entirely correct. Coupon rate 30.44 % % a You find the following corporate bond quotes. To calculate the number of years until maturity, assume that it is currently January 15, 2019. The bonds have a par value of $2,000 and semiannual coupons. Company (Ticker) Coupon Xenon, Inc. (XIC) 5.90 Kenny Corp. (KCC) 7.17 Williams Co. (WICO) ?? Maturity Jan 15, 2030 Jan 15, 2027 Jan 15, 2034 Last Price 94.243 ?? 94.785 Last Yield ?? 6.12 6.94 EST $ Vol (000's) 57,367 48,946 43,807 What is the yield to maturity for the bond issued by Xenon, Inc.? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Answer is complete but not entirely correct. Yield to maturity 6.99 %