Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. using the company shell midstream partners l.p. (s

Using the company Shell Midstream Partners L.P. (SHLX) Go to yahoo.com and download five years...

90.2K

Verified Solution

Question

Finance

Using the company Shell Midstream Partners L.P. (SHLX) Go to yahoo.com and download five years of the monthly prices of the stock that you have chosen. Also download 5 years of monthly data for the S&P 500 prices (SPY) for the same period into your Excel spreadsheet.
1. Estimate the monthly return of the stock and the S&P 500. 
2. Estimate average monthly return for both the stock and the S&P500. (Average of 5 years monthly returns of step 1)
3. Estimate the standard deviation of monthly returns of the stock and the S&P500 (SPY) over the past 5 years.
4. Compare total risk of your stock and S&P500. In addition, compare the market risk of your stock & SPY.
5. Compare the risk-return trade off of your stock and S&P500 (SPY). (Hint: standard deviation of returns is a measure of total risk, whereas beta is a measure of market risk).

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

1-Prove the identity. cosh(x) + sinh(x) = ex cosh(x) + sinh(x) = 1 2 ex + e?x + 1 2    = 1 2    = 2-Prove the identity. sinh(x + y)...

Basic Math
Q

Use bond-energy data to calculate the enthalpy of formation for eah of the following compounds at...

Chemistry
Q

Explain why the partial pressure of oxygen decreases and carbon dioxide increases from their values in...

Medical Sciences
Q

Chapter 04, Problem 036 During a tennis match, a player serves the ball at 25.5 m/s, with...

Physics
Q

he following stem and leaf plot represents the distribution of weights for a group of...

Statistics
Q

Accounting
Q

Question 4 of 5 .../30 =...

Accounting
Q

A $200 petty cash fund has cash of $20 and receipts of $177. The journal...

Accounting
Q

Business income (Sch C) where to put each amount? 2. The Rock...

Accounting
Q

Blaser Division had $1,044,000 in invested assets, sales of $1,215,000, income from operations of $238,000,...

Accounting
Q

Lower-of-Cost-or-Market inventory On the basis of the following data, determine the value of the inventory...

Accounting
Q

After reading this chapter, it isn't surprising that you're becoming an investment wizard with your...

Finance