a. The duration and modified duration can be calculated using a spreadsheet, such as Excel. It...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 calculation Bond 1: 13 years, 8.61%, priced to yield 7.45%. 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.789% priced to yield 7.56%. 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.23%. 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.49%, priced to yield 7.81%. 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 $330,000 each into bonds 1 and 3 and $170,000 each into bonds 2 and 4. The duration of this portfolio is years. (Round to two decimal places.) d. Which portfoliothe portfolio in part b or the portfolio in part c-should Elliot select if he thinks rates are about to head up and he wants to avoid as much price volatility as possible? (Choose the best answer below.) A. He should invest in either portfolio. The portfolio in part c has a higher duration than the portfolio part b. If rates are about to rise, then it is equally safe to invest in either portfolio, because both portfolios would be equally price volatile. B. He should invest in the portfolio in part b. The portfolio in part c has a higher duration than the portfolio in part b. If rates are about to rise, then it is safer to invest in the portfolio in part b, because it would be less price volatile than the other portfolio. C. He should invest in the portfolio in part c. The portfolio in part b has a higher duration than the portfolio in part c. If rates are about to rise, then it is safer to invest in the portfolio in part c, because it would be less price volatile than the other portfolio. D. He should invest in the portfolio in part c. The portfolio in part c has a higher duration than the portfolio in part b. If rates are about to rise, then it is riskier to invest in the portfolio in part b, because it would be more price volatile than the other portfolio. Treasury bonds: 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. 1. An 8.61%, 13-year bond that's priced at $1,095.54 to yield 7.45%. 2.A 7.789%, 15-year bond that's priced at $1020.34 to yield 7.56%. 3. A 20-year stripped Treasury (zero coupon) that's priced at $199.28 to yield 8.23%. 4. A 24-year, 7.49% bond that's priced at $965.54 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 4 U.S. Treasury bonds. c. Find the duration of the portfolio if Elliot puts $330,000 each into bonds 1 and 3 and $170,000 each into bonds 2 and 4. d. Which portfolio-b or cshould 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 calculation Bond 1: 13 years, 8.61%, priced to yield 7.45%. 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.789% priced to yield 7.56%. 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.23%. 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.49%, priced to yield 7.81%. 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 $330,000 each into bonds 1 and 3 and $170,000 each into bonds 2 and 4. The duration of this portfolio is years. (Round to two decimal places.) d. Which portfoliothe portfolio in part b or the portfolio in part c-should Elliot select if he thinks rates are about to head up and he wants to avoid as much price volatility as possible? (Choose the best answer below.) A. He should invest in either portfolio. The portfolio in part c has a higher duration than the portfolio part b. If rates are about to rise, then it is equally safe to invest in either portfolio, because both portfolios would be equally price volatile. B. He should invest in the portfolio in part b. The portfolio in part c has a higher duration than the portfolio in part b. If rates are about to rise, then it is safer to invest in the portfolio in part b, because it would be less price volatile than the other portfolio. C. He should invest in the portfolio in part c. The portfolio in part b has a higher duration than the portfolio in part c. If rates are about to rise, then it is safer to invest in the portfolio in part c, because it would be less price volatile than the other portfolio. D. He should invest in the portfolio in part c. The portfolio in part c has a higher duration than the portfolio in part b. If rates are about to rise, then it is riskier to invest in the portfolio in part b, because it would be more price volatile than the other portfolio. Treasury bonds: 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. 1. An 8.61%, 13-year bond that's priced at $1,095.54 to yield 7.45%. 2.A 7.789%, 15-year bond that's priced at $1020.34 to yield 7.56%. 3. A 20-year stripped Treasury (zero coupon) that's priced at $199.28 to yield 8.23%. 4. A 24-year, 7.49% bond that's priced at $965.54 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 4 U.S. Treasury bonds. c. Find the duration of the portfolio if Elliot puts $330,000 each into bonds 1 and 3 and $170,000 each into bonds 2 and 4. d. Which portfolio-b or cshould 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?
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
Choose four of your identified transactions in real estate trust account and discuss ways thatinaccuracies could occur and what could be done to prevent the
-
8. Consider countries X and Y with risk-free rates of 8 and 10 percent, respectively. The future price (Currency X/ Currency Y) for a contract deliverable in 3 months is the same as the current...
-
Please make sure that you show step by step work. Ive looked everywhere and I can not find an answer that shows step by step, where each number comes from, or how is calculated. Please be use as much...
-
Consider the following independent situations found during audit testing of Faran Ltd, which has a balance date of 30 June 2019. Assume that all the situations are material. (i)Recent industrial...
-
Pannier Company is the parent company that owns an 80% interest in Jodestar Company. The interest was acquired at book value, and the simple equity method is used to record the ownership interest....
-
Why do proponents of the Beyond Budgeting movement recommend abandoning traditional budgets?
-
Repeat Problem 14.D2 except for countercurrent process with a. Three stages. b. Eight stages. Data From Problem 14.D2 Alumina solids are being washed to remove \(\mathrm{NaOH}\) from liquid entrained...
-
Determine how current values might be determined for investments, land, buildings, equipment, patents, copyrights, trademarks, and franchises. How might the use of current values in the accounting...
-
7. The NPV and payback period What information does the payback period provide? Suppose you are evaluating a project with the expected future cash inflows shown in the following table. Your boss has...
-
Mary purchased a 1/3 interest in partnership for $500 cash. What is Jane's intial outside basis and the balance to her capital account at the time of purchase? In the absence of a Section 754...
-
Distinguish between traditional, behavioral, and interactionist views of team conflict. How might each explain and deal with an episode of project team conflict?
-
Choose any business organization and describe the business or organization you are analyzing. 1. Analyze social media activities of the business and suggest improvements. 2. What are the strategies...
-
Why is effective communication from customer service representatives especially critical to customer satisfaction and loyalty? Explain two communication channels that you feel are important in order...
-
Choose a Destination Countryand a product or service that is available in Canada and that you believe would be a good fit/opportunity for a target segment(s) in that country. (it does not need to be...
-
Describe shortly the ecosystems for reagent manufacturing in the U.S., Canada, and Mexico, specifically the laboratory reagent suppliers. Who are the main players and how influential are they in...
-
Use an excel template to record the following transactions and create financial statements for Year 1. Accume th
-
Write the binomial probability in words. Then, use a continuity correction to convert the binomial probability to a normal distribution probability. P(x 110)
-
The Mann Corporation began operations in 2015.Information relating to the companys purchases of inventory and sales of products for 2015 and 2016 is presented below. Calculate the weighted-average...
-
Presented below is financial data for two companies that are identical yma in every respect except that Company X uses the FIFO method to value its inventory and Company Z uses the LIFO method to...
-
The following financial information is taken from the annual report of Intel Corporation: Using the above data, calculate the companys inventory turnover, inventory-on-hand period, and gross profit...
Study smarter with the SolutionInn App