Enter formulas as follows to complete the table of projections in the range C6:110:
In cell C7, create a formula without using a function that multiplies the sales projection for the first year (cell C6) by the first growth rate (cell C5), and adds the sales projection for the first year (cell C6 to the result to determine the first estimate for 2022.