a. Use a spreadsheet to calculate the durations of the two bonds in Spreadsheet 11.1 if the
Question:
a. Use a spreadsheet to calculate the durations of the two bonds in Spreadsheet 11.1 if the interest rate increases to 12%. Why does the duration of the coupon bond fall while that of the zero remains unchanged? (Hint: Examine what happens to the weights computed in column E.)
b. Use the same spreadsheet to calculate the duration of the coupon bond if the coupon were 12% instead of 8%. Explain why the duration is lower. (Again, start by looking at column E.)
LO.1
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Essentials Of Investments
ISBN: 9780697789945
8th Edition
Authors: Zvi Bodie, Alex Kane, Alan J. Marcus
Question Posted: