Excel Assignment Help

In how many years will "M" and "KSS" have the same Sales? (Assume that the previous 5-year Sales trend continues)

(example: 1.23 or "This is not possible")?

I need the formula to write in cell B16

asenn B 2020 19,974 $ 13,057.00 $ 5,705.00 $ 2019 20,229 $ 13,163 $ 5,601 $ D 2018 20,084 $ 13,167 $ 5,501 $ E 2017 18,686 $ 12,882 $ 4,435 $ F 2016 19,204 13,199 4,452 G Growth 0.99% -0.27% 6.40% 2020 A 1 KSS 2 Sales/Revenue 3 Cost of Goods Sold (COGS) incl. D&A 4 SG&A Expense 5 6 M 7 Sales/Revenue 8 Cost of Goods Sold (COGS) incl. D&A 9 SG&A Expense 10 11 JWN 12 Sales/Revenue 13 Cost of Goods Sold (COGS) incl. D&A 14 SG&A Expense 15 16 Mand KSS will have the same sales in $ $ S 25,331 $ 16,152 $ 7,897 $ 2019 25,739 $ 16,177 $ 7,947 $ 2018 25,641 $ 16,172 S 7,819 $ 2017 25,778 $ 16,679 $ 7,271 $ 2016 Growth 27,079 -1.65% 17,557 -2.06% 7,195 2.35% $ $ $ 2020 15,524 $ 9,932 $ 4,776 $ 2019 15,860 $ 10,155 $ 4,796 $ 2018 15,478 $ 9,890 $ 4,678 $ 2017 14,757 $ 9,440 $ 4,327 $ 2016 Growth 14,437 1.83% 9,168 2.02% 4,120 3.76% years 17