Solve for questions A-D
Evaluating Risk and Return - Excel
Aaron Neubx
File
Home Insert Page Layout
Formulas
Data
Review View Developer Help Power Pivot
Tell me what you want to do
Arial
10
A
b Wrap Text
General
AutoSum - Sort & Find & Clear & Filter Select & Ccineng
Bg Copy Paste Format Painter Clipboard
Conditional Format as Cell Formatting Label Styles Styles
Insert Delete Format
Merge & Center
Font
Alignment
Number
Cells
G16
3
Bartman Industries Stock Price Dividend $16.95 $1.13 $14.55 $1.06 $16.10 $1.00 $10.55 $0.95 $11.32 $0.90 $7.42 $0.85
Reynolds Inc, Winslow 5000 Stock Price Dividend Includes Dividends $48.50 $2.80 $11,582.66 $51.75 $2.70 $8,908.45 $48.50 $2.55 $8,796.02 $58.70 $2.40 $6,506.82 $59.95 $2.15 $5,727.48 $55.20 $1.90 $4,772.22
Year 2020 2019 2018 2017 2016 2015
11
a. Calculating the annual rates of return for Bartman, Reynolds, and the Winslow 5000 Index
Year Bartman Reynolds Winslow
2014 #N/A #N/A #N/A
2015 #N/A #N/A #N/A
2016 #N/A #N/A #N/A
2017 #N/A #N/A #N/A
2018 #N/A #N/A #N/A
2019 #N/A #N/A #N/A
2020 #N/A #N/A #N/A
Calculating each entity's average return over the 5-year period
Bartman Reynolds Average return
Winslow
Bartman #N/A
Reynolds #N/A
Winslow #N/A
b. Calculating the standard deviations of the returns for Bartman, Reynolds, and the Winslow 5000
Bartman Reynolds Winslow
Bartman #N/A
Reynolds #N/A
Winslow #N/A
c. Calculating the coefficients of variation for Bartman, Reynolds, and the Winslow 5000
Bartman Reynolds Winslow Coefficient of variation
Bartman #N/A
Reynolds #N/A
Winslow #N/A
d. Calculating the Sharpe ratios for Bartman, Reynolds, and the Index using their average returns
Risk-free rate 4.00%
Bartman Reynolds Winslow Sharpe ratio Sheet1 (+)
Bartman #N/A
Reynolds #N/A
Winslow #N/A
Ready
Cy Accessibility: Good to go 68F
?
90%
Q L
X
3:58 PM 10/25/2022