Question
In: Finance
The table below shows annual returns for stocks of companies X and Y. Calculate the arithmetic...
| The table below shows annual returns for stocks of companies X and Y. Calculate the arithmetic average returns. In addition, calculate their variances, as well as their standard deviations. |
| Returns | ||
| Year | X | Y |
| 1 | 11 % | 19 % |
| 2 | 29 | 40 |
| 3 | 18 | -9 |
| 4 | -19 | -23 |
| 5 | 20 | 48 |
| Requirement 1: | |
| (a) | The arithmetic average return of company X's stock is: |
| (Click to select) 11.80% 9.56% 13.33% 14.75% 14.40% | |
| (b) |
The arithmetic average return of company Y's stock is: |
| (Click to select) 15.00% 16.95% 18.30% 12.15% 18.75% |
| Requirement 2: | |
| (a) | The variance of company X's stock returns is: (Do not round intermediate calculations.) |
| (Click to select) 0.027354 0.041997 0.033770 0.033597 0.042213 | |
| (b) | The variance of company Y's stock returns is: (Do not round intermediate calculations.) |
| (Click to select) 0.075938 0.117188 0.107043 0.093750 0.085635 |
| Requirement 3: | |
| (a) |
The standard deviation of company X's stock returns is: (Do not round intermediate calculations.) |
| (Click to select) 18.23% 14.89% 20.49% 18.38% 22.97% | |
| (b) |
The standard deviation of company Y's stock returns is: (Do not round intermediate calculations.) |
| (Click to select) 32.72% 29.26% 24.80% 30.62% 38.27% |
rev: 09_20_2012
Next Visit question map
Question1of10Total1 of 10
Prev
Solutions
Expert Solution
Requirement 1)
Arithmetic Return = Sum of all returns / Number of observations
For Stock X
xbar = (11% + 29% + 18% - 19% + 20%) / 5
xbar = 11.8% -- Average return
For Stock Y
Ybar = (19% + 40% - 9% - 23% + 48%) / 5
Ybar = 15.00% -- Average return
--------------------------------------
Requirement 2)
Variance
For Stock X
| Year | X | X- Xbar | (X - Xbar)^2 | |
| 1 | 11% | -0.80% | 6.4E-05 | |
| 2 | 29% | 17.20% | 0.029584 | |
| 3 | 18% | 6.20% | 0.003844 | |
| 4 | -19% | -30.80% | 0.094864 | |
| 5 | 20% | 8.20% | 0.006724 | |
| Xbar --- > | 11.80% | 0.13508 | Total |
Hence, Variance = 0.13508 / (5 - 1)
Variance = 0.0337700
For Stock Y
| Year | Y | Y- Ybar | (Y - Ybar)^2 | |
| 1 | 19% | 4.00% | 0.001600 | |
| 2 | 40% | 25.00% | 0.062500 | |
| 3 | -9% | -24.00% | 0.057600 | |
| 4 | -23% | -38.00% | 0.144400 | |
| 5 | 48% | 33.00% | 0.108900 | |
| Ybar --- > | 15.00% | 0.375000 | Total |
Hence, Variance = 0.375 / (5 - 1)
Variance = 0.093750
-----------------------------
Requirement 3)
For Stock X
Standard Deviation = Square root (0.033770)
Standard Deviation = 0.183766156 = 18.38%
For Stock Y
Standard Deviation = Square root (0.09375)
Standard Deviation = 0.306186218 = 30.62%
jeff jeffy answered 8 months agoRelated Solutions
EXCEL FILE ONLY Refer to the table below. The table below shows the annual returns (in...
EXCEL FILE ONLY
Refer to the table below. The table below shows the annual
returns (in percentages) for 2 major market indices. For each
index, calculate the arithmetic mean return and the geometric mean
return of full-year returns from 2005-2015. What is the
relationship between the arithmetic and geometric mean returns?
2015
2014
2013
2012
2011
2010
2009
2008
2007
2006
2005
Nasdaq Composite Index
1.37
8.59
50.0
-31.5
-21.1
-39.3
85.6
39.6
21.6
22.7
39.9
Dow Jones Industrial Average...
Consider stocks of two companies A and B, the table below gives their expected returns and...
Consider stocks of two companies A and B, the table below gives
their expected returns and standard deviation Expected return for
Stock A 10% Expected return for Stock B 25% Standard deviation for
Stock A 12% Standard deviation for Stock B 30% Plot the risk and
expected return of portfolio of these two stocks for the following
correlation coefficient : -1.0,-0.5,0.0,0.5,1.0
Table below shows the historical returns for Companies A, B and C Year Company A Company...
Table below shows the historical returns for Companies A, B and
C
Year
Company A
Company B
Company C
1
30%
26%
47%
2
7%
15%
-54%
3
18%
-14%
15%
4
-22%
-15%
7%
5
-14%
2%
-28%
6
10%
-18%
40%
7
26%
42%
17%
8
-10%
30%
-23%
9
-3%
-32%
-4%
10
38%
28%
75%
11
27.0%
23.4%
42.3%
12
6.3%
13.5%
-48.6%
13
16.2%
-12.6%
13.5%
14
-19.8%
-13.5%
6.3%
15
-12.6%
1.8%
-25.2%
16...
Calculate the expected returns for the stocks of the following companies: Beta &
Calculate the expected returns for the stocks of the following
companies:
Beta
Treasury Bill Return
S&P 500 Return
Adidas
0.62
3.9%
10.7%
Pepsico
0.36
3.9%
10.7%
Dine
Brands
0.56
3.9%
10.7%
If the actual returns to these stocks are: Dine Brands 7.71%;
Pepsico 8.1%; and Adidas 7.5%, which stock is undervalued,
overvalued or correctly valued?
3. The table below shows units of commodity X and Y that the U.S. and Mexico...
3. The table below shows units of commodity X and Y that the
U.S. and Mexico can produce with one- hour of labor time. Output
Per Hour of Labor Commodity U.S. Mexico X (in units) 5 20 Y (in
units) 30 5
a. Identify the commodity in which the U.S. and Mexico have a
comparative advantage.
Output Per Hour of Labor
Commodity
U.S.
Mexico
X (in units)
5
20
Y (in units)
30
5
b. Suppose that the U.S. exchanges...
Table 3 (below) shows annual returns for the S&P 500 for the years 2000-2016: Table 3:...
Table 3 (below) shows annual returns for the S&P 500 for
the years 2000-2016:
Table 3: Annual Returns
Year
Returns
2000
-9.0%
2001
-11.9%
2002
-22.0%
2003
28.4%
2004
10.7%
2005
4.8%
2006
15.6%
2007
5.5%
2008
-36.6%
2009
25.9%
2010
14.8%
2011
2.1%
2012
15.9%
2013
32.2%
2014
13.5%
2015
1.4%
2016
11.7%
Calculate:
The cumulative return over the 17 years;
The average annual return;
The standard deviation;
The Sharpe Ratio (assuming a risk free rate of 2.3% on...
question 8 parts a-e a Returns on stocks X and Y are listed below: Period 1...
question 8 parts a-e
a
Returns on stocks X and Y are listed below:
Period
1
2
3
4
5
6
7
Stock X
8%
0%
3%
-2%
5%
12%
7%
Stock Y
5%
-2%
4%
7%
1%
12%
-3%
What is the correlation of returns on the two
stocks?
Please round your answer to the nearest hundredth.
Note that the correct answer will be evaluated based on the
full-precision result you would obtain using Excel.
b
Returns on stocks...
Using the table below, calculate the variance of X, variance of Y, standard deviation of X,...
Using the table below, calculate the variance of X, variance of
Y, standard deviation of X, standard deviation of Y,
the covariance between X and Y, the correlation coefficient between
X and Y, and find the regression line assuming X is the independent
variable (find the slope and the intercept). Show your work
Fill in the Blanks:
X
Y
X-Xbar
Y-Ybar
(X-Xbar)^2
(Y-Ybar)^2
(X-Xbar)*(Y-Ybar)
5
3
9
6
12
15
17
20
21
23
Sum
Calculate the following and show...
In table 1.1 below, information on three stocks (X, Y and Z) in the next period...
In table 1.1 below, information on three stocks (X, Y and Z) in
the next period is stated. The stocks are traded on a financial
market, where the usual assumptions for a normal market are
satisfied. It is assumed, that a risk-free asset is traded on the
financial market as well, which has a return of 5% (rf) in the next
period.
Problem: Determine the tangent portfolio of the three stocks (i.e.
determine the weights that the three stocks have...
The table below shows the production possibilities of two countries, X and Y, of two goods,...
The table below shows the production possibilities of two
countries, X and Y, of two goods, A and B, given a fixed amount of
resources and particular technology. (For country X: a worker can
produce per month 78A or 26B. For country Y a worker can produce
per month Y: 96A or 48B).
A
B
X
78
26
Y
96
48
1. Which country has the absolute advantage in A, and which
country has the absolute advantage in B? (1...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Why does a particular codon represent only one specific amino acid?
- Write a function template sort that takes two references to generic objects and switches them if...
- What 2 things happen to the melting point of a solid when an impurity is present?
- How Can Hominin Evolution be characterized as " mosaic evolution" Use examples of species from the...
- Absorption and Variable Costing Income Statements for Two Months and Analysis During the first month of...
- Mobile and wireless devices are being increasingly used in the Business Administration and Management Industry. write...
- What are the options that might be considered in relation to introducing flexible work practices? What...
ADVERTISEMENT