Show me the steps to solve in excel please

The bond pays a coupon rate of $6\mathrm{.}5\%$ and pays interest semi$-$annually.

The settlement date is $7/05/2022$

The bond matures on $6/15/2046$

The par value is $$100,$ or $100\%$ of par.

The yield to maturity is $7\%.$

Calculate the today's price using the PRICE function $($as a $\%$ of par$)$

Calculate the modified duration of the bond