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 O in order to copy its contents into a spreadsheet.) Month Cola Co. Gas Co. 9.40% January February - 3.00% 2.20% - 5.40% March - 6.29% -4.10% April 7.40% 0.40% May -0.10% - 0.30% June - 1.80% 0.40% 0.10% July August September - 2.50% 1.90% - 2.10% 0.50% 6.20% October - 1.50% 2.50% November 5.70% 0.30% .... The average monthly return for Cola Co. is %. (Round to two decimal places.)
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 O in order to copy its contents into a spreadsheet.) Month Cola Co. Gas Co. 9.40% January February - 3.00% 2.20% - 5.40% March - 6.29% -4.10% April 7.40% 0.40% May -0.10% - 0.30% June - 1.80% 0.40% 0.10% July August September - 2.50% 1.90% - 2.10% 0.50% 6.20% October - 1.50% 2.50% November 5.70% 0.30% .... The average monthly return for Cola Co. is %. (Round to two decimal places.)
Managerial Accounting
15th Edition
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:Carl Warren, Ph.d. Cma William B. Tayler
Chapter16: Financial Statement Analysis
Section: Chapter Questions
Problem 2MAD
Related questions
Question
Cola Co. (%) Gas Co. (%)
January 0.0940 -0.0300
February 0.0220 -0.0540
March -0.0629 -0.0410
April 0.0740 0.0040
May -0.0010 -0.0030
June -0.0180 0.0040
July 0.0010 -0.0250
August 0.0190 -0.0210
September 0.0050 0.0620
October -0.0150 0.0250
November 0.0570 0.0030
December 0.0580 0.0060
Transcribed Image Text: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
in order to copy its contents into a spreadsheet.)
Month
Cola Co.
Gas Co.
- 3.00%
January
February
9.40%
2.20%
- 5.40%
March
- 6.29%
- 4.10%
April
7.40%
0.40%
May
- 0.10%
- 0.30%
June
- 1.80%
0.40%
- 2.50%
July
August
September
0.10%
1.90%
- 2.10%
0.50%
6.20%
October
- 1.50%
2.50%
November
5.70%
0.30%
The average monthly return for Cola Co. is
%. (Round to two decimal places.)
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Recommended textbooks for you
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial Accounting
Accounting
ISBN:
9781305088436
Author:
Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Finance
ISBN:
9780357033609
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial Accounting
Accounting
ISBN:
9781305088436
Author:
Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Finance
ISBN:
9780357033609
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning
Fundamentals of Financial Management, Concise Edi…
Finance
ISBN:
9781285065137
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Fundamentals Of Financial Management, Concise Edi…
Finance
ISBN:
9781337902571
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Fundamentals of Financial Management, Concise Edi…
Finance
ISBN:
9781305635937
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning