Enter formulas in the yellow cells to create a model. Industry Unit Model Estimated Total Market...

Transcribed Image Text:

Enter formulas in the yellow cells to create a model. 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 Company Unit Models Direct Channel: Market Share Retail Channel: Market Share Direct Channel: Units Sold Retail Channel: Units Sold Total Units Sold Revenues Model Direct Channel: Price Retail Channel: Price Direct Channel: Revenues Retail Channel: Revenues Total Revenues 2017 630 33% 2017 50% 70% 2017 200 125 2018 15% 40% 2018 45% 75% 2018 200 125 2019 15% 48% Company 2019 40% 80% 2019 200 125 2020 15% 58% 2020 35% 85% 2020 200 125 CAGR 15% 20% 0% 0% CAGR -11% 7% 0% 0% 0% 0% CAGR 0% 0% 0% 0% 0% 2017 2017 190 125 Sole Competitor 2018 2019 2018 180 125 2019 170 125 2020 2020 160 125 CAGR 0% 0% 0% 0% 0% 0% CAGR -6% 0% 0% 0% 0% 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 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 2017 100 2017 10% 5% 2018 100 2018 10% 5% 2019 100 2019 10% 5% 2020 100 2020 10% 5% CAGR 0% 0% 0% 0% 0% 0% CAGR 0% 0% 0% 0% 0% 2017 2017 10% 5% 2018 2018 10% 5% 2019 2019 10% 5% 2020 2020 10% 5% CAGR 0% 0% 0% 0% 0% 0% CAGR 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? Enter formulas in the yellow cells to create a model. 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 Company Unit Models Direct Channel: Market Share Retail Channel: Market Share Direct Channel: Units Sold Retail Channel: Units Sold Total Units Sold Revenues Model Direct Channel: Price Retail Channel: Price Direct Channel: Revenues Retail Channel: Revenues Total Revenues 2017 630 33% 2017 50% 70% 2017 200 125 2018 15% 40% 2018 45% 75% 2018 200 125 2019 15% 48% Company 2019 40% 80% 2019 200 125 2020 15% 58% 2020 35% 85% 2020 200 125 CAGR 15% 20% 0% 0% CAGR -11% 7% 0% 0% 0% 0% CAGR 0% 0% 0% 0% 0% 2017 2017 190 125 Sole Competitor 2018 2019 2018 180 125 2019 170 125 2020 2020 160 125 CAGR 0% 0% 0% 0% 0% 0% CAGR -6% 0% 0% 0% 0% 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 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 2017 100 2017 10% 5% 2018 100 2018 10% 5% 2019 100 2019 10% 5% 2020 100 2020 10% 5% CAGR 0% 0% 0% 0% 0% 0% CAGR 0% 0% 0% 0% 0% 2017 2017 10% 5% 2018 2018 10% 5% 2019 2019 10% 5% 2020 2020 10% 5% CAGR 0% 0% 0% 0% 0% 0% CAGR 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? Enter formulas in the yellow cells to create a model. 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 Company Unit Models Direct Channel: Market Share Retail Channel: Market Share Direct Channel: Units Sold Retail Channel: Units Sold Total Units Sold Revenues Model Direct Channel: Price Retail Channel: Price Direct Channel: Revenues Retail Channel: Revenues Total Revenues 2017 630 33% 2017 50% 70% 2017 200 125 2018 15% 40% 2018 45% 75% 2018 200 125 2019 15% 48% Company 2019 40% 80% 2019 200 125 2020 15% 58% 2020 35% 85% 2020 200 125 CAGR 15% 20% 0% 0% CAGR -11% 7% 0% 0% 0% 0% CAGR 0% 0% 0% 0% 0% 2017 2017 190 125 Sole Competitor 2018 2019 2018 180 125 2019 170 125 2020 2020 160 125 CAGR 0% 0% 0% 0% 0% 0% CAGR -6% 0% 0% 0% 0% 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 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 2017 100 2017 10% 5% 2018 100 2018 10% 5% 2019 100 2019 10% 5% 2020 100 2020 10% 5% CAGR 0% 0% 0% 0% 0% 0% CAGR 0% 0% 0% 0% 0% 2017 2017 10% 5% 2018 2018 10% 5% 2019 2019 10% 5% 2020 2020 10% 5% CAGR 0% 0% 0% 0% 0% 0% CAGR 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? Enter formulas in the yellow cells to create a model. 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 Company Unit Models Direct Channel: Market Share Retail Channel: Market Share Direct Channel: Units Sold Retail Channel: Units Sold Total Units Sold Revenues Model Direct Channel: Price Retail Channel: Price Direct Channel: Revenues Retail Channel: Revenues Total Revenues 2017 630 33% 2017 50% 70% 2017 200 125 2018 15% 40% 2018 45% 75% 2018 200 125 2019 15% 48% Company 2019 40% 80% 2019 200 125 2020 15% 58% 2020 35% 85% 2020 200 125 CAGR 15% 20% 0% 0% CAGR -11% 7% 0% 0% 0% 0% CAGR 0% 0% 0% 0% 0% 2017 2017 190 125 Sole Competitor 2018 2019 2018 180 125 2019 170 125 2020 2020 160 125 CAGR 0% 0% 0% 0% 0% 0% CAGR -6% 0% 0% 0% 0% 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 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 2017 100 2017 10% 5% 2018 100 2018 10% 5% 2019 100 2019 10% 5% 2020 100 2020 10% 5% CAGR 0% 0% 0% 0% 0% 0% CAGR 0% 0% 0% 0% 0% 2017 2017 10% 5% 2018 2018 10% 5% 2019 2019 10% 5% 2020 2020 10% 5% CAGR 0% 0% 0% 0% 0% 0% CAGR 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? Enter formulas in the yellow cells to create a model. 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 Company Unit Models Direct Channel: Market Share Retail Channel: Market Share Direct Channel: Units Sold Retail Channel: Units Sold Total Units Sold Revenues Model Direct Channel: Price Retail Channel: Price Direct Channel: Revenues Retail Channel: Revenues Total Revenues 2017 630 33% 2017 50% 70% 2017 200 125 2018 15% 40% 2018 45% 75% 2018 200 125 2019 15% 48% Company 2019 40% 80% 2019 200 125 2020 15% 58% 2020 35% 85% 2020 200 125 CAGR 15% 20% 0% 0% CAGR -11% 7% 0% 0% 0% 0% CAGR 0% 0% 0% 0% 0% 2017 2017 190 125 Sole Competitor 2018 2019 2018 180 125 2019 170 125 2020 2020 160 125 CAGR 0% 0% 0% 0% 0% 0% CAGR -6% 0% 0% 0% 0% 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 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 2017 100 2017 10% 5% 2018 100 2018 10% 5% 2019 100 2019 10% 5% 2020 100 2020 10% 5% CAGR 0% 0% 0% 0% 0% 0% CAGR 0% 0% 0% 0% 0% 2017 2017 10% 5% 2018 2018 10% 5% 2019 2019 10% 5% 2020 2020 10% 5% CAGR 0% 0% 0% 0% 0% 0% CAGR 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? Enter formulas in the yellow cells to create a model. 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 Company Unit Models Direct Channel: Market Share Retail Channel: Market Share Direct Channel: Units Sold Retail Channel: Units Sold Total Units Sold Revenues Model Direct Channel: Price Retail Channel: Price Direct Channel: Revenues Retail Channel: Revenues Total Revenues 2017 630 33% 2017 50% 70% 2017 200 125 2018 15% 40% 2018 45% 75% 2018 200 125 2019 15% 48% Company 2019 40% 80% 2019 200 125 2020 15% 58% 2020 35% 85% 2020 200 125 CAGR 15% 20% 0% 0% CAGR -11% 7% 0% 0% 0% 0% CAGR 0% 0% 0% 0% 0% 2017 2017 190 125 Sole Competitor 2018 2019 2018 180 125 2019 170 125 2020 2020 160 125 CAGR 0% 0% 0% 0% 0% 0% CAGR -6% 0% 0% 0% 0% 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 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 2017 100 2017 10% 5% 2018 100 2018 10% 5% 2019 100 2019 10% 5% 2020 100 2020 10% 5% CAGR 0% 0% 0% 0% 0% 0% CAGR 0% 0% 0% 0% 0% 2017 2017 10% 5% 2018 2018 10% 5% 2019 2019 10% 5% 2020 2020 10% 5% CAGR 0% 0% 0% 0% 0% 0% CAGR 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? Enter formulas in the yellow cells to create a model. 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 Company Unit Models Direct Channel: Market Share Retail Channel: Market Share Direct Channel: Units Sold Retail Channel: Units Sold Total Units Sold Revenues Model Direct Channel: Price Retail Channel: Price Direct Channel: Revenues Retail Channel: Revenues Total Revenues 2017 630 33% 2017 50% 70% 2017 200 125 2018 15% 40% 2018 45% 75% 2018 200 125 2019 15% 48% Company 2019 40% 80% 2019 200 125 2020 15% 58% 2020 35% 85% 2020 200 125 CAGR 15% 20% 0% 0% CAGR -11% 7% 0% 0% 0% 0% CAGR 0% 0% 0% 0% 0% 2017 2017 190 125 Sole Competitor 2018 2019 2018 180 125 2019 170 125 2020 2020 160 125 CAGR 0% 0% 0% 0% 0% 0% CAGR -6% 0% 0% 0% 0% 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 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 2017 100 2017 10% 5% 2018 100 2018 10% 5% 2019 100 2019 10% 5% 2020 100 2020 10% 5% CAGR 0% 0% 0% 0% 0% 0% CAGR 0% 0% 0% 0% 0% 2017 2017 10% 5% 2018 2018 10% 5% 2019 2019 10% 5% 2020 2020 10% 5% CAGR 0% 0% 0% 0% 0% 0% CAGR 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? Enter formulas in the yellow cells to create a model. 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 Company Unit Models Direct Channel: Market Share Retail Channel: Market Share Direct Channel: Units Sold Retail Channel: Units Sold Total Units Sold Revenues Model Direct Channel: Price Retail Channel: Price Direct Channel: Revenues Retail Channel: Revenues Total Revenues 2017 630 33% 2017 50% 70% 2017 200 125 2018 15% 40% 2018 45% 75% 2018 200 125 2019 15% 48% Company 2019 40% 80% 2019 200 125 2020 15% 58% 2020 35% 85% 2020 200 125 CAGR 15% 20% 0% 0% CAGR -11% 7% 0% 0% 0% 0% CAGR 0% 0% 0% 0% 0% 2017 2017 190 125 Sole Competitor 2018 2019 2018 180 125 2019 170 125 2020 2020 160 125 CAGR 0% 0% 0% 0% 0% 0% CAGR -6% 0% 0% 0% 0% 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 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 2017 100 2017 10% 5% 2018 100 2018 10% 5% 2019 100 2019 10% 5% 2020 100 2020 10% 5% CAGR 0% 0% 0% 0% 0% 0% CAGR 0% 0% 0% 0% 0% 2017 2017 10% 5% 2018 2018 10% 5% 2019 2019 10% 5% 2020 2020 10% 5% CAGR 0% 0% 0% 0% 0% 0% CAGR 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? Enter formulas in the yellow cells to create a model. 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 Company Unit Models Direct Channel: Market Share Retail Channel: Market Share Direct Channel: Units Sold Retail Channel: Units Sold Total Units Sold Revenues Model Direct Channel: Price Retail Channel: Price Direct Channel: Revenues Retail Channel: Revenues Total Revenues 2017 630 33% 2017 50% 70% 2017 200 125 2018 15% 40% 2018 45% 75% 2018 200 125 2019 15% 48% Company 2019 40% 80% 2019 200 125 2020 15% 58% 2020 35% 85% 2020 200 125 CAGR 15% 20% 0% 0% CAGR -11% 7% 0% 0% 0% 0% CAGR 0% 0% 0% 0% 0% 2017 2017 190 125 Sole Competitor 2018 2019 2018 180 125 2019 170 125 2020 2020 160 125 CAGR 0% 0% 0% 0% 0% 0% CAGR -6% 0% 0% 0% 0% 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 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 2017 100 2017 10% 5% 2018 100 2018 10% 5% 2019 100 2019 10% 5% 2020 100 2020 10% 5% CAGR 0% 0% 0% 0% 0% 0% CAGR 0% 0% 0% 0% 0% 2017 2017 10% 5% 2018 2018 10% 5% 2019 2019 10% 5% 2020 2020 10% 5% CAGR 0% 0% 0% 0% 0% 0% CAGR 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? Enter formulas in the yellow cells to create a model. 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 Company Unit Models Direct Channel: Market Share Retail Channel: Market Share Direct Channel: Units Sold Retail Channel: Units Sold Total Units Sold Revenues Model Direct Channel: Price Retail Channel: Price Direct Channel: Revenues Retail Channel: Revenues Total Revenues 2017 630 33% 2017 50% 70% 2017 200 125 2018 15% 40% 2018 45% 75% 2018 200 125 2019 15% 48% Company 2019 40% 80% 2019 200 125 2020 15% 58% 2020 35% 85% 2020 200 125 CAGR 15% 20% 0% 0% CAGR -11% 7% 0% 0% 0% 0% CAGR 0% 0% 0% 0% 0% 2017 2017 190 125 Sole Competitor 2018 2019 2018 180 125 2019 170 125 2020 2020 160 125 CAGR 0% 0% 0% 0% 0% 0% CAGR -6% 0% 0% 0% 0% 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 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 2017 100 2017 10% 5% 2018 100 2018 10% 5% 2019 100 2019 10% 5% 2020 100 2020 10% 5% CAGR 0% 0% 0% 0% 0% 0% CAGR 0% 0% 0% 0% 0% 2017 2017 10% 5% 2018 2018 10% 5% 2019 2019 10% 5% 2020 2020 10% 5% CAGR 0% 0% 0% 0% 0% 0% CAGR 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?