$2.$ Suppose the bondholder just received the September $30,2024$ coupon payment.

$[1$ point$]$ Using the PV function, what is the present value of the remaining coupon payments?

$[1$ point$]$ Using the PV function, what is the present value of the face value payment at maturity?

$[1$ point$]$ By referencing cells D$16$ and D$17,$ what is the value of the bond?

$[1$ point$]$ Recalculate the value of the bond using the PRICE function.

$3.$ Suppose Powell spoke later in the day on September $30,2024$ and the price of the bond fell to $$1,000.$

$[1$ point$]$ Using the RATE function, what is the new yield to maturity of the bond?

$[1$ point$]$ Using the YIELD function, what is the new yield to maturity of the bond?