Comparables Analysis Below is data on 6 different companies: American Airlines AAL Archer Daniels Midland Boeing BA CVS CVS Electronic Arts Ralph Lauren EA RL ADM Revenues 2015 67,702 7,405 Revenues 2016 40,990 40,180 42,622 44,541 4,396 4,845 5,150 6,653 6,182 Revenues 2017 Revenues 2018 153,290 177,526 184,786 194,579 163,041 62,346 60,828 64,341 60,160 96,114 93,496 94,005 101,127 81,490 3,269 6,313 Cost of Revenues 2018 2,427 4,950 1,322 1,433 1,199 R&D 2018 SG&A 2018 2,336 4,381 27,517 3,324 41,885 2,656 EBIT 2018 1,845 996 562 Pretax Income 2018 1,884 2,060 11,987 11,604 1,144 583 1,079 60 Taxes 2018 472 4,021 1,406 2,002 (596) 2,088 245 152 Net Income 2018 1,412 1,815 1,019 431 10,460 4,101 Dividends Declared 2018 186 758 202 Use the data above to calculate the Income Statement ratios below. American Archer Daniels Airlines Midland Boeing CVS Electronic Arts Ralph Lauren Revenue Growth, 2018 Revenue CAGR, 2015-2018 Use the data above to calculate the Income Statement ratios below for 2018. Insert the correct formula for Company 1 (column D) and calculate the answer. Hint: You may copy formulas from Company 1 (column D) to Company 2-6 (columns E-1) American Airlines Archer Daniels Midland Boeing CVS Electronic Arts Ralph Lauren Gross Margin R&D Percent SGA& Percent EBIT (Operating) Margin Tax Rate Net Margin Payout Ratio Comparables Analysis Below is data on 6 different companies: American Airlines AAL Archer Daniels Midland Boeing BA CVS CVS Electronic Arts Ralph Lauren EA RL ADM Revenues 2015 67,702 7,405 Revenues 2016 40,990 40,180 42,622 44,541 4,396 4,845 5,150 6,653 6,182 Revenues 2017 Revenues 2018 153,290 177,526 184,786 194,579 163,041 62,346 60,828 64,341 60,160 96,114 93,496 94,005 101,127 81,490 3,269 6,313 Cost of Revenues 2018 2,427 4,950 1,322 1,433 1,199 R&D 2018 SG&A 2018 2,336 4,381 27,517 3,324 41,885 2,656 EBIT 2018 1,845 996 562 Pretax Income 2018 1,884 2,060 11,987 11,604 1,144 583 1,079 60 Taxes 2018 472 4,021 1,406 2,002 (596) 2,088 245 152 Net Income 2018 1,412 1,815 1,019 431 10,460 4,101 Dividends Declared 2018 186 758 202 Use the data above to calculate the Income Statement ratios below. American Archer Daniels Airlines Midland Boeing CVS Electronic Arts Ralph Lauren Revenue Growth, 2018 Revenue CAGR, 2015-2018 Use the data above to calculate the Income Statement ratios below for 2018. Insert the correct formula for Company 1 (column D) and calculate the answer. Hint: You may copy formulas from Company 1 (column D) to Company 2-6 (columns E-1) American Airlines Archer Daniels Midland Boeing CVS Electronic Arts Ralph Lauren Gross Margin R&D Percent SGA& Percent EBIT (Operating) Margin Tax Rate Net Margin Payout Ratio