10

PLEASE DO ONLY IN EXCEL ! And write what formulas used in the table, not just show the numbers!!

Beta Estimation 10. You need to estimate the equity cost of capital for XYZ Corp. You have the following data available regarding past returns: Problems 471 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 4%, 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)? How does your answer to part (c) affect your estimate? Explain