Excel accounts

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