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
Current ratio 0.98 0.86 0.99
Debt ratio 0.85 0.81 0.81
Earnings per share 5.14 5.23 8.84
Inventory turnover 8.47 9.32 9.39
Net income ($ in millions) $ 7,120 $ 7,314 $ 12,515
Rate of return on assets 10.97% 13.05% 13.40%
Receivables turnover 8.67 8.98 9.05
Return on assets 9.34% 10.31% 17.69%
Operating income percentage 14.32% 15.32% 15.64%
Revenues ($ in millions) $ 70,372 $ 67,161 $ 64,661
Times interest earned ratio 9.04 10.96 8.54
Working capital ($ in millions) (371) (2,816) (245)
Notes:
Debt ratio = TL/TA
Inv. TO= CGS/Avg. Inv.
Rate of Return on Assets=EBIT/TA
Acciounts receivable TO=SALES/Avg. AR
Return on Assets=NI + {Interest Expense * (1-Tax)} / Avg TA
Operating Income %=operatinig income /SALES REVENUE
TIE Ratio=EBIT/Interest Exp.
WC=CA - CL
Inventory Turnover, Receivables Turnover, Return on Assets figures for 2018 use ONLY 2018 values in the denominator as we don't have 2017 numbers to average

image text in transcribedimage text in transcribed

Dec. 31, 2020 Dec. 31, 2019 Dec. 31, 2018 $ 9,077 2,025 11,102 5,013 3,685 3,071 2,059 $ 6,795 1,771 8,566 2,348 3,144 3,266 1,916 19,240 19,273 812 6,184 2,460 10,777 10,395 0 17,506 649 $ 6,480 1,467 7,947 3,228 3,971 3,379 1,886 20,411 19,025 854 6,075 2,412 10,838 9,266 109 16,764 627 24,930 19,412 867 4,148 2,674 9,598 6,682 51 14,109 745 83,216 87,296 86,381 CURRENT ASSETS Cash and cash equivalents Short-term investments TOTAL CASH, CASH EQUIVALENTS AND SHORT-TERM INVESTMENTS Marketable securities Trade accounts receivable, less allowances of $524 and $501, respectively Inventories Prepaid expenses and other assets TOTAL CURRENT ASSETS EQUITY METHOD INVESTMENTS OTHER INVESTMENTS OTHER ASSETS Deferred Tax Assets, Net, Noncurrent PROPERTY, PLANT AND EQUIPMENT - net TRADEMARKS WITH INDEFINITE LIVES BOTTLERS' FRANCHISE RIGHTS WITH INDEFINITE LIVES GOODWILL OTHER INTANGIBLE ASSETS TOTAL ASSETS CURRENT LIABILITIES Accounts payable and accrued expenses Notes and Loans Payable, Current Current maturities of long-term debt Accrued income taxes TOTAL CURRENT LIABILITIES LONG-TERM DEBT OTHER LIABILITIES DEFERRED INCOME TAXES THE COCA-COLA COMPANY SHAREOWNERS' EQUITY Common stock, $0.25 par value; authorized 11,200 shares; issued 7,040 shares Capital surplus Reinvested earnings Accumulated other comprehensive income (loss) Treasury stock, at cost - 2,760 and 2,772 shares, respectively EQUITY ATTRIBUTABLE TO SHAREOWNERS OF THE COCA-COLA COMPANY EQUITY ATTRIBUTABLE TO NONCONTROLLING INTERESTS TOTAL EQUITY TOTAL LIABILITIES AND EQUITY 11,145 2,183 485 788 14,601 40,125 9,453 1,833 11,312 10,994 4,253 414 26,973 27,516 8,510 2,284 9,533 13,835 5,003 411 28,782 25,376 7,646 2,354 1,760 17,601 66,555 (14,601) (52,016) 19,299 1,985 $ 21,284 $87,296 1,760 17,154 65,855 (13,544) (52,244) 18,981 2,117 $ 21,098 $ 86,381 1,760 16,520 63,234 (12,814) (51,719) 16,981 2,077 $ 19,058 $ 83,216 CONSOLIDATED STATEMENTS OF INCOME - USD ($) shares in Millions, $ in Millions Revenues Cost of Goods and Services Sold GROSS PROFIT Selling, General and Administrative Expense Other Cost and Expense, Operating OPERATING INCOME Dec. 31, 2019 37,266 14,619 22,647 12,103 458 10,086 563 Interest income Dec. 31, 2020 33,014 13,433 19,581 9,731 853 8,997 370 1,437 978 841 9,749 1,981 7,768 21 7,747 Dec. 31, 2018 34,300 13,067 21,233 11,002 1,079 9,152 689 950 1,008 (1,674) 8,225 1,749 6,476 42 6,434 Interest expense Equity income (loss) - net Other income (loss) - net INCOME BEFORE INCOME TAXES 946 1,049 34 10,786 1,801 8,985 65 8,920 Income taxes CONSOLIDATED NET INCOME Net Income (Loss) Attributable to Noncontrolling Interest NET INCOME ATTRIBUTABLE TO SHAREOWNERS OF THE COCA-COLA COMPANY 1.51 2.09 2.07 BASIC NET INCOME PER SHARE (in dollars per share) DILUTED NET INCOME PER SHARE (in dollars per share) AVERAGE SHARES OUTSTANDING in shares) Effect of dilutive securities in shares) AVERAGE SHARES OUTSTANDING ASSUMING DILUTION (in shares) 1.8 1.79 4295 28 4323 1.5 4259 4276 38 40 4314 4299 NOTES: Tax rate= Provision for Income Taxes / Income before taxes 0.2032 0.1670 0.2126

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_2

Step: 3

blur-text-image_3

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

Internationale Rechnungslegung IFRS Praxis

Authors: Author

1st Edition

3834909289, 9783834909282

More Books

Students also viewed these Accounting questions