Input area: State Probability Stock A Stock B Recession 0.15 0.04 (0.17) Normal 0.55 0.09 0.12 Boom 0.30 0.17 0.27 (Use cells A6 to D9 from the given information to complete this question.) Output area: Stock A Probability Return Product Return deviation Squared deviation Product Recession Normal Boom Standard deviation Stock B Recession Normal Boom E(R) Variance Probability Return Product Return deviation Squared deviation Product E(R) Standard Deviation Variance

Input area: State Probability Stock A Stock B Recession 0.15 0.04 (0.17) Normal 0.55 0.09 0.12 Boom 0.30 0.17 0.27 (Use cells A6 to D9 from the given information to complete this question.) Output area: Stock A Probability Return Product Return deviation Squared deviation Product Recession Normal Boom Standard deviation Stock B Recession Normal Boom E(R) Variance Probability Return Product Return deviation Squared deviation Product E(R) Standard Deviation Variance

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

The interpretation of stock beta coefficient requires an assumption of an average stock which has a beta coefficient of O +1 O -1 O 0.5
Given the following probability distribution, what are the expected return and the standard deviation of returns for Security J? State Pi ri 1 0.5 11% 2 0.3 8% 3 0.2 5% O 9.40%; 2.04% O 8.90%; 2.34% O 7.40%; 2.94% O 8.40%; 2.64% O 7.90%; 1.74%
QUESTION 1 Under which of the following scenarios, the minimum variance portfolio that contains two stocks has the smallest standard deviation? OA. The correlation between the two stock returns is -1 OB. The correlation between the two stock returns is -0.2 OC. The correlation between the two stock returns is 0.2 OD. The correlation between the two stock returns is 0.5
Suppose that there are four risky assets whose expected returns E(r) and variance- covariance matrix (S) are shown in the spreadsheet below. We also consider the portfolio weights of two portfolios x and y of risky assets (see Cells B8:E9): 1 8 Portfolio x 9 Portfolio y A FOUR-ASSET PORTFOLIO PROBLEM Variance-covariance, S 20 Portfolio variance, 21 Portfollo standard deviation o 0.10 0.01 0.03 0.05 11 Portfolio x and y statistics: Mean, variance, covariance, correlation 12 Mean, Ejr, 13 Variance, 14 Covariance() 15 Correlation P 16 17 Calculating returns of combinations of Portfolio x and Portfolio y 18 Proportion of x 19 Mean portfolio return, r 0.01 0.30 0.06 -0.04 0.20 0.20 10.50% 0.1216 0.0714 0.4540 ? ? ? 0.3 0.03 0.06 0.40 0.02 0.30 0.10 ? 0.05 0.02 0.50 0.40 0.10 0.10 0.60 Mean, Er Variance, 0.2014 Question il Question ili Mean returns E(r) ? 7% 9% 11% 20% Question i i. Write the Excel formula used to estimate the mean and variance of portfolio y in cells E12 and E13,…
Q3. Find the Expected Return, Variance, and Standard Deviation for the Stock Returns 1 and 2. Also, you are requested to find the Covariance and Coefficient of Variation with the following information. Probability Stock - 1 Stock - 2 42% 09% 01% 0.22 04% 39% 0.05 38% 47% 31% 41% 18%
Which of the following statements regarding standard deviation is TRUE: Group of answer choices A measure of the dispersion of a random variable The annualised volatility The square root of volatility Always expressed in %
how to calculate a stocks average monthly returnn, its return variance, standard deviation and betas
2. The following table gives information on the return and variance of assets A and B, whose covariance is 0.0003: A B 0} 0,0009 0,0012 E (R₂) 0,05 0,06 a. Does the portfolio (1/3 of A and 2/3 of B) dominate the portfolio (2/3 of A and 1/3 of B)? b. Does the portfolio (1/2, 1/2) belong to the efficient frontier? c. If there were the possibility of lending and borrowing at 2%, would the portfolio (1/2, 1/2) belong to the new efficient frontier?
From the following informatongiven below , calculate and differentiate between a. Arithmetic Mean, b. Geometric Mean and c. Standard Deviation Partiulard stock A stock B Year 1 13% 19% Year 2 15% 23% Year 3 12% 20% Year 4 11% 18%
Question A You are given the following data on two stocks (A and B): Stock A Stock BExpected return 10% 12%Variance 0.04 0.09You are unsure about the correlation of the two stocks. What is the highest possible variance for an equally-weighted portfolio? (Hint: think about which assumption on the correlation leads to the highest portfolio variance) Group of answer choices 0.0625 0.0535 0.0650 0.0400 Full explain this question and text typing work only We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line
The following table has expected returns and variance-covariance of five stocks. The T-Bill rate is 3. Variance-Covariance Returns V F GM WMT Y V 27.226 588.659 -275.078 -319.948 -36.805 -93.170 F 11.653 -275.078 5716.621 22.772 56.588 52.187 GM 4.633 -319.948 22.772 729.510 569.730 -258.506 WMT 12.905 -36.805 56.588 569.730 932.361 367.376 Y 6.908 -93.170 52.187 -258.506 367.376 1466.966 T-Bill 3.000 questions a) determine the Tangency portfolio weights and calculate its expected return, standard deviation and Sharpe Ratio. Assume short sales are allowed. Write the equation of risk-return relations. b) determine the Tangency portfolio and calculate its expected return, standard deviation and Sharpe Ratio assuming…
Uncorrelated assets A and B have standard deviation of return 0.3 and 0.4 respectively. If a denotes the proportion invested in A, which value of a leads to the Minimum Variance Portfolio? A. 0.55 B. 0.64 C. 0.12 D. 0.80 .

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