Figure 11.2 illustrates a 9% coupon, 8-year maturity bond with annual payments, selling at a yield to

Question:

Figure 11.2 illustrates a 9% coupon, 8-year maturity bond with annual payments, selling at a yield to maturity of 10%. Confirm using Spreadsheet 11.2 that the bond’s duration is 5.97 years. What would its duration be if the bond paid its coupon semiannually? Why intuitively does duration fall?Cash flow 1,200- 1,100- 1,000- 900- 800- 700- 600- 500- 400- 300- 200- 100- 0 2 3 Bond duration = 5.97 years

SPREADSHEET 11.2 Using Excel functions to compute duration excel Please visit us at www.mhhe.com/bkm A 1

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Essentials Of Investments

ISBN: 9780073368719

7th Edition

Authors: Zvi Bodie, Alex Kane, Alan J. Marcus

Question Posted: