7. The Excel file Portfolio Bond Immunization Data contains information about three bonds. Coupons are paid annually. 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 options performance in attempting to achieve immunization.

Please Show work in Excel

Data provided 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}