Using Excel, complete the table for calculating the duration given the information below. a) Time to maturity is X years, the coupon rate is Y percent, the face value is $Z, and the interest rate is 5%. X=5, Y=5, Z=1,000. b) What is the new bond price and duration when the interest rate increases to 5.5%? How large is the price decline after the interest rate hike? c) Compare your answer in b) with the one obtained from using the approximation formula. d) Repeat c) when the interest rate now increases from 5 to 25%.