Spreadsheet Questions
1. Suppose that Ford's return in June 2010 had been 4%, and its return in july 2010 had been 15% .Would you expect its beta to be more or less than the value obtained in the spreadsheet? Reestimate beta with these new data, and confirm your intution.
2. Suppose that Ford's return in each month had been 1% higher than the values presented in the accompanying spreadsheet. Would Ford's beta differ from the value obtained in the spreadsheet? Reestimate beta with these new data and confirm your intuition.
3. Suppose that you add 1 more month of data to your spreadsheet and find that in October 2010, Fors was down 5% while the market was up 5%. Would you expect Ford's beta to be more or less than the values obtained in the spreadsheet? Reestimate beta with this new data point, and confirm your intuition.
Home Work
• Text, page 348 "Calculating Risk" spreadsheet analysis
• 6 months - August 2017 - January 2018 Apple stock
• Data source - Yahoo Finance
Attachment:- Calculating Risk.rar