Learning Objectives: Calculate market betas using monthly returns
- Due: Sunday 9/16 (end of week 4). Late assignments will not be accepted.
- You need to show your working notes for credit. You must submit your work using 1 Excel file (.xls or .xlsx).
- Upload Excel file to Canvas > Module 3 > Mini-case 1
- 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
- S&P 500 Index (ticker: ^GSPC)
- Apple Inc. (ticker: AAPL)
- Procter & Gamble (ticker: PG