None Using Excel (Minimum variance portfolio) What will bethe weights, the expected return, the variance, and thestandard deviation of the minimum variance portfoliocombining the stocks below? Please show excelformulasABCDE1 RETURN STATISTICS OF X AND Y STOCKS23 Mean returnX21.00%14.00%4 Variance5 Sigma0.110.04533.17%21.21%67 Covariance of returns-0.0020-0.02848 Correlation of returns910 Minimum variance portfolioProportion of X1112Proportion of Y1314Expected return15Variance of return16Sigma1718

Here's how to calculate the minimum variance portfolio for Stocks X and Y in Excel:1. Data…

Answered: Using Excel (Minimum 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

Expected retun and standard deviation. Use the following information to answer the questions: a. What is the expected return of each asset? b. What is the variance and the standard deviation c. What is the expected return of a portfolio with 1 1 Data Table d. What is the portfolio's variance and standard de - X Hint Make sure to round all intermediate calculatio Swers yo (Click on the following icon D in order to copy its contents into a spreadsheet.) a. What is the expected return of asset J? (Round to four decimal places.) Return on Return on Return on Probability of State State of Asset J in Asset Kin State 0.200 0.140 0.040 Asset L in Economy State State Вoom 0.28 0.070 0.260 0.180 Growth 0.37 0.25 0.070 Stagnant 0.070 0.060 -0.210 Recession 0.10 0.070 -0.100 Print Done
Consider the following information for four portfolios, the market, and the risk-free rate (RFR): Portfolio Return Beta SD A1 0.15 1.25 0.182 A2 0.1 0.9 0.223 A3 0.12 1.1 0.138 A4 0.08 0.8 0.125 Market 0.11 1 0.2 RFR 0.03 0 0 Refer to Exhibit 18.6. Calculate the Jensen alpha Measure for each portfolio. a. A1 = 0.014, A2 = -0.002, A3 = 0.002, A4 = -0.02 b. A1 = 0.002, A2 = -0.02, A3 = 0.002, A4 = -0.014 c. A1 = 0.02, A2 = -0.002, A3 = 0.002, A4 = -0.014 d. A1 = 0.03, A2 = -0.002, A3 = 0.02, A4 = -0.14 e. A1 = 0.02, A2 = -0.002, A3 = 0.02, A4 = -0.14
Suppose the index model for stocks A and B is estimated with the following results:rA = 2% + 0.8RM + eA, rB = 2% + 1.2RM + eB , σM = 20%, and RM = rM − rf . The regressionR2 of stocks A and B is 0.40 and 0.30, respectively.(a) What is the variance of each stock? (b) What is the firm-specific risk of each stock? (c) What is the covariance between the two stocks?
Given Portfolio 1 Expected Return= 0.15 Portfolio variance = 0.001 Standard Deviation = 0.0316 and Portfolio 2 Expected Return= 0.173 Portfolio variance = 0.001011 Standard Deviation = 0.03179 Compare these results.
Assume that the covariance between Stock A and Stock B is -28%^2 (0.0028). Compute the expected rate of return and variance of rate of return of Donald’s portfolio.
The following portfolios are being considered for investment. During the period under consideration, RFR = 0.07.Portfolio Return Beta σiA 0.15 1.0 0.05B 0.20 1.5 0.10C 0.10 0.6 0.03D 0.17 1.1 0.06Market 0.13 1.0 0.04 a. Compute the Sharpe measure for each portfolio and the market portfolio. b. Compute the Treynor measure for each portfolio and the market portfolio. c. Rank the portfolios using each measure, explaining the cause for any differences you find in the rankings.
Given: Calculate the expected returns and expected standard deviations of a two-stock portfolio having a correlation coefficient of 0.70 under the following conditions a. w1 = 1.00 b. w1 = 0.75 c. w1 = 0.50 d. w1 = 0.25 e. w1 = 0.05 Plot the results on a return-risk graph. Without calculations, draw in what the curve would look like first if the correlation coefficient had been 0.00 and then if it had been −0.70.
Assume the risk-free rate is r = 3%. Consider the data below:Stock(stock 1, stock 2)Expected Return(15%,7%)Volatility(40%,30%)a) Find the What the minimum variance portfolio when ρ12 = 0? and then computeits expected return and volatility?b) Find the minimum variance portfolio when ρ12= =0.4? and then compute itsexpected return and volatility?c) Determine the tangent portfolios & their respective mean returns and volatilities.
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,…
Consider the expected return and standard deviation of the following two assets: Asset 1: E[r1]=0.1 and σ1=0.2 Asset 2: E[r2]=0.3 and σ2=0.4 (a) Draw (e.g. with Excel) the set of achievable portfolios in mean-standard deviation space for the cases: (i) ρ12= -1, (ii) ρ12=0. (b) Suppose ρ12=-1. Which portfolio has the minimal variance? What is the variance and expected return of that portfolio? (c) Derive the formula for the variance of a portfolio with four assets.
What is the standard deviation of the following portfolio if the coefficient of the correlation between the two securities is equl to 0.5? Variance % Proportion of investment in the portfolio security 1 10 0.3 security 2 20 0.7

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

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