I need a little help this week in my FINC 600 class. Please provide answers in the excel attachment, each tab requires answers.

Problem 11-49 Consider a portfolio consisting of the following three stocks: HEC Corp Green Midget AliveAndWell Portfolio Weight 0.25 0.35 0.40 Volatility 12% 25% 13% The volatility of the market portfolio is 10% and it has an expected return of 8%. The ris a. Compute the beta and expected return of each stock. b. Using your answer from part a, calculate the expected return of the portfolio. c. What is the beta of the portfolio? d. Using your answer from part c, calculate the expected return of the portfolio and v to part b. Volatility of market portfolio Market expected return Risk-free rate 10% 8% 3% a. Compute the beta and expected return of each stock. Stock HEC Corp Green Midget AliveAndWell Beta E[R] b. Using your answer from part a, calculate the expected return of the portfolio. Expected return c. What is the beta of the portfolio? Beta d. Using your answer from part c, calculate the expected return of the portfolio and v to part b. Expected return Match? Requirements 1. In cell D24, by using relative and absolute cell references, calculate the beta for H 2. To calculate the betas for Green Midget and AliveAndWell, copy cell D24 and pas 3. In cell E24, by using relative and absolute cell references, calculate the expected r 4. To calculate the expected returns for Green Midget and AliveAndWell, copy cell E E25:E26 (1 pt.). 5. Calculate the expected return of the portfolio by using the function SUMPRODU function SUMPRODUCT and cell references, calculate the expected return of the 6. Calculate the beta of the portfolio by using the function SUMPRODUCT. In cell SUMPRODUCT and cell references, calculate the beta of the portfolio (1 pt.). 7. In cell D38, by using cell references, calculate the expected return of the portfolio 8. To verify that your answer for part (d) matches your answer for part (b), you need of the portfolio in part (d) with the expected return of the portfolio in part (b). In c pt.). e stocks: Correlation with Market Portfolio 0.4 0.6 0.5 as an expected return of 8%. The risk-free rate is 3%. stock. xpected return of the portfolio. xpected return of the portfolio and verify that it matches your answer stock. xpected return of the portfolio. xpected return of the portfolio and verify that it matches your answer l references, calculate the beta for HEC Corp (1 pt.). liveAndWell, copy cell D24 and paste it onto cells D25:D26 (1 pt.). references, calculate the expected return for HEC Corp (1 pt.). idget and AliveAndWell, copy cell E24 and paste it onto cells by using the function SUMPRODUCT. In cell D30, by using the , calculate the expected return of the portfolio (1 pt.). function SUMPRODUCT. In cell D34, by using the function e the beta of the portfolio (1 pt.). the expected return of the portfolio (1 pt.). s your answer for part (b), you need to compare the expected return eturn of the portfolio in part (b). In cell D39, type either Yes or No (1 Problem 12-4 Suppose all possible investment opportunities in the world are limited to the five stocks liste below. What does the market portfolio consist of? Stock A B C D E Price/Share ($) 10 20 8 50 45 Shares Outstanding (millions) 10 12 3 1 20 Market value (million) Share of Market portfolio Stock A Stock B Stock C Stock D Stock E Total Requirements 1. In cell D17, by using cell references, calculate the market value of stock A (1 pt.). 2. To calculate the market values of stocks B thru E copy cell D17 and paste it onto cell pt.). 3. You will calculate the total market value of all the stocks in the market portfolio by u SUM. In cell D22, by using the function SUM and cell references, calculate the total all the stocks in the market portfolio (1 pt.). 4. In cell E17, by using absolute and relative cell references, calculate the share (percen in the market portfolio (1 pt.). 5. To calculate the share (percentage) of stocks B thru E in the market portfolio, copy ce it onto cells E18:E21 (1 pt.). are limited to the five stocks listed in the table market value of stock A (1 pt.). py cell D17 and paste it onto cells D18:D21 (1 ocks in the market portfolio by using the function cell references, calculate the total market value of ences, calculate the share (percentage) of stock A E in the market portfolio, copy cell E17 and paste 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