Find the spreadsheet for Table 3.4. in Connect. Show how duration and volatility change if (a) The

Question:

Find the spreadsheet for Table 3.4. in Connect. Show how duration and volatility change if

(a) The bond's coupon is 8% of face value and

(b) The bond's yield is 6%. Explain your finding.

TABLE 3.4

Coupon
A coupon or coupon payment is the annual interest rate paid on a bond, expressed as a percentage of the face value and paid from issue date until maturity. Coupons are usually referred to in terms of the coupon rate (the sum of coupons paid in a... Face Value
Face value is a financial term used to describe the nominal or dollar value of a security, as stated by its issuer. For stocks, the face value is the original cost of the stock, as listed on the certificate. For bonds, it is the amount paid to the...