extBox 1 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: 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 Using excel formula! Year Unit sales Input Data Year 2009 market , 10000 10% 2010 2011 2012 2013 2014 2015 2016 2017 2018 Annual growth 1st Company 2nd Company Entry year Sales loss 15% Distances Q3 MakeupSales