Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The following spreadsheet contains monthly returns for Cola Co. and Gas Co. for . Using these data, estimate the average monthly return and the volatility
The following spreadsheet contains monthly returns for Cola Co. and Gas Co. for . Using these data, estimate the average monthly return and the volatility for each stock.
Cola Co. (%) Gas Co. (%)
January 0.0030 0.0150
February -0.0470 -0.0130
March 0.0396 0.0540
April 0.0190 -0.0130
May 0.0390 0.0450
June -0.0680 -0.0730
July -0.0230 -0.1010
August 0.0750 0.0570
September 0.0640 -0.0540
October 0.0800 -0.0300
November -0.0638 -0.0530
December 0.0540 -0.0060
The average monthly return for Cola Co. is ___
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started