Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3. Download monthly stock prices for S&P500 ETF (Ticker: SPY), Consolidated Edison (Ticker: ED), Amazon (Ticker: AMZN) and the from January 1, 2018, to December

image text in transcribed
3. Download monthly stock prices for S\&P500 ETF (Ticker: SPY), Consolidated Edison (Ticker: ED), Amazon (Ticker: AMZN) and the from January 1, 2018, to December 31, 2022. Calculate monthly returns. [Total 16 points] a. Graph a scatterplot of ConEd's returns versus the S\&P 500 and add a trendline. Make sure to display the equation and R2 on the chart. [4 points] b. Compute your own slope, intercept and r-squared using the appropriate excel functions. Do you get the same values as the trendline? Why or why not? [ 3 points] c. Interpret the intercept, slope and R-squared. [2 points] d. Graph a scatterplot of Amazon's returns versus the S\&P 500 and add a trendline. Make sure to display the equation and R2 on the chart. What is the for Amazon over this period? (Adjust the y-axis for both charts to range from 30% to 30% so visual comparison is easier.) [3 points] e. Based on these two charts, which stock has more systematic risk? Based on these two charts, which stock's return is more correlated with the market? Explain. [2 points] f. What is the expected return for each stock if the market earns a return of 3.83% ? [2 points]

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Finance Version 3.1

Authors: Rachel S. Siegel

3rd Edition

1453334807, 978-1453334805

More Books

Students also viewed these Finance questions

Question

3.2 Discuss the strategic importance of technology in HRM.

Answered: 1 week ago