Create excel sheet using monthly stock price data

Assignment Help Finance Basics

Reference no: EM131736003

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.

Reference no: EM131736003

Questions Cloud

Employer to minimize-eliminate risk of violation of privacy : How could these privacy concerns create risk for the employer? Identify solutions for the employer to minimize or eliminate the risk of violation of privacy.

Predict the log breakdown time for a batch : Insulating Fluid. Which would you use to predict the log breakdown time for a batch of insulating fluid which is to be put on test at 30 kV.

How much revenue should zack recognize in the first year : Zack will not have any continuing involvement with Sparky following transfer of the license. How much revenue should Zack recognize in first year of contract

Demonstrate course-related knowledge : Demonstrate course-related knowledge.Identify stakeholders that would be involved in the selection of a health IT system.

Create excel sheet using monthly stock price data : Create excel sheet Using monthly stock price data from 2010-2017 for Under Armour and its competitor Nike: compute mean, standard deviation and coefficient.

What is the probability of a randomly selected person : QMB 3600 Quantitative Methods in Business - what is the probability of a randomly selected person from this population has an income

What four class sizes should be used in the experiment : Researchers at a university wish to estimate the effect of class size on course comprehension. An intermediate course in statistics can be taught to classes.

Consumer behavior-why do we buy what we buy : Consumer Behavior: Why do we buy what we buy?

Space allocation and departments-to-locations assignment : Explain the difference between a space allocation problem and departments-to-locations assignment problem.

User Account

All Pages