Question

Find the duration of a bond with settlement date May 30, 2016, and maturity date November...

Find the duration of a bond with settlement date May 30, 2016, and maturity date November 21, 2025. The coupon rate of the bond is 5%, and the bond pays coupons semiannually. The bond is selling at a yield to maturity of 6%. ( Round your answers to 4 decimal places.)

Macaulay duration
Modified duration
0 0
Add a comment Improve this question Transcribed image text
Answer #1

1.
=DURATION(DATE(2016,5,30),DATE(2025,11,21),5%,6%,2,1)=7.56967773810732

2.
=MDURATION(DATE(2016,5,30),DATE(2025,11,21),5%,6%,2,1)=7.34920168748283

Add a comment
Know the answer?
Add Answer to:
Find the duration of a bond with settlement date May 30, 2016, and maturity date November...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Find the duration of a bond with settlement date May 29, 2012, and maturity date November...

    Find the duration of a bond with settlement date May 29, 2012, and maturity date November 19, 2021. The coupon rate of the bond is 6%, and the bond pays coupons semiannually. The bond is selling at a yield to maturity of 7%. (Do not round intermediate calculations. Round your answers to 4 decimal places.)      Macaulay duration      Modified duration   

  • Find the duration of a bond with settlement date June 14, 2018, and maturity date December...

    Find the duration of a bond with settlement date June 14, 2018, and maturity date December 21, 2027. The coupon rate of the bond is 8%, and the bond pays coupons semiannually. The bond is selling at a yield to maturity of 9%. (Do not round intermediate calculations. Round your answers to 4 decimal places.) Macaulay Duration    Modified Duration

  • Find the duration of a bond with settlement date June 10, 2012, and maturity date December...

    Find the duration of a bond with settlement date June 10, 2012, and maturity date December 13, 2021. The coupon rate of the bond is 7%, and the bond pays coupons semiannually. The bond is selling at a yield to maturity of 8%. (Do not round intermediate calculations. Round your answers to 4 decimal places.)      Macaulay duration      Modified duration   

  • Find both the Macaulay and Modified duration of a bond with a settlement date of May...

    Find both the Macaulay and Modified duration of a bond with a settlement date of May 27, 2020, and maturity date November 15, 2031. The coupon rate of the bond is 5.5%, and the bond pays coupons semiannually. The bond is selling at a bond -equivalent yield to maturity of 6.5%.

  • Find the duration of a bond with settlement date June 10, 2018, and maturity date December...

    Find the duration of a bond with settlement date June 10, 2018, and maturity date December 13, 2027. The coupon rate of the bond is 7%, and the bond pays coupons semiannually. The bond is selling at a yield to maturity of 8%. (Do not round intermediate calculations. Round your answers to 4 decimal places.)

  • Manually compute the modified duration for the following bond: Maturity Date: 04/20/2017 Settlement Date: 02/05/2016 Coupon...

    Manually compute the modified duration for the following bond: Maturity Date: 04/20/2017 Settlement Date: 02/05/2016 Coupon Rate: 10% Coupon Frequency: Semiannual Yield-to-Maturity: 12% Day Count Convention: 30/360 (European)

  • You just purchased a $1000 par value bond maturing on 30th June 2025. Suppose today’s date...

    You just purchased a $1000 par value bond maturing on 30th June 2025. Suppose today’s date (settlement date) is 30th June 2019 and the yield to maturity is 6%. Given all these inputs, do the following. a) Assume the bond is a zero coupon bond (with annual compounding). Compute the bond’s Macaulay duration (using the DURATION function) and modified duration (using the MDURATION function). b) Holding everything else constant, now assume the bond pays coupons semi-annually. Compute the bond’s Macaulay...

  • A Treasury bond that settles on October 18, 2016, matures on March 30, 2035. The coupon...

    A Treasury bond that settles on October 18, 2016, matures on March 30, 2035. The coupon rate is 6.30 percent and the bond has a yield to maturity of 5.85 percent. What are the Macaulay duration and modified duration? (Use the duration function in Excel to solve the problem. Do not round intermediate calculations. Round your answers to 4 decimal places.) Macaulay duration Modified duration

  • porte A Treasury bond that settles on October 18, 2016, matures on March 30, 2035. The...

    porte A Treasury bond that settles on October 18, 2016, matures on March 30, 2035. The coupon rate is 5.75 percent and the bond has a yield to maturity of 5.08 percent. What are the Macaulay duration and modified duration? (Use the duration function in Excel to solve the problem. Do not found intermediate calculations. Round your answers to 4 decimal places.) Macaulay duration Modified duration

  • Problem 10-35 Duration (LO4, CFA6) A Treasury bond that settles on October 18, 2016, matures on...

    Problem 10-35 Duration (LO4, CFA6) A Treasury bond that settles on October 18, 2016, matures on March 30, 2035. The coupon rate is 6.15 percent and the bond has a yield to maturity of 5.64 percent. What are the Macaulay duration and modified duration? (Use the duration function in Excel to solve the problem. Do not round intermediate calculations. Round your answers to 4 decimal places.) Answer is complete but not entirely correct. 11.3694 Macaulay duration Modified duration 10.7624

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT