FINANCE

Using the Excel File:

1. Pick 3 stocks from the Most Actives List and download the last three years of  monthly adjusted prices for these stocks and S&P 500 Index to Table 1
2. Calculate the monthly retuns  of these three stocks in Table 1
3. Calculate the standard deviations of returns for three stocks and a portfolio with equal investment in three stocks  using Table 5, similar to the TESLA example we did in class. Use the excel function STDEVP to check your answer and enter your findings in Table 2
4. Use the CORREL Function to calculate the Correlation Coefficient of monthly returns for each pair of  stock and enter in Table 3. Whick pair provides the greatest gain from diversification? Why?
5.Calculate the  beta,  market variance and firm specific variance for three stocks and a portfolio with equal investment in three stocks  using the TREND function in Table 4