Question

Elliot Karlin is a​ 35-year-old bank executive who has just inherited a large sum of money. Having spent several years in the​ bank's investments​ department, he's well aware of the concept of duration and decides to apply it to his bond portfolio. In​ particular, Elliot intends to use $1 million of his inheritance to purchase 4 U.S. Treasury​ bonds:

1. An 8.59%​, 13-year bond​ that's priced at $1,091.27 to yield 7.48%.

2. A 7.795%​, 15-year bond​ that's priced at $1019.97 to yield 7.57%.

3. A​ 20-year stripped Treasury​ (zero coupon)​ that's priced at $199.67 to yield 8.22%.

4. A​ 24-year, 7.46% bond​ that's priced at $958.15 to yield 7.85%.

Note that these bonds are semiannual compounding bonds.

a. Find the duration and the modified duration of each bond.

b. Find the duration of the whole bond portfolio if Elliot puts $250,000 into each of the 4 U.S. Treasury bonds.

c. Find the duration of the portfolio if Elliot puts $300,000 each into bonds 1 and 3 and $200,000 each into bonds 2 and 4.

d. Which portfolio dash—b or c —should Elliot select if he thinks rates are about to head up and he wants to avoid as much price volatility as​ possible? Explain. From which portfolio does he stand to make more in annual interest​ income? Which portfolio would you​ recommend, and​ why?

a. The duration and modified duration can be calculated using a​ spreadsheet, such as Excel. It gives the precise duration measure because it avoids the​ rounding-off errors, which are inevitable with manual calculations.

Bond​ 1: 13​ years, 8.59%​, priced to yield 7.48%.

The duration of this bond is __ years. Round to two decimal​ places.)

The modified duration of this bond is __ years.​ (Round to two decimal​ places.)

Bond​ 2: 15​ years, 7.795% priced to yield 7.57%.

The duration of this bond is ___ years.​(Round to two decimal​ places.)

The modified duration of this bond is ___ years.(Round to two decimal​ places.)

Bond​ 3: 20​ years, zero​ coupon, priced to yield 8.22%.

The duration of this bond is __ years.​(Round to two decimal​ places.)

The modified duration of this bond is ___ years.​(Round to two decimal​ places.)

Bond​ 4: 24​ years, 7.46%​, priced to yield 7.85%.

The duration of this bond is __ years.(Round to two decimal​ places.)

The modified duration of this bond is ___ years.(Round to two decimal​ places.)

b. Find the duration of the whole bond portfolio if Elliot puts $250,000 into each of the 4 U.S. Treasury bonds.

The duration of this portfolio is __ years.(Round to two decimal​ places.)

c. Find the duration of the portfolio if Elliot puts $300,000 each into bonds 1 and 3 and $200,000 each into bonds 2 and 4.

The duration of this portfolio is __ years.(Round to two decimal​ places.)

Answer 1

For settlement and maturity date, let's assume all 4 bonds are purchased today and will mature at the end of their life.

for Bond 1, settlement date is today's date i.e. 8/12/2019 on which bond is purchased. bond's life is 13 years. so, after 13 years it will mature on maturity date 8/12/2032.

a. Duration and modified duration of all 4 bonds:

b. Total portfolio value is $1,000,000 and $250,000 invested in each of the 4 bonds. So weight of each bond in the portfolio is $250,000/$1,000,000 = 0.25.

Portfolio duration = weight of the bond*duration of the bond

Portfolio duration = 0.25*8.3 + 0.25*9.16 + 0.25*20 + 0.25*11.26 = 2.075 + 2.29 + 5 + 2.815 = 12.18

c. weight of bond 1 and 3 = $300,000/$1,000,000 = 0.30 each

Weight of bond 2 and 4 = $200,000/$1,000,000 = 0.20 each

Portfolio duration = 0.30*8.3 + 0.20*9.16 + 0.30*20 + 0.20*11.26 = 2.49 + 1.832 + 6 + 2.252 = 12.57

d. Elliot should select portfolio b if he thinks rates are about to head up and he wants to avoid as much price volatility as​ possible. Portfolio b has lower duration than portfolio c. Interest rate and bond price have inverse relation. if interest rates rise then bond having longer duration will fall in value more than bond having shorter duration and vice versa.

So, portfolio b which has shorter duration will fall in value less than portfolio c.

From portfolio c he stands to make more in annual interest​ income because it has higher weight in bond 1 which pays the highest coupon interest.

Coupon rates are fixed. so portfolio will get same coupon interest irrespective of higher interest rates in future.

hence portfolio b is recommended because it will fall in value less when interest rates rise.