Question: 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

 How would I calculate these different things using excel. I need

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. Symbol: GE Task 5 Task 4b o (Annualized) Close General Electric Task 2 Task 3 Task 3 Task 4a Adjusted Monthly Ave Ave Monthly Date Returns Monthly Annual Rts) 10/1/2015 24.4851 11/1/2015 25 3497 12/1/2015 26.3742 1/1/2018 24.8302 2/1/2016 24 8644 3/1/2016 27.3515 4/1/2016 26.4587 5/1/2016 28.0093 6/1/2016 27.0647 7/1/2016 270034 8/1/2016 27 0901 9/1/2016 25.6853 10/1/2016 25.4392 11/1/2016 26.8904 12/1/2018 27.6247 1/1/2017 26. 167 2/1/2017 26 284 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 9/1/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.5958 4/1/2018 13. 1469 5/1/2018 13.1562 6/1/2018 127171 7/1/2018 12.8534

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!