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 $6\mathrm{.}0\%,$ and the bond pays coupons semiannually. The bond is selling at a bond$-$equivalent yield to maturity of $7\mathrm{.}0\%.$ Use SPREADSHEET $16\mathrm{.}3$

Using Excel functions to compute duration