Please show the formula and answer for highlighted boxes in yellow.

A B C D G K We have calculated the change in the Average Automobile Age for two historic periods: \begin{tabular}{|c|c|} \hline CAGR & Average Automobile Age \\ \hline 20002015 & 1.67% \\ \hline 20082015 & 1.75% \\ \hline \end{tabular} 2017 is excluded because the data had not yet been reported. Enter formulas in column J that calculate the number of 'Replacement Automobile Sales' as the 'Pct of Trailing Year Replaced' multiplied by the number of 'Registered Automobiles' of the prior year. You can select between hypothesised CAGR of Average Automobile Age of zero or that since 2008 in cell L156. Total Automobile Sales Total Automobile Sales is the sum of Expansion Automobile Sales plus Replacement Automobile Sales. Analyzing alternative hypothesized scenarios Iteratively apply the model you have developed to calculate the Total Automobile Sales in 2030 for each of the following four scenarios. Hint: Change the selections in Row 156 \begin{tabular}{|l|r|r|r|} \hline 13 Year CAGR 2017-30E & \multicolumn{2}{c|}{ Average Automobile Age } \\ & & 0.00% & 1.75% \\ \hline Automobiles/ & 0.00% & & \\ \hline Household & 0.45% & & \\ \cline { 2 - 3 } & & & \\ \hline \end{tabular} A B C D G K We have calculated the change in the Average Automobile Age for two historic periods: \begin{tabular}{|c|c|} \hline CAGR & Average Automobile Age \\ \hline 20002015 & 1.67% \\ \hline 20082015 & 1.75% \\ \hline \end{tabular} 2017 is excluded because the data had not yet been reported. Enter formulas in column J that calculate the number of 'Replacement Automobile Sales' as the 'Pct of Trailing Year Replaced' multiplied by the number of 'Registered Automobiles' of the prior year. You can select between hypothesised CAGR of Average Automobile Age of zero or that since 2008 in cell L156. Total Automobile Sales Total Automobile Sales is the sum of Expansion Automobile Sales plus Replacement Automobile Sales. Analyzing alternative hypothesized scenarios Iteratively apply the model you have developed to calculate the Total Automobile Sales in 2030 for each of the following four scenarios. Hint: Change the selections in Row 156 \begin{tabular}{|l|r|r|r|} \hline 13 Year CAGR 2017-30E & \multicolumn{2}{c|}{ Average Automobile Age } \\ & & 0.00% & 1.75% \\ \hline Automobiles/ & 0.00% & & \\ \hline Household & 0.45% & & \\ \cline { 2 - 3 } & & & \\ \hline \end{tabular}