Compute the mean standard deviation and coefficient of


Assignment

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.

Solution Preview :

Prepared by a verified Expert
Finance Basics: Compute the mean standard deviation and coefficient of
Reference No:- TGS02532605

Now Priced at $30 (50% Discount)

Recommended (93%)

Rated (4.5/5)