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 9 years, subject to the condition that the proportion invested in Bond 2 is 22% larger than the proportion invested in Bond 1. Show work in Excel please.

data in picture

\begin{tabular}{|l|c|c|c|} \hline Yield to maturity (Expected/Current) & 9% & & \\ \hline Number of Years to Future Liability & 9.00 & & \\ \hline Future Liability & $15,000.00 & & \\ \hline & & & \\ \hline & & & \\ \hline & Bond 1 & Bond 2 & Bond 3 \\ \hline Coupon rate & 6.00% & 8.000% & 10.00% \\ \hline Maturity (Years) & 10 & 20 & 25 \\ \hline Face value & 1,000 & 1,000 & 1,000 \\ \hline \end{tabular}