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

Use Spreadsheet $16\mathrm{.}3.$

Note: Do not round intermediate calculations. Round your answers to $2$ decimal places.SPREADSHEET $16\mathrm{.}3$

Using Excel functions to compute duration

what is the Macaulay duration?

what is the modified duration?