he following three defense stocks are to be combined into a stock index in January 2016 (perhaps a portfolio manager believes these stocks are an appropriate benchmark for his or her performance). Assume the index is scaled by a factor of 10 million; that is, if the total value of all firms in the market is $5 billion, the index would be quoted as 500. Show all excel formulas and steps.

		Price
	Shares (millions)		1/1/16			1/1/17			1/1/18
Douglas McDonnell	205		$	103		$	109		$	123
Dynamics General	450			48			44			58
International Rockwell	290			77			66			80

a. Calculate the initial value of the index if a value-weighting scheme is used. (Round your answer to 2 decimal places.)

b. What is the rate of return on this index for the year ending December 31, 2016? For the year ending December 31, 2017? (A negative value should be indicated by a minus sign. Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places.)