Required information Benchmark Assignment - Coca-Cola Co. & Pepsico Inc. You will need to use the...

Transcribed Image Text:

Required information Benchmark Assignment - Coca-Cola Co. & Pepsico Inc. You will need to use the data below from the two companies to calculate problems and answer the following questions. Note: Round your answer to 2 decimal places. Coca-Cola Co. (in Pepsico Inc. (in millions) millions) Net Revenue (Sales) $38,655 $79,474 Net Income $9,771 $7,618 Current Assets $22,545 $21,783 Current Liabilities $19,950 $26,220 Cash & Cash Equivalents $12,625 $5,988 Accounts (Trade) Receivables $3,512 $8,680 Total Assets (12/31/21) $94,354 $92,377 Total Assets (12/31/20) $87,296 $92,918 Total Liabilities (12/31/21) $69,494 $76,226 Stockholders Equity (12/31/21) $23,000 $16,043 Stockholders Equity (12/31/20) $19,300 $13,454 Calculate ROI by calculating margin and turnover for each company (DuPont model). Then Calculate ROE for each company. A B C Coca-Cola Co. Pepsico Inc. 1 2 Margin (%) 3 Turnover 4 ROI (Margin X Turnover) 5 ROE Required information Benchmark Assignment - Coca-Cola Co. & Pepsico Inc. You will need to use the data below from the two companies to calculate problems and answer the following questions. Note: Round your answer to 2 decimal places. Coca-Cola Co. (in Pepsico Inc. (in millions) millions) Net Revenue (Sales) $38,655 $79,474 Net Income $9,771 $7,618 Current Assets $22,545 $21,783 Current Liabilities $19,950 $26,220 Cash & Cash Equivalents $12,625 $5,988 Accounts (Trade) Receivables $3,512 $8,680 Total Assets (12/31/21) $94,354 $92,377 Total Assets (12/31/20) $87,296 $92,918 Total Liabilities (12/31/21) $69,494 $76,226 Stockholders Equity (12/31/21) $23,000 $16,043 Stockholders Equity (12/31/20) $19,300 $13,454 Calculate ROI by calculating margin and turnover for each company (DuPont model). Then Calculate ROE for each company. A B C Coca-Cola Co. Pepsico Inc. 1 2 Margin (%) 3 Turnover 4 ROI (Margin X Turnover) 5 ROE