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...
-
2.) Suppose that a nursery (grows plants) is located next to a paper mill that emits air pollutants. This air pollution is harming the growth of the plants in the nursery. More specifically, the air...
-
When a write of attachment may be obtained?
-
Marvel Studio's motion picture Guardians of the Galaxy opened over the first two days of the 2014 Labor Day weekend to a record-breaking $94.3 million in ticket sales revenue in North America (the...
-
Romero issues $3,400,000 of 10%, 10-year bonds dated January 1, 2020, that pay interest semiannually on June 30 and December 31. The bonds are issued at a price of $3,010,000. Required 1. Prepare the...
-
Hemming Company reported the following current-year purchases and sales for its only product Units Acquired at Cost @$12.20- @$17.20 - Date January 1 January 10 March 14 March 15 July 30 October 5...
-
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%...
-
Sheldon Company just took its physical inventory on December 31. The count of inventory items on hand at the company's business locations resulted in a total inventory cost of $300,000. In reviewing...
-
1Given the following matrices compute the indicated quantities. 4 -2 17 A= 9-6 B= 0 0 0-1 200 0 3 7 [300] C=0 20 0 51 [-2 D= 0-4 10-1 6 E=-2 8 2 1 -1 20 1-2 07 31 10 9 5 (a) AB (b) C-1 (c) D'D (d) E-
-
Reliable Motors shares are expected to pay dividends of $1.35, $1.05, and $1.70 at the end of each of the next three years, respectively. The investor expects the price of the shares at the end of...
-
An investor has just taken a long position in a one-year forward contract on a dividend paying stock. The stock is expected to pay a dividend of $6 per share in five months and in eleven months. The...
-
An investor buys a 30-year bond with a $1,000 face value for $950. The bond's coupon rate is 5 percent and interest payments are made semi-annually. Using the YTM (yield to maturity) approximation...
-
Suppose your father has just retired and has a retirement nest egg currently worth $1,000,000. If he plans to take out $98,100 at the end of each of the next 25 years, the beginning one year from...
-
Write a segment of code to perform each of the following operations. You may call any of the member functions of StackType. The details of the stack type are encapsulated; you may use only the stack...
-
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....
-
You are planning to invest in fine wine. Each case costs $100 (at time 0), and you know from experience that the (future) value of a case of wine held fort years is100 * t^(1/2)fort1. (Suppose that...
-
(b) Ntow Ltd prepared the following estimated figures for its Manufacturing Division for the four months ending 31st March 2019: Month Production in units Cost () January 14,000 220,000 February...
-
Suppose you short-sell a $100m 10-year on-the-run par treasury and buy an $100m 10-year off-the-run par treasury to earn the yield spread in late 1997. At the time, the rates on these bonds were...
Study smarter with the SolutionInn App