Question

In: Finance

7. Bond 1 and Bond 2 both have a face value of $1,000. Bond 1 pays...

7. Bond 1 and Bond 2 both have a face value of $1,000. Bond 1 pays a 5% coupon (annual payments) while Bond 2 is a zero coupon bond. On November 30, 2014 (immediately after the annual coupon payment), Bond 1 had exactly 20 years to maturity, while Bond 2 had 15 years to maturity. The yield to maturity for each bond was 10% on November 30, 2014, and was 8% on November 30, 2015.

A. What was the price of each bond on November 30, 2014?

B. What was the duration of each bond on November 30, 2014?

C. What was the price of each bond on November 30, 2015?

D. What was the one-year return on each bond if the bond was purchased on November 31, 2014 (immediately after the coupon was paid) and was sold on November 31, 2015 (immediately after the coupon was received)?

E. Which bond was more “sensitive” to this interest rate change, and why? In your answer to this question, address the following items:

• Based upon “time to maturity,” which bond should be more sensitive to the interest rate change? • Based upon the relative size of the coupon payments, which bond should be more sensitive to the interest rate change?

Solutions

Expert Solution

A]

Price of Bond 1 is calculated using PV function in Excel :

rate = 10% (YTM of bond)

nper = 20 (Years remaining until maturity with 1 coupon payment each year)

pmt = 1000 * 5% (annual coupon payment = face value * coupon rate)

fv = 1000 (face value receivable on maturity)

PV is calculated to be $574.32

Price of Bond 1 is $574.32

Price of zero-coupon bond = face value / (1 + YTM)years to maturity

Price of Bond 2 = $1,000 / (1 + 10%)15 = $239.39

Price of Bond 2 is $239.39

B]

Duration of Bond 1 is calculated using DURATION function in Excel :

settlement = November 30, 2014

maturity = 15 years from November 30, 2014, which is November 30, 2029

coupon = coupon rate of bond, which is 5%

yld = YTM of bond, which is 10%

frequency = number of coupon payments per year, which is 1

DURATION is calculated to be 9.65

Duration of a zero-coupon bond is equal to the years until maturity.

Duration of Bond 2 is 15.00

C]

Price of Bond 1 is calculated using PV function in Excel :

rate = 8% (YTM of bond)

nper = 19 (Years remaining until maturity with 1 coupon payment each year)

pmt = 1000 * 5% (annual coupon payment = face value * coupon rate)

fv = 1000 (face value receivable on maturity)

PV is calculated to be $711.89

Price of Bond 1 is $711.89

Price of zero-coupon bond = face value / (1 + YTM)years to maturity

Price of Bond 2 = $1,000 / (1 + 8%)14 = $340.46

Price of Bond 2 is $340.46

D]

Return on Bond 1 = (sale price - purchase price + annual coupon payment) / purchase price

Return on Bond 1 = ($711.89 - $574.32 + ($1,000 * 5%)) / $574.32

Return on Bond 1 = 32.66%

Return on Bond 2 = (sale price - purchase price ) / purchase price

Return on Bond 2 = ($340.46 - $239.39) / $239.39

Return on Bond 2 = 42.22%


Related Solutions

a company's bond have a par (face value of 1,000. the bond pays semiannual interest of...
a company's bond have a par (face value of 1,000. the bond pays semiannual interest of $40 and mature in five years. how much would you pay for the bond if you required rate is 10% and how much would you pay if your required rate is 8%
A 7 percent coupon bond has a face value of $1,000 and pays interest annually. The...
A 7 percent coupon bond has a face value of $1,000 and pays interest annually. The current yield is 7.3 percent. What is the current price of this bond?
An investor pays $1,230 for a bond with a face value of $1,000 and an annual...
An investor pays $1,230 for a bond with a face value of $1,000 and an annual coupon rate of 9 percent. The investor plans to hold the bond until its maturity date in eight years. The bond has a yield to maturity of __________ percent. (Note: This question requires a financial calculator.) 5.67 5.39 9.00 10.94
A bond with 10 years to maturity has a face value of $1,000.  The bond pays an...
A bond with 10 years to maturity has a face value of $1,000.  The bond pays an 8 percent semiannual coupon, and the bond has a 10.8 percent nominal yield to maturity.  What is the price of the bond today?
A bond with 30 years to maturity has a face value of $1,000. The bond pays...
A bond with 30 years to maturity has a face value of $1,000. The bond pays an 8 percent semiannual coupon, and the bond has a 7 percent nominal yield to maturity. What is the price of the bond today? DO NOT USE EXCEL
Consider a 7-year bond with face value $1,000 that pays an 8.4% coupon semi-annually and has...
Consider a 7-year bond with face value $1,000 that pays an 8.4% coupon semi-annually and has a yield-to-maturity of 6.9%. What is the approximate percentage change in the price of bond if interest rates in the economy are expected to increase by 0.40% per year? Submit your answer as a percentage and round to two decimal places. (Hint: What is the expected price of the bond before and after the change in interest rates?) Can you please explain with FV,...
~~~In Excel~~~~ Question 1. A US-Treasury bond with face value of $1,000 pays interest at an...
~~~In Excel~~~~ Question 1. A US-Treasury bond with face value of $1,000 pays interest at an annual rate of 5%. Coupons are paid twice per year. a. If this bond has 4 years to mature, what is the price of the bond if current yield to maturity is 4%? Calculate this by finding the value of coupons and principal separately. (12) b. If the coupon were instead paid once per year, what would be the price of the bond? ~~~In...
Jason has just bought a bond that pays 2% annual coupons with $1,000 face value and...
Jason has just bought a bond that pays 2% annual coupons with $1,000 face value and 30 years to maturity. (a) If the yield of the bond bought today was 3%, what was its purchase price? (b) One year later, the bond's YTM has dropped to 2.5%. If you sell the bond immediately after receiving the coupon, i) what is the bond’s current yield? ii) what is the bond’s capital gains yield (CGY)? iii) what is the bond’s total (holding...
Jason has just bought a bond that pays 2% annual coupons with $1,000 face value and...
Jason has just bought a bond that pays 2% annual coupons with $1,000 face value and 30 years to maturity. (a) If the yield of the bond bought today was 3%, what was its purchase price? (b) One year later, the bond's YTM has dropped to 2.5%. If you sell the bond immediately after receiving the coupon, i) what is the bond’s current yield? ii) what is the bond’s capital gains yield (CGY)? iii) what is the bond’s total (holding...
The Government of Canada 2-year coupon bond has a face value of $1,000 and pays annual...
The Government of Canada 2-year coupon bond has a face value of $1,000 and pays annual coupons of $30. The next coupon is due in one year. Currently, the one and two-year spot rates on Government of Canada zero coupon bonds are 5% and 5.5%. Use this information to answer part a) and b). a) What is the correct price for the coupon bond at time zero (immediately)? A) $925.46 B) $952.41 C) *$953.98 D) $971.68 E) $1009.54 b) What...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT