Please answer these questions using excel. Thanks.

Duration

1. What is the duration of a 10-year, 6% bond if the market rate on bonds of similar quality is 5.8%?

2. Now suppose that the yield to maturity has changed to 5.81%. Using Macaulay duration, what is the approximate percent change in the price of the bond? (You do not need to recalculate Macaulay duration using 5.81%. Use the duration value that you found in Problem 1.)

3. Using convexity, what is the approximate percent change in the price of the bond?