Question: I need help for finding the Volatility for Cola Co. and Gas Co. ASAP please. The following spreadsheet contains monthly returns for Cola Co. and

I need help for finding the Volatility for Cola Co. and Gas

I need help for finding the Volatility for Cola Co. and Gas Co. ASAP please.

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.) The average monthly return for Cola Co. is \%. (Round to two decimal places.) The average monthly return for Gas Co. is .76%. (Round to two decimal places.) The volatility for Cola Co. is \%. (Round to two decimal places.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Please help me figure out the volatility for Cola Co. and GasCo.? Thank you! The following spreadsheet contains monthly returns for Cola Co. and Gas Co. for 2013 . Using these data, estimate the...

i need help getting the average monthly return and the volatility for both stocks The following spreadsheet contains monthly returns for ColaCo. and GasCo for 2013. Using these data, estimate the...

I am having trouble with the excel format and how to enter the functions as well as which ones are used to solve each type of problem. Use table in the next tab for the following problems. a. Compute...

You have a portfolio with a standard deviation of 26% and an expected return of 15%. You are considering adding one of the two stocks in the following table. If after adding the stock you will have...

Gas Co Cola Co -4.90% 1.10% 5.12% Month 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...

need volatity for both companies 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...

The following spreadsheet contains monthly returns for Cola Co . and Gas Co . for 2 0 2 2 Using these data, estimate the average monthly return and the volatility for each stock. Please calculate the...

You are purchasing insurance for your house. You have three options: Zero deductible policy that will pay 100% of all damage expenses for the year costs you $350 per month. Low dedutible policy that...

1. Which of the following two positions do you agree with most: communication on the Internet should be made more anonymous, or communication on the Internet should be made more identifiable. 2. If...

Facebook has bonds on the market with 10.5 years to maturity. The nominal value of the bond is 500 and YTM is 8.6% and the bond makes semi-annual coupon payment. If coupon rate is 6%, what is the...

10) For a bond that pays cash interest (i.e., not a zero coupon bond), YTM is (a) always equal to the coupon rate (b) always equal to the current yield (c) is always less than the coupon rate (d) can...

What is the purpose of job redesign? Which job redesign described in the text would appeal to you and why? scussion Boards

Define HRM. Based on your experience, how do you think HRM has played a role in your workplace? Why is it important for employees to be familiar with legal issues in the healthcare workplace? Review...

What is the role of the Joint Commission in health care?