Stanley, Inc. issues a $15-$year $$1,000$ bond that pays $$42\mathrm{.}50$ semi$-$annually. The market price for the bond is $$960.$ The market's required yield to maturity on a comparable$-$risk bond is $9$ percent.

a$.$ What is the value of the bond to you?.

b$.$ What happens to the value if the market's yield to maturity on a comparable$-$risk bond $($i$)$ increases to $11$ percent or $($ii$)$ decreases to $7$ percent?

c$.$ Under which of the circumstances in part b should you purchase the bond?

PV $($price$),42\mathrm{.}5$ semi$-$annual coupon payment'given rather than coupon rate $-$ input payment directly rather than calculate

YTM

b$.$ Coupon rate

Par $($FV$)$

Years $($n$)$

$m$

PMT

PV $($price$)$

YTM

Coupon rate

Par. $($FV$)$

Years $($n$)$

$m$

PMT

PV $($price$)$

YTM

Please show how to solve for Excel