Please show all calculations

Elliot Karlin is a 35yeardd bank exeomive wi'Io has just inherited a large sum of money. Having spent several years in the bank's investments department, he's well aware of the conceptof duration and decides to apply itto his bond portfolio. In paltiwiar, Elliot intends to use 51 million of his inheritance to purchase 4 US. Treasury bonds: 1. An 8.64%, 13year bond that's priced at $1,094.51 toyield 149%. 2. A?.?73%, 15year bond that's priced at $1013.02to yield ?.5?%. 3. A 20year stripped Treasury (zero coupon) that's priced at $193.14 to yield 3.26%. 4. A 24-year, 147% bond that's priced at $961.30 to yield 7.03%. Note that these bonds are semiannual compounding bonds. a. Find the duration and the modied duration of each bond. b. Find the duration of the whole bond portfolio if Elliot puts $250,000 into each of the 4 U.3. Treasury bonds. 1:. Find the duration ofthe portfolio ifElliot puts $340,000 each into bonds 1 and 3 and 5160,0110 each into bonds 2 and 4. d. Which portfoliob or cshould Elliot select it 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 portlodio 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.64%, priced to yield 7.49%. 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.773% 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.26%. The duration of this bond is 20 years. (Round to two decimal places.) The modified duration of this bond is 18.47 years. (Round to two decimal places.) Bond 4: 24 years, 7.47%, priced to yield 7.83%. 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 D years. {Round to two decimal planes} 1:. Find the duration of the portfolio if Elliot puts $34lil each into bonds 1 and 3 and $150,000 each into bonds 2 and 4. The duration of this portfolio is D years. {Round to two decimal places}