Create a spreadsheet workbook to solve the problems below 1.Identify the 30 stocks that make up the Dow Jones Industrial Average and collect their closing stock prices from Friday, April 19 (data can be found on numerous websites - Marketwatch, WSJ, etc.). Identify the closing price of the DJIA and compute the divisor used in calculating the price-weighted index (DJIA), as of Friday, April 19. (Note: your divisor answer wil1 differ slightly from what is published due to rounding) 2. If 3M splits 4-for-1 after the market closes on Friday, what is the new divisor used when the market opens on Monday, April 22? Utilize a value and the percentage daily change for the daily scenarios listed below using a price-weighted index, value-weighted index, and arithmetic equal-weighted index. te tab for question 3. Given the quotes below, calculate the index Security Number of Shares Outstanding 500 1000 750 rice 50 25 15 Daily Scenarios Day 1 Price-weighted divisor is 3; Base index value is 100 (except for the Price Weighted Index); Day 1 is base year All three stocks increase by 4% Security 1 increases by 4% Security 2 increases by 4% Security 3 increases by 4% Day Day Day 4 Day 5 Create a spreadsheet workbook to solve the problems below 1.Identify the 30 stocks that make up the Dow Jones Industrial Average and collect their closing stock prices from Friday, April 19 (data can be found on numerous websites - Marketwatch, WSJ, etc.). Identify the closing price of the DJIA and compute the divisor used in calculating the price-weighted index (DJIA), as of Friday, April 19. (Note: your divisor answer wil1 differ slightly from what is published due to rounding) 2. If 3M splits 4-for-1 after the market closes on Friday, what is the new divisor used when the market opens on Monday, April 22? Utilize a value and the percentage daily change for the daily scenarios listed below using a price-weighted index, value-weighted index, and arithmetic equal-weighted index. te tab for question 3. Given the quotes below, calculate the index Security Number of Shares Outstanding 500 1000 750 rice 50 25 15 Daily Scenarios Day 1 Price-weighted divisor is 3; Base index value is 100 (except for the Price Weighted Index); Day 1 is base year All three stocks increase by 4% Security 1 increases by 4% Security 2 increases by 4% Security 3 increases by 4% Day Day Day 4 Day 5