Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I have completed industry and company model units can you check if thats correct and help with the remaining models Enter formulas in the yellow

I have completed industry and company model units can you check if thats correct and help with the remaining models

image text in transcribed
Enter formulas in the yellow cells to create a model. Industry Unit Model 2016 2017 2018 2019 CAGR Estimated Total Market Size in Units 650 748 860 989 15% Growth Rate 15% 15% 15% Estimated Percent Direct 339 10% 18% 58% 20% Direct Market Size in Units 217 299 413 569 Retail Market Size in Units 433 449 447 419 Company Competitor Company Unit Models 2016 2017 2018 2019 CAGR 2016 2017 2018 2019 CAGR Estimated Direct Market Share 50% 45%% 40% 35% 11% 50% 55% 50% 65% 9% Estimated Retail Market Share 70% 75% 80% 35% 7% 30% 25% 20% 15% -21% Direct Units Sold 108 135 165 199 23% 108 164 248 370 51% Retail Units Sold 303 336 358 6% 130 L12 89 53 -22% Total Units Sold 412 471 523 556 11% 238 277 337 433 22% 0% 0% Revenues Model 2016 2017 2018 2019 CAGR 2016 2017 2018 2019 CAGR Price to Direct 200 200 200 200 190 180 170 160 6% Price to Retailers 125 125 125 125 0% 125 125 125 125 0% Direct Revenues 0% 0% Retail Revenues 0% 0% Total Revenues 0% 0% Gross Profit Model 2016 2017 2018 2019 CAGR 2016 2017 2018 2019 CAGR Unit Cost 100 100 100 100 0% 0% Direct Cost of Revenues 0% 0% Retail Cost of Revenues 0% Direct Gross Profit 0% 0% Retail Gross Profit 0% 0% Total Gross Profit 0% 0% EBIT (Operating Profit) Model 2016 2017 2018 2019 CAGR 2016 2017 2018 2019 CAGR Direct SG&A Percent 10% 10% 10% 10% 10% 10% 10% 10% Retail SG&A Percent 5% 5% 5% 5% 5% 5% 5% 5% Direct SG&A 0% 0% Retail SG&A 0% 0% Direct EBIT 0% 0% Retail EBIT 0% 0% Total EBIT 0% 0%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Elements Of Chemical Reaction Engineering

Authors: H. Fogler

6th Edition

013548622X, 978-0135486221

Students also viewed these Finance questions