Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Real Estate Finance Theory And Practice

Authors: Terrence M. Clauretie, G. Stacy Sirmans

4th Edition

032414377X, 978-0324143775

More Books

Students also viewed these Finance questions

Question

=+4. What might explain any differences that you identify?

Answered: 1 week ago

Question

=+2. Is there a strong collective bargaining culture in evidence?

Answered: 1 week ago