yellow celis to create a model. ndustry Unit Model 2019 2018 2020 2021 CAGR Estimated Total Market Size in Units 640 736 15% Growth Rate 15% 15% 15% Estimated Percent Direct Channel 33% 40% 48% 58% 20% Direct Channel: Market Size in Units 0% Retail Channel: Market Size in Units 0% Company Sole Competitor ompany Unit Models 2020 2018 2019 2020 2021 CAGR 2018 2019 2021 CAGR Direct Channel: Market Share 50% 45% 40% 35% -11% 0% Retail Channel: Market Share 70% 75% 80% 85% 7% 0% Direct Channel: Units Sold 0% 0% Retail Channel: Units Sold 0% 0% Total Units Sold 0% 0% 0% 0% evenues Model 2018 2019 2020 2021 CAGR 2018 2019 2020 2021 CAGR Direct Channel: Price 200 200 200 200 0% 190 180 170 160 -6% Retail Channel: Price 125 125 125 125 0% 125 125 125 125 0% Direct Channel: Revenues 0% 0% Retail Channel: Revenues 0% 0% Total Revenues 0% 0% ross Profit Model 2018 2019 2020 2021 CAGR 2018 2019 2020 2021 CAGR Unit Cost 100 100 100 100 0% 0% Direct Channel: Cost of Revenues 0% 0% Retail Channel: Cost of Revenues 0% 0% Direct Channel: Gross Profit 0% 0% Retail Channel: Gross Profit 0% 0% Total Gross Profit 0% 0% Total Gross Margin BIT (Operating Profit) Model 2018 2019 2020 2021 CAGR 2018 2019 2020 2021 CAGR Direct Channel: SG&A Percent 10% 10% 10% 10% 10% 10% 10% 10% Retail Channel: SG&A Percent 5% 5% 5% 5% 5% 5% 5% 5% Direct Channel: SG&A 0% 0% Retail Channel: SG&A 0% 0% Direct Channel: EBIT 0% 0% Retail Channel: EBIT 0% 0% Total EBIT 0% 0%
yellow celis to create a model. ndustry Unit Model 2019 2018 2020 2021 CAGR Estimated Total Market Size in Units 640 736 15% Growth Rate 15% 15% 15% Estimated Percent Direct Channel 33% 40% 48% 58% 20% Direct Channel: Market Size in Units 0% Retail Channel: Market Size in Units 0% Company Sole Competitor ompany Unit Models 2020 2018 2019 2020 2021 CAGR 2018 2019 2021 CAGR Direct Channel: Market Share 50% 45% 40% 35% -11% 0% Retail Channel: Market Share 70% 75% 80% 85% 7% 0% Direct Channel: Units Sold 0% 0% Retail Channel: Units Sold 0% 0% Total Units Sold 0% 0% 0% 0% evenues Model 2018 2019 2020 2021 CAGR 2018 2019 2020 2021 CAGR Direct Channel: Price 200 200 200 200 0% 190 180 170 160 -6% Retail Channel: Price 125 125 125 125 0% 125 125 125 125 0% Direct Channel: Revenues 0% 0% Retail Channel: Revenues 0% 0% Total Revenues 0% 0% ross Profit Model 2018 2019 2020 2021 CAGR 2018 2019 2020 2021 CAGR Unit Cost 100 100 100 100 0% 0% Direct Channel: Cost of Revenues 0% 0% Retail Channel: Cost of Revenues 0% 0% Direct Channel: Gross Profit 0% 0% Retail Channel: Gross Profit 0% 0% Total Gross Profit 0% 0% Total Gross Margin BIT (Operating Profit) Model 2018 2019 2020 2021 CAGR 2018 2019 2020 2021 CAGR Direct Channel: SG&A Percent 10% 10% 10% 10% 10% 10% 10% 10% Retail Channel: SG&A Percent 5% 5% 5% 5% 5% 5% 5% 5% Direct Channel: SG&A 0% 0% Retail Channel: SG&A 0% 0% Direct Channel: EBIT 0% 0% Retail Channel: EBIT 0% 0% Total EBIT 0% 0%
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Transcribed Image Text:Enter formulas in the yellow cells to create a model.
Industry Unit Model
2018
2019
2020
2021
CAGR
Estimated Total Market Size in Units
640
736
15%
Growth Rate
15%
15%
15%
Estimated Percent Direct Channel
33%
40%
48%
58%
20%
Direct Channel: Market Size in Units
0%
Retail Channel: Market Size in Units
0%
Company
Sole Competitor
Company Unit Models
2018
2019
2020
2021
CAGR
2018
2019
2020
2021
CAGR
Direct Channel: Market Share
50%
45%
40%
35%
-11%
0%
Retail Channel: Market Share
70%
75%
80%
85%
7%
0%
Direct Channel: Units Sold
0%
0%
Retail Channel: Units Sold
0%
0%
Total Units Sold
0%
0%
0%
0%
Revenues Model
2018
2019
2020
2021
CAGR
2018
2019
2020
2021
CAGR
Direct Channel: Price
200
200
200
200
0%
190
180
170
160
-6%
Retail Channel: Price
125
125
125
125
0%
125
125
125
125
0%
Direct Channel: Revenues
0%
0%
Retail Channel: Revenues
0%
0%
Total Revenues
0%
0%
Gross Profit Model
2018
2019
2020
2021
CAGR
2018
2019
2020
2021
CAGR
Unit Cost
100
100
100
100
0%
0%
Direct Channel: Cost of Revenues
0%
0%
Retail Channel: Cost of Revenues
0%
0%
Direct Channel: Gross Profit
0%
0%
Retail Channel: Gross Profit
0%
0%
Total Gross Profit
0%
0%
Total Gross Margin
n
EBIT (Operating Profit) Model
2018
2019
2020
2021
CAĞR
2018
2019
2020
2021
CAGR
Direct Channel: SG&A Percet
10%
10%
10%
10%
10%
10%
10%
10%
Retail Channel: SG&A Percent
5%
5%
5%
5%
5%
5%
5%
5%
Direct Channel: SG&A
0%
0%
Retail Channel: SG&A
0%
0%
Direct Channel: EBIT
0%
0%
Retail Channel: EBIT
0%
0%
Total EBIT
0%
0%
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education