Using at least three of the bonds, construct an immunized portfolio for an investor with an investment horizon equal to three (3) years. Compute (a) the expected yield of the portfolio you construct and (b) the total amount an investor must invest in each bond in such a portfolio if s/he faces a liability equal to $100,000 in three years.

$, C, Q Excel File Edit View Insert Format Tools Data Window Help .. AutoSave@c rr O, DRe 84%)1. Mon 2:14 PM Project 3 Q Search Sheet Insert Draw Page Layout Formulas Data Review View Developer ShareA Cu Calibri (Body , | 12 , A-Ar - = - AutoSum A7 Wrap Text General Copy Format B I U Cond tional Format Cell Formatting as Table Styles Clear Filter 1 Coupon Maturity Price .375 23119 0.9892 Yield %) Coupon value maturity period price one verrate Duration Weight 18.09740518 0.22103 Yield curve S21.88 1.989041096 $ 989.20 5.3678 12/31/20 1.0150 5.20% S30.003.994520548 S 1,015.00 2.8982 5.25 12/31/21 $ 0.8529 5.58% s262s s994s20s48 $852.87 28348 7.75 12/31/22 $0.8948 5.54% 538.75| 7.994520548 $894.76| 2.8185 5.375123123 $0.9818 5.80%, S26.88 : 9.994520548| $981.80 , 2.7949. 0.787674285 . 14.82518106 0.18107 18.0866042 0.2209 10.36688857 0.12662 8 current date 9 par value 10 Interest rate 1219 0.1 12 13 Meturity Period 15 16 18 26 35 Sheett Ready IT + 100% $, C, Q Excel File Edit View Insert Format Tools Data Window Help .. AutoSave@c rr O, DRe 84%)1. Mon 2:14 PM Project 3 Q Search Sheet Insert Draw Page Layout Formulas Data Review View Developer ShareA Cu Calibri (Body , | 12 , A-Ar - = - AutoSum A7 Wrap Text General Copy Format B I U Cond tional Format Cell Formatting as Table Styles Clear Filter 1 Coupon Maturity Price .375 23119 0.9892 Yield %) Coupon value maturity period price one verrate Duration Weight 18.09740518 0.22103 Yield curve S21.88 1.989041096 $ 989.20 5.3678 12/31/20 1.0150 5.20% S30.003.994520548 S 1,015.00 2.8982 5.25 12/31/21 $ 0.8529 5.58% s262s s994s20s48 $852.87 28348 7.75 12/31/22 $0.8948 5.54% 538.75| 7.994520548 $894.76| 2.8185 5.375123123 $0.9818 5.80%, S26.88 : 9.994520548| $981.80 , 2.7949. 0.787674285 . 14.82518106 0.18107 18.0866042 0.2209 10.36688857 0.12662 8 current date 9 par value 10 Interest rate 1219 0.1 12 13 Meturity Period 15 16 18 26 35 Sheett Ready IT + 100%