****WIll need to be shown how to use and in excel****

A 15-year U.S. Treasury bond with a face value of $1,000 pays a coupon of 5.50% (2.750% of face value every six months). The reported yield to maturity is 5.2% (a six-month discount rate of 5.2/2 = 2.6%).

What is the present value of the bond?

If the yield to maturity changes to 1%, what will be the present value?

If the yield to maturity changes to 8%, what will be the present value?

If the yield to maturity changes to 15%, what will be the present value?

(For all requirements, do not round intermediate calculations. Round your answers to 2 decimal places.)