Question

You are analyzing the historical performance of a stock. The annual returns for the last ten...

You are analyzing the historical performance of a stock. The annual returns for the last ten years are shown below.

Year Ann Ret

2018 12%

2017 9%

2016 ‐5%

2015 3%

2014 ‐13%

2013 6%

2012 20%

2011 0%

2010 ‐6%

2009 14%

Calculate the average annual return, the variance and standard deviation of this stock over the ten‐year period.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Avg Ret = Sum [ Ret ] / n

= [ 12%+9%-5%+3%-13%+6%+20%+0%-6%+14% ] / 10

= 40% / 10

= 4%

Variance = sum [ (X -AvgX)^2 ] / n

Year X X - Avg X (X- Avg X)^2
2018 12.00% 8.00% 0.0064
2017 9.00% 5.00% 0.0025
2016 -5.00% -9.00% 0.0081
2015 3.00% -1.00% 0.0001
2014 -13.00% -17.00% 0.0289
2013 6.00% 2.00% 0.0004
2012 20.00% 16.00% 0.0256
2011 0.00% -4.00% 0.0016
2010 -6.00% -10.00% 0.01
2009 14.00% 10.00% 0.01
Sum [ (X- Avg X)^2 ] 0.0936
Variance = Sum [ (X- Avg X)^2 ] / n 0.00936

SD = SQRT [ Variance ]

= SQRT [ 0.00936 ]

= 0.0967

Add a comment
Know the answer?
Add Answer to:
You are analyzing the historical performance of a stock. The annual returns for the last ten...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Use the following historical stock returns for GAF, Inc. to answer questions 19 and 20: Annual...

    Use the following historical stock returns for GAF, Inc. to answer questions 19 and 20: Annual Stock Return Year 2005 13% 2006 1% 2007 -6% 2008 19% 2009 39% 2010 46% 2011 6% 2012 -4% 2013 14% 2014 -6% 2015 8% 0% 2016 2017 16% 2018 22% 19. What was the average annual historical return for GAF, Inc. over the 14 year period? 20. What was the standard deviation of retuns for GAF, Inc. stock over the 14 year time...

  • Use the following historical stock returns for GAF, Inc. to answer questions 19 and 20: Year...

    Use the following historical stock returns for GAF, Inc. to answer questions 19 and 20: Year Annual Stock Return 2005 13% 2006 1% 2007 -6% 2008 19% 2009 39% 2010 46% 2011 6% 2012 -4% 2013 14% 2014 -6% 2015 8% 2016 0% 2017 16% 2018 22% 19. What was the average annual historical return for GAF, Inc. over the 14 year period? 20. What was the standard deviation of returns for GAF, Inc. stock over the 14 year time...

  • 2005 Use the following historical stock returns for GAF, Inc. to answer questions 19 and 20:...

    2005 Use the following historical stock returns for GAF, Inc. to answer questions 19 and 20: Year Annual Stock Return 13% 2006 1% 2007 -6% 2008 19% 2009 39% 46% 2011 6% 2012 -4% 2013 14% 2014 -6% 2015 8% 2016 0% 2017 16% 2018 22% 2010 19. What was the average annual historical return for GAF, Inc. over the 14 year period? 20. What was the standard deviation of returns for GAF, Inc. stock over the 14 year time...

  • You purchased 100 shares of McDonald's Corp. common stock on 04/01/2009 for $57.49 per share. On...

    You purchased 100 shares of McDonald's Corp. common stock on 04/01/2009 for $57.49 per share. On December 29, 2017 you sold the 100 shares for $172.12 per share. Dividend payment dates and amounts per share for the period of time you owned the stock are shown below. PLEASE SHOW EXCEL FUNCTIONS/FORMULAS (A) Calculate your annual rate of return on this investment. (B) Calculate your annual rate of return without including the dividends in the calculation. You will need to use...

  • Annual and Average Returns for Stocks, Bonds, and T-Bills, 1950 to 2017 Long-Term Treasury Bonds 6.6%...

    Annual and Average Returns for Stocks, Bonds, and T-Bills, 1950 to 2017 Long-Term Treasury Bonds 6.6% 0.0 1.6 1950 to 2017 Average 1950 to 1959 Average 1960 to 1969 Average 1970 to 1979 Average 1980 to 1989 Average 1990 to 1999 Average 2000 to 2009 Average Annual Return 2011 Annual Return 2012 Annual Return 2013 Annual Return 2014 Annual Return 2015 Annual Return 2016 Annual Return 2017 Annual Return 2010 to 2017 Average Stocks 12.7% 20.9 8.7 7.5 18.2 19.0...

  • Stocks A and B have the following historical returns: Year Stock A's Returns, A Stock B's...

    Stocks A and B have the following historical returns: Year Stock A's Returns, A Stock B's Returns, re 2011 - 23.40% 15.7094 2012 31.50 29.30 2013 17.75 28.40 2014 - 1.50 - 12.80 2015 29.00 24.15 .. Calculate the average rate of return for stock A during the period 2011 through 2015. Round your answer to two decimal places. Calculate the average rate of return for stock B during the period 2011 through 2015. Round your answer to two decimal...

  • Stocks A and B have the following historical returns Year Stock A'sReturns, A Stock B's Returns,...

    Stocks A and B have the following historical returns Year Stock A'sReturns, A Stock B's Returns, rB 2011 2012 2013 2014 2015 23.00%, 26.75 15.75 3.50 29.50 1 7.50% 16,80 26.40 10.40 30.20 a. Calculate the average rate of retum for stock A during the period 2011 through 2015. Round your answer to two decimal places. Calculate the average rate of retum for stock 8 during the period 2011 through 2015. Round your answer to two decimal places, b Assume...

  • 11. Quantitative Literacy (using numerical data to reason and accurately solve quantitative problems.) Part a. Analyzing...

    11. Quantitative Literacy (using numerical data to reason and accurately solve quantitative problems.) Part a. Analyzing 10 years of tuition data la. Interpretation The following Table A shows the average costs for the indicated academic year for all Texas public two-year community colleges. 2008-2009 2009-2010 2010-2011 2011-2012 2012-2013 2013-2014 2014-2015 $1662 $1746 $1858 $2040 $2146 $2204 $2290 2015-2016 2016-2017 2017-2018 2018-2019 2019-2020 2020-2021 $2324 $2437 $2560 $2620 ? ? Table A Texas Public Two-Year In-District Tuition and Fees Source: The...

  • Passive Stock Market Investor (PSMI) holds one stock market index ETF in his/her portfolio, but has...

    Passive Stock Market Investor (PSMI) holds one stock market index ETF in his/her portfolio, but has learned that investing in a bond market index ETF as well may reduce his/her portfolio risk due to diversification. The annual returns for both ETFs for the last ten years are listed below. Measured by the standard deviation of returns, by how much would PSMI’s portfolio’s historical risk been reduced if PSMI invested 70% in the stock market index ETF and 30% in the...

  • The following table sets out the CPI index for each quarter from March 2009 to March...

    The following table sets out the CPI index for each quarter from March 2009 to March 2018. Use this information to answer questions 2, 3 and 4 below. Quarter Consumer price index; All groups - Quarterly Mar-2009 92.5 Jun-2009 92.9 Sep-2009 93.8 Dec-2009 94.3 Mar-2010 95.2 Jun-2010 95.8 Sep-2010 96.5 Dec-2010 96.9 Mar-2011 98.3 Jun-2011 99.2 Sep-2011 99.8 Dec-2011 99.8 Mar-2012 99.9 Jun-2012 100.4 Sep-2012 101.8 Dec-2012 102.0 Mar-2013 102.4 Jun-2013 102.8 Sep-2013 104.0 Dec-2013 104.8 Mar-2014 105.4 Jun-2014 105.9...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT