Find the betas for Amazon (AMZN) and Dow Chemical (DOW) at Google Finance. Once there click on "Historical Prices" and select Weekly prices. Once there select the Date Range of 01/01/2008 to 12/31/2008 and then download to a spreadsheet. Do this for both stocks and then do the same for the S&P500 Index. Finally, find the beta for each given their performance against the S&P500 Index (you can use the formula on Excel's functions). Next, using the calculated betas find the expected returns for both Amazon and Dow. Are the returns what you expected for each? Why or why not? The response should be between 3 and 5 pages in Word and should include course material to support statements. One of the pages should be the Excel sheet that shows calculations. This sheet can either be part of the appendix or may be attached separately. The response should adhere to APA style and formatting.
Your directions seem clear.
How would you like us to help you on this assignment?