1. The Excel file Portfolio Bond Weight Calculation Data contains information about three bonds. Coupons are paid annually. Use matrix algebra and this data to construct a portfolio consisting of Bond 1, Bond 2, and Bond 3 that has a duration of 11 years, subject to the condition that the proportion invested in Bond 2 is 10% larger than the proportion invested in Bond

D A B 1 Portfolio Bond Weight Calculation Data - PROJECT 3 - Fall 2021 2 3 Yield to maturity (Expected/Current) 7% 4 Number of Years to Future Liability 11.00 5 Future Liability $20,000.00 6 7 8 Bond 1 Bond 2 9 Coupon rate 5.00% 7.000% 10 Maturity (Years) 12 25 11 Face value 1,000 1,000 12 13 Bond 3 8.00% 28 1,000 D A B 1 Portfolio Bond Weight Calculation Data - PROJECT 3 - Fall 2021 2 3 Yield to maturity (Expected/Current) 7% 4 Number of Years to Future Liability 11.00 5 Future Liability $20,000.00 6 7 8 Bond 1 Bond 2 9 Coupon rate 5.00% 7.000% 10 Maturity (Years) 12 25 11 Face value 1,000 1,000 12 13 Bond 3 8.00% 28 1,000