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

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