8. The Excel file Question 8 Data Project 3 contains information about three bonds. 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 8 years. b. Find a combination of Bond 1 and Bond 2 having a target duration of 8. c. Find a combination of Bond 1 and Bond 3 having a target duration of 8. d. Perform an analysis using a data table and an accompanying graph to determine which portfolio 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 portfolio at the end of 8 years. ii. Based on your data table, construct a graph that demonstrates the performance of these two portfolios. e. Explain which portfolio you prefer to use to attempt to immunize this obligation which is due in 8 years. f. Comment on each portfolio's performance. 8. The Excel file Question 8 Data Project 3 contains information about three bonds. 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 8 years. b. Find a combination of Bond 1 and Bond 2 having a target duration of 8. c. Find a combination of Bond 1 and Bond 3 having a target duration of 8. d. Perform an analysis using a data table and an accompanying graph to determine which portfolio 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 portfolio at the end of 8 years. ii. Based on your data table, construct a graph that demonstrates the performance of these two portfolios. e. Explain which portfolio you prefer to use to attempt to immunize this obligation which is due in 8 years. f. Comment on each portfolio's performance