Please Use Excel when possible and show functions. Be as clear as possible. Thank you.

Bond Hook Union Eight Coupon 8.00% 7.00% 8.75% Maturity Date 12/25/24 08/24/28 09/25/39 Interest rates on bonds similar to the 4.70% Back bond that matures in 5 years are 3.63%. What is its price? How much is the Eight bond worth to you if you believe it should yield 9.63%? The 6.00% Flank bond that matures on April 10, 2040 has a quoted price of 116.15. What is its yield to maturity? If you purchased the Hook bond today for $969.00, what is the yield to maturity? Interest rates on bonds similar to the 6.10% Lock bond that matures on February 26, 2026 are 5.11%. What is its quoted price? The 3.00% Prop bond that matures in 4 years has a face value of $5,000.00 and sells for $4,811.50. What is its yield to maturity? Bond Hook Union Eight Coupon 8.00% 7.00% 8.75% Maturity Date 12/25/24 08/24/28 09/25/39 Interest rates on bonds similar to the 4.70% Back bond that matures in 5 years are 3.63%. What is its price? How much is the Eight bond worth to you if you believe it should yield 9.63%? The 6.00% Flank bond that matures on April 10, 2040 has a quoted price of 116.15. What is its yield to maturity? If you purchased the Hook bond today for $969.00, what is the yield to maturity? Interest rates on bonds similar to the 6.10% Lock bond that matures on February 26, 2026 are 5.11%. What is its quoted price? The 3.00% Prop bond that matures in 4 years has a face value of $5,000.00 and sells for $4,811.50. What is its yield to maturity