50.1K

Verified Solution

Link Copied!

Intro Download weekly prices for Ford (ticker symbol F) from Yahoo Finance from 1/1/2014 to 12/27/2017 to an Excel worksheet and label it "F". To download the historical prices, go to Yahoo Finance and search for "F". Click on "Historical Data" and set a date range from 1/1/2014 to 12/27/2017. Click on "Done." Change frequency to "Weekly" and click on "Apply," then on "Download." Attempt 1/10 for 10 pts. Part 1 Add another column labeled "Return" and calculate the weekly return based on the change in the adjusted close price. What was the return from 1/1/14 to 1/8/14? -0.00502 Try again Try again See solution (-2 pts.) Part 2 Attempt 1/10 for 10 pts. To find beta, we also need the return on the market portfolio. Download the data for the S&P 500 (^GSPC) for the same time period onto a new worksheet labeled "GSPC". What was the return on the index from 1/1/14 to 1/8/14? Hint: If Yahoo Finance doesn't let you download the data for the S&P 500, try this link instead. 5+ decimals Part 3 Attempt 1/10 for 10 pts. Create a new worksheet labeled 'beta' in Excel. Using Excel's SLOPE() function and the industry model, what is the beta for Ford? 2+ decimals Submit Intro Download weekly prices for Ford (ticker symbol F) from Yahoo Finance from 1/1/2014 to 12/27/2017 to an Excel worksheet and label it "F". To download the historical prices, go to Yahoo Finance and search for "F". Click on "Historical Data" and set a date range from 1/1/2014 to 12/27/2017. Click on "Done." Change frequency to "Weekly" and click on "Apply," then on "Download." Attempt 1/10 for 10 pts. Part 1 Add another column labeled "Return" and calculate the weekly return based on the change in the adjusted close price. What was the return from 1/1/14 to 1/8/14? -0.00502 Try again Try again See solution (-2 pts.) Part 2 Attempt 1/10 for 10 pts. To find beta, we also need the return on the market portfolio. Download the data for the S&P 500 (^GSPC) for the same time period onto a new worksheet labeled "GSPC". What was the return on the index from 1/1/14 to 1/8/14? Hint: If Yahoo Finance doesn't let you download the data for the S&P 500, try this link instead. 5+ decimals Part 3 Attempt 1/10 for 10 pts. Create a new worksheet labeled 'beta' in Excel. Using Excel's SLOPE() function and the industry model, what is the beta for Ford? 2+ decimals Submit

Answer & Explanation Solved by verified expert

See Answer