Use the data given to calculate annual returns for Goodman, Landry, and the Market Index, nd then calculate average returns over the five-year period. (Hint: Remember, returns are alculated by subtracting the beginning price from the ending price to get the capital gain or ss, adding the dividend to the capital gain or loss, and dividing the result by the beginning rice. Assume that dividends are already included in the index. Also, you cannot calculate the te of return for 2014 because you do not have 2013 data.) ata as given in the problem are shown below: Goodman Industries Stock Price $25.88 $22.13 $24.75 $16.13 Year 2019 2018 2017 2016 2015 2014 2019 2018 דורת Dividend $1.73 $1.59 $17.06 $11.44 le now calculate the rates of return for the two companies and the index: Goodman $1.50 $1.43 $1.35 $1.28 Landry Incorporated Stock Price $73.13 $78.45 $73.13 $85.88 $90.00 $83.63 Landry Index Market Index Dividend Includes Divs. $4.50 17,495.97 $4.35 13.178.55 $4.13 13,019.97 $3.75 9.651.05 $3.38 8,403.42 $3.00 7,058.96 b. Calculate the standard deviation of the returns for Goodman, Landry, and the Market Index. (Hint: Use the sample standard deviation formula given in the chapter, which corresponds to the STDEV function in Excel.) Since this is not a weighted average, use the function wizard to calculate the standard deviations. Standard deviation of returns c. Construct a scatter diagram graph that shows Goodman's and Landry' returns on the vertical axis and the Market Index's returns on the horizontal axis. It is easiest to make scatter diagrams with a data set that has the X-axis variable in the left column, so we reformat the returns data calculated above and show it just below. Year 0 0 Goodman Landry Index 0 0 0 Index Goodman 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Landry 0.0% 0.0% 0.0% 0.0% 0.0%

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
icon
Related questions
icon
Concept explainers
Topic Video
Question

Concepts of Risk.  In broad terms, why is some risk diversifiable? Why are some risks non-diversifiable?  Does it follow that an investor can control the level of unsystematic risk in a portfolio, but not the level of systematic risk?

a. Use the data given to calculate annual returns for Goodman, Landry, and the Market Index,
and then calculate average returns over the five-year period. (Hint: Remember, returns are
calculated by subtracting the beginning price from the ending price to get the capital gain or
loss, adding the dividend to the capital gain or loss, and dividing the result by the beginning
price. Assume that dividends are already included in the index. Also, you cannot calculate the
rate of return for 2014 because you do not have 2013 data.)
Data as given in the problem are shown below:
Goodman Industries
Year
2019
2018
2017
2016
2015
2014
2019
2018
2017
2016
2015
Stock Price
$25.88
$22.13
$24.75
Average
$16.13
$17.06
$11.44
We now calculate the rates of return for the two companies and the index:
Dividend
$1.73
$1.59
$1.50
$1.43
$1.35
$1.28
Goodman
Landry Incorporated
Stock Price
$73.13
$78.45
$73.13
$85.88
$90.00
$83.63
Landry
Index
Market Index
Dividend Includes Divs.
$4.50 17,495.97
$4.35 13,178.55
$4.13 13,019.97
$3.75 9,651.05
$3.38 8,403.42
$3.00 7,058.96
b. Calculate the standard deviation of the returns for Goodman, Landry, and the Market Index. (Hint: Use the sample standard deviation
formula given in the chapter, which corresponds to the STDEV function in Excel.)
Since this is not a weighted average, use the function wizard to calculate the standard deviations.
Standard deviation of returns
c. Construct a scatter diagram graph that shows Goodman's and Landry' returns on the vertical axis and the Market Index's returns on the
horizontal axis.
Goodman Landry Index
It is easiest to make scatter diagrams with a data set that has the X-axis variable in the left column, so we reformat the returns data calculated
above and show it just below.
Year
0
0
0
0
0
Index Goodman
0.0%
0.0%
0.0%
0.0%
0.0%
0.0%
0.0%
0.0%
0.0%
0.0%
Landry
0.0%
0.0%
0.0%
0.0%
0.0%
Transcribed Image Text:a. Use the data given to calculate annual returns for Goodman, Landry, and the Market Index, and then calculate average returns over the five-year period. (Hint: Remember, returns are calculated by subtracting the beginning price from the ending price to get the capital gain or loss, adding the dividend to the capital gain or loss, and dividing the result by the beginning price. Assume that dividends are already included in the index. Also, you cannot calculate the rate of return for 2014 because you do not have 2013 data.) Data as given in the problem are shown below: Goodman Industries Year 2019 2018 2017 2016 2015 2014 2019 2018 2017 2016 2015 Stock Price $25.88 $22.13 $24.75 Average $16.13 $17.06 $11.44 We now calculate the rates of return for the two companies and the index: Dividend $1.73 $1.59 $1.50 $1.43 $1.35 $1.28 Goodman Landry Incorporated Stock Price $73.13 $78.45 $73.13 $85.88 $90.00 $83.63 Landry Index Market Index Dividend Includes Divs. $4.50 17,495.97 $4.35 13,178.55 $4.13 13,019.97 $3.75 9,651.05 $3.38 8,403.42 $3.00 7,058.96 b. Calculate the standard deviation of the returns for Goodman, Landry, and the Market Index. (Hint: Use the sample standard deviation formula given in the chapter, which corresponds to the STDEV function in Excel.) Since this is not a weighted average, use the function wizard to calculate the standard deviations. Standard deviation of returns c. Construct a scatter diagram graph that shows Goodman's and Landry' returns on the vertical axis and the Market Index's returns on the horizontal axis. Goodman Landry Index It is easiest to make scatter diagrams with a data set that has the X-axis variable in the left column, so we reformat the returns data calculated above and show it just below. Year 0 0 0 0 0 Index Goodman 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Landry 0.0% 0.0% 0.0% 0.0% 0.0%
d. Estimate Goodman's and Landry's betas as the slopes of regression lines with stock returns
on the vertical axis (y-axis) and market return on the horizontal axis (x-axis). (Hint: use Excel's
SLOPE function.) Are these betas consistent with your graph?
Goodman's beta =
Landry' beta =
e. The risk-free rate on long-term Treasury bonds is 6.04%. Assume that the market risk premium is 5%.
What is the expected return on the market? Now use the SML equation to calculate the two companies'
required returns.
Market risk premium (RPM) =
Risk-free rate =
Expected return on market =
Goodman:
Required return
Landry:
Required return
5.000%
6.040%
=
=
f. If you formed a portfolio that consisted of 50% Goodman stock and 50% Landry stock, what would be its beta and its required return?
Portfolio beta =
g. Suppose an investor wants to include Goodman Industries' stock in his or her portfolio. Stocks A, B, and C are currently in the portfolio,
and their betas are 0.769, 0.985, and 1.423, respectively. Calculate the new portfolio's required return if it consists of 25% of Goodman, 15% of
Stock A, 40% of Stock B, and 20% of Stock C.
Required return on portfolio:
Goodman
Stock A
Stock B
Stock C
Beta rtfolio Weight
25%
15%
40%
20%
100%
0.769
0.985
1.423
Portfolio Beta =
=
Transcribed Image Text:d. Estimate Goodman's and Landry's betas as the slopes of regression lines with stock returns on the vertical axis (y-axis) and market return on the horizontal axis (x-axis). (Hint: use Excel's SLOPE function.) Are these betas consistent with your graph? Goodman's beta = Landry' beta = e. The risk-free rate on long-term Treasury bonds is 6.04%. Assume that the market risk premium is 5%. What is the expected return on the market? Now use the SML equation to calculate the two companies' required returns. Market risk premium (RPM) = Risk-free rate = Expected return on market = Goodman: Required return Landry: Required return 5.000% 6.040% = = f. If you formed a portfolio that consisted of 50% Goodman stock and 50% Landry stock, what would be its beta and its required return? Portfolio beta = g. Suppose an investor wants to include Goodman Industries' stock in his or her portfolio. Stocks A, B, and C are currently in the portfolio, and their betas are 0.769, 0.985, and 1.423, respectively. Calculate the new portfolio's required return if it consists of 25% of Goodman, 15% of Stock A, 40% of Stock B, and 20% of Stock C. Required return on portfolio: Goodman Stock A Stock B Stock C Beta rtfolio Weight 25% 15% 40% 20% 100% 0.769 0.985 1.423 Portfolio Beta = =
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Knowledge Booster
Stock Valuation
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
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…
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