. Calculate and analyse the betas of each of these stocks (you need to explain what is the meaning of these betas latest answer 2022

  Calculating Betas and Expected Stock Returns for Microsoft Corporation (MSFT), Walmart Inc. (WMT), General Motors Company (GM), and Johnson & Johnson (JNJ).  A. Collect 5 years of monthly data for each of these stocks and S&P500 Index, (explain meaning using corporate finance terminology)Order similar from  B. Calculate and analyse the betas of each of these stocks (you need to explain what is the meaning of these betas). (Writing focused so write more on this than other Q’s)C. Calculate the average annual returns and standard deviations for all 4 stocks and S&P500 Index. (Explain meaning of these and reasoning)Order similar from  Order similar from  D. Calculate the required rate of return based on CAPM for each of the 4 stocks. You can assume the risk-free rate of 1%. (Write about answer and its meaning and what this entails) Order similar from  E. Analyse which of these stocks have been a good/bad investment over the last 5 years.  (Discuss and analyse is writing focused so write more on this one than other Q’s) Order similar from