Question

You are given the following information concerning a stock and the market Returns Market Stock Year 15% 27% 19 2011 2012 19 2

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

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

cell references are providedSTATS - Microsoft Excel (Product Activation Failed) Add-Ins File Home Insert Page Layout Formulas Data Review View - 2x % Cut

Add a comment
Know the answer?
Add Answer to:
You are given the following information concerning a stock and the market Returns Market Stock Year...
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
  • You are given the following information concerning a stock and the market: Returns Year Market Stock...

    You are given the following information concerning a stock and the market: Returns Year Market Stock 2011 15 % 27 % 2012 14 30 2013 15 6 2014 −14 −24 2015 37 16 2016 15 25 a. Calculate the average return and standard deviation for the market and the stock. (Use Excel to complete the problem. Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places.) b. Calculate the correlation between the stock and...

  • You are given the following information concerning a stock and the market: Returns Year Market Stock...

    You are given the following information concerning a stock and the market: Returns Year Market Stock 2011 20 % 32 % 2012 10 10 2013 20 4 2014 −15 −29 2015 37 16 2016 15 16 a. Calculate the average return and standard deviation for the market and the stock. (Use Excel to complete the problem. Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places.) b. Calculate the correlation between the stock and...

  • Assume these are the stock market and Treasury bill returns for a 5-year period: Year 2011...

    Assume these are the stock market and Treasury bill returns for a 5-year period: Year 2011 2012 2013 2014 2015 Stock Market T-Bill Return Return (%) (%) -37.03 1.80 28.60 0.30 16.86 0.14 1.28 0.06 16.36 0.08 a. What was the risk premium on common stock in each year? (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places.) Year 2011 2012 Risk Premium (39.10) % 28.30% 16.721% 1.22 % 16.28 % 2013 2014...

  • 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...

  • here are two stocks in the market, Stock A and Stock B. The price of Stock...

    here are two stocks in the market, Stock A and Stock B. The price of Stock A today is $78. The price of Stock A next year will be $67 if the economy is in a recession, $90 if the economy is normal, and $100 if the economy is expanding. The probabilities of recession, normal times, and expansion are .23, .57, and .20, respectively. Stock A pays no dividends and has a correlation of .73 with the market portfolio. Stock...

  • REALIZED RATES OF RETURN NEED TO BE DONE USING EXCEL!!!! Stocks A and B have the following historical returns: Year S...

    REALIZED RATES OF RETURN NEED TO BE DONE USING EXCEL!!!! Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's Returns, rB 2011 - 24.00% - 12.10% 2012 20.50 23.70 2013 17.75 31.90 2014 - 5.25 - 11.70 2015 25.75 2.95 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...

  • 50% invested in stock A and 50% invested in stock B. the following table, and the...

    50% invested in stock A and 50% invested in stock B. the following table, and the fact that the correlation of A and B is 0.47, calculate the volatility (standard deviation) of a portfolio that Using the data Realized Returns Stock B Stock A Year - 5 % 19% 2008 35% 8% 2009 7% 8% 2010 -9% -2% 2011 -14 % 2% 2012 27% 12% 2013 . (Round to two decimal places.) The standard deviation of the portfolio is

  • You have been given the following return information for a mutual fund, the market index, and...

    You have been given the following return information for a mutual fund, the market index, and the risk-free rate. You also know that the return correlation between the fund and the market is 0.95. Risk-Free Year 2011 2012 2013 2014 2015 Fund -19.40% 25.10 13.70 7.20 -1.98 Market -37.50% 20.80 13.30 8.40 -4.20 NON Calculate Jensen's alpha for the fund, as well as its information ratio. (Do not round intermediate calculations. Enter the alpha as a percent rounded to 2...

  • You have been given the following return information for a mutual fund, the market index, and...

    You have been given the following return information for a mutual fund, the market index, and the risk-free rate. You also know that the return correlation between the fund and the market is 0.87. Year Fund Market Risk-Free 2011 –14.85 % –29.50 % 3 % 2012 25.10 20.00 5 2013 12.90 10.90 2 2014 7.20 8.00 5 2015 –1.50 –3.20 3 Calculate Jensen’s alpha for the fund, as well as its information ratio. (Do not round intermediate calculations. Enter the...

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