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 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
Get step-by-step solutions from verified subject matter experts
