Question: Excel Assignment Help 1) In how many years will JWN be twice as big as KSS, in terms of Sales? (Assume that the previous 5-year
Excel Assignment Help

1) In how many years will "JWN" be "twice as big" as "KSS", in terms of Sales? (Assume that the previous 5-year Sales trend continues) (example: 12.34 or "This is not possible")?
I need the formula to write in cell B16
2) In how many years will "JWN" be bigger than "KSS" and "M" combined, in terms of Sales? (Assume that the previous 5-year Sales trend continues) (example: 12.34 or "This is not possible")?
please I need the formula to write in excel for both questions
$ $ $ 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 Growth 0.99% -0.27% 6.40% . 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 JWN will be twice as big as KSS in 17 $ $ $ 2020 25,331 $ 16,152 $ 7,897 $ 2019 25,739 $ 16,177 $ 7,947 $ 2018 25,641 $ 16,172 $ 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
