you chose. For example, replace Index A WITH Step 02: In cell B2 we will set the index for the stock you chose to be 100 by taking the April 2017 price divided by itself with the result multiplied by 100. For example, for Microsoft in column E, the formula might be =100*E2/E2. For each future period we will want to divide by the same original value in cell E2, so when we copy the cell downwards, we want to 'fix' the dominator in the equation. We can do this by putting a dollar sign in front of the E and 2:=100*E2/$E$2. If you chose to use a different stock than Microsoft, everything will be the same, just a different letter than "E". O