Question

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

Find the duration of a bond with settlement date June 10, 2016, and maturity date December 13, 2025. 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

Homework Answers

Answer #1

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -

Hope this will help, please do comment if you need any further explanation. Your feedback would be appreciated.

Know the answer?
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
Similar Questions
Find the duration of a bond with settlement date June 16, 2016, and maturity date December...
Find the duration of a bond with settlement date June 16, 2016, and maturity date December 25, 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%. (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 16, 2016, and maturity date December...
Find the duration of a bond with settlement date June 16, 2016, and maturity date December 25, 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%. (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 May 30, 2018, and maturity date November...
Find the duration of a bond with settlement date May 30, 2018, and maturity date November 21, 2027. 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%. (Do not round intermediate calculations. Round your answers to 4 decimal places.) Macaulay duration: ??? Modified duration: ???
A bond has a yield to maturity of 8 percent. It matures in 10 years. Its...
A bond has a yield to maturity of 8 percent. It matures in 10 years. Its coupon rate is 8 percent. What is its modified duration? The bond pays coupons twice a year. (Do not round intermediate calculations. Enter your answers rounded to 2 decimal places.)
Assume that June 19, 2018 is the settlement date. A bond was issued on November 12,...
Assume that June 19, 2018 is the settlement date. A bond was issued on November 12, 2005, and matures November 12, 2025. It pays a 4.50% coupon semiannually and has a yield on June 19, 2018 of 7.25%. What was the market rate of the above bond when it was first issued? How would I do this on excel?
A bond with a coupon rate of 9 percent sells at a yield to maturity of...
A bond with a coupon rate of 9 percent sells at a yield to maturity of 10 percent. If the bond matures in 10 years, what is the Macaulay duration of the bond? What is the modified duration? (Do not round intermediate calculations. Round your answers to 3 decimal places.)
Find the duration of a 4.0% coupon bond making semiannually coupon payments if it has three...
Find the duration of a 4.0% coupon bond making semiannually coupon payments if it has three years until maturity and has a yield to maturity of 6.0%. What is the duration if the yield to maturity is 8.0%? Note: The face value of the bond is $100. (Do not round intermediate calculations. Round your answers to 4 decimal places.)
Find the convexity of a seven-year maturity, 6.2% coupon bond selling at a yield to maturity...
Find the convexity of a seven-year maturity, 6.2% coupon bond selling at a yield to maturity of 7.7%. The bond pays its coupons annually. (Do not round intermediate calculations. Round your answer to 4 decimal places.) Convexity
a. Find the duration of a 6% coupon bond making annual coupon payments if it has...
a. Find the duration of a 6% coupon bond making annual coupon payments if it has three years until maturity and has a yield to maturity of 6%. Note: The face value of the bond is $1,000. (Do not round intermediate calculations. Round your answers to 3 decimal places.) b. What is the duration if the yield to maturity is 10%? Note: The face value of the bond is $1,000. (Do not round intermediate calculations. Round your answers to 3...
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 5.55 percent and the bond has a yield to maturity of 4.80 percent. What are the Macaulay duration and modified duration? Macaulay duration: Modified duration: