Reference no: EM131564502
Spread Sheet Exercise
The data below are annual total returns for General Foods and Sigma Technology for the period 1997-2011. Sigma Technology is highly regarded by many investors for its innovative products. It had returns more than twice as large as that of General Foods. What would have been the results if an investor had placed half her funds in General Foods and half in Sigma Technology during this 15-year period in order to try to earn a larger return than that avaible in General Foods alone? Would the risk have been too large?
a. Calculate the arithmetic mean returns for each stock.
b. Calculate the standard deviation for each stock using the STDEV function in the spreadsheet.
c. Calculate the correlation coefficient using the CORREL function in the spreadsheet.
d. Calculate the covariance using the COVAR function in the spreadsheet.
e. Calculate the portfolio return assuming equal weight for each stock.
f. Set up a calcuation for the standard deviation of the portfolio that will allow you to substitute different values for the correlation coefficient or the standard deivations of the stocks. Using equal weights for the two stocks calculate the standard deviation of the portolio consisting of equal parts of the two stocks.
g. How does the portfolio return compare to the retuen of the General Foods alone? How does the risk of the portfolio compare to the risk of having held General Foods alone?
h. Assume that the correlation between the two stocks had been -0.10. How much would portfolio risk have changed relative to the result calculated in f?
GF ST
2011 -0.141 0.222
2010 0.203 0.079
2009 -0.036 -0.0220
2008 -0.204 0.527
2007 0.073 -0.628
2006 -0.111 0.684
2005 0.023 1.146
2004 0.291 0.564
2003 0.448 0.885
2002 0.482 0.433
2001 0.196 0.516
2000 0.103 -0.056
1999 0.075 0.153
1998 0.780 1.207
1997 0.254 0.736
|
What percent of light is transmitted through the second pane
: A double-pane window has a thin air space between two parallel panes of glass. If 90.0% of the incoming light is transmitted through a pane, and 10.0%.
|
|
Music influence the development of recording techniques
: The use of drugs by musicians of the 1960s, a tradition they inherited from the older blues and jazz players
|
|
Consumer surplus does he receive
: How many times will Eli use the health club for a workout, and how much consumer surplus does he receive? Explain.
|
|
Develop a template for the stock element
: Develop a template for the stock element and, within the template, enter the following HTML code: Save your changes to the portfolio.xsl file.
|
|
Calculate the arithmetic mean returns for each stock
: Calculate the arithmetic mean returns for each stock. Calculate the covariance using the COVAR function in the spreadsheet.
|
|
Role in behavioral economics
: With all of the ads on social media, do you think social media plays a role in behavioral economics? Why or Why not?
|
|
Result of the global economic crisis
: Specifically, the leaders addressed, "what we have learned - and what we need to do differently as a result of the Global Economic Crisis that began in 2008".
|
|
Diagnosis of major depressive disorder
: patient on the psychiatric unit with a diagnosis of Major Depressive Disorder
|
|
In what types of situations would capital budgeting decision
: Suppose you deposited the $1,000 in 4 payments of $250 each at the end of Years 1, 2, 3, and 4.
|