All my stocks should be done in the last 5 years range please, The 5 stocks that need to be used to calculate everything are, AAPL(Apple), NVDA(Nvidia), RIVN(Rivian), NKE(Nike), and AMZN(Amazon). please make an excel doc/workbork for the work. thank you

Part 3. Portfolio Analysis (5 pts) For the portfolio analysis, you will need to perform the following steps: 1. Calculate the average monthly and annualized return, standard deviation, beta, Sharpe ratio, and Treynor's measure for each stock. 2. Calculate the correlation between each stock 3. Rank the stocks according to their Sharpe ratio and Treynor's measure. 4. Construct an equal-weighted portfolio and calculate the average monthly and annualized return, standard deviation, Sharpe ratio, and Treynor's measure 5. Construct a value-weighted portfolio and calculate the average monthly and annualized returm, standard deviation, Sharpe ratio, and Treynor's measure. Part 3. Portfolio Analysis (5 pts) For the portfolio analysis, you will need to perform the following steps: 1. Calculate the average monthly and annualized return, standard deviation, beta, Sharpe ratio, and Treynor's measure for each stock. 2. Calculate the correlation between each stock 3. Rank the stocks according to their Sharpe ratio and Treynor's measure. 4. Construct an equal-weighted portfolio and calculate the average monthly and annualized return, standard deviation, Sharpe ratio, and Treynor's measure 5. Construct a value-weighted portfolio and calculate the average monthly and annualized returm, standard deviation, Sharpe ratio, and Treynor's measure