Learning Objectives: Calculate market betas using monthly returns Submission Instructions: Sunday 9/16 (end of week 4).

/in /by

Learning Objectives: Calculate market betas using monthly returns

Submission Instructions:

  1. Due: Sunday 9/16 (end of week 4). Late assignments will not be accepted.
  2. You need to show your working notes for credit. You must submit your work using 1 Excel file (.xls or .xlsx).
  3. Upload Excel file to Canvas > Module 3 > Mini-case 1
  4. For %, round your answer to the nearest 2 decimal % points such as “12.35%”.

Problems (5 questions, 1 point for each):

1. Retrieve monthly data for the period of 01/01/2012 – 12/31/2017 from Yahoo Finance for

  1. S&P 500 Index (ticker: ^GSPC)
  2. Apple Inc. (ticker: AAPL)
  3. Procter & Gamble (ticker: PG