You Must Complete This Assignment In The Next 2 Hours Save Each Answer Immediately By Clicking On The Save Button Yo 1 (125.78 KiB) Viewed 38 times
You must complete this assignment in the next 2 hours. Save each answer immediately by clicking on the "Save" button. You can change your answer any time before your time is up. Unsaved answers will not be submitted. The table below shows historical end-of-week adjusted close prices (including dividends) for a stock and the S&P 500. A B D 1 Week Stock S&P 500 2 0 34.46 2,736 3 1 35.1 2,678 4 2 38.03 2,725 3 37.4 2,785 4 34.8 2,838 7 5 37.1 2,764 8 6 38.87 2,838 9 7 33.88 2,777 10 8 34.21 2,875 11 9 35.09 3,028 12 10 36.26 2,991 13 Sum 395.2 31,035 SUM(C2:C12) Copy and paste all data into your own spreadsheet. Calculate the sum of the prices for both assets to check that you copied all values correctly. If your sums match those shown above, you can delete row 13 in your spreadsheet. Attempt 1/1 Part 1 What is the holding period return over the 10 weeks for the S&P 500? 3+ decimals Save 56 00
Attempt 1/1 Part 2 What is the geometric average weekly return for the S&P 500? 4+ decimals Save Attempt 1/1 Part 3 What is the annualized return for the S&P 500 (EAR)? Hint: Annualize your results from part 1 and part 2 to verify your answer. Both methods must give you exactly the same result. 2+ decimals Save Attempt 1/1 Part 4 What is standard deviation of weekly returns for the S&P 500? 4+ decimals Save
Part 5 What is the beta of the stock (not the S&P 500)? 3+ decimals Save Attempt 1/1
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!