In: Finance
A 6.25 percent coupon bond with 15 years left to maturity is priced to offer a yield to maturity of 7.5 percent. You believe that in one year, the yield to maturity will be 7.0 percent. What is the change in price the bond will experience in dollars? (Do not round intermediate calculations. Round your final answer to 2 decimal places.)
Please work in excel