Question

The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the simple three-month moving average for each month for both companies. (Input all amounts as positive values. Do not round intermediate calculations. Round your answers to 2 decimal places.)

	IBM				AMZN
January	$	180.44		$	626.46
February		180.49			632.84
March		202.81			561.38
April		219.75			551.30
May		188.05			491.58
June		212.77			484.78
July		246.46			609.09
August		193.09			532.86
September		224.87			510.36
October		215.67			610.82
November		200.39			583.73
December		178.14			665.70

	IBM AMZN March April May June July August September October November December

Answer 1

IBM				AMZN
Month	Closing price	3 months moving average =(closing price month 1+ closing price month 2 +closing price of month 3)/3 …….(closing price month 10 + closing price month 11 + closing price month 12)/ 3	3 months moving average	Closing price	3 months moving average =(closing price month 1+ closing price month 2 +closing price of month 3)/3 …….(closing price month 10 + closing price month 11 + closing price month 12)/ 3	3 months moving average
January	180.44			626.46
February	180.49			632.84
March	202.81	(H289+H290+H291)/3	187.91	561.38	(K289+K290+K291)/3	606.89
April	219.75	(H290+H291+H292)/3	201.02	551.3	(K290+K291+K292)/3	581.84
May	188.05	(H291+H292+H293)/3	203.54	491.58	(K291+K292+K293)/3	534.75
June	212.77	(H292+H293+H294)/3	206.86	484.78	(K292+K293+K294)/3	509.22
July	246.46	(H293+H294+H295)/3	215.76	609.09	(K293+K294+K295)/3	528.48
August	193.09	(H294+H295+H296)/3	217.44	532.86	(K294+K295+K296)/3	542.24
September	224.87	(H295+H296+H297)/3	221.47	510.36	(K295+K296+K297)/3	550.77
October	215.67	(H296+H297+H298)/3	211.21	610.82	(K296+K297+K298)/3	551.35
November	200.39	(H297+H298+H299)/3	213.64	583.73	(K297+K298+K299)/3	568.30
December	178.14	(H298+H299+H300)/3	198.07	665.7	(K298+K299+K300)/3	620.08