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. The average monthly return for Cola Co. is The average monthly return for Gas Co. is The volatility for Cola Co. is%. (Round to two decimal places.) %. (Round to two decimal places.) %. (Round to two decimal places.) January February March April May June July August September October November Month Cola Co. 2.40% 0.90% 1.60% - 1.60% 2.80% 4.60% 0.80% -0.80% - 0.80% -0.40% 5.90% Gas Co. 6.20% - 4.60% 4.60% - 5.90% 3.80% 6.00% -0.40% -2.00% - 3.60% 0.60% 1.80% 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. The average monthly return for Cola Co. is The average monthly return for Gas Co. is The volatility for Cola Co. is%. (Round to two decimal places.) %. (Round to two decimal places.) %. (Round to two decimal places.) January February March April May June July August September October November Month Cola Co. 2.40% 0.90% 1.60% - 1.60% 2.80% 4.60% 0.80% -0.80% - 0.80% -0.40% 5.90% Gas Co. 6.20% - 4.60% 4.60% - 5.90% 3.80% 6.00% -0.40% -2.00% - 3.60% 0.60% 1.80%
Expert Answer:
Answer rating: 100% (QA)
Solution To estimate the average monthly return and volatility for each stock we can use the following formulas Average Monthly Return Sum ofMonthly R... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
With respect to digital and social media marketing. What new metric should firms be tracking going forward? The role of blockchain technology. Whether and why the digital/social media marketing...
-
Noguchi Company manufactures cooling systems. Noguchi produces all the parts necessary for its product except for one electronic component, which is purchased from two local suppliers: Manzer Inc....
-
The general ledger of Blossom Care Corp., a veterinary company, showed these balances on August 31, 2024: Cash $9,900; Accounts Receivable $3,960; Supplies $770; Equipment $14,300; Accounts Payable...
-
Your current bank offers interest on deposits at 5% compounded annually.Western Bank would like to lure you to their bank and will offer you daily compounding. What stated APR must Western Bank offer...
-
Solex Company manufactures three products from a common input in a joint processing operation. Joint processing costs up to the split-off point total $95,000 per year. The company allocates these...
-
Due to the limited availability of recycling materials, the plant manager is considering making a pitch to the President regarding an addition to the current line of products from the Charlotte...
-
Under what conditions may a debt due within the next year (as measured at year-end) be reported as a noncurrent liability? Under what conditions may a long-term debt (as measured at year-end) be...
-
Avaya Corporation had the following stock outstanding from 2011 through 2014: Preferred stock: $100 par value, 8 percent cumulative, 5,000 shares authorized, issued, and outstanding Common stock: $10...
-
Donna's Beauty Salon had the following transactions for July: July 9: Purchased 625 units of inventory at $6 per unit. The seller offered a cash discount of 2/10, n/30. July 10: Returned 30 defective...
-
Adam Rust looked at his mechanic and sighed. The mechanic had just pronounced a death sentence on his road-weary car. The car had served him wellat a cost of $500 it had lasted through four years of...
-
1. How does CVP analysis contribute to increasing the quality of decisions? 2. What is your interpretation of operating leverage? Is it relevant? Can you estimate it from a traditional GAAP...
-
b) Suppose that there are only three people that live in a (very) small town: Eric, Greg, and Katie. The town is thinking of building a park which you can assume is a public good for these three...
-
In Psychological Safety Climate and Workplace Bullying in Vietnam's Public Sector (2017), the authors suggest the bureaucratic and impersonal characteristics of the work environment, combined with a...
-
On January 26, Vibrant Co. borrowed cash from Conrad Bank by issuing a 90-day note with a face amount of $70,800. Assume a 360-day year. 1. What is the proceeds of the note, assuming the note carries...
-
If r is the instantaneous position vector for a particle, show that the velocity and acceleration of the particle are given by (use Eq. A.7-2): d V= r = 8,7 +8,10 +8 dt a = 8,( r) + (r + 2) + 8 - in...
-
While the vast majority of Americans are generally law-abiding citizens, most of us will eventually run afoul of the law, perhaps for something as minor as a traffic infraction. Would treatment such...
-
T/F (no need for justification) Packets flowing throughvirtual circuit (VC) networks useVC identifiersin-stead of IP addresses. RoutersinVCnetworksdonotmaintainanystate....
-
Prepare a stock card using the following information A company is registered for GST which it pays quarterly, assume GST was last paid on the 30th of June 2019. It uses weighted average cost...
-
Assuming that you own only the Series A preferred stock in Problem 4 (and that each share of all series of preferred stock is convertible into one share of common stock), what percentage of the firm...
-
Suppose you receive $100 at the end of each year for the next three years. a. If the interest rate is 8%, what is the present value of these cash flows? b. What is the future value in three years of...
-
You are long two calls on the same share of stock with the same exercise date. The exercise price of the first call is $40 and the exercise price of the second call is $60. In addition, you are short...
-
The rules of conduct of CAs, CGAs, and CMAs require them to report a breach of the rules of conduct by a member to their profession's disciplinary body. What should they do before making such a...
-
The auditor's working papers usually can be pro vided to someone else only with the permission of the client. What is the rationale for such a rule?
-
Many people believe that a public accountant cannot be truly independent when payment of fees is dependent on the management of the client. Explain a way of reducing this appearance of lack of...
Study smarter with the SolutionInn App