You want to create a price-weighted index for semiconductor companies LRCX, MU, AMAT, and ORCL. Their respective price when you created the index is: $550, $75, $125 and $85.

a. If you want the initial index to be 1,000, what must be the initial divisor?

b. A year late, the price of the stocks were: $680, $105, $152 and $88. How much has the index change?

c. Repeat step b, except LRCX has gone for a 10 for 1 split at the start. How much has the index change now?

Please show how to solve in excel