For each competitor company compute the following 9 ratios for the most recent year (2018) for each company. The balance sheet from 2 years ago will be needed to compute average total assets and average stockholders' equity. Round your answers to 2 decimal places. For percentages, show the percentage carried to 2 decimal places. Ex: 1286 = 12.86% Evaluating the ability to pay current liabilities 1. Working capital 2. Current ratio 3. Quick ratio (Acid-test ratio) Evaluating the ability to pay long term debt 4. Debt ratio 5. Number of times interest charges earned Evaluating profitability (Show results as a percentage) 6. Profit margin percentage 7. Return on assets 8. Return on equity (there are no preferred dividends; compute average stockholders' equity the same way you computed average total assets: Beginning Total Equity + Ending Total Equity = Subtotal/2) Evaluating stock as an investment 9. Price-Earnings (P/E) ratio (use basic earnings per share found on the bottom of the income statement) Consolidated Statement of Income PepsiCo, Inc. and Subsidiaries Fiscal years ended December 29, 2018, December 30, 2017 and December 31, 2016 (in millions except per share amounts) 2018 2017 2016 64,661 S63.525 $ 62,799 29,381 28,796 28,222 35,280 34,729 34,577 25,170 24,453 2 4,773 10.110 0 276 9,804 298 (19) (1,525) (1.15I) (1,342) 306 110 9,1899,602 8,553 (1370) 4.694 2.174 122559 4.90 6.379 SU 12515 S 4.857 S 6.329 244 Net Revenue Cost of sales Gross profit Selling, general and administrative expenses Operating Profit Other pension and retiree medical benefits income (expense) Interest expense Interest income and other Income before income taxes (Benefit from provision for income taxes (See Note 5) Net income Less: Net income attributable to non controlling interests Net Income Attributable to PepsiCo Net Income Attributable to PepsiCo per Common Share Basic Diluted Weighted average common shares outstanding Basic Diluted $ 8.84 S 278 S 3.40 $ 4.39 185 436 1.4151.425 1.425 1.438 1.439 1,452 See accompanying notes to the consolidated financial statements. THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED BALANCE SHEETS TOTAL CALEASH EQUIVALENTS AND SHORTERMINVESTMENT se TOTAL CURRENTASSETS DE INCOME TAXASSES TRADEMARKS WITH INDEFINE LIVES BOTTERS FRANCE WITH INDEFINITE LIVES TOTUL RRENT LIABILITIES 10 also TOTAL EQUITY TUTARTISAN THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF INCOME Youth NET OPERATING REVENUES S SS3 191.171 GROSS PROFIT Selling en and administrative Other t han OPERATING INCOME Interesting Interest Egy 91973 RS L wal. sales 15155257 INCOME FROM CONTINUING OPERATIONS BEFORE INCOME TALES 6727 LINE 6.550 NET INCOME FROM CONTINUING OPERATIONS Income from discontinued operation of income 512147 and the CONSOLIDATED NET INCOME 6476 1 NET INCOME ATTRIBUTABLE TO SHAREOWNERS OF THE COCACOLA COMPANY $ 1.58 151 Hentiang pori Basi net income per share from m ed operation BASIC NET INCOME PER SHARE Diluted income per share from continuing 1.31 SOYS 151 DELETED NET INCOME PER SHARE AVERAGE SHARES OUTSTANDING AVERAGE SHARES OUTSTANDING DILUTED 429 414 4157 Cadded aperte todo Refere nt THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF INCOME Youth NET OPERATING REVENUES S SS3 191.171 GROSS PROFIT Selling en and administrative Other t han OPERATING INCOME Interesting Interest Egy 91973 RS L wal. sales 15155257 INCOME FROM CONTINUING OPERATIONS BEFORE INCOME TALES 6727 LINE 6.550 NET INCOME FROM CONTINUING OPERATIONS Income from discontinued operation of income 512147 and the CONSOLIDATED NET INCOME 6476 1 NET INCOME ATTRIBUTABLE TO SHAREOWNERS OF THE COCACOLA COMPANY $ 1.58 151 Hentiang pori Basi net income per share from m ed operation BASIC NET INCOME PER SHARE Diluted income per share from continuing 1.31 SOYS 151 DELETED NET INCOME PER SHARE AVERAGE SHARES OUTSTANDING AVERAGE SHARES OUTSTANDING DILUTED 429 414 4157 Cadded aperte todo Refere nt For each competitor company compute the following 9 ratios for the most recent year (2018) for each company. The balance sheet from 2 years ago will be needed to compute average total assets and average stockholders' equity. Round your answers to 2 decimal places. For percentages, show the percentage carried to 2 decimal places. Ex: 1286 = 12.86% Evaluating the ability to pay current liabilities 1. Working capital 2. Current ratio 3. Quick ratio (Acid-test ratio) Evaluating the ability to pay long term debt 4. Debt ratio 5. Number of times interest charges earned Evaluating profitability (Show results as a percentage) 6. Profit margin percentage 7. Return on assets 8. Return on equity (there are no preferred dividends; compute average stockholders' equity the same way you computed average total assets: Beginning Total Equity + Ending Total Equity = Subtotal/2) Evaluating stock as an investment 9. Price-Earnings (P/E) ratio (use basic earnings per share found on the bottom of the income statement) Consolidated Statement of Income PepsiCo, Inc. and Subsidiaries Fiscal years ended December 29, 2018, December 30, 2017 and December 31, 2016 (in millions except per share amounts) 2018 2017 2016 64,661 S63.525 $ 62,799 29,381 28,796 28,222 35,280 34,729 34,577 25,170 24,453 2 4,773 10.110 0 276 9,804 298 (19) (1,525) (1.15I) (1,342) 306 110 9,1899,602 8,553 (1370) 4.694 2.174 122559 4.90 6.379 SU 12515 S 4.857 S 6.329 244 Net Revenue Cost of sales Gross profit Selling, general and administrative expenses Operating Profit Other pension and retiree medical benefits income (expense) Interest expense Interest income and other Income before income taxes (Benefit from provision for income taxes (See Note 5) Net income Less: Net income attributable to non controlling interests Net Income Attributable to PepsiCo Net Income Attributable to PepsiCo per Common Share Basic Diluted Weighted average common shares outstanding Basic Diluted $ 8.84 S 278 S 3.40 $ 4.39 185 436 1.4151.425 1.425 1.438 1.439 1,452 See accompanying notes to the consolidated financial statements. THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED BALANCE SHEETS TOTAL CALEASH EQUIVALENTS AND SHORTERMINVESTMENT se TOTAL CURRENTASSETS DE INCOME TAXASSES TRADEMARKS WITH INDEFINE LIVES BOTTERS FRANCE WITH INDEFINITE LIVES TOTUL RRENT LIABILITIES 10 also TOTAL EQUITY TUTARTISAN THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF INCOME Youth NET OPERATING REVENUES S SS3 191.171 GROSS PROFIT Selling en and administrative Other t han OPERATING INCOME Interesting Interest Egy 91973 RS L wal. sales 15155257 INCOME FROM CONTINUING OPERATIONS BEFORE INCOME TALES 6727 LINE 6.550 NET INCOME FROM CONTINUING OPERATIONS Income from discontinued operation of income 512147 and the CONSOLIDATED NET INCOME 6476 1 NET INCOME ATTRIBUTABLE TO SHAREOWNERS OF THE COCACOLA COMPANY $ 1.58 151 Hentiang pori Basi net income per share from m ed operation BASIC NET INCOME PER SHARE Diluted income per share from continuing 1.31 SOYS 151 DELETED NET INCOME PER SHARE AVERAGE SHARES OUTSTANDING AVERAGE SHARES OUTSTANDING DILUTED 429 414 4157 Cadded aperte todo Refere nt THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF INCOME Youth NET OPERATING REVENUES S SS3 191.171 GROSS PROFIT Selling en and administrative Other t han OPERATING INCOME Interesting Interest Egy 91973 RS L wal. sales 15155257 INCOME FROM CONTINUING OPERATIONS BEFORE INCOME TALES 6727 LINE 6.550 NET INCOME FROM CONTINUING OPERATIONS Income from discontinued operation of income 512147 and the CONSOLIDATED NET INCOME 6476 1 NET INCOME ATTRIBUTABLE TO SHAREOWNERS OF THE COCACOLA COMPANY $ 1.58 151 Hentiang pori Basi net income per share from m ed operation BASIC NET INCOME PER SHARE Diluted income per share from continuing 1.31 SOYS 151 DELETED NET INCOME PER SHARE AVERAGE SHARES OUTSTANDING AVERAGE SHARES OUTSTANDING DILUTED 429 414 4157 Cadded aperte todo Refere nt