Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Excel Assignment Help Everything in the picture is true But I need help to know the formula to figure cell B22 B C D E

Excel Assignment Help

image text in transcribed

Everything in the picture is true

But I need help to know the formula to figure cell B22

B C D E 2019 2018 Growth ENTER 3 TICKERS BELOW $ 259,968 $ 265,809 -2.20% AAPL $ 162,264 $ 163,826 -0.95% FB $ 34,462 $ 30,941 11.38% GOOG 2019 2018 Growth $ 70,697 $ 55,838 26.61% $ 12,770 $ 9,355 36.50% $ 28,941 $ 21,570 34.17% A 1 Apple Inc. 2 Sales/Revenue 3 Cost of Goods Sold (COGS) incl. D&A 4 SG&A Expense 5 6 Facebook Inc. 7 Sales/Revenue 8 Cost of Goods Sold (COGS) ind. D&A 9 SG&A Expense 10 11 Alphabet Inc. 12 Sales/Revenue 13 Cost of Goods Sold (COGS) ind. D&A 14 SG&A Expense 15 16 17 Sales/Revenue 18 Cost of Goods Sold (COGS) incl. D&A 19 SG&A Expense 20 21 22 FB will beat Sales of AAPL in 2019 2018 Growth $ 161,402 $ 136,958 17.85% $ 71,896 $ 59,549 20.73% $ 54,033 $ 45,878 17.78% BEST 26.61% -0.95% 11.38% WORSE -2.20% 36.50% 34.17% NORMAL 14.09% 18.76% 21.11% 5.04 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

Global Banking

Authors: Roy C Smith, Ingo Walter, Gayle DeLong

3rd Edition

0195335937, 9780195335934

More Books

Students also viewed these Finance questions

Question

Briefly describe Bacons four Idols. How do the Idols apply today?

Answered: 1 week ago

Question

How does mandatory release affect the corrections system?

Answered: 1 week ago

Question

=+2. Are you happy to pay a price premium for CSR products?

Answered: 1 week ago