Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Below are the ratios (with excel formulas) calculated for Pepsi-Co, Inc. for you - all you need to do is calculate the Coca-Cola Company ratios
Below are the ratios (with excel formulas) calculated for Pepsi-Co, Inc. for you - all you need to do is calculate the Coca-Cola Company ratios | |||||||
Pepsi-Co, Inc. | The Coca-Cola Company | ||||||
Selected Financial Data | Selected Financial Data | ||||||
For years ended December 31 | For years ended December 31 | ||||||
2020 | 2019 | 2018 | 2020 | 2019 | 2018 | ||
Acid-test ratio (CA-inventory-prepaid)/CL | 0.77 | 0.66 | 0.82 | 0.96 | 0.56 | 0.69 | |
Current ratio (CA/CL) | 0.98 | 0.86 | 0.99 | 1.32 | 0.76 | 0.87 | |
Debt ratio | 0.85 | 0.81 | 0.81 | 0.76 | 0.76 | 0.77 | |
Earnings per share | 5.14 | 5.23 | 8.84 | 1.8 | 2.09 | 1.51 | |
Inventory turnover | 8.47 | 9.32 | 9.39 | 4.04 | 4.53 | 4.25 | |
Net income ($ in millions) | $ 7,120 | $ 7,314 | $ 12,515 | $ 7,747 | $ 8,920 | $ 6,434 | |
Accounts Receivables turnover | 8.67 | 8.98 | 9.05 | 9.28 | 9.74 | 9.31 | |
Return on assets | 9.34% | 10.31% | 17.69% | 7.61% | 9.64% | 6.83% | |
Operating income percentage | 14.32% | 15.32% | 15.64% | 27.25% | 27.06% | 26.68% | |
Revenues ($ in millions) | $ 70,372 | $ 67,161 | $ 64,661 | $ 33,014 | $ 37,266 | $ 34,300 | |
Working capital ($ in millions) CA-CL | (371) | (2,816) | (245) | 4,639 | 6,562 | 3,852 |
Pepsi balance sheet & income
Consolidated Balance Sheet - USD ($) shares in Millions, $ in Millions | Dec. 26, 2020 | Dec. 28, 2019 | Dec. 29, 2018 | Consolidated Statement of Income - USD ($) shares in Millions, $ in Millions | 12 Months Ended | ||||
ASSETS | Dec. 26, 2020 | Dec. 28, 2019 | Dec. 29, 2018 | ||||||
Cash and cash equivalents | $ 8,185 | $ 5,509 | $8,721 | Income Statement [Abstract] | |||||
Short-term Investments | 1,366 | 229 | 272 | Net Revenue | 70,372 | 67,161 | 64,661 | ||
Restricted Cash | 0 | 0 | 1,997 | Cost of sales | 31,797 | 30,132 | 29,381 | ||
Accounts and notes receivable, net | 8,404 | 7,822 | 7,142 | Gross profit | 38,575 | 37,029 | 35,280 | ||
Inventories | 4,172 | 3,338 | 3,128 | Selling, general and administrative expenses | 28,495 | 26,738 | 25,170 | ||
Prepaid expenses and other current assets | 874 | 747 | 633 | Operating Profit | 10,080 | 10,291 | 10,110 | ||
Total current assets | 23,001 | 17,645 | 21,893 | Other pension and retiree medical benefits income/(expense) | 117 | (44) | 298 | ||
Property, Plant and Equipment, net | 21,369 | 19,305 | 17,589 | Net interest expense and other | (1,128) | (935) | (1,219) | ||
Amortizable Intangible Assets, net | 1,703 | 1,433 | 1,644 | Income before income taxes | 9,069 | 9,312 | 9,189 | ||
Goodwill | 18,757 | 15,501 | 14,808 | Provision for/(benefit from) income taxes (See Note 5) | 1,894 | 1,959 | (3,370) | ||
Other Indefinite-lived Intangible Assets | 17,612 | 14,610 | 14,181 | Net income | 7,175 | 7,353 | 12,559 | ||
Indefinite-Lived Intangible Assets | 36,369 | 30,111 | 28,989 | Less: Net income attributable to noncontrolling interests | 55 | 39 | 44 | ||
Investments in Noncontrolled Affiliates | 2,792 | 2,683 | 2,409 | Net Income Attributable to PepsiCo | 7,120 | 7,314 | 12,515 | ||
Deferred Income Taxes | 4,372 | 4,359 | 4,364 | Net Income Attributable to PepsiCo per Common Share | |||||
Other Assets | 3,312 | 3,011 | 760 | Basic | 5.14 | 5.23 | 8.84 | ||
Total Assets | 92,918 | 78,547 | 77,648 | Diluted | 5.12 | 5.20 | 8.78 | ||
LIABILITIES AND EQUITY | Weighted-average common shares outstanding | ||||||||
Short-term debt obligations | 3,780 | 2,920 | 4,026 | Basic | 1,385 | 1,399 | 1,415 | ||
Accounts payable and other current liabilities | 19,592 | 17,541 | 18,112 | Diluted | 1,392 | 1,407 | 1,425 | ||
Total Current Liabiities | 23,372 | 20,461 | 22,138 | NOTES: | |||||
Long-Term Debt Obligations | 40,370 | 29,148 | 28,295 | Tax rate= Provision for Income Taxes/ Income before taxes | 0.2088 | 0.2104 | 0 | ||
Deferred Income Taxes | 4,284 | 4,091 | 3,499 | ||||||
Other Liabilities | 11,340 | 9,979 | 9,114 | ||||||
Total Liabilities | 79,366 | 63,679 | 63,046 | ||||||
PepsiCo Common Shareholders Equity | |||||||||
Common stock, par value 12/3 per share (authorized 3,600 shares, issued, net of repurchased common stock at par value: 1,380 and 1,391 shares, respectively) | $ 23 | $ 23 | 23 | ||||||
Additional Paid in Capital, Common Stock | $ 3,910 | $ 3,886 | 3,953 | ||||||
Retained Earnings (Accumulated Deficit) | 63,443 | 61,946 | 59,947 | ||||||
Accumulated Other Comprehensive Income (Loss), Net of Tax | $ (15,476) | $ (14,300) | $ (15,119) | ||||||
Treasury Stock, Value | (38,446) | (36,769) | (34,286) | ||||||
TOTAL PepsiCo common shareholders' equity | $ 13,454 | $ 14,786 | $ 14,518 | ||||||
Noncontrolling interests | 98 | 82 | 84 | ||||||
Total equity | $ 13,552 | $ 14,868 | $ 14,602 | ||||||
Total liabilities and Equity | 92,918 | 78,547 | 77,648 | ||||||
2. Using the financial data for the three years for PepsiCo, Inc., discuss the company's | |
a. Ability to pay current liabilities; | |
b. Ability to sell inventory and collect receivables; | |
c. Ability to pay long-term debt; and | |
d. Profitability. |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started