Please Anwer with Excel and with Formulas when needed thank you!

Zoom into the image if it is too blurry. I need the correct inputs for the yellow cells!

N CAGR 0% A B C D E F. G J K L M 47 48 What is a Direct Channel? 49 A Direct sales channel describes marketing and distribution directly to the potential buyers of products and services. 50 eCommerce firms selling Direct are often referred to as Direct-to-Consumer (DTC) as exemplified by AllBirds, Casper, Hubble Contacts and Warby Parker. 51 Indirect selling may include Distributors, Fulfillment and/or Retail sales. 52 A manufacturing could sell to a distributor which may then sell to the retailer (e.g., Walmart). 53 A manufacturer could sell to the retailer (e.g., Sears) which sells the product to the consumer 54 55 Enter formulas in the yellow cells to create a model. 56 57 Industry Unit Model 2018 2019 2020 2021 CAGR 58 Estimated Total Market Size in Units 640 15% 59 Growth Rate 15% 15% 15% 60 Estimated Percent Direct Channel 33% 40% 48% 58% 20% 61 Direct Channel: Market Size in Units 213 -100% 62 Retail Channel: Market Size in Units 0% 63 64 Company Sole Competitor 65 Company Unit Models 2018 2019 2020 2021 CAGR 2018 2019 2020 2021 66 Direct Channel: Market Share 50% 45% 40% 35% -11% 67 Retail Channel: Market Share 70% 75% 80% 85% 7% 68 Direct Channel: Units Sold 0% 69 Retail Channel: Units Sold 096 70 Total Units Sold 0% 71 0% 72 Revenues Model 2018 2019 2020 2021 CAGR 2018 2019 2020 2021 73 Direct Channel: Price 200 200 200 200 0% 190 180 170 160 Retail Channel: Price 125 125 125 125 0% 125 125 125 125 75 Direct Channel: Revenues 0% 76 Retail Channel: Revenues 0% 77 Total Revenues 0% 78 79 80 Gross Profit Model 2018 2019 2020 2021 CAGR 2018 2019 2020 2021 81 Unit Cost 100 100 100 100 0% 82 Direct Channel: Cost of Revenues 0% 83 Retail Chalinel: Cost of Revenues 0% 84 Direct Channel: Gross Profit 0% 85 Retail Channel: Gross Profit 0% 86 Total Gross Profit 0% 87 Total Gross Margin 88 0% 0% 0% 0% 0% CAGR -6% 0% 74 0% 0% 0% a CAGR 0% 0% 0% 0% 0 0% 0% H K M N CAGR CAGR G 2021 10% 5% 5 2018 10% 5% 2019 10% 5% 5 2020 10% 5% 2021 10% 5% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% A B C D E F 89 EBIT (Operating Profit) Model 2018 2019 2020 90 Direct Channel: SG&A Percent 10% 10% 10% 91 Retail Channel: SG&A Percent 5% 5% 5% 92 Direct Channel: SG&A 93 Retail Channel: SG&A 94 Direct Channel: EBIT 95 Retail Channel: EBIT : 96 Total EBIT 97 98 Use the model you have created to answer the following questions. 99 What was the CAGR of the 'Estimated Total Market Size in Units'? 100 101 102 What was the CAGR of the 'Direct Channel: Market Size' in Units? 103 104 105 What was the CAGR of the competitor's 'Total Revenues'? 106 107 108 What was the CAGR of the competitor's 'Direct Channel: Price'? 109 110 111 What was the CAGR of the company's 'Total EBIT'? 112 113 114 Did either company earn the majority of EBIT in Direct Channel? 115 116 117 What was the impact of the competitors aggressive pricing strategy? 118 119 120 N CAGR 0% A B C D E F. G J K L M 47 48 What is a Direct Channel? 49 A Direct sales channel describes marketing and distribution directly to the potential buyers of products and services. 50 eCommerce firms selling Direct are often referred to as Direct-to-Consumer (DTC) as exemplified by AllBirds, Casper, Hubble Contacts and Warby Parker. 51 Indirect selling may include Distributors, Fulfillment and/or Retail sales. 52 A manufacturing could sell to a distributor which may then sell to the retailer (e.g., Walmart). 53 A manufacturer could sell to the retailer (e.g., Sears) which sells the product to the consumer 54 55 Enter formulas in the yellow cells to create a model. 56 57 Industry Unit Model 2018 2019 2020 2021 CAGR 58 Estimated Total Market Size in Units 640 15% 59 Growth Rate 15% 15% 15% 60 Estimated Percent Direct Channel 33% 40% 48% 58% 20% 61 Direct Channel: Market Size in Units 213 -100% 62 Retail Channel: Market Size in Units 0% 63 64 Company Sole Competitor 65 Company Unit Models 2018 2019 2020 2021 CAGR 2018 2019 2020 2021 66 Direct Channel: Market Share 50% 45% 40% 35% -11% 67 Retail Channel: Market Share 70% 75% 80% 85% 7% 68 Direct Channel: Units Sold 0% 69 Retail Channel: Units Sold 096 70 Total Units Sold 0% 71 0% 72 Revenues Model 2018 2019 2020 2021 CAGR 2018 2019 2020 2021 73 Direct Channel: Price 200 200 200 200 0% 190 180 170 160 Retail Channel: Price 125 125 125 125 0% 125 125 125 125 75 Direct Channel: Revenues 0% 76 Retail Channel: Revenues 0% 77 Total Revenues 0% 78 79 80 Gross Profit Model 2018 2019 2020 2021 CAGR 2018 2019 2020 2021 81 Unit Cost 100 100 100 100 0% 82 Direct Channel: Cost of Revenues 0% 83 Retail Chalinel: Cost of Revenues 0% 84 Direct Channel: Gross Profit 0% 85 Retail Channel: Gross Profit 0% 86 Total Gross Profit 0% 87 Total Gross Margin 88 0% 0% 0% 0% 0% CAGR -6% 0% 74 0% 0% 0% a CAGR 0% 0% 0% 0% 0 0% 0% H K M N CAGR CAGR G 2021 10% 5% 5 2018 10% 5% 2019 10% 5% 5 2020 10% 5% 2021 10% 5% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% A B C D E F 89 EBIT (Operating Profit) Model 2018 2019 2020 90 Direct Channel: SG&A Percent 10% 10% 10% 91 Retail Channel: SG&A Percent 5% 5% 5% 92 Direct Channel: SG&A 93 Retail Channel: SG&A 94 Direct Channel: EBIT 95 Retail Channel: EBIT : 96 Total EBIT 97 98 Use the model you have created to answer the following questions. 99 What was the CAGR of the 'Estimated Total Market Size in Units'? 100 101 102 What was the CAGR of the 'Direct Channel: Market Size' in Units? 103 104 105 What was the CAGR of the competitor's 'Total Revenues'? 106 107 108 What was the CAGR of the competitor's 'Direct Channel: Price'? 109 110 111 What was the CAGR of the company's 'Total EBIT'? 112 113 114 Did either company earn the majority of EBIT in Direct Channel? 115 116 117 What was the impact of the competitors aggressive pricing strategy? 118 119 120