The $15-$year, $$1,000$ par value bonds of Waco Industries pay $8$ percent annual interest and makes interest payments on a semiannual basis. The market price of the bond is $$1,085,$ and the market's required yield to maturity on a comparable$-$risk bond is $10$ percent.

a$.$ Compute the bond's Yield to Maturity.

b$.$ Determine the value of the bond to you given the market's required yield to maturity on a comparable$-$risk bond.

c$.$ Should you purchase the bond?

Coupon rate

Par $($FV$)$

Years $($n$)$

m

PMT

PV $($price$)$

YTM

Coupon rate

Par $($FV$)$

Years $($n$)$

m

PMT

PV $($price$)$

YTM

Please show to solve for Excel