The following spreadsheet contains monthly returns for Cola Co. and Gas Co. for 2013. Using these...
Fantastic news! We've Found the answer you've been seeking!
Question:
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 order to copy its contents into a spreadsheet.) in Month January February March April May June July August September October November The average monthly return for Cola Co. is %. (Round to two decimal places.) Cola Co. 2.10% 0.30% 6.75% 0.50% 0.90% 3.40% 5.00% - 0.90% - 0.70% - 3.30% 3.20% Gas Co. 8.20% 0.60% 2.20% 2.30% 2.10% - 0.10% 1.70% - 3.10% 1.40% 3.40% 1.20% 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 order to copy its contents into a spreadsheet.) in Month January February March April May June July August September October November To find the average monthly return, use the following formula: 1 R=-=—= × (R₁ + R₂ + • • • + RT) X Calculate the average monthly return for Cola Co.: 1 R=2X x (7.10% + 5.30% + • • • + 13.40%) = 3.58% 12 Cola Co. 7.10% 5.30% 10.20% 0.60% - 3.90% 11.50% - 10.10% 15.42% - 10.12% 9.90% - 6.37% Gas Co. - 17.10% 7.40% -4.70% 14.70% - 1.40% - 5.50% - 2.90% 11.22% -0.80% 1.80% - 2.50% 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 order to copy its contents into a spreadsheet.) in Month January February March April May June July August September October November The average monthly return for Cola Co. is %. (Round to two decimal places.) Cola Co. 2.10% 0.30% 6.75% 0.50% 0.90% 3.40% 5.00% - 0.90% - 0.70% - 3.30% 3.20% Gas Co. 8.20% 0.60% 2.20% 2.30% 2.10% - 0.10% 1.70% - 3.10% 1.40% 3.40% 1.20% 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 order to copy its contents into a spreadsheet.) in Month January February March April May June July August September October November To find the average monthly return, use the following formula: 1 R=-=—= × (R₁ + R₂ + • • • + RT) X Calculate the average monthly return for Cola Co.: 1 R=2X x (7.10% + 5.30% + • • • + 13.40%) = 3.58% 12 Cola Co. 7.10% 5.30% 10.20% 0.60% - 3.90% 11.50% - 10.10% 15.42% - 10.12% 9.90% - 6.37% Gas Co. - 17.10% 7.40% -4.70% 14.70% - 1.40% - 5.50% - 2.90% 11.22% -0.80% 1.80% - 2.50%
Expert Answer:
Answer rating: 100% (QA)
To find the average monthly return for Cola Co we need to su... View the full answer
Related Book For
International Finance Theory and Policy
ISBN: 978-0133423648
10th edition
Authors: Paul R. Krugman, Maurice Obstfeld, Marc J. Melitz
Posted Date:
Students also viewed these finance questions
-
35) DNA was incorporated on January 2, 20X0, and commenced active operations immediately. Common shares were issued on the date of incorporation and no new common shares have been issued since then....
-
Laker Company reported the following January purchases and sales data for its only product. Date Activities Units Acquired at Cost Units sold at Retail Jan. 1 Beginning Inventory 350 units @ $ 11.00...
-
As defined in footnote 3, cross exchange rates are exchange rates quoted against currencies other than the U.S. dollar. If you return to Table 3-1, you will notice that it lists not only exchange...
-
Gregorian Company has recently issued bonds that are convertible into stock at the bondholders request. The interest rate on the bonds is ridiculously low because it is expected that most holders...
-
Should manager encourage or discourage organizational grapevines? Why?
-
(a) Use Parsevals theorem for the DFT to derive a relationship between | X c1 [k] | 2 and |x[n]| 2 . (b) Use Parsevals theorem for the DFT to derive a relationship between |X c2 [k] | 2 and ...
-
Africa offers a fast growing and exciting mobile phone market, with more than 50% growth per year since 2002. More than 28% of African consumers own mobile phones; a larger market than North America....
-
Logan Bruno Company has just received the August 31, 2008, bank statement, which is summarized below. The general ledger Cash account contained the following entries for the month of August. Deposits...
-
Put the argument from the following passage into standard form and construct an argument map diagram. There is no need to include unstated premises (assumptions) in your answer. Australia should not...
-
GloFish, Inc. has genetically engineered a species of fish that glows in normal lighting conditions. The company believes the new fish will be a huge success as a new pet option for children and...
-
Could laws pertaining to insider trading and the general protection of investors be simplified. Explain.
-
What are the different categories of projects a company may take up? Give examples of each of the categories.
-
What costs are incurred by a company in raising funds through equity?
-
Why is the cost of capital important for a company? What considerations should a company keep in mind while estimating its cost of capital?
-
The PVIF for a rupee on hand is ___.
-
Your investments can either double or become half over the next one year with equal probabilities. What is the expected return and risk?
-
Using the resources, answer the following questions: Describe what High Leverage Practices (HLPs) are and how they are used. Identify how HLPs connect to teaching and learning. Discuss how HLPs can...
-
Pappa's Appliances uses the periodic inventory system. Details regarding the inventory of appliances at January 1, purchases invoices during the year, and the inventory count at December 31 are...
-
Suppose residents of the U.S. consume relatively more of U.S. export goods than residents of foreign countries. In other words, U.S. export goods have a higher weight in the U.S. CPI than they do in...
-
How does the DD schedule shift if there is a decline in investment demand?
-
The interest rate on U.S. three-month Treasury bills dropped to very low levels at the end of 2008 and remained there for several years. Starting in January 2009 and ending in December 2013, find...
-
Gross profit is (A) Excess of sales over cost of goods sold (B) Sales less purchases (C) Cost of goods sold + opening inventory (D) Net profit less expenses of the period
-
To find the value of closing inventory at the end of a period we (A) Do this by physically counting the inventory (i.e. stocktaking) (B) Look in the inventory account (C) Deduct opening inventory...
-
Net profit is calculated in the (A) Trading account (B) Profit and loss account (C) Trial balance (D) Statement of financial position
Study smarter with the SolutionInn App