1) Use Excel to find the duration of a bond that has the following characteristics. Maturity (in years) : 21 Coupon : 4% Coupon frequency : annual Par value : $1,000.00 YTM : 15% 2) What happens to the duration of the bond if coupon changes? Illustrate with a graph of duration (y) vs coupon rate (x). Your graph should increase in coupon rate until no meaningful changes occur by adding a higher coupon 3) What happens to the duration of the bond if maturity changes? Illustrate with a graph of duration (y) vs. maturity (x). You graph should increase in maturity until no meaningful changes occur by adding a longer maturity.