Question

The following table shows historical beginning-of-year prices for a stock and the S&P 500. A B...

The following table shows historical beginning-of-year prices for a stock and the S&P 500.

A B C
1 Year Stock S&P 500
2 2011 32.67 577.69
3 2012 30.74 514.57
4 2013 30.11 436.52
5 2014 32.22 459.71
6 2015 29.92 384.76
7 2016 31.69 350.52
8 2017 29.46 309.2
9 2018 29.49 407.22
10 2019 30.37 460.6

Calculate the annual returns and regress the returns on the stock on the returns on the S&P 500.

What is the R2 of the regression?

Homework Answers

Answer #1

1. Annual Returns = (Closing price - Opening price) / Opening Price

2. Regression of returns of stock

R2 of the regression = 0.21168

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
Calculate the historical variance: Year Closing Stock Price 2009 32.25 2010 43.83 2011 60.30 2012 41.18...
Calculate the historical variance: Year Closing Stock Price 2009 32.25 2010 43.83 2011 60.30 2012 41.18 2013 46.94 2014 50.94 2015 32.97 2016 55.34 2017 55.09 2018 44.86 2019 72.59 Submit your answer as a decimal.
Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's...
Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's Returns, rB 2011 - 21.60% - 15.00% 2012 24.00 23.50 2013 16.50 33.90 2014 - 1.50 - 7.70 2015 26.50 9.20 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...
Problem 6-13 Historical Realized Rates of Return Stocks A and B have the following historical returns:...
Problem 6-13 Historical Realized Rates of Return Stocks A and B have the following historical returns: Year 2012 -24.70% -14.40% 2013 22.75 23.00 2014 11.75 37.10 2015 -2.50 -6.10 2016 31.50 -0.80 Assume that someone held a portfolio consisting of 50% of Stock A and 50% of Stock B. What would have been the realized rate of return on the portfolio in each year? What would have been the average return on the portfolio during this period? Round your answers...
Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's...
Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's Return rB 2013 -22.70% -15.00% 2014 23.00 16.40 2015 10.25 36.00 2016 -5.75 -9.30 2017 33.50 10.20 Calculate the average rate of return for Stock A during the period 2013 through 2017. Round your answer to two decimal places.______% Calculate the average rate of return for Stock B during the period 2013 through 2017. Round your answer to two decimal places.______% Assume that someone...
Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's...
Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's Returns, rB 2013 - 23.90% - 16.20% 2014 30.75 15.00 2015 15.25 20.90 2016 - 1.00 - 9.10 2017 31.50 42.00 Calculate the average rate of return for stock A during the period 2013 through 2017. Round your answer to two decimal places. _______ % Calculate the average rate of return for stock B during the period 2013 through 2017. Round your answer to...
8-20 REALIZED RATES OF RETURN Stocks A and B have the following historical returns: Year Stock...
8-20 REALIZED RATES OF RETURN Stocks A and B have the following historical returns: Year Stock A's Returns, rA. Stock B's Returns, rB 2011 (18.00%) (14.50%) 2012 33.00 21.80 2013 15.00 30.50 2014 (0.50) (7.60) 2015 27.00 26.30 a. Calculate the average rate of return for each stock during the period 2011 though 2015. b. Assume that someone held a portfolio consisting of 50% of Stock A and 50% of Stock B. What would the realized rate of return on...
A stock has the following historical stock prices. What is the standard deviation of the stock’s...
A stock has the following historical stock prices. What is the standard deviation of the stock’s returns? Year Price 2015 $          43 2016 $          55 2017 $          85 2018 $          70 2019 $          77 2020 $          84 Question 15 options: 19.44% 27.54% 47.03% 26.65% 30.67%
Stocks A and B have the following historical returns: Year 2012 -22.30% -14.50% 2013 25.25 23.30...
Stocks A and B have the following historical returns: Year 2012 -22.30% -14.50% 2013 25.25 23.30 2014 13.00 22.70 2015 -4.75 -6.70 2016 25.25 11.65 Calculate the average rate of return for each stock during the 5-year period. Round your answers to two decimal places. Stock A % Stock B % Assume that someone held a portfolio consisting of 50% of Stock A and 50% of Stock B. What would have been the realized rate of return on the portfolio...
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%