Find the betas for Amazon (AMZN) and Dow Chemical (DOW) at Google Finance In Tutorial Library
This is Tutorial details page
TITLE: Find the betas for Amazon (AMZN) and Dow Chemical (DOW) at Google Finance
CLASS / COURSE: Finance
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.
Completed Solution is attached. Click on Buy button and then download file to get full solution.