DaVita Health bonds are selling in the market for $$1,027\mathrm{.}50.$ These $8$ year bonds pay $6\mathrm{.}375\%$ semi$-$annually on a $$1,000$ par value. If the bond is purchased at market price, what is the bond's yield to maturity?

Note: format is $x.\%$

Use excel spreadsheet work shown