We have the opportunity to buy a $10-$year $($original term$)$ bond with $7$ years of semi$-$annual coupon payments remaining. The annual coupon rate is set at $5\%($$$25$ semi$-$annual payment$).$ If the current Yield to Maturity $($prevailing market rate on comparable bonds$)$ is approximately $6\mathrm{.}5\%,$ estimate the appropriate purchase price of the bond.

$*****$Use excel to solve, and show formulas$/$steps on how you solved it$.$

Will upvote!