Enter formulas in the yellow cells to create a model. 2018 2019 2020 2017 630 CAGR 15% Industry Unit Model Estimated Total Market Size in Units Growth Rate Estimated Percent Direct Channel Direct Channel: Market Size in Units Retail Channel: Market Size in Units 15% 40% 15% 48% 15% 58% 33% 20% 0% 0% Sole Competitor 2018 2019 2017 2020 2017 50% 70% Company 2018 2019 45% 40% 75% 80% 2020 35% 85% Company Unit Models Direct Channel: Market Share Retail Channel: Market Share Direct Channel: Units Sold Retail Channel: Units Sold Total Units Sold CAGR 0% 0% 0% 0% 0% CAGR -11% 7% 0% 0% 0% 0% CAGR 0% 0% 0% 0% 0% 2017 200 125 2018 200 125 2019 200 125 2020 200 125 2017 190 125 2018 180 125 2019 170 125 2020 160 125 Revenues Model Direct Channel: Price Retail Channel: Price Direct Channel: Revenues Retail Channel: Revenues Total Revenues 0% CAGR -6% 0% 0% 0% 0% 2018 2019 2017 2018 2019 2020 2017 100 2020 100 100 100 Gross Profit Model Unit Cost Direct Channel: Cost of Revenues Retail Channel: Cost of Revenues Direct Channel: Gross Profit Retail Channel: Gross Profit Total Gross Profit Total Gross Margin CAGR 0% 0% 0% 0% 0% 0% CAGR 0% 0% 0% 0% 0% 0% 2019 CAGR CAGR 2017 10% 5% 2018 10% 5% 10% 5% 2020 10% 5% 2017 10% 5% 2018 10% 5% 2019 10% 5% 2020 10% 5% EBIT (Operating Profit) Model Direct Channel: SG&A Percent Retail Channel: SG&A Percent Direct Channel: SG&A Retail Channel: SG&A Direct Channel: EBIT Retail Channel: EBIT Total EBIT 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% Use the model you have created to answer the following questions. What was the CAGR of the 'Estimated Total Market Size in Units'? What was the CAGR of the 'Direct Channel: Market Size' in Units? What was the CAGR of the competitor's 'Total Revenues'? What was the CAGR of the competitor's 'Direct Channel:Price'? What was the CAGR of the company's 'Total EBIT'? Did either company earn the majority of EBIT in Direct Channel? What was the impact of the competitors aggressive pricing strategy