Question
In: Finance
The following table shows the past annual returns for Stock A and Stock B, please find...
The following table shows the past annual returns for Stock A and Stock B, please find the expected return, standard deviation and coefficient of variation for Stock A, Stock B and a Portfolio that puts 40% weight on Stock A and 60% weight on Stock B.
Year Stock A Returns Stock B Returns
2005 10.30% 10.71%
2006 -0.10% 25.00%
2007 23.30% 0.38%
2008 2.20% 26.20%
2009 14.00% 11.52%
Solutions
Expert Solution
The expected return for stock A and B has been calculated using SUM function, standard deviation has been calculated using STDEV function , covariance between the stocks has been calculated using COVARIANCE function
jeff jeffy answered 1 year agoRelated Solutions
The following table shows the annual returns (in percent) and summary measures for a sample of...
The following table shows the annual returns (in percent) and
summary measures for a sample of returns from the Vanguard Energy
Fund and the Vanguard Health Care Fund from 2012 through 2016.
Year
Energy (%)
Health Care (%)
2012
44.6
15.41
2013
19.68
10.87
2014
37
10.43
2015
-42.87
-18.45
2016
28.36
20.96
If the risk-free rate is 3%, using mean-variance analysis, which
fund performed better, and why?
a.
The Energy Fund performed better, because its Sharpe Ratio was
higher....
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...
The following table shows the annual returns over a six year period for the S&P 500...
The following table shows the annual
returns over a six year period for the S&P 500 market index and
MCH, Inc. Assume that the historical information represents a
population. Use this data to calculate the correlation between both
sets of security returns. Discuss your findings.
Year
S&P
500
MCH,
Inc.
2013
0.15
0.37
2014
0.13
0.09
2015
0.14
-0.11
2016
-0.09
0.08
2017
0.12
0.11
2018
0.09
0.04
Please show me each step. Thank you
The following table shows the annual returns over a six year period for the S&P 500...
The following table shows the annual
returns over a six year period for the S&P 500 market index and
MCH, Inc. Assume that the historical information represents a
population. Use this data to calculate the correlation between both
sets of security returns. Discuss your findings.
Year
S&P
500
MCH,
Inc.
2013
0.15
0.37
2014
0.13
0.09
2015
0.14
-0.11
2016
-0.09
0.08
2017
0.12
0.11
2018
0.09
0.04
The following table contains annual returns for the stocks of ABC Corp. (ABC) and Company B...
The following table contains annual returns for the stocks of
ABC Corp. (ABC) and Company B (B). The returns are calculated
using end-of-year prices (adjusted for dividends and stock
splits). Use the information for ABC Corp. (ABC) and Company B
(B) to create an Excel spreadsheet that calculates the average
returns over the 10-year period for portfolios comprised of ABC
and B using the following, respective, weightings: (1.0, 0.0),
(0.9, 0.1), (0.8, 0.2), (0.7, 0.3), (0.6, 0.4), (0.5, 0.5),
(0.4,...
Below are the annual returns of the stock A, B, C and D and the market...
Below are the annual returns of the stock A, B, C and D and the
market portfolio for the period 2018-2022. Find the expected return
and standard deviation of the stock A, B, C, D and the market
portfolio. PREPARED BY HANDWRITING.
Year
Prob.
Asset A
Asset B
Asset C
Asset D
Market
2018
0,20
11,00
9,00
12,00
15,00
14,00
2019
0,25
13,00
11,00
15,00
13,00
12,00
2020
0,10
9,00
8,00
11,00
10,00
9,00
2021
0,20
12,00
12,00
11,00
13,00...
Company A and B are both service companies. For the past three years their stock returns...
Company A and B are both service companies. For the past three
years their stock returns were:
A: -5%, 15%, 20%
B: 8%, 8%, 20%
If A and B are combined into a portfolio with 50% of the funds
invested in each stock, calculate the expected return on the
portfolio.
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...
The annual returns of three stocks for the past seven years are given in the following...
The annual returns of three stocks for the past seven
years are given in the following table:
Year
Stock X
Stock Y
Stock Z
2011
3.00%
14.00%
19.00%
2012
9.00%
7.00%
11.00%
2013
12.00%
19.00%
5.00%
2014
19.00%
13.00%
12.00%
2015
23.00%
-7.00%
11.00%
2016
5.00%
-3.00%
7.00%
2017
10.00%
9.00%
14.00%
Determine the average return and the standard deviation of
returns for each stock. Which stock has the highest expected return
and which one has the highest risk?
Determine...
Table 2 shows regressions of the standard deviation and Sharpe ratio of household portfolio annual returns...
Table 2 shows regressions of the standard deviation and Sharpe
ratio of household portfolio annual returns for different brackets
of the distribution of net wealth in Sweden between 1999 and 2007
(standard errors are not reported). The reported Sharpe ratio of a
household portfolio is equal to the expected return of the
portfolio divided by its standard deviation. The Sharpe ratio is
used to measure performance in relation to risk taken. For example,
when comparing two portfolios, the one with...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Respond to the following in a minimum of 175 words: Discuss what elements should be present...
- 1) The 3rd bright fringe of a double slit interference pattern is 30.0 cm above the...
- A solar cell generates a potential difference of 0.320 V when a 445.0 ? resistor is...
- A ceiling fan consists of a small cylindrical disk with 5 thin rods coming from the...
- You measure the following quantities as A = 1.0 m ± 0.2 m, B = 2.0...
- Froya Fabrikker A/S of Bergen, Norway, is a small company that manufactures specialty heavy equipment for...
- When the electricity goes out on your campus, a backup source powers the servers that handle...
ADVERTISEMENT