Question

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: ???

Homework Answers

Answer #1

Macaulay duration can be found out using 'DURATION' function in excel

The modified duration can be found out using 'MDURATION' function in excel

Payment frequency is 2 since coupons are paid semi-annually

Settlement date 30-May-18
Maturity date 21-Nov-27
Coupon rate 5%
Payment frequency per year 2
Bond YTM 6%
Macaulay duration 7.5691343
Modified duration 7.348674

Macaulay duration (in years) = 7.57

Modified duration (in years) = 7.35

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 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
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.)
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.)
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...
Find the duration of a 8% coupon bond making annual coupon payments if it has three...
Find the duration of a 8% coupon bond making annual coupon payments if it has three years until maturity and a yield to maturity of 7.8%. What is the duration if the yield to maturity is 11.8%? (Do not round intermediate calculations. Round your answers to 4 decimal places.) YTM Duration 7.8% YTM