Question:
A-
Create excel sheet Using monthly stock price data from 2010-2017 for Under Armour and its competitor Nike:
1) compute the mean, standard deviation, and coefficient of variance; and
2) graph the monthly stock prices.
3) compare the two firms which has the lowest standalone risk and best risk-to-return ratio.
Source: Yahoo!Finance or Mergent Online.
B-
In separate excel sheet :
1) Compute the beta coefficient, using S&P 500 Index as the benchmark;
2) Compute the Sharpe Ratio