Two bonds are available for purchase in the financial markets. The first bond is a two-year, $1,000 bond that pays an annual coupon of 5 percent. The second bond is a two-year, $1,000, zero-coupon bond.

a. What is the duration of the coupon bond if the current yield to maturity is 4 percent? 5 percent? 7 percent?

b. How does the change in the current yield to maturity affect the duration of this coupon bond?

c. Calculate the duration of the zero-coupon bond with a yield to maturity of 4 percent, 5 percent, and 7 percent.

d. How does the change in the yield to maturity affect the duration of the zero-coupon bond?

e. Explain why change in the yield to maturity affect the coupon bond differently than it affects the zero-coupon bond?

If possible, please do it non-excel format