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: 61% (13 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 machine is found to vibrate with simple harmonic motion at a frequency of \(20 \mathrm{~Hz}\) and an amplitude of acceleration of \(0.5 \mathrm{~g}\). Determine the displacement and velocity of the...
-
You are engaged to perform an audit of the Wilcox Corp. for the year ended December \(31,19 X 0\). Only merchandise shipped by the Wilcox Corporation to customers up to and including December 30,...
-
Taylor Industries, Inc., develops standard costs for all its direct materials, direct labor, and overhead costs. It uses these costs to price products, cost inventories, and evaluate the performance...
-
you must write YOUR professional biography. Highlight your work experience, education, volunteer work, and anything else that you consider relevant. Your introduction should be at least two...
-
Archipelago Smiths bank account reflecting the transactions for the financial year ended December 31, 2014, is reported below. He has lost his financial statements in a flood and is asking his newly...
-
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%...
-
Draw a structure for (CH 3 CH 2 CH 2 ) 2 CHCH(CH 2 CH 3 ) 2 in which all carboncarbon bonds are shown explicitly; then name the compound.
-
You have your own company, the EIE0120, a LLC. This company produces stamped metal parts. You have been asked by a current customer to provide a quotation for a product that is similar to but...
-
provide requirements for a ATM machine On MS word (PLEASE USE AGILE METHODOLOGY) Who is the actor on a this ATM machine What is the system? Write a User Story for the ATM machine write system...
-
Calculate the binding energy per nucleon for Be, 59 Co, 208 pb, and 195 pt. (For the atomic masses, see this table. Enter your answers to at least two decimal places.) (a) Be MeV/nucleon 59 Co...
-
Water flows through a pipe section that tapers from an internal diameter of 200 mm down to 100 mm over a distance of 1 m. Determine the pressure drop over the section for a flow of 0.06 m3s-1. The...
-
Millie Industries manufactures two products, Monogram and Signature, for industrial use. Millie's manufacturing facility is highly automated, with very little direct labour being involved in the...
-
If an object at temperature \(B\) is surrounded by air at temperature \(A\), it will gradually cool so that the temperature \(T\), \(t\) minutes later, is given by Newton's law of cooling:...
-
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....
-
A corporation issues 13 %, 15-year bonds with a par value of $570,000 and semiannual interest payments. On the issue date, the annual market rate for these bonds is 11%, which implies a selling price...
-
A production department reports the following conversion costs. Equivalent units of production for conversion total 436,000 units this period. Calculate the cost per equivalent unit of production for...
-
If you were asked whether a large university such as Tennessee or Michigan with a large seating capacity for their football stadiums should build a new football stadium, how would you respond and...
Study smarter with the SolutionInn App