Please see attached. I need the excel formulas and answers. Thank you.

Problem 13-20 Consider the following stocks, all of which will pay a liquidating dividend in a year and Stock A Stock B Stock C Stock D Market Capitalization ($ million) 800 750 950 900 Expected Liquidating Dividend ($ million) 1,000 1,000 1,000 1,000 Beta 0.77 1.46 1.25 1.07 a. Calculate the expected return of each stock. b. What is the sign of the correlation between the expected return and market capitali a. Calculate the expected return of each stock. Expected return Stock A Expected return Stock B Expected return Stock C Expected return Stock D b. What is the sign of the correlation between the expected return and market capitali Correlation coefficient The sign of the correlation is Requirements 1. In cell E20, by using cell references, calculate the expected return of stock A (1 pt 2. To calculate the expected returns of stocks B thru D, copy cell E20 and paste it on 3. You will calculate the correlation between the expected return and the market capi using the function CORREL. In cell E27, by using the function CORREL and ce the correlation between the expected return and the market capitalization of the sto 4. To discern the sign of the correlation between the expected return and the market c stocks, you need to compare whether the correlation coefficient is greater or less th either Positive or Negative (1 pt.). g dividend in a year and nothing in the interim: eturn and market capitalization of the stocks? eturn and market capitalization of the stocks? ed return of stock A (1 pt.). y cell E20 and paste it onto cells E21:E23 (1 pt.). eturn and the market capitalization of the stocks by unction CORREL and cell references, calculate et capitalization of the stocks (1 pt.). d return and the market capitalization of the icient is greater or less than zero. In cell E28, type