Consulting Assignment Your supervisor asked to help review a portion of a clients stock portfolio to determine the risk$/$return profiles of $12$ stocks in the portfolio. Specifically, you have been asked to determine the monthly average returns and standard deviations for the $12$ stocks for the past five years. The stocks $($with their symbols in parentheses$)$ are:Apple Inc. $($AAPL$)$Amazon$.$com Inc. $($AMZN$)$Berkshire Hathaway Inc. $($BRK$-$B$)$Cisco Systems, Inc. $($CSCO$)$Exxon Mobil Corporation $($XOM$)$Facebook$,$ Inc. $($now Meta Platforms, Inc.$)($FB$)$Intel Corporation $($INTC$)$Johnson & Johnson $($JNJ$)$Pfizer Inc. $($PFE$)$Tesla$,$ Inc. $($TSLA$)$Visa Inc. $($V$)$Walt Disney Company $($DIS$)$The consulting firm can access expensive databases that provide all this information with a few simple keystrokes. Still, your supervisor wants you to build your research skills; thus, she asked you to gather the data yourself. She suggested the following data sources. Find price data for each stock on Yahoo! Finance $($finance$.$yahoo.com$)$ by doing the following:a$)$ Enter the stock symbol. On the page for that stock, click Historical Data.b$)$ Enter the start date and the end date to cover the five$-$year period. Make sure you click monthly next to the date; the closing prices reported by Yahoo! will then be for the last day of each month.c$)$ Download the prices after updating the date range and frequency.d$)$ Keep the column Adjusted Close for the stock.e$)$ Repeat these steps for the remaining stocks, pasting each closing price right next to the other stocks, again making sure that the correct prices on the correct dates appear on the same rows$\mathrm{.}1.$ Collect the monthly price for each stock for the past five years. Remember to use the Adjusted Close. The adjusted closing prices are adjusted to account for events like dividend payments and stock splits. You will compute returns from the percentage change in monthly adjusted prices$\mathrm{.}2.$ Convert these prices to monthly returns as the percentage change in the monthly adjusted prices. $($Hint: Create a separate worksheet within the Excel file.$)$ Note that to compute a return for each month, you need a beginning and ending price, so you will not be able to compute the return for the first month$\mathrm{.}3.$ Compute the mean monthly returns and standard deviations for the monthly returns of each of the stocks. Convert the monthly statistics to annual statistics for easier interpretation $($multiply the mean monthly return by $12$ and multiply the monthly standard deviation by the square root of $12)\mathrm{.}4.$ Add a column in your Excel worksheet with each month's average return across stocks. This is the monthly return to an equally weighted portfolio of these $12$ stocks. Compute monthly returns' mean and standard deviation for the equally weighted portfolio. Double$-$check that the average return on this equally weighted portfolio is equal to the average return of all individual stocks. Convert these monthly statistics to annual statistics $($as described in Step $3)$ for interpretation$5.$ Generate an Excel plot using the annual statistics you have obtained and$/$or computed, depicting standard deviation $($volatility$)$ on the x$-$axis and average return on the y$-$axis by following these steps:In your spreadsheet, establish three columns containing the statistics obtained in Steps $3$ and $4$ for each of the individual stocks and the equally weighted portfolio. The initial column should display the stock ticker, the second the annual standard deviation, and the third the annual mean return.Select and highlight the data in the last two columns $($standard deviation and mean$).$Navigate to the "Insert" tab, choose "Chart," and then opt for $"$XY Scatter Plot."Complete the chart wizard to finalize the plot.Confirm that all data points on the plot are appropriately labeled with the corresponding stock tickers$\mathrm{.}6.$ What do you notice about the average of the volatilities $($standard deviations$)$ of the individual stocks, compared to the volatility of the equally weighted portfolio? In answering this question, be sure to reference the values calculated in your analysis.