Please show process and formulas in Excel. Below is Ch8_bootstrap.xlsm

Use Ch8_bootstrap.xlsm file and the matrix approach to do this problem. Example 8.2 in the textbook will also help: Use the following data for settlement date May 28, 2010 to answer the following questions: (assume semi-annual payments, and par values of $100 ) a) Compute the annualized yield to maturity of the bonds given above. (10 points) b) Estimate the term-structure of interest rates using the coupon bonds given above. (10 points) c) Plot the yield curve and term structure on the same graph. (10 points) d) Estimate the price of a 0.75%, November 30, 2011 maturity bond as of May 28, 2010. (10 points) Use Ch8_bootstrap.xlsm file and the matrix approach to do this problem. Example 8.2 in the textbook will also help: Use the following data for settlement date May 28, 2010 to answer the following questions: (assume semi-annual payments, and par values of $100 ) a) Compute the annualized yield to maturity of the bonds given above. (10 points) b) Estimate the term-structure of interest rates using the coupon bonds given above. (10 points) c) Plot the yield curve and term structure on the same graph. (10 points) d) Estimate the price of a 0.75%, November 30, 2011 maturity bond as of May 28, 2010. (10 points)