Stocks A and B have the following historical returns: Year rA rB 2015 -18% 56% 2016 44% 8% 2017 -22% -4% 2018 22% 24% 2019 34% -24% A. Calculate the average rate of return for each stock during the 5-year perioc that someone held a portfolio consisting of 50% of Stock A and 50% of Sto What would have been the realized rate of return on the portfolio in each y would have been the average return on the portfolio for the 5-year period? B. Now calculate the standard deviation of returns for each stock and for the C. Looking at the annual returns data on the two stocks, would you guess tha correlation coefficient between returns on the two stocks is closer to 0.8 c D. If you added more stocks at random to the portfolio, which of the following most accurate statement of what would happen to o,? I. O, would remain constant. II. O, would decline to somewhere in the vicinity of 20%. II. O, would decline to zero if enough stocks were included.

EBK CFIN
6th Edition
ISBN:9781337671743
Author:BESLEY
Publisher:BESLEY
Chapter8: Risk And Rates Of Return
Section: Chapter Questions
Problem 18PROB
icon
Related questions
Question
DO NOT ANSWER IN EXCEL
Stocks A and B have the following historical returns:
Year
rA
rB
2015
-18%
56%
2016
44%
8%
2017
-22%
-4%
2018
22%
24%
2019
34%
-24%
A. Calculate the average rate of return for each stock during the 5-year period. Assume
that someone held a portfolio consisting of 50% of Stock A and 50% of Stock B.
What would have been the realized rate of return on the portfolio in each year? What
would have been the average return on the portfolio for the 5-year period?
B. Now calculate the standard deviation of returns for each stock and for the portfolio.
C. Looking at the annual returns data on the two stocks, would you guess that the
correlation coefficient between returns on the two stocks is closer to 0.8 or to 20.8?
D. If you added more stocks at random to the portfolio, which of the following is the
most accurate statement of what would happen to o,?
I.
O, would remain constant.
II.
O, would decline to somewhere in the vicinity of 20%.
II.
O, would decline to zero if enough stocks were included.
Transcribed Image Text:DO NOT ANSWER IN EXCEL Stocks A and B have the following historical returns: Year rA rB 2015 -18% 56% 2016 44% 8% 2017 -22% -4% 2018 22% 24% 2019 34% -24% A. Calculate the average rate of return for each stock during the 5-year period. Assume that someone held a portfolio consisting of 50% of Stock A and 50% of Stock B. What would have been the realized rate of return on the portfolio in each year? What would have been the average return on the portfolio for the 5-year period? B. Now calculate the standard deviation of returns for each stock and for the portfolio. C. Looking at the annual returns data on the two stocks, would you guess that the correlation coefficient between returns on the two stocks is closer to 0.8 or to 20.8? D. If you added more stocks at random to the portfolio, which of the following is the most accurate statement of what would happen to o,? I. O, would remain constant. II. O, would decline to somewhere in the vicinity of 20%. II. O, would decline to zero if enough stocks were included.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Knowledge Booster
Risk and Return
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.
Similar questions
Recommended textbooks for you
EBK CFIN
EBK CFIN
Finance
ISBN:
9781337671743
Author:
BESLEY
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Finance
ISBN:
9780357033609
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Fundamentals Of Financial Management, Concise Edi…
Fundamentals Of Financial Management, Concise Edi…
Finance
ISBN:
9781337902571
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Fundamentals of Financial Management, Concise Edi…
Fundamentals of Financial Management, Concise Edi…
Finance
ISBN:
9781285065137
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning