Using Excel, determine the price of a semi-annual interest paying bond with the following term structure: Settlement: 11/15/2023

Final Maturity: 11/15/2053

Maturity value = $100.000 Coupon (Interest rate): Zero coupon (no interest accrues) until 11/15/2033 at which time it switches to 6.5% coupon until maturity.

Pays interest semi-annually. (Interest frequency = 2) Basis = 0

Bonds of similar quality and term structure are yielding 7.25%

Use the PRICE formula to complete your calculations. Show all values used in the calculation and have the formula reference those values. Show the resulting price to three decimal places. All values should be labeled. Include your name, section number and date