he Excel file Portfolio Bond Immunization Data ontains information about three bonds. Coupons are paid nually. Use this data to: a. Compute the amount to be invested to meet the future liability noted in the data. This future liability is due in 12 years. b. Find a combination of Bond 1 and Bond 2 having a target duration of 12 years. c. Find a combination of Bond 1 and Bond 3 having a target duration of 12 years. d. Perform an analysis using a data table and an accompanying graph to determine which of the following options (i.e., a portfolio consisting of Bond 1 and Bond 2, a portfolio consisting of Bond 1 and Bond 3 , or a portfolio consisting of Bond 2) would be preferred to attempt to immunize this obligation. i. Construct a data table by varying the yield to maturity that shows the value of each option at the end of 12 years. Use yield to maturity values ranging from 0% to 15% in 1% increments. ii. Based on your data table, construct a graph that demonstrates the performance of these 3 options. iii. Analyze each option's performance in attempting to achieve immunization. \begin{tabular}{|c|c|c|c|} \hline \multicolumn{2}{|c|}{ PORTFOLIO BOND IMMUNIZATION DATA - Fall 2023} & & \\ \hline Yield to maturity (Expected/Current) & 7% & & \\ \hline Number of Years to Future Liability & 12.00 & & \\ \hline \multirow{2}{*}{\begin{tabular}{l} Future Liability \\ \end{tabular}} & $15,000.00 & & \\ \hline & Bond 1 & Bond 2 & Bond 3 \\ \hline Coupon rate & 4.00% & 5.00% & 6.00% \\ \hline Maturity (Years) & 14 & 25 & 30 \\ \hline Face value & 1,000 & 1,000 & 1,000 \\ \hline \end{tabular}