Dewey, Cheatham & Howe, a regional brokerage house, has an issue of $$1,000$ par value bonds

with $18$ years left until maturity. The coupon rate is $7\mathrm{.}7\%,$ with semi$-$annual payments. If the current

price of the bond is $$1,175,$ what is the bond$$s YTM$?$ ANSWER WITH EXCEL