ACC 557 Week 2 Homework Part 1&2 | Strayer University, Washington

Week 2 1. What was the Close price and Adjusted Close price, respectively, for MSFT on January 13, 2012? 2. Calculate the daily return for MSFT on January 13, 2012 using the “Close price” and enter it here. Write y ...

Week 2 1. What was the Close price and Adjusted Close price, respectively, for MSFT on January 13, 2012? 2. Calculate the daily return for MSFT on January 13, 2012 using the “Close price” and enter it here. Write your answer as a percentage, with no percentage sign ("%"), and rounded to the nearest hundredth decimal place (e.g., you would enter "1.2344%" as "1.23", not "0.012344"). 3. Calculate the percentage daily return for MSFT on June 27, 2016 using the “Adjusted Close price” and enter it here. Write your answer as a percentage, with no percentage sign ("%"), and rounded to the nearest hundredth decimal place (e.g., you would enter "1.2344%" as "1.23", not "0.012344"). 4. Calculate the difference between MSFT's "Close price" and "The Adjusted Close price" on October 17, 2014 and enter it here. 5. Calculate the daily return on August 31, 2011 for DJI using the “Close price” and enter it here. Write your answer as a percentage, with no percentage sign ("%"), and rounded to the nearest hundredth decimal place (e.g., you would enter "1.2344%" as "1.23", not "0.012344"). 6. Calculate the daily return for DJI on November 1, 2012 using the “Adjusted Close price” and enter it here. Write your answer as a percentage, with no percentage sign ("%"), and rounded to the nearest hundredth decimal place (e.g., you would enter "1.2344%" as "1.23", not "0.012344"). 7. What was the numerical difference between DJI's "Close price" and "Adjusted Close price" on August 28, 2012, January 23, 2014, and December 1, 2015? 8. Which price reflects the true return of holding a security? 9. What could explain the differences between Adjusted Close price and Close price (check all the apply)? Stock split Dividend payments Events where the corporation pays out stock to stockholders 10. In order to make accurate calculations of a stock's return, which price should you use? Part 2 1. Using the results you get from the Daily Returns quiz for MSFT, calculate the following summary statistic "mean" of the MSFT return series (using the adjusted close series): 2. Using the results you get from the Daily Returns quiz for MSFT, calculate the following summary statistic "standard deviation" of the MSFT return series (using the adjusted close series): 3. Using the results you get from the Daily Returns quiz for MSFT, calculate the following summary statistic "min" of the MSFT return series (using the adjusted close series): 4. Using the results you get from the Daily Returns quiz for MSFT, calculate the following summary statistic "max" of the MSFT return series (using the adjusted close series): 5. Using the results you get from the Daily Returns quiz for MSFT, calculate the following summary statistic "Sharpe Ratio" of the MSFT return series (using the adjusted close series): 6. Using the results you get from the Daily Returns quiz for DJI, calculate the following summary statistic "mean" of the DJI return series (using the adjusted close series): 7. Using the results you get from the Daily Returns quiz for DJI, calculate the following summary statistic "standard deviation" of the DJI return series (using the adjusted close series): 8. Using the results you get from the Daily Returns quiz for DJI, calculate the following summary statistic "min" of the DJI return series (using the adjusted close series): 9. Using the results you get from the Daily Returns quiz for DJI, calculate the following summary statistic "max" of the DJI return series (using the adjusted close series): 10. Using the results you get from the Daily Returns quiz for DJIA, calculate the following summary statistic "Sharpe Ratio" of the return series (using the adjusted close series):