7. A drug company believes its new drug will sell 10,000 units in 2004. They expect 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. The size of the market is growing at 10 percent per year. Given values for the years in which the two competitors enter, develop a worksheet that computes the annual sales for the years 2004- 2013. A1 v X fx ='Chapter 12 Q7' B C D E F G H 1 2 3 4 Year 2004 sales 10000 1st comp entry 2006 2nd comp entry 2009 annual growth 10% 5 Year Unit sales 1st comp drop 30% 6 2004 2nd comp drop 15% 7 2005 CO 2006 9 2007 10 2008 11 2009 12 2010 13 2011 14 2012 15 2013 16 17 18