Question

8-22. 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. Bartman Industries Reynolds Inc. Winslow 5000 Year Stock Price Dividend Stock Price Dividend Includes Dividends 2017 $17.25 $1.15 $48.75 $3.00 $11,663.98 2016 14.75 1.06 52.30 2.90 8,785.70 2015 16.50 1.00 48.75 2.75 8,679.98 2014 10.75 0.95 57.25 2.50 6,434.03 2013 11.37 0.90 60.00 2.25 5,602.28 2012 7.62 0.85 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. in excel

          8-22.
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.
Bartman Industries
Reynolds Inc.
Winslow 5000
Year
Stock Price
Dividend
Stock Price
Dividend
Includes Dividends
2017
$17.25
$1.15
$48.75
$3.00
$11,663.98
2016
14.75
1.06
52.30
2.90
8,785.70
2015
16.50
1.00
48.75
2.75
8,679.98
2014
10.75
0.95
57.25
2.50
6,434.03
2013
11.37
0.90
60.00
2.25
5,602.28
2012
7.62
0.85
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. in excel

Added by Henry J.

Question

Please give Ace some feedback