Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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,

image text in transcribed
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 four U.S. Treasury bonds: 1. An 8.65%, 13-year bond that's priced at $1,095.33 to yield 7.49%. 2. A 7.847%, 15-year bond that's priced at $1023.69 to yield 7.58% 3. A 20-year stripped Treasury (zero coupon) that's priced at $197.76 to yield 8.27%. 4. A 24-year, 7.46% bond that's priced at $962.31 to yield 7.81%. 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 four U.S. Treasury bonds c. Find the duration of the portfolio if Elliot puts $320,000 each into bonds 1 and 3 and $180,000 each into bonds 2 and 4. d. Which portfolioborshould 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 incomo? 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. Press Continue to see more 11 parts remaining Continue 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 four U.S. Treasury bonds: 1. An 8.65%, 13-year bond that's priced at $1,095.33 to yield 7.49%. 2. A 7.847%, 15-year bond that's priced at $1023.69 to yield 7.58% 3. A 20-year stripped Treasury (zero coupon) that's priced at $197.76 to yield 8.27%. 4. A 24-year, 7.46% bond that's priced at $962.31 to yield 7.81%. 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 four U.S. Treasury bonds c. Find the duration of the portfolio if Elliot puts $320,000 each into bonds 1 and 3 and $180,000 each into bonds 2 and 4. d. Which portfolioborshould 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 incomo? 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. Press Continue to see more 11 parts remaining Continue

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Analysis And Modeling Using Excel And VBA

Authors: Chandan Sengupta

2nd Edition

047027560X, 978-0470275603

More Books

Students also viewed these Finance questions

Question

Understand the functions of human resources management.

Answered: 1 week ago