Question

The following spreadsheet contains monthly returns for Cola Co. and Gas Co. for 2013. Using these​...

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.

Cola Co. Gas Co.
January -0.071 -0.081
February -0.021 -0.02
March -0.038 -0.026
April -0.041 -0.05
May 0.015 -0.047
June 0.012 -0.032
July -0.211 0.067
August -0.145 -0.085
September -0.288 -0.126
October 0.229 0.165
November -0.134 -0.061
December -0.018 0.029

What is the volatility for Cola Co. ?

What is the volatility for Gas Co. ?

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The following spreadsheet contains monthly returns for Cola Co. and Gas Co. for 2013. Using these​...
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. Month Cola Co. Gas Co. January -0.20​% 0.30​% February -7.20​% -3.90​% March 6.26​% -3.70​% April -7.10​% -4.90​% May 1.60​% -5.70​% June 4.90​% -4.60​% July 3.00​% 0.70​% August -2.70​% -6.40​% September 0.00​% -0.90​% October 10.50​% 10.20​% November 4.90​% -6.70​% December 4.20​% -1.50​% The average monthly return for Cola Co. is ? ​%. ​
The following spreadsheet contains monthly returns for Cola Co. and Gas Co. for 20132013. Using these​...
The following spreadsheet contains monthly returns for Cola Co. and Gas Co. for 20132013. Using these​ data, estimate the average monthly return and the volatility for each stock. ​(Click on the following icon     in order to copy its contents into a​ spreadsheet.) Month Cola Co. Gas Co. January 6.706.70​% 2.002.00​% February 7.707.70​% negative 4.00−4.00​% March negative 1.30−1.30​% 6.706.70​% April 6.306.30​% 7.707.70​% May negative 1.90−1.90​% negative 2.80−2.80​% June 3.903.90​% 3.203.20​% July negative 1.00−1.00​% negative 1.50−1.50​% August negative 2.50−2.50​% 3.703.70​% September negative...
A large drug store chain outsources the manufacturing of its pain relief tablets to two different...
A large drug store chain outsources the manufacturing of its pain relief tablets to two different independent manufacturers, Manufacturer A and Manufacturer B. The quality control department of the chain would like to ensure that the population mean amount of the active ingredient in the tablets is still the same between the two manufacturers. The department assumes the population standard deviation for the amount of the active ingredient in a tablet based on the specifications from the manufacturers. The quality...
Dupree Industries is deciding whether to automate one phase of its production process. The manufacturing equipment...
Dupree Industries is deciding whether to automate one phase of its production process. The manufacturing equipment has a six-year life and will cost $915,000. Projected net cash inflows are as?follows Year 1 $260,000 Year 2 253,000 Year 3 227,000 Year 4 211,000 Year 5 203,000 Year 6 177,000 Requirments 1. Compute this? project's NPV using duprees 16?% hurdle rate. Should Duprees invest in the? equipment? 2. Dupree could refurbish the equipment at the end of six years for $104,000. The...