Find the value of a bond maturing in $11$years$,$ with a $$$$1,000$ par value and a coupon interest rate of $11\%(5\mathrm{.}5\%$ paid$$ semiannually$)$ if the required return on$$ similar$-$risk bonds is $18\%$ annual interest. Use in excel formula