The Table Below Shows Historical End Of Week Adjusted Close Prices Including Dividends For A Stock And The S P 500 A 1 (143.28 KiB) Viewed 32 times
The table below shows historical end-of-week adjusted close prices (including dividends) for a stock and the S&P 500. A B C 1 Week Stock S&P 500 2 37.29 2,792 3 37.93 2,734 4 40.86 2,749 5 40.23 2,849 6 38.1 2,902 7 40.4 2,828 8 42.17 2,901 9 37.29 2,840 10 37.62 2,938 11 9 38.5 3,091 12 10 39.67 3,054 13 Sum 430.06 31,678=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. O 1 2 3 4 5 6 7 ∞
Attempt 1/1 Part 1 What is the holding period return over the 10 weeks for the S&P 500? 3+ decimals Save Attempt 1/1 Part 2 What is the geometric average weekly return for the S&P 500? 4+ decimals Save Part 3 Attempt 1/1 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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!