Excel for and Exam.bs Po (price Consider the three stocks in the following table Prepresents the price at time and represents an shares outstanding met July 2020 August 2020 Qomillion shares) Pu 0 GS 200 400 205 400 HD 250 1000 200 1.000 AAPL 3.000 140 12.000 Assume a price-weighted index started to construct in July 2020 (divisor starts at 3) This index only has three components: GS, HD. and AAPL In August 2020, AAPL decided to split shares 4-for.1 540 (1) What is the index value in August 2020 (2) What is the new divisor in August 2020? (Note: Apple was the largest and therefore the most influential component of DJ a price-weighted index Aller Apple spil shares 4-for-In August 2020 AAPL moved to the most influential component of the 30-member blue-chip index to perhaps the middle of the pack among the components, and the divor cropped accordingly (1) The index value is $341.67. (1) The new divisor is 1.77 (1) The index value is 5357.41. (1) The new divisor is 2.77 (1) The index value is $201.67. (1) The new divisor is 2.77 (1) The Index value is $330.00 (1) The new divisor is 1.77