As an investor, you are considering an investment in the bonds of Wayne Enterprises. The bonds pay interest semiannually, will mature in nine years, and have a coupon rate of $7\%$ with a par value of $$1,000.$ Currently the bonds are selling for $$823.$

$\backslash$table$[[$Wayne Enterprices$],[$Price$,$$$,823\mathrm{.}00],[$Par Value,$$,1,000\mathrm{.}00$

With excel formulas please