!!! This is a multiple-part Question !!!

Question 9) Duration and Convexity in Excel: What is the Modified Duration of a 10-year, 7% coupon, $1,000 par bond, with a 7% yield to maturity?

a) 7.1

b) 7.2

c) 7.5

d) 7.6

Question 10) Duration and Convexity in Excel: Which is greater, the duration of a 10-year, 6% coupon bond with a 6% yield to maturity or a 10-year 7% coupon bond with 7% yield to maturity?

A) the 7%, 7% bond.

B) the 6%, 6% bond.

Question 11) Duration and Convexity in Excel: All other parameters equal, higher coupon means ___.

1) lower duration.

2) higher duration.

3) the same duration.

4) you cannot tell.

48 49 50 51 52 53 6. The sensitivity of a bond's price to a change in its yield is inversely related to the yield to maturity at which the bond currently is selling. high YTM low YTM Par $1,000 $1,000 $1,000 $1,000 Coupon rate 6.0% 6.0% 6.0% 6.0% years to maturity 10 10 10 10 yield to maturity 6.0% 5.0% 3.0% 2.0% Price $1,000.00 $1,077.95 $1,257.53 $1,360.91 change in price due to 1% yield chan 7.8% 8.2% 54 55 56 57 58 59 60 61 Now Maturity Price Coupon Time Duration (and Convexity) in Excel 3/25/2020 Duration 7.6619 3/25/2030 Mduration 7.4387 $1,000.00 6.0% 10 6.0% 62 63 64 YTM 65 66 67 68 69 0.000889996 1 113.2075472 2 320.3987184 3 604.5258838 4 950.5123959 Convexity 1.769886566 70 Use Duration (and Convexity) to Approx. Change in Price YTM change to: 5.0% $ change in price % change in price ($74.39) -7.44% ($74.48) -7.43% 71 72 Duration Duration+Conv. 73 48 49 50 51 52 53 6. The sensitivity of a bond's price to a change in its yield is inversely related to the yield to maturity at which the bond currently is selling. high YTM low YTM Par $1,000 $1,000 $1,000 $1,000 Coupon rate 6.0% 6.0% 6.0% 6.0% years to maturity 10 10 10 10 yield to maturity 6.0% 5.0% 3.0% 2.0% Price $1,000.00 $1,077.95 $1,257.53 $1,360.91 change in price due to 1% yield chan 7.8% 8.2% 54 55 56 57 58 59 60 61 Now Maturity Price Coupon Time Duration (and Convexity) in Excel 3/25/2020 Duration 7.6619 3/25/2030 Mduration 7.4387 $1,000.00 6.0% 10 6.0% 62 63 64 YTM 65 66 67 68 69 0.000889996 1 113.2075472 2 320.3987184 3 604.5258838 4 950.5123959 Convexity 1.769886566 70 Use Duration (and Convexity) to Approx. Change in Price YTM change to: 5.0% $ change in price % change in price ($74.39) -7.44% ($74.48) -7.43% 71 72 Duration Duration+Conv. 73