An investor is considering the purchase of a $10$ year $(7\%$ coupon bond selling

for $$1019\mathrm{.}50$ and a par value of $$1,000.$ The yield to maturity for this bond is

$6\mathrm{.}73\%.$

$($a$)$ What would be the total future dollars if this investor invested $$1019\mathrm{.}50$ for

$10$ years earning $6\mathrm{.}73\%$ compounded semiannually?

$($b$)$ What would be the total future dollars from the coupon payments and the

repayment of principal at the end of $10$ years?

$($c$)$ What are the total coupon payments over the life of this bond?

$($d$)$ How much must the interest on interest on the coupon payments be earned

by the investor? Using excel for all parts of the questions