please view both pics

This Question: 5 pts 15 of 20 This You need to estimate the equity cost of capital for XYZ Corp. You have the following data available regarding past returns. a. What was XYZ's average historical return? b. Compute the market's and XYZs excess returns for each year. Estimate XYZ's beta. c. Estimate XYZs historical alpha. d. Suppose the current risk-free rate is 4%, and you expect the markets return to be 10% Use the CAPM to estimate an expected return for XYZ Corp's stock. e. Would you base your estimate of XYZ's equity cost of capital on your answer in part (a) or in part (d)? a. What was XYZ's average historical return? XYZs average historical retum was% Round to one decimal place) b. Compute the market's and XYZs excess returns for each year The market's excess return for 2011 was 1% (Round to the nearest integer ) The market's excess return for 2012 was %. Round to the nearest integer) E Data Table (Click on the icon located on the top-right comer of the data table below in order to copy its contents into a spreadsheet) XYZ's excess return for 2011 was 11% (Round to the nearest integer) Year 2011 2012 Risk-free Return 2% 196 Market Return XYZ Return 7% 9% XYZ's excess return for 2012 was 1%. (Round to the nearest integer ) -32% -45% Estimate XYZ's beta XYZ's beta is[] (Round to two decimal places) Print Done Click to select your answer(s) Save for Later DELL