Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

48 In the two grey boxes below we demonstrate how the hypothesized scenario can be entered into the model. In 157 we have already

  

48 In the two grey boxes below we demonstrate how the hypothesized scenario can be entered into the model. In 157 we have already entered the hypothesized 'Growth Rate'. In 156 the formula '=$G56* (1+157)' applies the hypothesized 'Growth Rate' to the 'Estimated Total Market Size in Units' for 2019. In 158 we have already entered the hypothesized 'Estimated Percent Direct'. In 159 the formula '=156*158' applies the hypothesized 'Estimated Percent Direct' to the 'Estimated Total Market Size 49 50 51 52 Units'. 53 Enter values or formulas in the yellow cells below to develop the forecast. 54 2016-2019 55 Industry Unit Model 2016 2017 2018 2019 CAGR 2020E 56 Estimated Total Market Size in Units 600 660 726 799 10% 998 57 Growth Rate 10% 10% 10% 25% 58 Estimated Percent Direct 33% 40% 48% 58% 20% 45% 59 Direct Market Size in Units 200 264 348 460 32% 449 60 Retail Market Size in Units 400 396 378 339 -5% 549 61 62 Company 63 Company Unit Models 2016 2017 2018 2019 CAGR 2020E 64 Estimated Direct Market Share 50% 40% 30% 20% 65 Estimated Retail Market Share 70% 75% 80% 85% 66 Direct Units Sold 100 106 105 92 -64% 67 Retail Units Sold 280 297 302 288 732% 68 Total Units Sold 380 403 407 380 716% 69 70 Revenues Model 2016 2017 2018 2019 CAGR 2020E 71 Price to Direct 200 200 200 200 0% 72 Price to Retailers 125 125 125 125 0% 73 Direct Revenues 20,000 21,120 20,909 18,400 -3% 74 Retail Revenues 35,000 37,125 37,752 35,977 1% 75 Total Revenues 55,000 58,245 58,661 54,377 0% 76 77 78 Gross Profit Model 2016 2017 2018 2019 CAGR 2020E 79 Unit Cost 100 100 100 100 0% 80 Direct Cost of Revenues 10,000 10,560 10,454 9,200 -3% Company Unit Models 2016 2017 2018 2019 CAGR 2020E Estimated Direct Market Share 50% 40% 30% 20% Estimated Retail Market Share 70% 75% 80% 85% Direct Units Sold 100 106 105 92 -64% Retail Units Sold 280 297 302 288 732% Total Units Sold 380 403 407 380 716% Revenues Model 2016 2017 2018 2019 CAGR 2020E Price to Direct 200 200 200 200 0% Price to Retailers 125 125 125 125 0% Direct Revenues 20,000 21,120 20,909 18,400 -3% Retail Revenues 35,000 37,125 37,752 35,977 1% Total Revenues 55,000 58,245 58,661 54,377 0% Gross Profit Model 2016 2017 2018 2019 CAGR 2020E Unit Cost 100 100 100 100 0% Direct Cost of Revenues 10,000 10,560 10,454 9,200 -3% Retail Cost of Revenues 28,000 29,700 30,202 28,782 1% Direct Gross Profit 10,000 10,560 10,454 9,200 -3% Retail Gross Profit 7,000 7,425 7,550 7,195 1% Total Gross Profit 17,000 17,985 18,005 16,395 -1% Operating Profit Model 2016 2017 2018 2019 CAGR 2020E Direct SG&A Percent 10% 10% 10% 10% Retail SG&A Percent 5% 5% 5% 5% Direct SG&A 2,000 2,112 2,091 1,840 -3% Retail SG&A 1,750 1,856 1,888 1,799 1% Direct EBIT 8,000 8,448 8,364 7,360 -3% Retail EBIT 5,250 5,569 5,663 5,397 1% Total EBIT 13,250 14,017 14,026 12,756 -1%

Step by Step Solution

3.44 Rating (160 Votes )

There are 3 Steps involved in it

Step: 1

Company unit model 2016 2017 2018 2019 CAGR 2020E estimated direct market share 50 40 30 20 10 10 e... 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

Document Format ( 1 attachment)

Excel file Icon
6267b862a6b9a_Book3333.xlsx

300 KBs Excel File

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

Physics

Authors: Alan Giambattista, Betty Richardson, Robert Richardson

2nd edition

77339681, 978-0077339685

More Books

Students also viewed these Mathematics questions

Question

What is the stage-gate or phase-review model? What are the stages?

Answered: 1 week ago