provide excel solutions please

You find the following corporate bond quotes. To calculate the number of years until maturify disume that it is currently Jantiany 15 . 2022. The bonds thre a par value of $2.000 and semlannusi coupons a. What price would you expect to poy for the Kenny Corporation bond? Note: Do not round intermediate calculations and round your answer to 2 decimal pleces, 9.9,32.16. b. What is the bonds current yield? Note: Do not round intermediate calcuiations and enter your answer as a percent rounded to 2 decimal ploces; e.9, 32.16