The purpose of this assignment is to learn more about systematic risk Choose 2 stocks - look up betas for your stocks using Excel Data Types, Yahoo! Finance, or Koyfin.com (published betas are usually 5-year betas) - Download a year of adjusted closing prices for your stocks and the S&P500 from Yahoo* -calculate daily HPR for each - regress [Data, Data Analysis, Regression] each stock HPR on the benchmark HPR (Y is the stock and X is the benchmark) - the slope is the one-year beta - test whether the beta is significantly greater/less than one - Calculate downside beta for each stock - select your data - use Data, Sort to sort by S&P500 returns, lowest to highest - your data set is all of the HPRs where the S&P500 benchmark is negative - regress each stock on the benchmark for the restricted data set - the slope is your downside beta - test whether the downside beta is significantly greater/less than one - Make a table to add to your Word summary: For your stock and the benchmark, compare average daily HPRs, standard deviation, skewness, kurtosis, calculated 1-year betas, calculated downside betas, and published 5-year betas

- Discussion: What do the betas mean? What is the difference between regular betas and downside betas? Are your betas statistically significant? How do betas help you with investment decisions? What did you learn about your stocks? Which asset is best according to these measures?

table Template: Stokc1 Stock 2 S&P500 Average daily HPR Standard deviation Skewness Kurtosis Calculated one-year beta Downside one-year beta Published five-year beta