Please show your work by excel and calculator

You find the following corporate bond quotes. To calculate the number of years until maturity, assume that it is currently January 15. 2022. The bonds have a par value of $2,000 and semiannual coupons. a. What price would you expect to pay for the Kenny Corporation bond? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.9., 32.16. b. What is the bond's current yleld? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.9. 32.16