Answered step by step
Verified Expert Solution
Link Copied!

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

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

Advanced Financial Accounting

Authors: Richard Lewis, David Pendrill

5th Edition

0273622919, 978-0273622918

More Books

Students also viewed these Accounting questions