Question: Excel Assignment In how many years will JWN be bigger than KSS and M combined, in terms of Sales? (Assume that the previous 5-year Sales

Excel Assignment

Excel Assignment In how many years will "JWN" be bigger than "KSS"

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")?

I need the formula to write in cell B16

D F $ $ $ B 2020 19,974 $ 13,057.00 $ 5,705.00 $ 2019 20,229 $ 13,163 $ 5,601 $ 2018 20,084 $ 13,167 $ 5,501 $ E 2017 18,686 $ 12,882 $ 4,435 $ 2016 19,204 13,199 4,452 G Growth 0.99% -0.27% 6.40% $ 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 JWN" be bigger than "KSS" and "M" 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!