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

Yield to maturity (Expected/Current) Number of Years to Future Liability Future Liability 8% 10.00 $10,000.00 Coupon rate Maturity (Years) Face value Bond 1 6.00% 12 1,000 Bond 2 7.000% 18 Bond 3 8.00% 30 1,000 1,000 Yield to maturity (Expected/Current) Number of Years to Future Liability Future Liability 8% 10.00 $10,000.00 Coupon rate Maturity (Years) Face value Bond 1 6.00% 12 1,000 Bond 2 7.000% 18 Bond 3 8.00% 30 1,000 1,000