provide excel

You find the following Treasury bond quotes. To calculate the number of years untif maturify, assume that it is currently May 2022 Afi of the bonds have a par value of $1.000 and pay semannual coupons a. In the above table, find the Treasuty bond that matures in May 2044 . What is the asked price of this bond in doflars? Note: Do not round intermediote colculations and round your onswer to 2 decimal places, e.9. 3216, b. If the bid-ask spread for this bond is 0545 , what is the bid price in dollars? Note: Do not round intermediate colculations and round your answer to 2 decimal places, e.9, 32.16