Create a spreadsheet workbook to solve the problem below.

1. Given the quotes below, calculate the index value and the percentage daily change for the daily scenarios listed below using a price-weighted index, value-weighted index, arithmetic equalweighted index, and a geometric equal-weighted index. Also, calculate the divisor for each day for the price-weighted index.

Daily Scenarios

Stock	Price	Number of Shares Outstanding
1	50	500
2	35	1000
3	15	750

Base index value is 100. If no change is listed for a stock on a day, assume the stock price didnt change.

Day 1: Day 1 is base year.

Day 2: All three stocks increase by 4%

Day 3: Stock 1 increases by 3%, Stock 2 increases by 6%

Day 4: Stock 2 increases by 5%, Stock 3 increases by 2%

Day 5: Stock 3 increases by 4%, Stock 1 increases by 1%

Day 6: All three stocks decrease by 2% (After close on Day 6, Stock 3 splits 2-for 1)

Day 7: Stock 3 increases by 1%, Stock 2 decreases by 3%