1) What is the average return for Home Depot, Inc. (HD)? 2) What is the standard deviation...
Fantastic news! We've Found the answer you've been seeking!
Question:
1) What is the average return for Home Depot, Inc. (HD)?
2) What is the standard deviation for Costo Wholesale Corporation (COST)?
3)What is the correlation between BBY and MSFT?
4) What is the beta for Costo Wholesale Corporation (COST)?
Transcribed Image Text:
Date S&P 500 Adj Close Price BBY Adj Close Pric HD Adj Close Pric MSFT Adj Close Pric FB Adj Close Price 1/1/2015 $ 30.34 $ 36.39 $ 75.91 $ 2/1/2015 $ 32.84 $ 39.50 $ 78.97 $ 3/1/2015 $ 32.58 $ 36.89 $ 82.22 $ 30.41 $ 78.77 $ 30.45 $ 79.19 $ 28.62 $ 4/1/2015 $ 5/1/2015 $ 6/1/2015 $ 7/1/2015 $ 8/1/2015 $ 9/1/2015 $ 10/1/2015 $ 11/1/2015 $ 12/1/2015 $ 1/1/2016 $ 2/1/2016 $ 3/1/2016 $ 4/1/2016 $ 5/1/2016 $ 6/1/2016 $ 7/1/2016 $ 8/1/2016 $ 9/1/2016 $ 10/1/2016 $ 11/1/2016 $ 12/1/2016 $ 1/1/2017 $ 2/1/2017 $ 3/1/2017 $ 4/1/2017 $ 1,994.99 $ 2,104.50 $ 2,067.89 $ 2,085.51 $ 2,107.39 $ 2,063.11 $ 2,103.84 $ 1,972.18 $ 1,920.03 $ 2,079.36 $ 2,080.41 $ 2,043.94 $ 1,940.24 $ 1,932.23 $ 2,059.74 $ 2,065.30 $ 2,096.95 $ 2,098.86 $ 2,173.60 $ 2,170.95 $ 2,168.27 $ 2,126.15 $ 2,198.81 $ 2,238.83 $ 2,278.87 $ 2,363.64 $ $ 2,362.72 2,384.20 $ 28.53 $ 32.46 $ 32.80 $ 31.14 $ 28.25 $ 27.07 $ 25.02 $ 29.01 $ 29.06 $ 29.38 $ 29.46 $ 28.02 $ 31.06 $ 35.57 $ 35.29 $ 36.23 $ 42.55 $ 39.73 $ 41.71 $ 41.34 $ 46.04 $ 48.90 $ 94.43 $ 103.78 $ 102.75 $ 97.25 $ 101.28 $ 101.02 $ 106.95 $ 106.43 $ 105.54 $ 113.56 $ 122.97 $ 121.47 $ 116.02 $ 114.51 $ 123.10 $ 124.20 $ 122.56 $ 119.06 $ 128.90 125.06 $ $ 120.60 $ 114.35 $ 121.28 $ 126.33 $ 129.63 $ 136.53 $ 138.34 $ 147.97 $ 44.13 $ 42.51 $ COST Adj Close Price 40.31 $ 42.64 $ 39.74 $ 40.68 $ 48.38 $ 49.9 $ 51.34 $ 50.98 $ 47.08 $ 51.47 $ 46.48 $ 49.39 $ 48.02 $ 53.19 $ $ 53.93 54.39 $ 56.59 56.91 $ $ 59.08 $ 61.46 $ 60.83 $ 62.99 $ 65.48 $ 85.77 $ 94.01 $ 89.73 $ 89.90 $ 101.97 $ 104. $ 104.66 $ 112.21 $ 106.92 $ 114.10 $ 117.58 $ 118.81 $ 114.28 $ 123.94 $ 126.12 $ 128.27 $ 130.99 $ 118.42 $ 115.05 $ 130.32 $ 135.54 $ 142.05 $ 150.25 $ 126.33 129.84 138.62 130.88 130.82 123.91 133.31 128.49 133.00 145.47 148.50 148.96 139.39 138.38 145.74 137.00 138.00 145.67 155.11 150.35 141.85 137.53 139.62 149.37 152.96 165.30 156.87 166.06 Date S&P 500 Adj Close Price BBY Adj Close Pric HD Adj Close Pric MSFT Adj Close Pric FB Adj Close Price 1/1/2015 $ 30.34 $ 36.39 $ 75.91 $ 2/1/2015 $ 32.84 $ 39.50 $ 78.97 $ 3/1/2015 $ 32.58 $ 36.89 $ 82.22 $ 30.41 $ 78.77 $ 30.45 $ 79.19 $ 28.62 $ 4/1/2015 $ 5/1/2015 $ 6/1/2015 $ 7/1/2015 $ 8/1/2015 $ 9/1/2015 $ 10/1/2015 $ 11/1/2015 $ 12/1/2015 $ 1/1/2016 $ 2/1/2016 $ 3/1/2016 $ 4/1/2016 $ 5/1/2016 $ 6/1/2016 $ 7/1/2016 $ 8/1/2016 $ 9/1/2016 $ 10/1/2016 $ 11/1/2016 $ 12/1/2016 $ 1/1/2017 $ 2/1/2017 $ 3/1/2017 $ 4/1/2017 $ 1,994.99 $ 2,104.50 $ 2,067.89 $ 2,085.51 $ 2,107.39 $ 2,063.11 $ 2,103.84 $ 1,972.18 $ 1,920.03 $ 2,079.36 $ 2,080.41 $ 2,043.94 $ 1,940.24 $ 1,932.23 $ 2,059.74 $ 2,065.30 $ 2,096.95 $ 2,098.86 $ 2,173.60 $ 2,170.95 $ 2,168.27 $ 2,126.15 $ 2,198.81 $ 2,238.83 $ 2,278.87 $ 2,363.64 $ $ 2,362.72 2,384.20 $ 28.53 $ 32.46 $ 32.80 $ 31.14 $ 28.25 $ 27.07 $ 25.02 $ 29.01 $ 29.06 $ 29.38 $ 29.46 $ 28.02 $ 31.06 $ 35.57 $ 35.29 $ 36.23 $ 42.55 $ 39.73 $ 41.71 $ 41.34 $ 46.04 $ 48.90 $ 94.43 $ 103.78 $ 102.75 $ 97.25 $ 101.28 $ 101.02 $ 106.95 $ 106.43 $ 105.54 $ 113.56 $ 122.97 $ 121.47 $ 116.02 $ 114.51 $ 123.10 $ 124.20 $ 122.56 $ 119.06 $ 128.90 125.06 $ $ 120.60 $ 114.35 $ 121.28 $ 126.33 $ 129.63 $ 136.53 $ 138.34 $ 147.97 $ 44.13 $ 42.51 $ COST Adj Close Price 40.31 $ 42.64 $ 39.74 $ 40.68 $ 48.38 $ 49.9 $ 51.34 $ 50.98 $ 47.08 $ 51.47 $ 46.48 $ 49.39 $ 48.02 $ 53.19 $ $ 53.93 54.39 $ 56.59 56.91 $ $ 59.08 $ 61.46 $ 60.83 $ 62.99 $ 65.48 $ 85.77 $ 94.01 $ 89.73 $ 89.90 $ 101.97 $ 104. $ 104.66 $ 112.21 $ 106.92 $ 114.10 $ 117.58 $ 118.81 $ 114.28 $ 123.94 $ 126.12 $ 128.27 $ 130.99 $ 118.42 $ 115.05 $ 130.32 $ 135.54 $ 142.05 $ 150.25 $ 126.33 129.84 138.62 130.88 130.82 123.91 133.31 128.49 133.00 145.47 148.50 148.96 139.39 138.38 145.74 137.00 138.00 145.67 155.11 150.35 141.85 137.53 139.62 149.37 152.96 165.30 156.87 166.06
Expert Answer:
Answer rating: 100% (QA)
To answer the questions we need to calculate the average return standard deviation correlation and beta for the given stock data First lets organize the data Date SP 500 Adj Close Price BBY Adj Close ... View the full answer
Related Book For
Fundamentals of Investments
ISBN: 978-0132926171
3rd edition
Authors: Gordon J. Alexander, William F. Sharpe, Jeffery V. Bailey
Posted Date:
Students also viewed these finance questions
-
Modify Listing 20.6, MultipleBallApp.java to assign a random radius between 2 and 20 when a ball is created. When the - button is clicked, one of largest balls is removed. Listing 1 import...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
A researcher wanted to find out if there was difference between older movie goers and younger movie goers with respect to their estimates of a successful actors income. The researcher first...
-
How do the Uniform Trade Secrets Act (UTSA) and the Economic Espionage Act of 1996 differ? Why don't these acts always provide a sufficient remedy for the theft of trade secrets?
-
Norsk Optronics, ALS, of Bergen, Norway, had a current ratio of 2.5 on June 30 of the current year. On that date, the companys assets were: The Norwegian currency is the krone, denoted here by the...
-
a) The function is increasing. The table below gives values for the function at selected values of x. A logarithmic regression y=a+blnx is used to model the data. Find the logarithmic regression...
-
How many liters of bio-oil can be generated with Iowa's 2009 corn stover yield? Use appropriate data from Quick Stats, a \(65 \mathrm{wt} . \%\) yield of bio-oil from corn stover, and a bio-oil...
-
As stated in the previous problem, a government issued $8.5 million of special assessment bonds to nance a sewer-extension project. To service the debt, it assessed property owners $8.5 million....
-
Below are the chunks of code which needs refactoring, make them better in terms of design without changing their behavior. Also state what part you have changed and how it has led to better design....
-
Lang and Thomas, a local CPA firm, has been asked to bid on a contract to perform audits for three counties in its home state. Should the firm be awarded the contract, it must hire one new staff...
-
RIN(BASE) can generally be neglected in a transistor circuit with voltage divider bias when: RIN(BASE) > 10R2 R2 > RIN(BASE) R1 < < R2 RIN(BASE) > R2
-
What does NGO stand for?
-
Consider the effect on profitability of introducing a heat-mass exchanger into the ammonia synthesis loop operating at \(90 \mathrm{bar}\). What is the optimal operating temperature of the flash...
-
Which involves the greatest degree of uncertainty, an event or an incident?
-
An organization must decide between Singapore, London, or Buffalo as the location for the construction of a new manufacturing facility. Is this an example of a strate- gic, tactical, or...
-
An organization must decide whether a particular shipment should be sent by air freight or surface (ground) trucking. Is this an example of a strategic, tactical, or implementation level of decision?
-
Given m(w) 5w = 9w+7, answer the following: The average rate of change of m from - 3 to 5 = Round answers to 3 decimal places as needed.
-
Write a paper about the Working relationship in the organization- collaboration within and outside the organization
-
There are literally thousands of mutual funds available for purchase. Describe what criteria you might use in selecting from among these many funds.
-
Bones Ely owns a $1,000 face-value bond with three years to maturity. The bond makes annual interest payments of $75, the first to be made one year from today. The bond is currently priced at...
-
Explain why call options on nondividend-paying stocks are "worth more alive than dead."
-
a. Assume that \(y_{1}, \ldots, y_{n}\) are i.i.d. with a negative binomial distribution with parameters \(r\) and \(p\). Determine the maximum likelihood estimators. b. Use the sampling mechanism in...
-
For the data in Table 12.1, confirm that the Pearson statistic in equation (12.3) is 41.98 . Table 12.1 (12.3) Count Observed (j) (nj) Fitted Counts Using the Poisson Distribution (np;) 01234 6,996...
-
Consider a Poisson regression. Let \(e_{i}=y_{i}-\widehat{\mu}_{i}\) denote the \(i\) th ordinary residual. Assume that an intercept is used in the model so that one of the explanatory variables...
Study smarter with the SolutionInn App