risks table

instrutions

company name. you can get the stock price on Yahoo finance with the ticker name NEE

assignment template

risks rate

Expert Q\&A Done name of company, you can download the monthly adjusted stock price on yahoo finance with the ticker name NEE. you can download it as an excel file. from June 12018 to May 31 2023 (60 months) Nextera Energy Inc instructions 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 (F/6), 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 Nextera Energy Inc Expert Q\&A Done name of company, you can download the monthly adjusted stock price on yahoo finance with the ticker name NEE. you can download it as an excel file. from June 12018 to May 31 2023 (60 months) Nextera Energy Inc instructions 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 (F/6), 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 Nextera Energy Inc