How would I calculate these different things using excel. I need to find the monthly return,...

 

Transcribed Image Text:

How would I calculate these different things using excel. I need to find the monthly return, the average monthly return, the average annual return, the monthly standard deviation, and the annualized standard deviation. I then need to calculate the coefficient variation from the annualized returns and annualized deviations (CV column). I am using the adjusted closing price of a stock for 61 months (60 month calculation). I have recorded the adjusted closing price monthly. I have attached an example screenshot that includes a good chunk of the months, and am only interested in understanding what formulas to use. General Electric Symbol: GE Task 2 Task 3a Task 3b Task da Task 4b Task 5 Ave. Monthly r Annualt Adjusted Monthly Ave. e (Monthly Rins) Date Close Returns (Annualized) CV 10/1/2015 24.481 11/1/2015 25 3497 12/1/2015 26.3742 1/1/2016 24.8302 2/1/2016 24 9644 3/1/2016 27.3515 4/1/2016 26.4567 5/1/2016 26.0093 6/1/2016 27.0847 7/1/2016 27 0034 8/1/2016 27 0901 9/1/2016 25.6853 10/1/2016 25.4392 11/1/2016 26.8904 12/1/2016 27.6247 1/1/2017 26.167 2/1/2017 26 264 3/1/2017 26.473 4/1/2017 25 7534 5/1/2017 24.3232 6/1/2017 23.9945 7/1/2017 23 1501 8/1/2017 22 1919 91/2017 21.8575 10/1/2017 18.413 11/1/2017 16.7051 12/1/2017 15 9379 1/1/2018 14.9801 2/1/2018 13.0717 3/1/2018 12.5956 4/1/2018 13 1469 5/1/2018 13. 1562 6/1/2018 12.7171 7/1/2018 12.8534 How would I calculate these different things using excel. I need to find the monthly return, the average monthly return, the average annual return, the monthly standard deviation, and the annualized standard deviation. I then need to calculate the coefficient variation from the annualized returns and annualized deviations (CV column). I am using the adjusted closing price of a stock for 61 months (60 month calculation). I have recorded the adjusted closing price monthly. I have attached an example screenshot that includes a good chunk of the months, and am only interested in understanding what formulas to use. General Electric Symbol: GE Task 2 Task 3a Task 3b Task da Task 4b Task 5 Ave. Monthly r Annualt Adjusted Monthly Ave. e (Monthly Rins) Date Close Returns (Annualized) CV 10/1/2015 24.481 11/1/2015 25 3497 12/1/2015 26.3742 1/1/2016 24.8302 2/1/2016 24 9644 3/1/2016 27.3515 4/1/2016 26.4567 5/1/2016 26.0093 6/1/2016 27.0847 7/1/2016 27 0034 8/1/2016 27 0901 9/1/2016 25.6853 10/1/2016 25.4392 11/1/2016 26.8904 12/1/2016 27.6247 1/1/2017 26.167 2/1/2017 26 264 3/1/2017 26.473 4/1/2017 25 7534 5/1/2017 24.3232 6/1/2017 23.9945 7/1/2017 23 1501 8/1/2017 22 1919 91/2017 21.8575 10/1/2017 18.413 11/1/2017 16.7051 12/1/2017 15 9379 1/1/2018 14.9801 2/1/2018 13.0717 3/1/2018 12.5956 4/1/2018 13 1469 5/1/2018 13. 1562 6/1/2018 12.7171 7/1/2018 12.8534