Question: Enter formulas in the yellow cells to create a model. 2019 2020 2021 2018 640 CAGR 15% 736 15% Industry Unit Model Estimated Total Market

 Enter formulas in the yellow cells to create a model. 2019

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!