Find the duration of a bond with a settlement date of May 27, 2025, and maturity date November 15, 2036. The coupon rate of the bond is 9.5%, and the bond pays coupons semiannually. The bond is selling at a bond-equivalent yield to maturity of 10.5%. Use Spreadsheet 16.3.

Note: Do not round intermediate calculations. Round your answers to 2 decimal places.

Using Excel functions to compute duration