\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline 55 & \multirow{2}{*}{\multicolumn{12}{|c|}{ Enter formulas in the yellow cells to create a model. }} \\ \hline 55 & & & & & & & & & & & & \\ \hline 57 & & 2019 & & & & & & & & & \\ \hline 53 & & & 2019 & 2020 & 2021 & 2022 & ans & & & & & \\ \hline 59 & & 620 & 530 & 630 & ms & 15x & & & & & \\ \hline 60 & & 3x & & 15k & 1st & & & it & , & & \\ \hline 61 & & & 335 & & 4n & sen & 20N & & & & & \\ \hline 62 & \multicolumn{2}{|l|}{ Metiot Cannet Market Sue h Unsi } & & & & & as & & & & & \\ \hline 63 & & & & & & & os & & & & 7 & \\ \hline 64 & & & & & & & tis & & & & & \\ \hline 65 & Company Unit Modet & & & & Company & & & & Sol & lompeti & & \\ \hline 66 & Orect Oumet Maties Share & & \begin{tabular}{ll} 2019 \\ 5003 \end{tabular} & 2020 & 2021 & 2002 & CAGA & 2019 & 2020 & 2sen & & cach \\ \hline 6 & \multirow{2}{*}{ Retal Oranset Martet Share } & & son & 45x & 405 & 35x & -115 & & & & & \\ \hline 68 & & & & 75x & sos & ass & N & & & & & ox \\ \hline 69 & Dinct Cumel Unats sold & & & & & & os & & & & & \\ \hline 70 & Retal Chanel Unts sold & & & & & & os & & & & & os \\ \hline 71 & Total Lnes Sold & at & & & & & os & & & & & \\ \hline 72 & & & & & & & os & & & & & os \\ \hline7322 & Nevenues Mode! & & 2019 & 2020 & 2021 & 20n & cuas & 2019 & 2000 & 2021 & 20n & cuan \\ \hline & Drect Chamnet Price & Exting & 200 & 200 & 200 & 200 & os & 190 & .100 & 10 & 160 & ax \\ \hline 74 & Nesal Channet Price & & 125 & 125 & 125 & 125 & on & 125 & 125 & 125 & 128 & on \\ \hline 75 & Drect Oannel Mevehuts & & & & & & os & & & & & \\ \hline 76 & Artaichannet Revenuts & & & & & & ov & & & Z & & \\ \hline 7 & Total Eevenuei : & & & & & & ox & & & & & \\ \hline 73 & & 23 & & & & & & & & & & \\ \hline 79 & p7= & & & & & & & 3 & & & & \\ \hline 8 & Gross How mosel & & 2019 & 2020 & seni & 2002 & cact & 2019 & 2020 & 2021 & 2002 & ach \\ \hline 8 & Untont & & 100 & 100 & 7.100 & 100 & os & & & +1 & & on \\ \hline 2 & \multicolumn{2}{|l|}{ Dreat Chamel Cout ef Revenues } & & & & & os & - & & & & ar \\ \hline 83 & \multicolumn{2}{|l|}{ Rutal Oramel Cost a Rerenus } & & & & & os & & & & & on \\ \hline en & & (. & & & & & os & & & & & os \\ \hline is & & & & & & & , ox & & + & & & on \\ \hline 86 & Toul Grui Prota & = & & & & & os & & & & & ox \\ \hline 87 & Total Coni Maren & & & & & & & & & z & & \\ \hline 8 & 1 & & 7 & & & & & & & & & \\ \hline 89 & cerr (Operatine Frofin) Model & & 2019 & 2000 & 203 & & cica & 2019 & 2020 & 2021 & & anan \\ \hline 90 & Ored Oumet sasa fercant & & 10s & 100 & 100 & 10s & & ion & 100 & 100 & 100 & \\ \hline 91 & Metail Gannet SOSA Percent & & 5N & 35 & 3x & 5s & & ss & 5s & is & 5x & \\ \hline 92 & Orent Charnet SGsA & is & & & & & of & & & & & \\ \hline 93 & Eetai Channet sosa & & & & & & os & & & & & a \\ \hline 94 & Dest Chamet tai :. & & & & & & os & & & & & \\ \hline 95 & Mrat Chamel EerT & & & & & & os & & & & & \\ \hline 96 & Poticar & & & & & & os & & & & & an \\ \hline \end{tabular} Jse the model you have created to answer the following questions. What was the CAGR of the 'Estimated Total Market Size in Units'? What was the CAGR of the 'Direct Channel: Market Size' in Units? What was the CAGR of the competitor's 'Total Revenues'? What was the CAGR of the competitor's 'Direct Channel: Price'? What was the CAGR of the company's Total EBIT'? Did either company eam the majority of EBIT in Direct Channel
