The following spreadsheet contains monthly returns for Coca Cola 9KO) and EXXON Mobile (XOM) for 1980. Using
Question:
The following spreadsheet contains monthly returns for Coca Cola 9KO) and EXXON Mobile (XOM) for 1980. Using the data in MS Excel, estimate the:
a) Average monthly return and volatility
b) Covariance between the stocks
c) Correlation between thestocks
Transcribed Image Text:
KO 0.404 0.045 YOM 0.099 0.098 -0.045 0.011 0.076 0.045 0.005 -0.004 0.077 0.223 0.013 0.034 Month anuary February Mar April une Jul August September October November December -0.023 0.099 -0.124 0.003 0.012 0.012 0.103 0.098 0.877
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 64% (14 reviews)
Computation of the Follow...View the full answer
Answered By
Utsab mitra
I have the expertise to deliver these subjects to college and higher-level students. The services would involve only solving assignments, homework help, and others.
I have experience in delivering these subjects for the last 6 years on a freelancing basis in different companies around the globe. I am CMA certified and CGMA UK. I have professional experience of 18 years in the industry involved in the manufacturing company and IT implementation experience of over 12 years.
I have delivered this help to students effortlessly, which is essential to give the students a good grade in their studies.
3.50+
2+ Reviews
10+ Question Solved
Related Book For
Question Posted:
Students also viewed these Finance questions
-
The following spreadsheet contains monthly returns for Cola Co. and Gas Co. for 2010. Using these data, estimate the average monthly return and volatility for each stock (see MyFinanceLab for the...
-
The Coca Cola Company has to employ the highest quality processes and establish standards which guarantee the production of a standardised product which meets consumers high expectations each and...
-
Using Exxon Mobile Inc. Develop an EFE Matrix and an IFE Matrix. The EFE Matrix summarizes the results of your external audit and the IFE Matrix focuses on your company's major internal strengths and...
-
Q No. 1) a) Construct the Histogram for the following frequency distribution relating to the ages of telephone operators. Age (Years) No. of Operators 10-15 15-20 20-25 25-30 30--35 10 22 17 b)...
-
The equilibrium constant KP for the reaction is 1.05 at 250°C. The reaction starts with a mixture of PCl5, PCl3, and Cl2 at pressures 0.177 atm, 0.223 atm, and 0.111 atm, respectively, at...
-
A sample of n 5 10 automobiles was selected, and each was subjected to a 5-mph crash test. Denoting a car with no visible damage by S (for success) and a car with such damage by F, results were as...
-
Accounting for Credit Card Sales} Frank's Tattoos and Body Piercing operates near campus. At the end of a recent day, Frank's cash register included credit card documnts for the following sales...
-
On August 1, Cairle Companys work-in-process inventory consisted of three jobs with the following costs: During August, four more jobs were started. Information on costs added to the seven jobs...
-
Neptune Biometrics, despite its promising technology, is having difficulty generatingprofits. Having raised $85 million in an initial public offering of its stock early in the year,the company is...
-
1. What do you think the real problem was here? If you say that it was Jane trying to push too hard, explore what that really means. How responsible should the employer be for the discomfort of other...
-
Suppose the market risk premium is 4.0 % and the risk-free interest rate is 3.0%. Use the data below to calculate the expected return of investingin: Industrv H.J. Heinz Cisco Systems, Inc. General...
-
The following table looks similar, but is the monthly returns for both companies in 1992. Calculate the volatility (standard deviation) of a portfolio that is 55% invested in Coca-Cola and 45%...
-
An electric motor draws a current of 16 amp at 110 V. The output shaft delivers a torque of 10 N-m at a speed of 1500 RPM. Determine (a) The electric power transferred. (b) Shaft power. (c) The rate...
-
Sheridan Bucket runs a company, Yummy Green Drinks AB, that specializes in selling healthy drinks at a reasonable price. A six-pack of drinks (25 cl each bottle) is sold for 21 SEK. The supplier...
-
K* = (1 a) K Total Shortwave
-
5. Complete the following tasks: a. Define and interpret . What is a mean-variance efficient portfolio? Use the digits of your student ID as Y variable and your mobile number as X variable. You can...
-
Php 15,000 was due on November 3, 2006. If money is worth 14% compounded semi-annually, find the value of this obligation (a) on November 3, 2010; (b) on November 3, 2002
-
While scrolling through your favorite social media site, apicture of Philodendron ?a common houseplant?catchesyour eye. Your friend says about the photo, ?This houseplant and Iare best friends. It?s...
-
A slab of clay \(50 \mathrm{~mm}\) thick was dried from both flat surfaces-with the four thin edges sealed-by exposure to dry air. The initial uniform moisture content was \(15 \%\). The drying took...
-
What is the ideal number of children to have? This question was asked on the Sullivan Statistics Survey I. Draw a dot plot of the variable Children from theSullivanStatsSurveyI data set at...
-
From the following, calculate the amount of bills accepted during the year. Bills payable as on April 01, 2005 Bills payable as on March 31, 2006 Bills payable dishonoured during the year Bills...
-
Classify the following accounts as real (permanent) or nominal (temporary) and indicate with an X whether the account is closed. Also indicate the financial statement in which each account will...
-
Classify the following accounts as real (permanent) or nominal (temporary) and indicate with an X whether the account is closed. Also indicate the financial statement in which each account will...
-
The ledger accounts after adjusting entries for Cortez Services are presented below. a. Journalize the following closing entries and number as steps 1 through 4. b. What is the new balance of J....
-
Can you solve this for me
-
Company UVW produces a single product with a selling price of $15 per unit. Fixed costs, such as rent and insurance, amount to $100,000, while variable costs, including raw materials and direct...
-
Process Costing at Coca-Cola Values: Total Production Costs: $2,000,000 Units Produced: 100,000 Cost per Equivalent Unit: $20 Requirements: Calculate the cost per unit using process costing at...
Study smarter with the SolutionInn App