Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Choose company of your choice.
The assignment particulars are as follows:
You will need to collect the stock price data for any 2 companies of your choice and the S&P 400 index. Choose companies that are in different industries. Collect the end-of-month prices for the last 21 months of your chosen stocks and the S&P 400 and set them on the spreadsheet. Taking this raw data, compute the monthly returns for all (there should be 20 returns). Make sure that I am able to see the cell formulas for each computation.
Next, compute the mean rate of return and the standard deviation of returns for both your stocks and the stock market. Compute the beta value for each stock and plot the characteristic lines of the 2 companies on 2 graphs. Compute the correlation coefficient for the 2 stocks. Plot the returns of your stocks against each other on a graph within the spreadsheet.
Next, assume that you construct a portfolio where you put equal money in each of your 2 stocks. Compute the 20 monthly rates of return for the portfolio and the standard deviation of returns of the portfolio and its beta value. Finally, within the spreadsheet discuss in DETAIL your findings regarding risk/return of your portfolio as compared to the risk/return characteristics of the 2 individual stocks. These comments must be detailed with a complete analysis.
Spreadsheet project guidelines This project MUST be done on an excel spreadsheet and be submitted to me AS ONE SPREADSHEET WITH THE FILE NAME BEING YOUR NAME. This is an individual assignment and you cannot collaborate with your classmates or others for this assignment. The assignment is due 22nd. You will lose a lot of points if the submission is late.
Select the suitable hypothesis.H 0 : π ≥ .052; H 1 : π 0 if z
1.on november 26 1995 the minneapolis tribune ran an article on gender differences in shopping behavior. when 400 women
Women's incomes. The average income of American women who work full-time and have only a high school degree is $33,230. You wonder whether the mean income of female graduates from your local high school who work full-time but have only a high scho..
you are going to select 6 players for a volleyball team from a group of 13 players. how many possible teams can be
Assume that in a hypothesis test with null hypothesis H 0 : μ = 14.0 at a = 0.05, that a value of 13.0 for the sample mean results in the null hypothesis not being rejected. That corresponds to a confidence interval result of:
the acceptable level for insect filth in a certain food item is 4 insect fragments per 10 grams. a sample random of 50
Compute the 95% confidence and prediction intervals for values of y for X = 40. Determine correlation coefficient, Interpret.
The mean heart rate is 90 beats per minute with a standard deviation of 5. Find the 98% confidence interval for the true mean heart rate of all people with this untreated condition.
Determine whether the following are demonstrative definitions, enumerative definitions, definitions by subclass, synonymous definitions, etymological definitions or operational definitions.- "Angel" is a word that originates from the Greek word ang..
Willow brook School is a small, private school in the Midwest United States. As an independent systems analyst, you work as an IT consultant, specializing in developing IT solutions for small businesses. You have been contacted by the director, Vi..
Find the mean, mode, median, and standard deviation. (I understand this step). What percentage of items circulate between 11.06 and 15.57 days? Use normal curve and estimate
A questionnaire will be published and the first 1000 completed questionnaires will be analyzed. Which of the following errors will be associated with the sample?
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd