Evaluating Risk and Return-995709

.xlsx

School

Northern Arizona University *

*We aren’t endorsed by this school

Course

120

Subject

Finance

Date

Nov 24, 2024

Type

xlsx

Pages

6

Uploaded by MegaResolve8522

Report
Evaluating Risk and Return Bartman Industries Reynolds Inc. Winslow 5000 Year Stock Price Dividend Stock Price Dividend Includes Dividends 2020 $17.35 $1.16 $49.25 $2.80 $11,006.20 2019 $14.70 $1.07 $53.20 $2.70 $8,463.89 2018 $16.50 $1.00 $49.25 $2.55 $8,354.95 2017 $10.75 $0.95 $58.25 $2.40 $6,268.43 2016 $11.52 $0.90 $61.80 $2.25 $5,533.19 2015 $7.62 $0.85 $57.05 $2.10 $4,625.87 a. Calculating the annual rates of return for Bartman, Reynolds, and the Winslow 5000 Index Year Bartman Reynolds Winslow 2020 25.92% -2.16% 30.04% 2019 -4.42% 13.50% 1.30% 2018 62.79% -11.07% 33.29% 2017 1.56% -1.86% 13.29% 2016 62.99% 12.27% 19.61% Calculating each entity's average return over the 5-year period Bartman Reynolds Winslow Average return 29.77% 2.14% 19.51% b. Calculating the standard deviations of the returns for Bartman, Reynolds, and the Wiinslow 5000 Bartman Reynolds Winslow Standard deviation 32.30% 10.50% 12.95% c. Calculating the coefficients of variation for Bartman, Reynolds, and the Wiinslow 5000 Bartman Reynolds Winslow Coefficient of variation 1.09 4.92 0.66 d. Calculating the Sharpe ratios for Bartman, Reynolds, and the Index using their average returns Risk-free rate 3.00% Bartman Reynolds Winslow Sharpe ratio 0.8287 -0.0824 1.2746 e. Constructing 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 A B C D E F 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59
f. Estimating Bartman's and Reynolds's betas by running regressions of their returns against the index's returns A B C D E F 60 61 62
Bartman's Calculations SUMMARY OUTPUT Regression Statistics Multiple R 0.726648591936013 R Square 0.52801817616259 Adjusted R Square 0.37069090155012 Standard Error 0.256252960289425 Observations 5 ANOVA df SS MS F Significance F Regression 1 0.220385306315156 0.220385306315156 3.35617697225868 0.164343991837771 Residual 3 0.196996738971281 0.065665579657094 Total 4 0.417382045286437 Coefficients Standard Error t Stat P-value Lower 95% Intercept -0.055879735399344 0.224452619983748 -0.248960049579238 0.819462935207227 -0.770188146577873 X Variable 1 1.81258110069832 0.989407095995772 1.8319871648728 0.164343991837771 -1.3361538563749 Reynolds's Calculations SUMMARY OUTPUT Regression Statistics Multiple R 0.750723356747679 R Square 0.563585558366504 Adjusted R Square 0.418114077822005 Standard Error 0.080078820732396 Observations 5 ANOVA df SS MS F Significance F Regression 1 0.024843760561501 0.024843760561501 3.87419964557318 0.143684802318065 Residual 3 0.019237852589674 0.006412617529891 Total 4 0.044081613151175 Coefficients Standard Error t Stat P-value Lower 95% Intercept 0.140061713546818 0.070141242849622 1.99685246306656 0.1397517121969 -0.08315902560797 X Variable 1 -0.608575965987938 0.309188831934347 -1.96829866777712 0.143684802318065 -1.59255282181239 Formulas Bartman's beta 1.8126 =B81 Reynolds's beta -0.6086 =B104 g. Calculating the two companies' required returns Market return 9.00% Risk-free rate 4.50% Bartman's required return 12.66% =B114+B109*(B113-B114) Reynolds's required return 1.76% =B114+B110*(B113-B114) h. Calculating the portfolio's beta and required return Bartman's weght 50% Reynolds's weght 50% Portfolio's beta 0.6020 =(B109+B110)/2 A B C D E F 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help