Please show work and formulas on excel

XYZ co has 12,000 shares of common stocks. the stock has a standard deviation of return of 25% and the stock index has a standard deviation return of 15%. The correlation coefficient between stock return and stock index return is 0.75. The stock is expected to pay dividend of $4 in one year and $4 in two years. Its expected price in two years is $45, The risk free rate is 3%. The stock market index has an expected return of 12%. 4. a. Estimate the undiversifiable risk of XYZ stock. b. Determine the beta of XYZ stock. 5. Use the security market line or the capital asset pricing model to determine a. the risk premium for stock XYZ and b. the required rate of return of the stock. 6. Determine a. the per share value of the stock and b. the total market value of all stocks. 7. a. How much debt relative to total value of debt and equity combined does XYZ have? b. How much equity relative to total value of debt and equity combined does XYZ have? 8. Determine the weighted average cost of capital