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'snvestments departmenhe's well aware of the concept of duration and decides to apply it to his bond portfolio. In particularElliot intends to use $1 million of his inheritance to purchase 4 U.S. Treasury bonds: 1. An 8.64%, 13-year bond that'spriced at $1,094.51 to yield 7.49% 2. A 7.863%, 15-year bond that'spriced at $1026.01 to yield 7.57% 3. A 20-year stripped Treasury (zerocoupon) that'spriced at $197.76 to yield 8.27%. 4. A 24-year, 7.42% bond that'spriced at $954.89 to yield 7.84% 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 Eliot puts $250,000 into each of the 4 U.S. Treasury bonds. c. Find the duration of the portfolio if Eliot puts $360,000 each into bonds 1 and 3 and $140,000 each into bonds 2 and 4. d. Which portfolioborcshould Eliot select if he thinks rates are about to head up and he wants to avoid as much price volatility as possible Explain. From which a. The duration and modified duration can be calculated using a spreadsheetuch 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.64%, priced to yield 7.49%. The duration of this bond is years. (Roundo two decimal places.) The modified duration of this bond is years. (Roundo two decimal places.) Bond 2:15 years 7,863% priced to yield 7.57% The duration of this bond is years. (Roundo two decimal places.) The modified duration of this bond is years. (Roundo two decimal places.) Bond 3:20 years zero couponpriced to yield 3.27%. The duration of this bond is years. (Roundo two decimal places.) The modified duration of this bond is years. (Roundo two decimal places.) Bond 4:24 years7.42%, priced to yield 7.84% The duration of this bond is [years. (Roundo two decimal places.) The modified duration of this bond is years. (Roundo two decimal places.) b. Find the duration of the whole bond portfolio it Eliot puts $250,000 into each of the 4 U.S. Treasury bonds The duration of this portfolio is years. (Roundo two decimal places.) c. Find the duration of the portfolio if Ellot puts $360,000 each into bonds 1 and 3 and $140,000 each into bonds 2 and 4. The duration of this portfolio is years. (Roundo two decimal places.) d. Which portfolio the portfolio in part b or the portfolio in part o--should Eliot select it he thinks rates are about to head up and he wants to avoid as much price volatility as possible?(Choosthe best answer below.) O A. He should invest in the portfolio in parte. The portfolio in part b has a higher duration than the portfolio in part e. It rates are about to rise then it is safer to invest in the portfolio in parte, because it would be less price volatile than the other portfolio OB. He should invest in either portfolio. The portfolio in parte has a higher duration than the portfolio part b. If rates are about to rise, then it is equally sado to invest in either portfoliobecause both portfolios would be equally price volatie OC. He should invest in the portfolio in parte. The portfolio in parte 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 OD. He should invest in the portfolio in part b. The portfolio in parte 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