Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2017 2018 2019 CAGR 15% 15% 15% 15% 58% 20% Competitor 2017 2018 CAGR 2016 2019 Company 2017 2018 45% 40% 75% 80% 2019 35%

image text in transcribed

2017 2018 2019 CAGR 15% 15% 15% 15% 58% 20% Competitor 2017 2018 CAGR 2016 2019 Company 2017 2018 45% 40% 75% 80% 2019 35% 85% CAGR 0% -11% 7% 0% 0% 0% 0% 0% 0% 2017 200 125 2018 200 125 2019 200 125 0% 0% CAGR 0% 0% 2016 190 125 2017 180 125 2018 170 125 2019 160 125 0% CAGR -6% 0% 53 Enter formulas in the yellow cells to create a model. 54 55 Industry Unit Model 2016 56 Estimated Total Market Size in Units 630 57 Growth Rate 58 Estimated Percent Direct 33% 59 Direct Market Size in Units 60 Retail Market Size in Units 61 62 63 Company Unit Models 2016 64 Estimated Direct Market Share 50% 65 Estimated Retail Market Share 70% 66 Direct Units Sold 67 Retail Units Sold 68 Total Units Sold 69 70 Revenues Model 2016 71 Price to Direct 200 72 Price to Retailers 125 73 Direct Revenues 74 Retail Revenues 75 Total Revenues 76 77 78 Gross Profit Model 2016 79 Unit Cost 100 80 Direct Cost of Revenues 81 Retail Cost of Revenues 82 Direct Gross Profit 83 Retail Gross Profit 84 Total Gross Profit 85 86 EBIT (Operating Profit) Model 2016 87 Direct SG&A Percent 10% 88 Retail SG&A Percent 5% 89 Direct SG&A 90 Retail SG&A 91 Direct EBIT 92 Retail EBIT 93 Total EBIT 0% 0% 0% 0% 0% 0% 2019 2016 2017 2018 2019 2017 100 2018 100 CAGR 0% CAGR 0% 100 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% CAGR CAGR 2017 10% 5% 2018 10% 5% 2019 10% 5% 2016 10% 5% 2017 10% 5% 2018 10% 2019 10% 5% 5% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 2017 2018 2019 CAGR 15% 15% 15% 15% 58% 20% Competitor 2017 2018 CAGR 2016 2019 Company 2017 2018 45% 40% 75% 80% 2019 35% 85% CAGR 0% -11% 7% 0% 0% 0% 0% 0% 0% 2017 200 125 2018 200 125 2019 200 125 0% 0% CAGR 0% 0% 2016 190 125 2017 180 125 2018 170 125 2019 160 125 0% CAGR -6% 0% 53 Enter formulas in the yellow cells to create a model. 54 55 Industry Unit Model 2016 56 Estimated Total Market Size in Units 630 57 Growth Rate 58 Estimated Percent Direct 33% 59 Direct Market Size in Units 60 Retail Market Size in Units 61 62 63 Company Unit Models 2016 64 Estimated Direct Market Share 50% 65 Estimated Retail Market Share 70% 66 Direct Units Sold 67 Retail Units Sold 68 Total Units Sold 69 70 Revenues Model 2016 71 Price to Direct 200 72 Price to Retailers 125 73 Direct Revenues 74 Retail Revenues 75 Total Revenues 76 77 78 Gross Profit Model 2016 79 Unit Cost 100 80 Direct Cost of Revenues 81 Retail Cost of Revenues 82 Direct Gross Profit 83 Retail Gross Profit 84 Total Gross Profit 85 86 EBIT (Operating Profit) Model 2016 87 Direct SG&A Percent 10% 88 Retail SG&A Percent 5% 89 Direct SG&A 90 Retail SG&A 91 Direct EBIT 92 Retail EBIT 93 Total EBIT 0% 0% 0% 0% 0% 0% 2019 2016 2017 2018 2019 2017 100 2018 100 CAGR 0% CAGR 0% 100 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% CAGR CAGR 2017 10% 5% 2018 10% 5% 2019 10% 5% 2016 10% 5% 2017 10% 5% 2018 10% 2019 10% 5% 5% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Focus On Personal Finance An Active Approach To Help You Develop Successful Financial Skills

Authors: Jack Kapoor, Les Dlabay, Robert Hughes

4th Edition

0078034787, 978-0078034787

More Books

Students also viewed these Finance questions

Question

2. Darwins notes in biology.

Answered: 1 week ago

Question

Explain the global implications for recruitment.

Answered: 1 week ago

Question

Describe what competencies and competency modeling are.

Answered: 1 week ago

Question

Summarize job design concepts.

Answered: 1 week ago