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 Beta -14 37 15 Average return Standard deviation Stock 34% 27 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. 3 -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 Beta -14 37 15 Average return Standard deviation Stock 34% 27 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. 3 -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.
Intermediate Financial Management (MindTap Course List)
13th Edition
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Eugene F. Brigham, Phillip R. Daves
Chapter3: Risk And Return: Part Ii
Section: Chapter Questions
Problem 1P: The standard deviation of stock returns for Stock A is 40%. The standard deviation of the market...
Related questions
Question
Har
Don't upload any image
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 4 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Recommended textbooks for you
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT