Question

In: Finance

Using excel, illustrate and check the following observations on bonds and interest rate sensitivity. You can...

Using excel, illustrate and check the following observations on bonds and interest rate sensitivity.

You can use any set of a given bond's characteristics of your choosing.

1. Prices of long-term bonds tend to be more sensitive to interest rate changes than prices of short-term bonds.

2. Bond prices' sensitivity to changes in yields increases at a decreasing rate as maturity increases.

3. Interest rate risk is inversely related to the bond's coupon rate. Prices of low-coupon bonds are more sensitive to changes in interest rates than prices of high-coupon bonds.

4. The sensitivity of a bond's price to a change in its yield to maturity is inversely related to the yield to maturity at which the bond is currently selling.

You can make up the excel macros.

Solutions

Expert Solution

Bond prices are sensitive to changes in Interest rates, they are inversely related to the interest rates. The intensity of the price sensitivity depends on bonds maturity and coupon rate. The longer the maturity of bond the higher its sensitivity to the interest rate change.Similarly the price of bond with low coupon rate will be more sensitive to the interest rate change.

Let us considered two bonds with 5 yrs Maturity. The first one with 8.5% rate bond of Rs 1000 face value, and current market value of Rs 954.74 and YTM of 10%. The second one with 11.5% rate bond of Rs 1000 face value and current market value 1044.57 and YTM is 10.6%.

8.5% Bond
Year Cash Flow Present Value @ 10% Proportn of Bond Price Poportion of Bond       Price * Time
1 85 77.27 0.082 0.082
2 85 70.25 0.074 0.149
3 85 63.86 0.068 0.203
4 85 58.06 0.062 0.246
5 1085 673.7 0.714 3.572
943.14 1 4.252
11.5% Bond
Year Cash Flow Present Value @ 10% Proportn of Bond Price Poportion of Bond       Price * Time
1 115 103.98 0.101 0.101
2 115 94.01 0.091 0.182
3 115 85 0.082 0.247
4 115 76.86 0.074 0.297
5 1115 673.75 0.652 3.259
1033.6 1 4.086

Volatility of bond=Duration/(1+YTM)

Volatility of 8.5% Bond=4.252/(1.100)=3.87

Volatility of 11.5% Bond=4.086/(1.106)=3.69

The 8.5% Bond has higher volatilty. If YTM increase b y 1% this will result in 3.87% decrease in the price of 8.5% bond in respect to 3.69% decrease of 11.5% bond.


Related Solutions

Using excel, illustrate and check the following observations on the duration of bonds. 1. The duration...
Using excel, illustrate and check the following observations on the duration of bonds. 1. The duration of a zero-coupon bond equals its time to maturity 2. With time to maturity and yield to maturity held constant, a bond's duration and interest rate sensitivity are higher when the coupon rate is lower 3. With the coupon rate held constant, a bond's duration and interest rate sensitivity generally increase with time to maturity. Duration always increases with maturity for bonds selling at...
a. Explain which of the following bonds has higher interest rate sensitivity. Bond A is a...
a. Explain which of the following bonds has higher interest rate sensitivity. Bond A is a 15-year, noncallable bond with a coupon rate of 7%, selling at par. Bond B is a 15-year, callable bond with a coupon rate of 9%, also selling at par. b. Tony, a fixed-income portfolio manager, is managing a portfolio of $10 million. His target duration is 7 years, and he can choose from two bonds: a zero-coupon bond with maturity of 3 years, and...
Suppose you are trying to determine the interest rate sensitivity of two bonds. Bond 1 is...
Suppose you are trying to determine the interest rate sensitivity of two bonds. Bond 1 is a 12% coupon bond with a 7-year maturity and a $1000 principal. Bond 2 is a ‘zero-coupon’ bond that pays $1120 after 7 year. The current interest rate is 12%. - Determine the duration of each bond. - If the interest rate increases 100 basis points (100 basis points = 1%), what will be the capital loss on each bond?
INTEREST RATE SENSITIVITY An investor purchased the following 5 bonds. Each bond had a par value...
INTEREST RATE SENSITIVITY An investor purchased the following 5 bonds. Each bond had a par value of $1,000 and an 10% yield to maturity on the purchase day. Immediately after the investor purchased them, interest rates fell, and each then had a new YTM of 5%. What is the percentage change in price for each bond after the decline in interest rates? Fill in the following table. Round your answers to the nearest cent or to two decimal places. Enter...
how the bond is sensitivity to the interest rate movement half page !
how the bond is sensitivity to the interest rate movement half page !
URGENT ANSWERS PLUS EXPLANATIONS-HOW YOU GOT ANSWER PLEASE. (Interest Rate Sensitivity) An investor purchased the following...
URGENT ANSWERS PLUS EXPLANATIONS-HOW YOU GOT ANSWER PLEASE. (Interest Rate Sensitivity) An investor purchased the following 4 bonds. Each bond had a face(par) value of $1,000 and an 6% yield to maturity on the purchase day. Immediately after the investor purchased them, interest rates changed, and each then had a new YTM (7% or 5%). What is the percentage change in price for each bond after the decline in interest rates? Fill in the following table with your answers. Bond...
Explain the following observations, using diagrams to illustrate your answer wherever possible: (a) Steel nails used...
Explain the following observations, using diagrams to illustrate your answer wherever possible: (a) Steel nails used to hold copper roofing sheet in position failed rapidly by wet corrosion. (b) The corrosion of an underground steel pipeline was greatly reduced when the pipeline was connected to a buried bar of magnesium alloy. (c) Mild-steel radiators in a central heating system were found to have undergone little corrosion after several years' service. (d) A reaction vessel for a chemical plant was fabricated...
I always rate! Show Excel work, please You have been asked to perform scenario analysis, sensitivity...
I always rate! Show Excel work, please You have been asked to perform scenario analysis, sensitivity analysis, and break even analysis for producing a new golf ball. These new golf balls will sell from $2 a piece. In the best case scenario you think you will sell 750,000 balls, in the most likely case you will sell 500,000 balls and in the worst case you will sell 300,00 balls. Your variable cost is 35% and you have $300,000 in fixed...
In an excel spreadsheet, calculate the real interest rate over the past 24 months (using monthly...
In an excel spreadsheet, calculate the real interest rate over the past 24 months (using monthly data) for the 30 year Treasury bond rate as the nominal interest rate and assuming that expected inflation was equal to actual inflation (based on the change in CPI). Make sure to include the Fisher Equation.
What is the value of the following $1000 par value bonds:         Interest rate      Required rate...
What is the value of the following $1000 par value bonds:         Interest rate      Required rate of return                 Years to maturity Value?                                4%                                    7%                                                          10               4%                                    5%                                                          10                         4%                                    9%                                                          10
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT