CAN YOU CHECK MY WORK PLEASE

	Stock price				Shares
	x	y	z		x	y	z
1/13/16	20	40	30		1000	2000	1000
1/14/16	25	42	18		1000	2000	2000
1/15/16	27	45	8		1000	2000	2000
1/16/16	20	40	10		3000	2000	2000
13-Jan20	30	2.533333333
14-Jan20	33.55263158
15-Jan20	31.57894737	1.794444444
16-Jan20	39.00928793
x	20000	80000	30000
y	25000	84000	36000
z	27000	90000	16000
	72000	254000	82000

Calculate a Standard & Poors Index for days 1 through 5 using a beginning index value of 30.

Identify what effects the splits had in determining the next days index. (Hint: think of the relative weighting of each stock.)

******************PLEASE CHECK MY WORK************

=(24+42+18/2)/30 = 2.533333333

=SUM(25+42+18) / 2.533333333 = 33.55263158

=SUM(27+45+8) / 2.533333333 = 31.5789474

=SUM((20+/3)+40+10) / 31.5789474 = 1.794444444

=SUM(20+40+10) / 1.794444444 = 39.0092879