5. Calculate the YTM based on the information provided and explain the difference between the Yield to Maturity rate and the original coupon rate.

YTM Bond Details: A bond is currently selling for $850 for 15 years until it matures. The bond has a current coupon rate of 6% and makes payments semi-annually. You purchased the bond today 1/1/2023 as your settlement date and you are interested in knowing what the YTM will be.

**Note, when calculating the YTM the bond price (% of par) and face value (% of par) will not be percentages, please use numbers for their respective section. The Yield Calculation is already built into Excel, all you have to do is type is =yield.