As the bond portfolio manager you are concerned about the impact of changing interest rates on your portfolio value. Use the information below and excel functions to determine the value of the current bond portfolio, the portfolio yield and the portfolio duration. this assignment you are assigned a portfolio of bonds. Assuming that insterest rate changes will impact all bonds equally what is the value of the bond portfolio if interest rates increase by 0.25% or 0.5%? From the additional bonds provided, which bond, if added to the bond portfolio will help insulate the portfolio from interest rate risk?

Please could you please check the answers are already answered and answer the last queation. The answers should be solved in the yelloew shadded cell

D an a Excel Project 421 Search Shee Home Insert Page Layout Formulas Data Revie View Insert Pa Calidori (Bodya 1 A- - - - - - - - 6. Wrap Text General B 1 U -- A A = = = "a Merge & Center $ % % % Conditional Forma Cell Formatting as Table Styles fIf you wanted to reduce the interest rate sensitivity of your bond portfolio which of the following bonds would you buy? Why? Ti Format Sort & Filter A38 1 Excel Project Due: October 26, 2017 As the bond portfolio manager you are concerned about the impact of changing interest rates on your portfolio value. Use the information below and excel functions to determine the value of the current bond portfolio, the portfolio yield and the portfolio duration, this assignment you are assigned a portfolio of bondsAssuming that insterest rate changes will impact all bonds equally what is the value of the bond portfolio if interest rates increase by 0.25% or 0.5%? From the additional bonds provided, which bond, if 2 added to the bond portfolio will help insulate the portfolio from interest quantity of Bonds in CouponsYear Maturity Portfolio Portfolio Duration Years to Maturity Boeing 3300% 2 3//35 a 3.39% 10/17/17 S s8.81 $ 100.00 500 $ 49,40500 0.005777419 13,27481848 $ 2.6517.3382192 $ 45,797.60 0.006727204 12.08001BOGS 17.14520548 SBB,001.60 0.013214906 16.77126023 $ 5,9727.6795 205 $ 33,037.95 0.002198592 2.119356327 $ 0.282161643836 $ 30,949.83 0.007218105 11.545B8927 $ 1.4520.26027397 I s $ 247,191.98 0.036136228 $ 1259 11 What is the value of the bond portfolio? Answ $ 247,19198 14 what is the portfolio yield? Answ 3.614% 17 What is the duration of the bond portfolio? Answ 12.59 T O T 20 if interest 21 Mswer Name Boeing, 23 Amazon 24 Starbucks 25 Costco 26 Nordstrom rease by 0.25% whet is the value of bond portfolio Yield Price Total value .64100% T $95.54 $47,818 .36 3.88100% $1143 $44,57154 3.96200, $105.65 $84,520.88 189500% $9959 $32,864.34 60500% $1145 $30,000.65 $239,865.76 T 29 if interest Mswer Name 31 Boeing Amazon rease by 0.50% whet is the value of bond portfolio Yield Price Total value 3.891% $92.58 $46,292 50 4.131% 108.16 $13264.43 Ready 100% D an a Excel Project 421 Search Shee Home Insert Page Layout Formulas Data Revie View Insert Pa Calidori (Bodya 1 A- - - - - - - - 6. Wrap Text General B 1 U -- A A = = = "a Merge & Center $ % % % Conditional Forma Cell Formatting as Table Styles fIf you wanted to reduce the interest rate sensitivity of your bond portfolio which of the following bonds would you buy? Why? Ti Format Sort & Filter A38 1 Excel Project Due: October 26, 2017 As the bond portfolio manager you are concerned about the impact of changing interest rates on your portfolio value. Use the information below and excel functions to determine the value of the current bond portfolio, the portfolio yield and the portfolio duration, this assignment you are assigned a portfolio of bondsAssuming that insterest rate changes will impact all bonds equally what is the value of the bond portfolio if interest rates increase by 0.25% or 0.5%? From the additional bonds provided, which bond, if 2 added to the bond portfolio will help insulate the portfolio from interest quantity of Bonds in CouponsYear Maturity Portfolio Portfolio Duration Years to Maturity Boeing 3300% 2 3//35 a 3.39% 10/17/17 S s8.81 $ 100.00 500 $ 49,40500 0.005777419 13,27481848 $ 2.6517.3382192 $ 45,797.60 0.006727204 12.08001BOGS 17.14520548 SBB,001.60 0.013214906 16.77126023 $ 5,9727.6795 205 $ 33,037.95 0.002198592 2.119356327 $ 0.282161643836 $ 30,949.83 0.007218105 11.545B8927 $ 1.4520.26027397 I s $ 247,191.98 0.036136228 $ 1259 11 What is the value of the bond portfolio? Answ $ 247,19198 14 what is the portfolio yield? Answ 3.614% 17 What is the duration of the bond portfolio? Answ 12.59 T O T 20 if interest 21 Mswer Name Boeing, 23 Amazon 24 Starbucks 25 Costco 26 Nordstrom rease by 0.25% whet is the value of bond portfolio Yield Price Total value .64100% T $95.54 $47,818 .36 3.88100% $1143 $44,57154 3.96200, $105.65 $84,520.88 189500% $9959 $32,864.34 60500% $1145 $30,000.65 $239,865.76 T 29 if interest Mswer Name 31 Boeing Amazon rease by 0.50% whet is the value of bond portfolio Yield Price Total value 3.891% $92.58 $46,292 50 4.131% 108.16 $13264.43 Ready 100%