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
-
How many milliliters of 0.150 M H2SO4 (sulfuric acid) are required to react with 8.20 g of sodium hydrogen carbonate, NaHCO3, according to the following equation? H2SO4(aq) + 2NaHCO3(aq) Na2SO4(aq)...
-
Compute the cost of the following: a. A government bond that has a \($1,000\) par value (face value) and a contract or coupon interest rate of 8 percent. A new issue would have a flotation cost of 4...
-
The velocity spectrum below is due to EDM damage. There are multiple sidebands in the spectrum that are usually separated by what frequency? D+ 300 R$ Pask 151 100 10202011201 Line
-
The following refers to units processed in Sunflower Printings binding department in March. Prepare a physical flow reconciliation. Units of Percent of Product Conversion Added Beginning work in...
-
How modern managerial accounting practices help companies grow Companies can find new ways to grow through forward-looking managerial accounting approaches. Improving business performance and...
-
Complete the payroll register for this pay period and update the Employee Earnings Record form for each employee with the corresponding information. The Step-2 of Form W-4 is unchecked. The amount...
-
6) You are 25 years old and just had your first child. Congratulations. Assume you can earn 5% per year on your investments. You want to save $300,000 for your child by her 18th birthday. You want to...
-
Management accounting is a mid-way between financial accounting and cost accounting. Elucidate.
-
Name the accounting principle involved/violated/affected in the following: (i) The firm changes method of depreciation. (ii) The firm does not consider unused stationery as asset. (iii) The firm...
-
Explain the following: (a) Management accounting is an extension of financial accounting. (b) Management accounting assists in corporate planning process.
-
Name the 5 major areas in which different accounting policies can be adopted by business enterprises. What is the requirement of the relevant accounting standard in this regard?
-
How would you analyse the financial position of a company from the point of view of (a) an investor, (b) a creditor, and (c) a financial executive of the company?
-
In the figure provided, a 24.9 ramp in an airport has luggage sliding down to the owner. Suitcase A has a mass of 6.29 kg with a coefficient of friction of k = 0.220 and another suitcase B has a mass...
-
Revol Industries manufactures plastic bottles for the food industry. On average, Revol pays $76 per ton for its plastics. Revol's waste-disposal company has increased its waste-disposal charge to $57...
-
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?
-
What is a P-value for a hypothesis test?
-
You plan a survey to estimate the proportion of students on your campus who carry an iPad regularly. How many students should be in the sample if you want (with 95% confidence) a margin of error of...
-
What is a hypothesis test?
Study smarter with the SolutionInn App