Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

QUESTION

# Start by retrieving MONTHLY data for the period of 01/01/2015 - 12/31/2017 from Yahoo website for Samp;P 500 Index (ticker:This assignment will require you to analyze time series of monthly returns. S

Start by retrieving MONTHLY data for the period of 01/01/2015 - 12/31/2017 from Yahoo website for Samp;P 500 Index (ticker:

This assignment will require you to analyze time series of monthly returns. Start by retrieving MONTHLY data for the period of 01/01/2015 - 12/31/2017 from Yahoo website for −

S&P 500 Index (ticker: ^GSPC) −

Verizon Communications Inc. (ticker: VZ) −

Intel Corporation (ticker: INTC) −

Chevron Corporation (ticker: CVX) −

Apple Inc. (ticker: AAPL)

Calculating Returns: Use the 'Adj Close' column to obtain returns for each period. Remember that the Adjusted Close column has already adjusted the prices for dividends and stock splits so you do not have to adjust for it again. Just use the adjusted close column to obtain the return R for each month t as: Rt = Adj Closet/Adj Closet-1

A. What is the average monthly return and standard deviation of returns for the above period for

(i) S&P 500, (ii) Verizon, (iii) Intel, (iv) Chevron, (v) Apple. (vi) Comment on your findings.

B. Calculate the stock betas:

(i) Calculate Verizon's beta for the 01/01/2015 - 12/31/2017 period,

(ii) Calculate Intel's beta for the 01/01/2015 - 12/31/2017 period,

(iii) Calculate Chevron's beta for the 01/01/2015 - 12/31/2017 period,

(iv) Calculate Apple's beta for the 01/01/2015 - 12/31/2017 period.