634 Words3 Pages

Executive Summary
Our team concludes that risk and return are strongly correlated. A higher risk usually yields a higher return. Our team observed that within Alex Sharpe’s portfolio, the Reynolds’ fund holds the highest risk (highest standard deviation of 32.45%), as well as the highest return (16.27% in comparison to Hasbro’s return of 11.31%). Although a lower standard deviation (lower risk) is ideal for an investment portfolio, the Reynolds’ fund yields a higher return for the higher associated risk. Furthermore, our team’s data illustrated that the mix of S&P with Reynolds has a higher return and lower standard deviation than the S&P alone. In addition, if Sharpe invests in Reynolds and Hasbro equally, at for instance, one*…show more content…*

While Reynolds has the higher std dev, the mix of S&P with Reynolds has a higher return and lower std dev than the S&P alone. Adding Hasbro to the S&P however increases risk and return. | S&P500 | Reynolds | Hasbro | Arithmetic | 6.89% | 7.05% | 6.97% | Std Dev | 12.48% | 12.45% | 12.53% | 3. Regression Analysis to Calculate Beta Perform a regression of each stocks’ monthly returns on the Index returns to compute a “beta” for each stock. How does this relate to your answer in question 2 above? That is, run a regression of excess returns on a stock as the dependent variable and the excess return of the market as the independent variable. Include a constant. The beta is also Covariance[r_i, R_m]/Var[R_m], where R_m is the return of the market. Risk free rate from regression =AVERAGE(0.0145226009606485,0.00368395181284158) = 0.009103276 Reynolds Constant (estimated risk free return): 0.014522601 Slope (beta from regression): 0.735763036 Beta calculated using covariance: 0.723500319 Hasbro Constant (estimated risk free return): 0.003683952 Slope (beta from regression): 1.419799452 Beta calculated using covariance: 1.396136128 4. Capital Asset Pricing Model (CAPM) How might the expected return of each stock relate to its riskiness? The return of each stock influences the stock’s riskiness. The higher the risk, the higher the stock’s return. Calculating the Sharpe

While Reynolds has the higher std dev, the mix of S&P with Reynolds has a higher return and lower std dev than the S&P alone. Adding Hasbro to the S&P however increases risk and return. | S&P500 | Reynolds | Hasbro | Arithmetic | 6.89% | 7.05% | 6.97% | Std Dev | 12.48% | 12.45% | 12.53% | 3. Regression Analysis to Calculate Beta Perform a regression of each stocks’ monthly returns on the Index returns to compute a “beta” for each stock. How does this relate to your answer in question 2 above? That is, run a regression of excess returns on a stock as the dependent variable and the excess return of the market as the independent variable. Include a constant. The beta is also Covariance[r_i, R_m]/Var[R_m], where R_m is the return of the market. Risk free rate from regression =AVERAGE(0.0145226009606485,0.00368395181284158) = 0.009103276 Reynolds Constant (estimated risk free return): 0.014522601 Slope (beta from regression): 0.735763036 Beta calculated using covariance: 0.723500319 Hasbro Constant (estimated risk free return): 0.003683952 Slope (beta from regression): 1.419799452 Beta calculated using covariance: 1.396136128 4. Capital Asset Pricing Model (CAPM) How might the expected return of each stock relate to its riskiness? The return of each stock influences the stock’s riskiness. The higher the risk, the higher the stock’s return. Calculating the Sharpe

Related

## Alex Sharpe's Portfolio Solution Essay

1231 Words | 5 PagesContext: Alex Sharpe currently invests her children’s educational savings in Vanguard 500 Index Fund, which tracks the performance of S&P 500 and is passively managed. However, she is now considering switching her investment strategy to a more active one to achieve better outcomes. Hasbro, a toy manufacturer, and Reynolds, a tobacco firm, have come into Sharpe’s sight and she wants to choose one of them and invest a small proportion of equity funds in it. In order to select a more appropriate

## Alex Sharpe's Portfolio Solution Essay

904 Words | 4 PagesAlex Sharpe’s Portfolio 1. Returns and Risk Estimate and compare the returns and variability (i.e. annual standard deviation over the past five years) of Reynolds and Hasbro with that of the S&P 500 Index. Which stock appears to be riskiest? S&P 500 Annualized Expected Return: 6.8920% S&P 500 SD (Annualized): 12.477% Reynolds Annualized Expected Return: 22.4980% Reynolds SD (Annualized): 32.446% Hasbro Annualized Expected Return: 14.2060% Hasbro SD (Annualized): 28.114% Reynolds

## Portfolio

1478 Words | 6 Pagesw rP os t S 908N20 ALEX SHARPE'S PORTFOLIO op yo Professor Colette Southam wrote this case solely to provide material for class discussion. The author does not intend to illustrate either effective or ineffective handling of a managerial situation. The author may have disguised certain names and other identifying information to protect confidentiality. Ivey Management Services prohibits any form of reproduction, storage or transmittal without its written permission. Reproduction

### Alex Sharpe's Portfolio Solution Essay

1231 Words | 5 Pages### Alex Sharpe's Portfolio Solution Essay

904 Words | 4 Pages### Portfolio

1478 Words | 6 Pages