Question: Find: 1) The average Monthly return for Cola Co. in percent form 2) The average Monthly return for Gas Co. in percent form 3) The

Find: 1) The average Monthly return for Cola Co. in percent formFind:

1) The average Monthly return for Cola Co. in percent form

2) The average Monthly return for Gas Co. in percent form

3) The volatility for Cola Co. in percent form

4) The volatility for Gas Co. in percent form

Month The following spreadsheet contains monthly returns for Cola Co. and Gas Co. for 2013. Using these data, estimate the average monthly return and the volatility for each stock. (Click on the following icon e in order to copy its contents into a spreadsheet.) January February March April May June July August September October November December Cola Co. 6.70% 7.70% -1.30% 6.30% - 1.90% 3.90% - 1.00% - 2.50% - 1.30% 3.30% 8.60% 5.60% Gas Co. 2.00% -4.00% 6.70% 7.70% - 2.80% 3.20% - 1.50% 3.70% 4.40% 0.20% 1.80% -2.10% Month The following spreadsheet contains monthly returns for Cola Co. and Gas Co. for 2013. Using these data, estimate the average monthly return and the volatility for each stock. (Click on the following icon e in order to copy its contents into a spreadsheet.) January February March April May June July August September October November December Cola Co. 6.70% 7.70% -1.30% 6.30% - 1.90% 3.90% - 1.00% - 2.50% - 1.30% 3.30% 8.60% 5.60% Gas Co. 2.00% -4.00% 6.70% 7.70% - 2.80% 3.20% - 1.50% 3.70% 4.40% 0.20% 1.80% -2.10%

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!