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 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.
Task 4b Task 5 Symbol: GE Task 3a Task 3b Monthly Ave. Ave. Returns Monthly Annual Task 4a o (Monthly Rtns) (Annualized) General Electric Task 2 Adjusted Date Close 10/1/2015 24.4861 11/1/2015 25.3497 12/1/2015 26.3742 1/1/2016 24.8302 2/1/2016 24.8644 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 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.5956 4/1/2018 13.1469 5/1/2018 13.1562 6/1/2018 12.7171 7/1/2018 12.8534 Task 4b Task 5 Symbol: GE Task 3a Task 3b Monthly Ave. Ave. Returns Monthly Annual Task 4a o (Monthly Rtns) (Annualized) General Electric Task 2 Adjusted Date Close 10/1/2015 24.4861 11/1/2015 25.3497 12/1/2015 26.3742 1/1/2016 24.8302 2/1/2016 24.8644 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 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.5956 4/1/2018 13.1469 5/1/2018 13.1562 6/1/2018 12.7171 7/1/2018 12.8534Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started