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

Excel Assignment Help 1) In how many years will "JWN" be "twice

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!