You Are Considering An Investment in The Stock Market and
You Are Considering An Investment in The Stock Market and
You Are Considering An Investment in The Stock Market and
#3523
You are considering an investment in the stock market and have identified two potential stocks
(XYZ and ABC) to purchase. The historical returns for the past five years are shown in the table
below.Year XYZ Returns ABC Returns2007................................9.50%.........................................
...............22.50%2008...............................13.50%.......................................................10.80%200
9...............................18.13%.......................................................17.10%2010................................
8.10%........................................................11.70%2011...............................11.70%.......................
..................................7.20%a. Calculate the average return and standard deviation of returns for
each stock over the past five years. Which stock would you prefer to own? Would everyone
make the same choice?b. Calculate the correlation coefficient between the two stocks. Does it
appear that a portfolio consisting of XYZ and ABC would provide good diversification?c.
Calculate the annual returns that would have been achieved had you owned a portfolio
consisting of 50% in XYZ and 50% in ABC over the past five years.d. Calculate the average
return and standard deviation of returns for the portfolio. How does the portfolio compare with
the individual stocks? Would you prefer the portfolio to owning either of the stocks alone?e.
Create a chart that shows how the standard deviation of the portfolio's returns changes as the
weight of XYZ changes.f. Using the Solver, what is the minimum standard deviation that could
be achieved by combining these stocks into a portfolio? What are the exact weights of the
stocks that result in this minimum standard deviation?View Solution:
You are considering an investment in the stock market and
ANSWER
http://paperinstant.com/downloads/you-are-considering-an-investment-in-the-stock-market-and/
1/1
Powered by TCPDF (www.tcpdf.org)