1. Use the index and stock prices to compute the cumulative and monthly returns of the S\&P500, AAPL, and PG. The return series need to be traceable to the input data. Returns cannot be computed for the first month but can be computed thereafter. For instance, say the initial price of a stock is X the first month, 1.05X in month 2 , and 1.12X in month 3 . Then, the cumulative (monthly) returns for months 2 and 3 are 5%(5%) and 12%(7%), respectively. (3 pts) 2. Use the cumulative returns data to create a figure showing the evolution of cumulative returns over time. The x-axis should reflect the time period. The y-axis should reflect returns. Plot separate series for the S\&P index, AAPL, and PG. The figure needs to be traceable to the input data on cumulative returns you created in question 1). (4 pts) 3. Using Excel formulas, compute the standard deviation for monthly returns for the S\&P, AAPL, and PG. Compute also the correlation coefficients of monthly returns between S\&P and AAPL, and S\&P and PG. Consider all the available monthly returns to compute the statistics. (4 pts) 4. Using the information from question 3), compute the estimated Beta for AAPL and PG. The estimates need to be traceable to the information from question 3. (4 pts) 1. Use the index and stock prices to compute the cumulative and monthly returns of the S\&P500, AAPL, and PG. The return series need to be traceable to the input data. Returns cannot be computed for the first month but can be computed thereafter. For instance, say the initial price of a stock is X the first month, 1.05X in month 2 , and 1.12X in month 3 . Then, the cumulative (monthly) returns for months 2 and 3 are 5%(5%) and 12%(7%), respectively. (3 pts) 2. Use the cumulative returns data to create a figure showing the evolution of cumulative returns over time. The x-axis should reflect the time period. The y-axis should reflect returns. Plot separate series for the S\&P index, AAPL, and PG. The figure needs to be traceable to the input data on cumulative returns you created in question 1). (4 pts) 3. Using Excel formulas, compute the standard deviation for monthly returns for the S\&P, AAPL, and PG. Compute also the correlation coefficients of monthly returns between S\&P and AAPL, and S\&P and PG. Consider all the available monthly returns to compute the statistics. (4 pts) 4. Using the information from question 3), compute the estimated Beta for AAPL and PG. The estimates need to be traceable to the information from question 3. (4 pts)