EVALUATING RISK AND RETURN Bartman Industries's and Reynolds Inc.'s stock prices and dividends, along with the Winslow 5000 Index, are shown here for the period 2012- 2017. The Winslow 5000 data are adjusted to include dividends. Year 2017 2016 2015 2014 2013 2012 Bartman Industries Stock Price $17.25 14.75 16.50 10.75 11.37 7.62 Reynolds Inc. Dividend Stock Price $1.15 1.06 1.00 0.95 0.90 0.85 $48.75 52.30 48.75 57.25 60.00 55.75 Dividend $3.00 2.90 2.75 2.50 2.25 2.00 Winslow 5000 Includes Dividends $11,663.98 8,785.70 8,679.98 6,434.03 5,602.28 4,705.97 a. Use the data to calculate annual rates of return for Bartman, Reynolds, and the Winslow 5000 Index. Then calculate each entity's average return over the 5-year peri- od. (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 2012 because you do not have 2011 data.) b. Calculate the standard deviations of the returns for Bartman, Reynolds, and the Winslow 5000. (Hint: Use the sample standard deviation formula, Equation 8.2a in this chapter, which corresponds to the STDEV function in Excel.) c. Calculate the coefficients of variation for Bartman, Reynolds, and the Winslow 5000. d. Assume the risk-free rate during this time was 3%. Calculate the Sharpe ratios for Bartram, Reynolds, and the Index over this period using their average returns. e. Construct a scatter diagram that shows Bartman's and Reynolds's returns on the vertical axis and the Winslow 5000 Index's returns on the horizontal axis.
EVALUATING RISK AND RETURN Bartman Industries's and Reynolds Inc.'s stock prices and dividends, along with the Winslow 5000 Index, are shown here for the period 2012- 2017. The Winslow 5000 data are adjusted to include dividends. Year 2017 2016 2015 2014 2013 2012 Bartman Industries Stock Price $17.25 14.75 16.50 10.75 11.37 7.62 Reynolds Inc. Dividend Stock Price $1.15 1.06 1.00 0.95 0.90 0.85 $48.75 52.30 48.75 57.25 60.00 55.75 Dividend $3.00 2.90 2.75 2.50 2.25 2.00 Winslow 5000 Includes Dividends $11,663.98 8,785.70 8,679.98 6,434.03 5,602.28 4,705.97 a. Use the data to calculate annual rates of return for Bartman, Reynolds, and the Winslow 5000 Index. Then calculate each entity's average return over the 5-year peri- od. (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 2012 because you do not have 2011 data.) b. Calculate the standard deviations of the returns for Bartman, Reynolds, and the Winslow 5000. (Hint: Use the sample standard deviation formula, Equation 8.2a in this chapter, which corresponds to the STDEV function in Excel.) c. Calculate the coefficients of variation for Bartman, Reynolds, and the Winslow 5000. d. Assume the risk-free rate during this time was 3%. Calculate the Sharpe ratios for Bartram, Reynolds, and the Index over this period using their average returns. e. Construct a scatter diagram that shows Bartman's and Reynolds's returns on the vertical axis and the Winslow 5000 Index's returns on the horizontal axis.
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
Related questions
Question
Transcribed Image Text:EVALUATING RISK AND RETURN Bartman Industries's and Reynolds Inc.'s stock prices
and dividends, along with the Winslow 5000 Index, are shown here for the period 2012-
2017. The Winslow 5000 data are adjusted to include dividends.
Year
2017
2016
2015
2014
2013
2012
Bartman Industries
Stock Price
$17.25
14.75
16.50
10.75
11.37
7.62
Reynolds Inc.
Dividend Stock Price
$1.15
1.06
1.00
0.95
0.90
0.85
$48.75
52.30
48.75
57.25
60.00
55.75
Dividend
$3.00
2.90
2.75
2.50
2.25
2.00
Winslow 5000
Includes Dividends
$11,663.98
8,785.70
8,679.98
6,434.03
5,602.28
4,705.97
a. Use the data to calculate annual rates of return for Bartman, Reynolds, and the
Winslow 5000 Index. Then calculate each entity's average return over the 5-year peri-
od. (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 2012
because you do not have 2011 data.)
b. Calculate the standard deviations of the returns for Bartman, Reynolds, and the
Winslow 5000. (Hint: Use the sample standard deviation formula, Equation 8.2a in this
chapter, which corresponds to the STDEV function in Excel.)
c. Calculate the coefficients of variation for Bartman, Reynolds, and the Winslow 5000.
d. Assume the risk-free rate during this time was 3%. Calculate the Sharpe ratios for
Bartram, Reynolds, and the Index over this period using their average returns.
e. Construct a scatter diagram that shows Bartman's and Reynolds's returns on the
vertical axis and the Winslow 5000 Index's returns on the horizontal axis.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 7 images
Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
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