A1 Data for Two Stocks23BCDEFGHJK2. Use the Excel file Data for Two Stocks to determine the following:a. Using EXCEL's Data Table Feature, create a one-way data table that determines thedifferent means and standard deviations for portfolios consisting of combinations ofStock A and Stock B by varying the correlation coefficient value between Stock A andStock B through the full range of possible correlation coefficient values. Use incrementsof 0.10 for the possible correlation coefficient values.b. Graph the correlation coefficients, the means, and the standard deviations of theportfolios from the one-way data table. Be sure to include a title for the graph and labelthe axes.c. Use Excel's Text Box Feature to explain how the portfolio means are affected bychanging the correlation coefficient values.d. Use Excel's Text Box Feature to explain how the portfolio standard deviations areaffected by changing the correlation coefficient values.45 Expected returnAB7.00%10.00%6 Variance of return0.560.747 Standard deviation of return8 Correlation74.83%0.7886.02%910 Proportion of A0.62111213141516171892 2919

Exploring Portfolio Characteristics using Excel Data TableHere's a breakdown of how to use Excel's…

Answered: A 1 Data for Two Stocks 2 3 B C D E F G…

Financial Management: Theory & Practice

16th Edition

ISBN:9781337909730

Author:Brigham

Publisher:Brigham

Chapter25: Portfolio Theory And Asset Pricing Models

Section: Chapter Questions

Problem 7SP

See similar textbooks

Similar questions

KINDLY ANSWER PART 5,6.and 7 Using the stock price data for any two companies provided below carry out the following tasks: 1.Compute, for each asset: i.Total Returns ii.Expected returns iii.standard deviation iv.Correlation Coefficient 2.Construct the variance-covariance matrix 3.Construct equally weighted portfolio and calculate Expected Return, Standard Deviation and Sharpe ratio. 4.Reconstruct equally weighted portfolio and calculate Expected Return, Standard Deviation and Sharpe ratio. 5.Use Solver to determine optimal risky portfolio. 6.Create hypothetical portfolios (commencing from Weight A=0 and weight B=100) 7.Calculate Expected return and Standard Deviation for all the above combinations 8.Graph the efficient frontier 9.Graph the optimal portfolio 10.Assuming that the investors prefers lower level of risk than what a portfolio of risky assets offer, introduce a risk free asset in the portfolio with a return of 3% 11.Using hypothetical weights (A= Portfolio of Risky…
Kindly answer 11 and 12 Using the stock price data for any two companies provided below carry out the following tasks: 1.Compute, for each asset: i.Total Returns ii.Expected returns iii.standard deviation iv.Correlation Coefficient 2.Construct the variance-covariance matrix 3.Construct equally weighted portfolio and calculate Expected Return, Standard Deviation and Sharpe ratio. 4.Reconstruct equally weighted portfolio and calculate Expected Return, Standard Deviation and Sharpe ratio. 5.Use Solver to determine optimal risky portfolio. 6.Create hypothetical portfolios (commencing from Weight A=0 and weight B=100) 7.Calculate Expected return and Standard Deviation for all the above combinations 8.Graph the efficient frontier 9.Graph the optimal portfolio 10.Assuming that the investors prefers lower level of risk than what a portfolio of risky assets offer, introduce a risk free asset in the portfolio with a return of 3% 11.Using hypothetical weights (A= Portfolio of Risky Assets, B= 1…
Stocks A and B have the following returns: (Click on the folowing icon a in order to copy its contents into a spreadsheet.) Stock A Stock B 0.08 0.06 0.15 0.05 0.04 0.05 0.01 -0.01 0.09 -0.03 a. What are the expected roturns of the two stocks? b. What are the standard deviations of the returns of the two stocks? c. If their correlation is 048, what is the expected return and standard deviation of a portfolio of 75% stock A and 25% stock B? a. What are the expected returns of the two stocks? The expected return for stock A is (Round to three decimal places.)
financial advisor evaluates four stocks for inclusion in an investor's portfolio. A orrelation matrix showing each stock's correlation with the other stocks is shown below Stock ALK CMN BTY DLE ALK 0.40 0.58 1.00 -0.25 BTY 0.40 1.00 0.16 -0.04 CMN -.25 .16 1.00 .37 DLE .58 .04 .37 1.00 f the goal is to reduce the investor's overall portfolio risk, which two stocks should the advisor recommend? a. ALK and DLE b. ALK and CMN c. BTY and DLE BTY and CM
Stocks A and B have the following returns: (Click on the following icon o in order to copy its contents into a spreadsheet.) Stock A Stock B 1 0.09 0.04 0.06 0.03 3. 0.12 0.06 4 - 0.04 0.02 5 0.09 -0.02 a. What are the expected returns of the two stocks? b. What are the standard deviations of the returns of the two stocks? c. If their correlation is 0.47, what is the expected return and standard deviation of a portfolio of 51% stock A and 49% stock B? a. What are the expected returns of the two stocks? The expected return for stock A is (Round to three decimal places.)
a. Calculate the expected return for Stock media Prima and Stock Astro 2. Calculate the standard deviation for Stock media Prima and Stock Astro 3. Calculate the covariance and correlation of coefficient for the above stock.
You run a regression for a stock's return on a market index and find the following Excel output: Multiple R 0.35 R-Square 0.12 Adjusted R-Square 0.02 Standard Error 38.45 Observations 12 Coefficients Standard Error t-Stat p-Value Intercept 4.05 15.44 0.26 0.80 Market 1.32 0.97 1.36 0.10 The stock is ________ riskier than the typical stock
Beta of a portfolio. The beta of four stocks-G, H, I, and J-are 0.42, 0.75, 1.19, and 1.65, respectively. What is the beta of a portfolio with the following weights in each asset: ? What is the beta of portfolio 1? (Round to two decimal places.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Portfolio 1 Portfolio 2 Portfolio 3 Weight in Stock G 25% 30% 10% Weight in Stock H 25% 40% 20% Weight in Stock I 25% 20% 40% Weight in Stock J 25% 10% 30% - X
Stocks A and B have the following returns: (Click on the following icon in order to copy its contents into a spreadsheet.) 123 45 Stock A 0.09 0.07 0.13 -0.01 0.09 Stock B 0.05 0.01 0.06 0.02 -0.04 a. What are the expected returns of the two stocks? b. What are the standard deviations of the returns of the two stocks? c. If their correlation is 0.42, what is the expected return and standard deviation of a portfolio of 60% stock A and 40% stock B?
Consider information given in the table below and answers the question asked thereafter: State Probability return on stock A Return on stock B A 0.15 10% 9% B 0.15 6% 15% C 0.10 20% 10% D 0.18 5% -8% E 0.12 -10% 20% F 0.30 8% 5% Calculate covariance and coefficient of correlation between the returns of thestocks A and B.v. Now suppose you have $100,000 to invest and you want to a hold a portfoliocomprising of $45,000 invested in stock A and remaining amount in stock B.Calculate risk and return of your portfolio.
You run a regression for the Tesla stock return on a market index to estimate the SML equation and find the following Excel output: Multiple R R-Square Adjusted R-Square Standard Error Observations Intercept Market = 0.28 0.25 0.02 40.01 60 13.35 and 0.97 0.8 and 0.1 0.28 and 0.25 0.26 and 1.36 0.2 and 0.75 Coefficients Standard Error t-Stat p-Value 0.2 0.75 The resulting SML equation for Laternios is given by: Er Laternios] 13.35 0.26 0.80 0.97 1.36 0.10 + __ × (E[rM] - rf)
An ideal value-relevant attribute is one for which the correlation coefficient of the values of the attribute and the stock prices is Group of answer choices a. +2.0 b. zero c. +1.0 d. -1.0

SEE MORE QUESTIONS

Recommended textbooks for you

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Pfin (with Mindtap, 1 Term Printed Access Card) (…

Finance

ISBN:

9780357033609

Author:

Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:

Cengage Learning

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Pfin (with Mindtap, 1 Term Printed Access Card) (…

Finance

ISBN:

9780357033609

Author:

Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS