2018 2019 2020 CAGR 15% 15% 40% 15% 48% 15% 58% 20% 0% 0% Sole Competitor 2018 2019 2017 2020 Company 2018 2019 45% 40% 75% 80% 2020 35% 85% CAGR 0% 0% 0% 0% CAGR -11% 7% 0% 0% 0% 0% CAGR 0% 0% 0% 0% 0% 2018 200 125 2019 200 125 2020 200 125 2017 190 125 2018 180 125 2019 170 125 55 Enter formulas in the yellow cells to create a model. 56 57 Industry Unit Model 2017 58 Estimated Total Market Size in Units 640 59 FO Growth Rate co 60 Estimated Percent Direct Channel 33% ca 61 Direct Channel: Market Size in Units ca 62 Retail Channel: Market Size in Units 63 64 65 Company Unit Models 2017 66 Direct Channel: Market Share 50% 67 Retail Channel: Market Share 70% 68 Direct Channel: Units Sold 69 Retail Channel: Units Sold 70 Total Units Sold 71 mai 72 Revenues Model 2017 73 Direct Channel: Price 200 74 Retail Channel: Price : 125 75 Direct Channel: Revenues 76 Retail Channel: Revenues 77 Total Revenues 78 79 80 Gross Profit Model 2017 81 Unit Cost 100 82 Direct Channel: Cost of Revenues 83 Retail Channel: Cost of Revenues 84 Direct Channel: Gross Profit 05 85 Retail Channel: Gross Profit 86 06 Total Gross Profit 87 Total Gross Margin 20 88 00 89 EBIT (Operating Profit) Model 2017 on 90 Direct Channel: SG&A Percent 10% 91 Retail Channel: SG&A Percent 5% 02 92 Direct Channel: SG&A 92 93 Retail Channel: SG&A 94 GA Direct Channel: EBIT 95 Retail Channel: EBIT 96 Total EBIT 97 2020 160 125 0% 0% CAGR -6% 0% 0% 06 0% 2017 2018 2019 2020 CAGR 2018 100 2019 100 2020 100 CAGR 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0 0% CAGR CAGR 2018 10% 5% 2019 10% 5% 2020 10% 5% 2017 10% 5% 2018 10% 5% 2019 10% 5% 2020 10% 5% 0% 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? 2018 2019 2020 CAGR 15% 15% 40% 15% 48% 15% 58% 20% 0% 0% Sole Competitor 2018 2019 2017 2020 Company 2018 2019 45% 40% 75% 80% 2020 35% 85% CAGR 0% 0% 0% 0% CAGR -11% 7% 0% 0% 0% 0% CAGR 0% 0% 0% 0% 0% 2018 200 125 2019 200 125 2020 200 125 2017 190 125 2018 180 125 2019 170 125 55 Enter formulas in the yellow cells to create a model. 56 57 Industry Unit Model 2017 58 Estimated Total Market Size in Units 640 59 FO Growth Rate co 60 Estimated Percent Direct Channel 33% ca 61 Direct Channel: Market Size in Units ca 62 Retail Channel: Market Size in Units 63 64 65 Company Unit Models 2017 66 Direct Channel: Market Share 50% 67 Retail Channel: Market Share 70% 68 Direct Channel: Units Sold 69 Retail Channel: Units Sold 70 Total Units Sold 71 mai 72 Revenues Model 2017 73 Direct Channel: Price 200 74 Retail Channel: Price : 125 75 Direct Channel: Revenues 76 Retail Channel: Revenues 77 Total Revenues 78 79 80 Gross Profit Model 2017 81 Unit Cost 100 82 Direct Channel: Cost of Revenues 83 Retail Channel: Cost of Revenues 84 Direct Channel: Gross Profit 05 85 Retail Channel: Gross Profit 86 06 Total Gross Profit 87 Total Gross Margin 20 88 00 89 EBIT (Operating Profit) Model 2017 on 90 Direct Channel: SG&A Percent 10% 91 Retail Channel: SG&A Percent 5% 02 92 Direct Channel: SG&A 92 93 Retail Channel: SG&A 94 GA Direct Channel: EBIT 95 Retail Channel: EBIT 96 Total EBIT 97 2020 160 125 0% 0% CAGR -6% 0% 0% 06 0% 2017 2018 2019 2020 CAGR 2018 100 2019 100 2020 100 CAGR 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0 0% CAGR CAGR 2018 10% 5% 2019 10% 5% 2020 10% 5% 2017 10% 5% 2018 10% 5% 2019 10% 5% 2020 10% 5% 0% 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