A drug company believes that the market size for its new drug in 2009 will be 10,000. The size of the market is growing at 10 percent per year.

The company expects two competitors to enter the market. The year in which the first competitor enters, the company expects to lose 30 percent of its market share. The year in which the second competitor enters, the company expects to lose 15 percent of its market share.

Requirements: Using Excel and Formulas

1. Give the appropriate range names to the given data in Input Data.

2. Compute the annual units sales of the company for the years 2009-2018.

Input Data				Year	Unit sales
Year 2009 market	10000			2009
Annual growth	10%			2010
	1st Company	2nd Company		2011
Entry year	2013	2016		2012
Sales loss	30%	15%		2013
				2014
				2015
				2016
				2017
				2018