for the required task, you are required to fill in the excel template provided. it should be done in excel.

company mame is Wells fargo & co

Go to finance.yahoo.com and download the ending monthly adjusted stock prices for the company assigned to you for 60 months. The ending month is May 2023. The risk-free rate is provided for you in an Excel file called "Risk-Free Rate". The following tasks should be completed. - Enter the 3-Month risk-free rate (E9:E68) - Calculate Monthly risk-free rate (F9:F68) - Enter the stock price information for the assigned company (G8:E68) - Calculate stock returns (H9:H68) - Enter S\&P 100 index data (I8:I68) - Calculate S\&P100 index return (J9:J68) - Calculate the Stock Risk Premium (K9:K68) - Calculate the Market Risk Premium (L9:L68) After you calculate these returns, please calculate for - Average return for the risk-free rate (F76), for the stock (H76) and the market (J76) - Standard Deviation for the risk-free rate (F77), for the stock (H77) and the market (J77) Lastly, Plot the monthly returns and index returns on a line graph. Go to finance.yahoo.com and download the ending monthly adjusted stock prices for the company assigned to you for 60 months. The ending month is May 2023. The risk-free rate is provided for you in an Excel file called "Risk-Free Rate". The following tasks should be completed. - Enter the 3-Month risk-free rate (E9:E68) - Calculate Monthly risk-free rate (F9:F68) - Enter the stock price information for the assigned company (G8:E68) - Calculate stock returns (H9:H68) - Enter S\&P 100 index data (I8:I68) - Calculate S\&P100 index return (J9:J68) - Calculate the Stock Risk Premium (K9:K68) - Calculate the Market Risk Premium (L9:L68) After you calculate these returns, please calculate for - Average return for the risk-free rate (F76), for the stock (H76) and the market (J76) - Standard Deviation for the risk-free rate (F77), for the stock (H77) and the market (J77) Lastly, Plot the monthly returns and index returns on a line graph