Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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. image text in transcribed

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.8534

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions