48 In the two grey boxes below we demonstrate how the hypothesized scenario can be entered...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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% 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%
Expert Answer:
Answer rating: 100% (QA)
Company unit model 2016 2017 2018 2019 CAGR 2020E estimated direct market share 50 40 30 20 10 10 e... View the full answer
Related Book For
Physics
ISBN: 978-0077339685
2nd edition
Authors: Alan Giambattista, Betty Richardson, Robert Richardson
Posted Date:
Students also viewed these mathematics questions
-
10 20 30 40 50 60 70 Mancom 10 20 30 40 50 60 70 Macom B Ages of group of patients: The youngest participant has: Type of the graph: Ages of group of patients: The oldest participant has: Y/O Y/O ...
-
1) Perform the time trend analysis for each ratio for these two companies over three years What kind of information can be obtained based on the trend analysis? (2) Perform the peer group analysis to...
-
Trans Jamaica Corporation wishes to invest in one of three transport infrastructure projects X, Y and Z with initial outlays of $500 million, $390 million and $650 million respectively. Projects are...
-
Reference groups influence us in three ways. These influences include informational, utilitarian, and dimensions. a. knowledge O b. O c. reputational O d. descriptive value-expressive
-
Cambro Construction Company hires union carpenters for home building. Cambro requires, as a condition of employment, that the carpenters provide and maintain various tools of their trade. Cambro pays...
-
Evaluate the iterated integral by converting to polar coordinates. 10 Jo | 4y-y2 x dx dy
-
\(\frac{44}{75} \div \frac{484}{285}\) Perform the indicated operations. Reduce to lowest terms.
-
On January 1, 2008, Crocker Company issued 10-year, $2,000,000 face value, 6% bonds, at par. Each $1,000 bond is convertible into 15 shares of Crocker common stock . Crockers net income in 2008 was...
-
You are the Chief Financial Officer at Infosys Ltd., which is considering the following two mutually exclusive projects. All amounts are in Indian Rupees. Year 70 1234 Cashflow (Project A) -50,00,000...
-
New Endor Airlines Database New Endor Airlines (NEA) is the premier aviation service in the small island nation of New Endor, located in the southwestern Pacific Ocean. For the 40 years since its...
-
. traversal: An examination of each element of an array. . #1-#10: What element values are stored in the following array? int a = {1, 7, 5, 12, 4, 14}; for (int i = 0; i < a. length - 1; it+) { if ...
-
What ethical considerations should be taken into account when leveraging consumer data for targeted advertising campaigns?
-
How can an organization leverage social media analytics to enhance its marketing campaigns and customer engagement ?
-
2. A football field measures 120.0 yards by 160.0 feet including end zones. Calculate the area in square meters. (Given: 1 yd-3 3. An oxygen molecule travels 975 miles per hour at room temperature....
-
Lemon company purchased 120 units for $40 each on January 31. It purchased 170 units for $35 each on February 28. It sold 170 units for $50 each from March 1 through December 31. If the company uses...
-
Calculate how many Calories would be found in a breakfastconsisting of: two eggs two pieces of toast buttered with one tablespoon of butter one 4 oz glass of orange juice. Express your answer to one...
-
The Blank______ is usually the best measure of the value received and, therefore, reflects the value of the acquirer's interest in the acquiree. Multiple choice question. fair value of assets...
-
When a company has a contract involving multiple performance obligations, how must the company recognize revenue?
-
Which of the fundamental forces has the shortest range, yet is responsible for producing the sunlight that reaches Earth?
-
Repeat Problem 20 for an organ pipe that is open at both ends. (a) What should be the length of an organ pipe, closed at one end, if the fundamental frequency is to be 261.5 Hz? (b) What is the...
-
When a car begins to move forward, what force makes it do so? Remember that it has to be an external force; the internal forces all add to zero. How does the engine facilitate the propelling force?
-
Show that the decomposition (10.37) of the nonlinear term is correct. Use direct substitution of (10.36) into the expression for one component of vector \(N\).
-
For the flow in Problem 7, write the boundary conditions for pressure when the flow is incompressible and inviscid and there is no body force.
-
If your course involves exercises with a CFD code, study the manual to determine which of the projection schemes discussed in Section 10.4 (SIMPLE, SIMPLEC, SIMPLER, PISO) are implemented. Are there...
Study smarter with the SolutionInn App