Question

The table below displays returns associated with a company's shares over the last 15 years. Year...

The table below displays returns associated with a company's shares over the last 15 years.

Year Return
(% pa)
2005 23
2006 17
2007 11
2008 15
2009 12
Year Return
(% pa)
2010 31
2011 2
2012 16
2013 8
2014 31
Year Return
(% pa)
2015 29
2016 5
2017 26
2018 6
2019 1

Based on this historic data, calculate the expected return on the shares and its standard deviation. Give your answers as a percentage per annum to 2 decimal places.

a)Expected return =  % pa

b)Standard deviation =  % pa

Homework Answers

Answer #1
Year Return Weight based on years Return*Weight Return - Expected return (Return - Expected return)^2
X X-X' (X-X')^2
2005 23 15 345 6.4 40.96
2006 17 14 238 0.4 0.16
2007 11 13 143 -5.6 31.36
2008 15 12 180 -1.6 2.56
2009 12 11 132 -4.6 21.16
2010 31 10 310 14.4 207.36
2011 2 9 18 -14.6 213.16
2012 16 8 128 -0.6 0.36
2013 8 7 56 -8.6 73.96
2014 31 6 186 14.4 207.36
2015 29 5 145 12.4 153.76
2016 5 4 20 -11.6 134.56
2017 26 3 78 9.4 88.36
2018 6 2 12 -10.6 112.36
2019 1 1 1 -15.6 243.36
Total 120 1992 1530.8
Expected return                            = 1992/120
= 16.6

Variance = Σ(X-X')^2 / n-1

= 1530.8 / 15-1

= 109.34

Standard deviation = √Variance

= √109.34

= 10.46

Know the answer?
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
Similar Questions
The table below displays returns associated with a company's shares over the last 15 years. Year...
The table below displays returns associated with a company's shares over the last 15 years. Year Return (% pa) 2005 9 2006 -2 2007 20 2008 -4 2009 18 Year Return (% pa) 2010 8 2011 19 2012 1 2013 13 2014 -2 Year Return (% pa) 2015 35 2016 -3 2017 28 2018 18 2019 31 Based on this historic data, calculate the expected return on the shares and its standard deviation. Give your answers as a percentage per...
Question 1 The table below displays returns associated with a company's shares over the last 15...
Question 1 The table below displays returns associated with a company's shares over the last 15 years. Year Return (% pa) 2004 19 2005 12 2006 17 2007 10 2008 32 Year Return (% pa) 2009 14 2010 4 2011 4 2012 30 2013 15 Year Return (% pa) 2014 26 2015 2 2016 10 2017 3 2018 28 Based on this historic data, calculate the expected return on the shares and its standard deviation. Give your answers as a...
Use the table for the question(s) below. Consider the following realized annual returns: Year End Index...
Use the table for the question(s) below. Consider the following realized annual returns: Year End Index Realized Return Stock A Realized Return 2006 23.6% 46.3% 2007 24.7% 26.7% 2008 30.5% 86.9% 2009 9.0% 23.1% 2010 -2.0% 0.2% 2011 -17.3% -3.2% 2012 -24.3% -27.0% 2013 32.2% 27.9% 2014 4.4% -5.1% 2015 7.4% -11.3% The variance of the returns on the Index from 2006 to 2015 is closest to:
How can I do regression analysis for Sales Revenue for Macys comparing it to TJX? Please...
How can I do regression analysis for Sales Revenue for Macys comparing it to TJX? Please show work and example in Excel if it's easier. Net Profit Margin 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 Sales Revenue - MACYS $ 15,776,000.00 $ 22,390,000.00 $ 26,970,000.00 $ 26,313,000.00 $    24,892,000.00 $ 23,489,000.00 $ 25,003,000.00 $ 26,405,000.00 $ 27,686,000.00 $ 27,931,000.00 $ 28,105,000.00 $ 27,079,000.00 $ 25,778,000.00 $ 24,837,000.00 Net Profit Margin 2005 2006 2007...
Create the following forecasts: a 4-period moving average forecast, an exponential smoothing forecast with alpha=0.2, and...
Create the following forecasts: a 4-period moving average forecast, an exponential smoothing forecast with alpha=0.2, and a linear trend forecast for your data. Calculate the MSE and MAPE for each. Plot the original series, and each of the forecasts. Create forecasts for 2017 Q1, 2017 Q2, 2017 Q3 and 2017 Q4 using each of these three techniques. If you had to choose one of these, which would you choose and why? Given your data, and this time period, would you...
(number 6) Below is a table found from the Bureau of Labor Statistics. Year CPI (index)...
(number 6) Below is a table found from the Bureau of Labor Statistics. Year CPI (index) Year CPI (index) 2000 172.2 2009 214.5 2001 177.1 2010 218.1 2002 179.9 2011 224.9 2003 184.0 2012 229.6 2004 188.9 2013 233.0 2005 195.3 2014 236.7 2006 201.6 2015 237.0 2007 207.3 2016 240.0 2008 215.3 What is the percent difference between 2015 and 2006? In 2006, my family income was $44,000. In 2016, my family income was $52,000. Using the percent change...
Suppose you are given the following end of year stock price data for Random Inc. stock....
Suppose you are given the following end of year stock price data for Random Inc. stock. Assume the returns are normally distributed, calculate the standard deviation of the annual returns. (Enter percentages as decimals and round to 4 decimals). Year Price 2005 43.65 2006 44.01 2007 45.77 2008 53.04 2009 45.67 2010 59.05 2011 46.88 2012 49.24 2013 43.99 2014 42.67 2015 48.14
The following data is provided for a market 500 Index: Year Total return Year Total return...
The following data is provided for a market 500 Index: Year Total return Year Total return 2000 16.0% 2010 2.0% 2001 8.0% 2011 3.0% 2002 -3.0% 2012 3.0% 2003 1.0% 2013 4.0% 2004 5.0% 2014 5.0% 2005 21.0% 2015 4.0% 2006 43.0% 2016 3.0% 2007 4.9% 2017 3.5% 2008 -7.0% 2018 4.5% 2009 0.1% 2019 5.8% Calculate the last 10 -year arithmetic average annual rate of return on the market Index. 3.78% 2.69% 0.37% 3.93%
The following data is provided for a market 500 Index: Year Total return Year Total return...
The following data is provided for a market 500 Index: Year Total return Year Total return 2000 16.0% 2010 2.0% 2001 8.0% 2011 3.0% 2002 -3.0% 2012 3.0% 2003 1.0% 2013 4.0% 2004 5.0% 2014 5.0% 2005 21.0% 2015 4.0% 2006 43.0% 2016 3.0% 2007 4.9% 2017 3.5% 2008 -7.0% 2018 4.5% 2009 0.1% 2019 5.8% Calculate the 20 -year geometric average annual rate of return on the market Index. 5.91% 3.32% 3.77% 0.28%
Consider the following realized annual returns: Year End Index Realized Return Stock A Realized Return 2006...
Consider the following realized annual returns: Year End Index Realized Return Stock A Realized Return 2006 23.6% 46.3% 2007 24.7% 26.7% 2008 30.5% 86.9% 2009 9.0% 23.1% 2010 -2.0% 0.2% 2011 -17.3% -3.2% 2012 -24.3% -27.0% 2013 32.2% 27.9% 2014 4.4% -5.1% 2015 7.4% -11.3% The average annual return on the Index from 2006 to 2015 is closest to: 8.75% 7.10% 9.75% 4.00%