You are given the following information concerning a stock and the market Year 2017 2018 2019 2020 2021 2022 Returns Market 18% 11 12 Correlation -14 37 15 Average return Standard deviation Beta Stock 34% 27 3 a. Calculate the average return and standard deviation for the market and the stock. Note: Use Excel to complete the problem. Enter your answers as a percent rounded to 2 decimal places. -21 16 22 Market Stock b. Calculate the correlation between the stock and the market, as well as the stock's beta. Note: Use Excel to complete the problem. Round your correlation answer to 2 decimal places and beta answer to 4 decimal places. % %

You are given the following information concerning a stock and the market Year 2017 2018 2019 2020 2021 2022 Returns Market 18% 11 12 Correlation -14 37 15 Average return Standard deviation Beta Stock 34% 27 3 a. Calculate the average return and standard deviation for the market and the stock. Note: Use Excel to complete the problem. Enter your answers as a percent rounded to 2 decimal places. -21 16 22 Market Stock b. Calculate the correlation between the stock and the market, as well as the stock's beta. Note: Use Excel to complete the problem. Round your correlation answer to 2 decimal places and beta answer to 4 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

The index model has been estimated from the excess returns for stock A with the following results: = RA 12.00% +1.55RM+ eA °M = 24.00% σ(eд) = 18.50% What is the standard deviation of the return for stock A? (Round your answer to 2 decimal places.) Standard deviation %
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
Consider the following Information: Stock Return if Market Return Is: Stock -12% 12% 12 14 C D Stock A B -12 -32 11 20 What is the beta of each of the stocks? (Leave no cells blank - be certain to enter "0" wherever required. Use decimals, not percents, in your calculations. A negative value should be indicated by a minus sign. Round your answers to 1 decimal place.) D E 22 15 Beta
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?
How can I calculate geometric average in Excel?
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.)
Use the portion of the stock table shown below to answer the questions that follow. Round dollar amounts to the nearest cent, if necessary. YTD %CHG 52- HI Week LO STOCK DIV YLD % VOL 100s CLOSE NET CHG 2.8 37.43 21.10 A1 0.99 3.7 789 27.02 –0.1 2.4 48.30 30.78 B1 ... 1303 41.68 0.4 If you purchased 400 shares of B1 stock at $45.03, what would the loss be if the shares were sold at the closing price indicated in the table.
You have estimated the following probability distributions of expected future returns for Stocks X and Y: Stock X Stock Y Probability Return Probability Return 0.1 -12 % 0.2 4 % 0.1 11 0.2 7 0.3 14 0.3 11 0.3 30 0.2 17 0.2 40 0.1 30 What is the expected rate of return for Stock X? Stock Y? Round your answers to one decimal place.Stock X: % Stock Y: % What is the standard deviation of expected returns for Stock X? For Stock Y? Round your answers to two decimal places.Stock X: % Stock Y: % Which stock would you consider to be riskier? is riskier because it has a standard deviation of returns.
The market and Stock J have the following probability distributions: Probability rM rJ 0.3 15.00 % 19.00 % 0.4 10.00 6.00 0.3 18.00 10.00 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet Calculate the expected rate of return for the market. Do not round intermediate calculations. Round your answer to two decimal places.fill in the blank %Calculate the expected rate of return for Stock J. Do not round intermediate calculations. Round your answer to two decimal places.fill in the blank % Calculate the standard deviation for the market. Do not round intermediate calculations. Round your answer to two decimal places.fill in the blank %Calculate the standard deviation for Stock J. Do not round intermediate calculations. Round your answer to two decimal places.fill in the blank %
b. Consider the following information about three stocks: Probability of State of i. ii. iii. iv. State of Economy V. Boom Recession Economy 0.40 0.60 From the information given, you are required to answer the following questions. Compute the Standard Deviation for each stock. Compute the Coefficient Variation for each stock. Based on your computation in part (i) and (ii), which stock is riskier? Explain your answer. Rate of Return if State Occurs Stock Hang Stock Hang Jebat 7% 13% Tuah 28% (5%) Stock Hang Kasturi 15% 3% Assume that you have RM14,000 invested in Stock Hang Jebat whose beta is 1.5, RM19,000 invested in Stock Hang Kasturi whose beta is 2.5 and RM17,000 invested in Stock Hang Tuah whose beta is 1.6. Determine what is the beta of this portfolio. Based on your answer in part (iv), compute the required rate of return for this portfolio, given that the market rate of return is 13% and risk-free rate is 5%.
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. % %
Consider the following probability distribution for stocks A and B: State Probability Return on Stock A Return on Stock B 1 0.10 10% 8% 2 0.20 13% 7% 3 0.20 12% 6% 4 0.30 14% 9% 5 0.20 15% 8% The coefficient of correlation between A and B is:

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