ANSWER IN EXCEL

Stein Company issued a $15-$year bond one year ago at a coupon rate of

$6\mathrm{.}1$ percent. The bond makes semi$-$annual coupon payments. If the yield to

maturity $($YTM$)$ on this bond is $5\mathrm{.}3$ percent per year, what is the current

price assuming $$2,000$ par value? Show all calculations and use the price

function.