Repeat problem 31, but for a value-weighted portfolio. Use the data from problem 30 to create a portfolio in which you invest $100 in each stock. Calculate the value of each stock investment each month ($100 × [1 + monthly rate of return]) and the value of the portfolio each month (sum of the value of each stock investment each month). Calculate the monthly rate of return on your portfolio. Using that data, calculate portfolio rate of return, calculate its statistics and compare them to the stocks. Compare the results to those in problem 31.
Use the monthly returns of the 5 companies you chose in the previous question to look at the return on an equally weighted portfolio of the 5 stocks (that is, a portfolio with equal investment in each stock each month). The portfolio rate of return each month is the equal-weighted average of the stocks’ rates of return. Use Excel to calculate the portfolio’s average return and standard deviation. Compare the portfolio statistics that of those of the stocks. What evidence of portfolio diversification do you find?