Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need the correct inputs for the yellow parts. 2018 2019 2020 2017 610 CAGR 15% 58 15% 40% 15% 48% 15% 58% 33% 20%
I need the correct inputs for the yellow parts.
2018 2019 2020 2017 610 CAGR 15% 58 15% 40% 15% 48% 15% 58% 33% 20% 0% 0% Sole Competitor 2018 2019 2017 2020 57 Industry Unit Model Estimated Total Market Size in Units 59 Growth Rate 60 Estimated Percent Direct Channel 61 Direct Channel: Market Size in Units 62 Retail Channel: Market Size in Units 63 64 65 Company Unit Models 66 Direct Channel: Market Share 67 Retail Channel: Market Share 68 Direct Channel: Units Sold 69 Retail Channel: Units Sold 70 Total Units Sold 71 72 Revenues Model 73 Direct Channel: Price 74 Retail Channel: Price 75 Direct Channel: Revenues 76 Retail Channel: Revenues 77 Total Revenues 2017 50% 70% Company 2018 2019 45% 40% 75% 80% 2020 35% 85% CAGR -11% 7% 0% 0% 0% 0% CAGR 0% 0% 0% 0% 0% CAGR 0% 0% 0% 0% 0% 0% CAGR -6% 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 0% 076 0% 78 2017 2018 2019 2020 2019 100 2020 100 CAGR 0% 0% 0 0% nou 0% 0% 0 0% CAGR 0% 0% 0% 0% 0 0% 0% CAGR CAGR 2019 10% 5% 2020 10% 5% 2017 10% 5% 2018 10% 5% 2019 10% 5% 2020 10% 5% 20 79 80 Gross Profit Model 2017 2018 81 Unit Cost 100 100 82 Direct Channel: Cost of Revenues 83 Retail Channel: Cost of Revenues 84 Direct Channel: Gross Profit 85 Retail Channel: Gross Profit 86 Total Gross Profit 87 Total Gross Margin 88 89 EBIT (Operating Profit) Model 2017 2018 90 Direct Channel: SG&A Percent 10% 10% 91 Retail Channel: SG&A Percent 5% 5% 02 92 Direct Channel: SG&A 93 92 Retail Channel: SG&A 94 GA Direct Channel: EBIT 95 95 Retail Channel: EBIT 96 96 Total EBIT 97 98 Use the model you have created to answer the following questions. 99 What was the CAGR of the 'Estimated Total Market Size in Units'? 100 101 102 102 What was the CAGR of the 'Direct Channel: Market Size' in Units? ' 103 104 105 What was the CAGR of the competitor's 'Total Revenues'? 106 107 108 What was the CAGR of the competitor's 'Direct Channel:Price'? 109 0% 0% % 0% 0% 0% 0 0% 0% 0% 0% 0% 110 111 What was the CAGR of the company's 'Total EBIT'? 112 113 114 Did either company earn the majority of EBIT in Direct Channel? 115 116 117 What was the impact of the competitors aggressive pricing strategy? 118 A B C D E F G H I 2017-2020 CAGR 2017 2018 2019 2020 2021E 600 660 726 799 10% 998 10% 10% 10% 25% 33% 40% 48% 58% 20% 45% 200 264 348 460 32% 449 400 396 378 339 -5% 549 2017 Company 2018 2019 40% 30% 2020 CAGR 2021E 50% 20% 20% 70% 75% 80% 85% 80% 100 106 105 92 90 280 297 302 288 -64% 732% 716% 439 380 403 407 380 529 2017 2018 2019 2020 CAGR 2021E 200 200 200 200 0% 200 125 125 125 125 0% 150 54 55 Industry Unit Model 56 Estimated Total Market Size in Units 57 Growth Rate 58 Estimated Percent Direct 59 Direct Market Size in Units 60 Retail Market Size in Units 61 62 63 Company Unit Models 64 Estimated Direct Market Share 65 Estimated Retail Market Share 66 Direct Units Sold 67 Retail Units Sold 68 Total Units Sold 69 70 Revenues Model 71 Price to Direct 72 Price to Retailers 73 Direct Revenues 74 Retail Revenues 75 Total Revenues 76 77 78 Gross Profit Model 79 Unit Cost 80 Direct Cost of Revenues 81 Retail Cost of Revenues 82 Direct Gross Profit 83 Retail Gross Profit 84 Total Gross Profit 85 86 Operating Profit Model 87 Direct SG&A Percent 88 Retail SG&A Percent 89 Direct SG&A 90 Retail SG&A 91 Direct EBIT 92 Retail EBIT 93 Total EBIT 20,909 -3% 8 20,000 35,000 55,000 21,120 37,125 58,245 37,752 58,661 18,400 35,977 54,377 1% 0% 17,969 65,885 83,853 2017 2018 2019 2020 CAGR 2021E 100 100 100 100 0% 100 10,000 10,560 10,454 -3% 8,984 28,000 30,202 43,923 9,200 28,782 9,200 7,195 10,000 10,454 29,700 10,560 7,425 17,985 8,984 1% -3% 1% -1% 7,550 21,962 7,000 17,000 18,005 16,395 30,946 2017 2018 2019 2020 CAGR 2021E 10% 10% 10% 10% 8% 5% 5% 5% 5% 5% 2,000 2,112 2,091 1,840 -3% 1,437 1,856 1% 1,750 8,000 1,888 8,364 3,294 7,547 8,448 5,569 1,799 7,360 5,397 12,756 -3% 1% 5,250 18,667 5,663 14,026 13,250 14,017 -1% 26,214Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started