Please use excel and show functions when applicable. Be as clear as can be. thank you

Bond Hook Union Eight Coupon 8.00% 7.00% 8.75% Maturity Date 12/25/24 08/24/28 09/25/39 The 4.50% Rugby bond that matures in 12 years has a quoted price of 107.25. What is its yield to maturity? Scrum has a zero coupon bond that matures on January 30, 2042. What is the percentage change in 3 the price of the bond if interest rates rise by 12 bps from 10.00%? What is the yield to maturity for the Union bond? It makes annual coupon payments and is quoted 4 at 110.70. Wing has a bond that matures in 16 years and a 9.10% coupon. What is the percentage change in 5 the price of the bond if interest rates fall by 17 bps from 7.94%? Bond Hook Union Eight Coupon 8.00% 7.00% 8.75% Maturity Date 12/25/24 08/24/28 09/25/39 The 4.50% Rugby bond that matures in 12 years has a quoted price of 107.25. What is its yield to maturity? Scrum has a zero coupon bond that matures on January 30, 2042. What is the percentage change in 3 the price of the bond if interest rates rise by 12 bps from 10.00%? What is the yield to maturity for the Union bond? It makes annual coupon payments and is quoted 4 at 110.70. Wing has a bond that matures in 16 years and a 9.10% coupon. What is the percentage change in 5 the price of the bond if interest rates fall by 17 bps from 7.94%