Problem $9\mathrm{.}1$: Assume a Tesla bond with a par value of $$1,000$ has $9$ years left until maturity. The bond pays $5\mathrm{.}5\%$ interest annually and makes coupon payments twice a year. The current price of the bond is $$945$ and the market's required yield to maturity on a comparablerisk bond is $6\mathrm{.}00\%.$ Solve using excel spreadsheet with excel formulas

a$.$ Compute the bonds yield to maturity.

b$.$ Determine the value of the bond to you, given your required rate of return $($the YTM on a comparable$-$risk bond$).$

c$.$ Should you purchase the bond?

a$.$ Coupon rate

$\backslash$table$[[$Par $($FV$),$$$1,000$