Question

(excel) Consider a 8% coupon bond making annual coupon payments with 4 years until maturity and...

(excel) Consider a 8% coupon bond making annual coupon payments with 4 years until maturity and a yield to maturity of 10%.

  1. What is the modified duration of this bond?
  1. If the market yield increases by 75 basis points, what is the actual percentage change in the bond’s price? [Actual, not approximation]
  1. Given that this bond’s convexity is 14.13, what price would you predict using the duration-with-convexity approximation for this bond at this new yield?
  1. What is the percentage error?

Homework Answers

Answer #1

a.

Annual coupon rate 8% MDURATION function in excel
Yield 10% 3.237903803
Settlement date 4/10/2020
Maturity date 4/10/2024
Payment frequency 1

b.

Annual coupon rate 8%
Old Yield 10%
Settlement date 4/10/2020
Maturity date 4/10/2024
Payment frequency 1
Redemption value 100
New yield 10.75%
Using function PRICE in excel
Bond Price at old yield = 10% Bond Price at new yield = 10.75%
93.66026911 91.42253393

Percentage change in bond price => (91.4225-93.6602)*100/91.4225 = -2.4476% (decrease)

c. Change in bond price = Duration effect + convexity effect

= (- Modified duration * change in yield) + (0.5* convexity* (change in yield)^2)

= (-3.2379*0.0075)+(0.5*14.13*0.0075*0.0075)

= -0.02388

=-2.388%

New price using convexity-duration = 93.6602*(100-2.388)/100 = 91.4236

d. Percentage error = = 0.001203%

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
A 4 year maturity bond making annual coupon payments with a coupon of 8% has a...
A 4 year maturity bond making annual coupon payments with a coupon of 8% has a duration of 3.607 years and a convexity of 16.08. The bond currently sells at a yield of 4%. What is the actual price of the bond if the YTM immediately increases to 6%? Round you answer to the nearest penny. Answer:
A 30-year maturity bond making annual coupon payments with a coupon rate of 7% has duration...
A 30-year maturity bond making annual coupon payments with a coupon rate of 7% has duration of 15.16 years and convexity of 315.56. The bond currently sells at a yield to maturity of 5%.     a. Find the price of the bond if its yield to maturity falls to 4% or rises to 6%. (Round your answers to 2 decimal places. Omit the "$" sign in your response.)       Yield to maturity of 4% $       Yield to maturity of 6%...
A 30-year maturity bond making annual coupon payments with a coupon rate of 10.2% has duration...
A 30-year maturity bond making annual coupon payments with a coupon rate of 10.2% has duration of 11.03 years and convexity of 176.83. The bond currently sells at a yield to maturity of 9%. a. Find the price of the bond if its yield to maturity falls to 8%. b. What price would be predicted by the duration rule? c. What price would be predicted by the duration-with-convexity rule? d-1. What is the percent error for each rule? d-2. What...
A 30-year bond making annual payments has a coupon rate of 12%,a duration of 11.54years, and...
A 30-year bond making annual payments has a coupon rate of 12%,a duration of 11.54years, and convexity of 192.4.The bond is currently selling at a yield to maturity of 8%. Use the duration-with -convexity approximation to predict the new price of the bond iftheyield to maturitydeclines from 8% to 7%.Assume a facevalue of 1000.
A bond with a coupon of 11.5% and 10 years remaining until maturity has a modified...
A bond with a coupon of 11.5% and 10 years remaining until maturity has a modified duration of 6.48 and convexity of 63. The bond is quoted at $115.75. If the required yield rises by 145 basis points, determine the predicted price of the bond. Please show work!
Consider a zero-coupon bond with $100 face value that matures in seven years and has a...
Consider a zero-coupon bond with $100 face value that matures in seven years and has a yield of 7%. i) What is the price when we assume that the (discrete) compounding frequency is semiannual? ii) What is the bond’s modified duration? iii) Use the modified duration to find the approximate changes in price if the bond yield rises by 10, 20, 50, 100 and 200 basis points. iv) evaluate the same bond price if rates changes by -200 bps, -100...
A 30-year maturity bond making annual coupon payments with a coupon rate of 16.0% has duration...
A 30-year maturity bond making annual coupon payments with a coupon rate of 16.0% has duration of 10.55 years and convexity of 161.7. The bond currently sells at a yield to maturity of 9%. a. Find the price of the bond if its yield to maturity falls to 8%. (Do not round intermediate calculations. Round your answer to 2 decimal places.) Price of the bond $ b. What price would be predicted by the duration rule? (Do not round intermediate...
A 6% coupon bond is making annual coupon payments and has a duration of 8 years....
A 6% coupon bond is making annual coupon payments and has a duration of 8 years. What will be the percentage change in the bond's price if its yield to maturity changes from 6% to 6.1%?
A bond has a coupon rate of 6 percent, with payments semi-annually. It matures in 2.5...
A bond has a coupon rate of 6 percent, with payments semi-annually. It matures in 2.5 years and has a yield to maturity of 7 percent (15 points). a. Use the “long method” to determine the duration and modified duration of this bond? b. If the yield to maturity increases to 9 percent, what is the approximate percent change in price based on the modified duration calculated in ‘a?’ c. What is the actual percentage change in price if the...
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
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT