Using the data in the following table, and the fact that the correlation of A and B is 0.52, calculate the volatility (standard deviation) of a portfolio that is 50% invested in stock A and 50% invested in stock B. (Click on the following icon in order to copy its contents into a spreadsheet.) Realized Returns Year 2008 2009 2010 2011 2012 2013 Stock A -3% 11% 5% -3% 2% 9% Stock B 15% 22% 8% - 5% 15% 15% The standard deviation of the portfolio is%. (Round to two decimal places.)

Using the data in the following table, and the fact that the correlation of A and B is 0.52, calculate the volatility (standard deviation) of a portfolio that is 50% invested in stock A and 50% invested in stock B. (Click on the following icon in order to copy its contents into a spreadsheet.) Realized Returns Year 2008 2009 2010 2011 2012 2013 Stock A -3% 11% 5% -3% 2% 9% Stock B 15% 22% 8% - 5% 15% 15% The standard deviation of the portfolio is%. (Round to two decimal places.)

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

8. (Portfolio of two stocks) The following spreadsheet presents data for stocks A and B. A B C 1 2 RETURN STATISTICS OF STOCKS A AND B Stock A Stock B 3 Average return 15% 10% 4 Variance 0.12 0.07 5 Standard deviation 34.64% 26.46% 6 7 Covariance of return, Cov(AIB) 0.0160 0.1746 <=B7/(B5*C5) a. 8 Correlation of return What are the return and the standard deviation of a portfolio com- posed of 30% of stock A and 70% of stock B? b. What are the return and the standard deviation of an equally weighted portfolio of stocks A and B?
F1 plaese help.....
How can I calculate geometric average in Excel?
What is Stock X's geometric returns if it has the following returns? Year 1 8% Year 2 - 5% Year 3 10% Year 4 - 6% Year 5 15% a. 4.1%. b. 5.2% c. 6.8% d. 8.5%
Syntex, Inc. is considering an investment in one of two common stocks. Given the information that follows, which investment is better, based on the risk (as measured by the standard deviation) and return? Common Stock A Common Stock B Probability Return Probability Return 0.35 13% 0.25 −7% 0.30 17% 0.25 8% 0.35 21% 0.25 15% 0.25 23% (Click on the icon in order to copy its contents into a spreadsheet.) Question content area bottom Part 1 a. Given the information in the table, the expected rate of return for stock A is enter your response here%. (Round to two decimal places.)
Using the data in the following table, calculate the volatility (standard deviation) of a portfolio that is 75% invested in stock A and 25% in stock B.
Given the time series of historical stock returns below, what is the standard deviation? (Hint: theexpected return is 4%)Time Period 1 2 3 4 5return (%) 5% -7% 12% 13% -3% a. 7.585%b. 0.79%c. 8.888%d. 2.155%
Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's Returns, rA 2014 (19.00 (14.70 %) 2015 34.75 19.50 2016 13.75 30.90 2017 (4.25 (9.30 ) 2018 34.25 33.10 Calculate the coefficient of variation for each stock and for the portfolio. Round your answers to two decimal places. Stock A Stock B Portfolio CV Assuming you are a risk-averse investor, would you prefer to hold Stock A, Stock B, or the portfolio?
A stock has had the following year-end prices and dividends: Year 1234 in 10 5 6 Price $64.68 71.55 77.35 63.62 73.81 83.25 Dividend Arithmetic average return. Geometric average return $.67 .72 .78 .87 .94 What are the arithmetic and geometric returns for the stock? Note: Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g.. 32.16. % %
Review the following market information: Current Stock Market Return 11.25% Current T-Bill Price $979.43 Historic T-Bill Average Return 2.80% Historic Stock Market Average Return 8.10% Stock Beta 1.23 What is the required return (rounded to two places)?
Using the data in the following table, calculate the volatility (standard deviation) of a portfolio that is 60% invested in stock A and 40% in stock B. The volatility of the portfolio is %. (Round to two decimal places.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Year Stock A Stock B 2010 2011 2012 2013 2014 2015 -10% 19% 4% -3% 5% 12% 19% 39% 24% -8% -8% 35% Print Done Х
None

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS