Please help estimate XYZ'sbeta - I am getting stuck . I could also use help with problems c-e, I am attempting to calculate it and it is not making sense.

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 XYZ 's excess returns for each year. Estimate XYZ 's beta. c. Estimate XYZ's historical alpha. d. Suppose the current risk-free rate is 3%, and you expect the market's return to be 8%. 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? XYZ 's average historical return was \%. (Round to one decimal place.) b. Compute the market's and XYZ's excess returns for each year. The market's excess return for 2007 was The market's excess return for 2008 was %. (Round to the nearest integer.) 1. (Round to the nearest integer.) Data table (Click on the following icon (Click on the following icon in order to copy its contents into a spreadsheet.) XYZ's excess return for 2007 was XYZ's excess return for 2008 was Estimate XYZ's beta. XYZ's beta is . (Round to two decimal places.) \%. (Round to the nearest integer.) \%. (Round to the nearest integer.)