PLEASE USE EXCEL FORMULAS FOR THE ANSWERS!

P21 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. 10 12 14 15 Input Data Year 2009 market Annual growth Year Unit sales 10000 10% 2010 2011 2012 2013 2014 2015 2016 2017 2018 17 18 19 1st Company 2nd Company Entry year Sales loss 2013 30% 2016 15% 21 26 Q1.DrugCompany Q2Distances Q3. MakeupSales