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

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Corporate Finance Principles And Practice

Authors: Denzil Watson, Antony Head

5th Edition

0273725343, 978-0273725343

More Books

Students also viewed these Finance questions

Question

What are the security requirements for the VMs?

Answered: 1 week ago