PLEASE ANSWER IN EXCEL FORMAT ACCORDING TO THE SHEET I PROVIDED. The Sanders Company issued $9\mathrm{.}5\%$ bonds, dated January $1,$ with a face amount of $$8,000,000$ on January $1,2024.$ The bonds mature on December $31,2033(10$ years$).$ For bonds of similar risk and maturity, the market yield is $11\mathrm{.}0\%.$ Interest is paid semiannually on June $30$ and December $31.$ Sanders uses the effective interest method.

Determine the price of the bonds at January $1,2024$ using Excel's PV function.