please send excel file as well

Problem 1: Creating an Index [20 pointsl Your task is to create an index, using Excel, from the 6 stocks in the table below. Using the information presented in the following table, answer the following set of questions: a. b. [6] What is the return on the price-weighted index for each of Day 1, Day 2, and Day 3? [6] Now assume the index is value-weighted. What is the return to the value-weighted index on Day 1, Day 2, and Day 3? c. [4] If the index were equal-weighted instead of value-weighted, would the Day 1 return be greater than, less than, or equal to the value-weighted index return in part b? Provide intuition, in addition to a specific numerical return. [4] Compute the index weights at the end of Day 1 for the equal weighted index, assuming any rebalancing has not yet taken place. If the equally weighted index rebalances at the end of each day, what is the required turnover on Day 1? d. Note: The dividend information is presented by ex-date, meaning the day on which the seller receives the dividend, not the buyer