You want to determine the duration for Bond XYZ. You invest in this bond on January 1, 2021. This bond matures on January 1, 2031. Yield-to-maturity 5.25% Annual coupon 5.75%, payable semi-annually Use Excel to find this bonds duration (Macauley). Be sure to attach Excel spreadsheet.

Question 4 Using the answer from Question 3, determine Bond XYZs price change in percent if market interest rates decrease by 15 BP (0.15%). Show all work.