Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Compute the following ratios for Coca-Cola and Pepsi for 2020. Use net income before controlling interest. (Round answers to 2 decimal places, e.g. 0.52 or

image text in transcribed

Compute the following ratios for Coca-Cola and Pepsi for 2020. Use net income before controlling interest. (Round answers to 2 decimal places, e.g. 0.52 or 52.45%)

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed Compute the following ratios for Coca-Cola and PepsiCo for 2020. Use net income before controlling interest. (Round answers to 2 decimal places, e.g. 0.52 or 52.45% ) \begin{tabular}{|c|c|c|c|} \hline \begin{tabular}{l} THE COCA-COLA COMPANY AND SUBSIDIARIES \\ CONSOLIDATED STATEMENTS OF INCOME \\ (In millions except per share data) \end{tabular} & & & \\ \hline Year Ended December 31, & 2020 & 2019 & 2018 \\ \hline Net Operating Revenues & $33,014 & $37,266 & $34,300 \\ \hline Cost of goods sold & 13,433 & 14,619 & 13,067 \\ \hline Gross Profit & 19,581 & 22,647 & 21,233 \\ \hline Selling, general and administrative expenses & 9,731 & 12,103 & 11,002 \\ \hline Other operating charges & 853 & 458 & 1,079 \\ \hline Operating Income & 8,997 & 10,086 & 9,152 \\ \hline Interest income & 370 & 563 & 689 \\ \hline Interest expense & 1,437 & 946 & 950 \\ \hline Equity income (loss)net & 978 & 1,049 & 1,008 \\ \hline Other income (loss)-net & 841 & 34 & (1,674) \\ \hline Income Before Income Taxes & 9,749 & 10,786 & 8,225 \\ \hline Income taxes & 1,981 & 1,801 & 1,749 \\ \hline Consolidated Net Income & 7,768 & 8,985 & 6,476 \\ \hline Less: Net income (loss) attributable to noncontrolling interests & 21 & 65 & 42 \\ \hline Net Income Attributable to Shareowners of The Coca-Cola Company & $7,747 & $8,920 & $6,434 \\ \hline Basic Net Income Per Share_1 & $1.80 & $2.09 & $1.51 \\ \hline Diluted Net Income Per Share_1 & $1.79 & $2.07 & $1.50 \\ \hline Average Shares Outstanding-Basic & 4,295 & 4,276 & 4,259 \\ \hline Effect of dilutive securities & 28 & 38 & 40 \\ \hline Average Shares OutstandingDiluted & 4,323 & 4,314 & 4,299 \\ \hline \multicolumn{4}{|l|}{1 Calculated based on net income attributable to shareowners of The Coca-Cola Company. } \\ \hline \begin{tabular}{l} THE COCA-COLA COMPANY AND SUBSIDIARIES \\ CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME \\ (In millions) \end{tabular} & & & \\ \hline Year Ended December 31, & & 2019 & 2018 \\ \hline Consolidated Net Income & & $7,768 & $6,476 \\ \hline \multicolumn{4}{|l|}{ Other Comprehensive Income: } \\ \hline Net foreign currency translation adjustments & & (911) & (2,035) \\ \hline Net gains (losses) on derivatives & & (54) & (7) \\ \hline Net change in unrealized gains (losses) on available-for-sale debt securities & & (47) & (34) \\ \hline Net change in pension and other postretirement benefit liabilities & & (267) & 29 \\ \hline Total Comprehensive Income & & 6,558 & 4,429 \\ \hline Less: Comprehensive income attributable to noncontrolling interests & & (132) & 95 \\ \hline Total Comprehensive Income Attributable to Shareowners of The Coca-Cola Company & & $6,690 & $4,334 \\ \hline \end{tabular} THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED BALANCE SHEETS (In millions except par value) \begin{tabular}{|c|c|c|} \hline December 31, & 2020 & 2019 \\ \hline \multicolumn{3}{|l|}{ ASSETS } \\ \hline \multicolumn{3}{|l|}{ Current Assets } \\ \hline Cash and cash equivalents & $6,795 & $6,480 \\ \hline Short-term investments & 1,771 & 1,467 \\ \hline Total Cash, Cash Equivalents and Short-Term Investments & 8,566 & 7,947 \\ \hline Marketable securities & 2,348 & 3,228 \\ \hline Trade accounts receivable, less allowances of $526 and $524, respectively & 3,144 & 3,971 \\ \hline Inventories & 3,266 & 3,379 \\ \hline Prepaid expenses and other assets & 1,916 & 1,886 \\ \hline Total Current Assets & 19,240 & 20,411 \\ \hline Equity method investments & 19,273 & 19,025 \\ \hline Other investments & 812 & 854 \\ \hline Other assets & 6,184 & 6,075 \\ \hline Deferred income tax assets & 2,460 & 2,412 \\ \hline Property, plant and equipmentnet & 10,777 & 10,838 \\ \hline Trademarks with indefinite lives & 10,395 & 9,266 \\ \hline Goodwill & 17,506 & 16,764 \\ \hline Other intangible assets & 649 & 736 \\ \hline Total Assets & $87,296 & $86,381 \\ \hline \multicolumn{3}{|c|}{ LIABILITIES AND EQUITY } \\ \hline \multicolumn{3}{|l|}{ Current Liabilities } \\ \hline Accounts payable and accrued expenses & $11,145 & $11,312 \\ \hline Loans and notes payable & 2,183 & 10,994 \\ \hline Current maturities of long-term debt & 485 & 4,253 \\ \hline Accrued income taxes & 788 & 414 \\ \hline Total Current Liabilities & 14,601 & 26,973 \\ \hline Long-term debt & 40,125 & 27,516 \\ \hline Other liabilities & 9,453 & 8,510 \\ \hline Deferred income tax liabilities & 1,833 & 2,284 \\ \hline \multicolumn{3}{|l|}{ The Coca-Cola Company Shareowners' Equity } \\ \hline Common stock, $0.25 par value; authorized 11,200 shares; issued 7,040 shares & 1,760 & 1,760 \\ \hline Capital surplus & 17,601 & 17,154 \\ \hline Reinvested earnings & 66,555 & 65,855 \\ \hline Accumulated other comprehensive income (loss) & (14,601) & (13,544) \\ \hline Treasury stock, at cost-2,738 and 2,760 shares, respectively & (52,016) & (52,244) \\ \hline Equity Attributable to Shareowners of The Coca-Cola Company & 19,299 & 18,981 \\ \hline Equity attributable to noncontrolling interests & 1,985 & 2,117 \\ \hline Total Equity & 21,284 & 21,098 \\ \hline Total Liabilities and Equity & $87,296 & $86,381 \\ \hline \end{tabular} THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF CASH FLOWS (In millions) \begin{tabular}{|c|c|c|c|} \hline Year Ended December 31, & 2020 & 2019 & 2018 \\ \hline \multicolumn{4}{|l|}{ Operating Activities } \\ \hline Consolidated net income & $7,768 & $8,985 & $6,476 \\ \hline Depreciation and amortization & 1,536 & 1,365 & 1,086 \\ \hline Stock-based compensation expense & 126 & 201 & 225 \\ \hline Deferred income taxes & (18) & (280) & (413) \\ \hline Equity (income) loss-net of dividends & (511) & (421) & (457) \\ \hline Foreign currency adjustments & (88) & 91 & (50) \\ \hline Significant (gains) losses-net & (914) & (467) & 743 \\ \hline Other operating charges & 556 & 127 & 558 \\ \hline Other items & 699 & 504 & 699 \\ \hline Net change in operating assets and liabilities & 690 & 366 & (1,240) \\ \hline Net Cash Provided by Operating Activities & 9,844 & 10,471 & 7,627 \\ \hline \multicolumn{4}{|l|}{ Investing Activities } \\ \hline Purchases of investments & (13,583) & (4,704) & (7,789) \\ \hline Proceeds from disposals of investments & 13,835 & 6,973 & 14,977 \\ \hline Acquisitions of businesses, equity method investments and nonmarketable securities & (1,052) & (5,542) & (1,263) \\ \hline Proceeds from disposals of businesses, equity method investments and nonmarketable securities & 189 & 429 & 1,362 \\ \hline Purchases of property, plant and equipment & (1,177) & (2,054) & (1,548) \\ \hline Proceeds from disposals of property, plant and equipment & 189 & 978 & 248 \\ \hline Other investing activities & 122 & (56) & (60) \\ \hline Net Cash Provided by (Used in) Investing Activities & (1,477) & (3,976) & 5,927 \\ \hline \multicolumn{4}{|l|}{ Financing Activities } \\ \hline Issuances of debt & 26,934 & 23,009 & 27,605 \\ \hline Payments of debt & (28,796) & (24,850) & (30,600) \\ \hline Issuances of stock & 647 & 1,012 & 1,476 \\ \hline Purchases of stock for treasury & (118) & (1,103) & (1,912) \\ \hline Dividends & (7,047) & (6,845) & (6,644) \\ \hline Other financing activities & 310 & (227) & (272) \\ \hline Net Cash Provided by (Used in) Financing Activities & (8,070) & (9,004) & (10,347) \\ \hline Effect of Exchange Rate Changes on Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents & 76 & (72) & (262) \\ \hline \multicolumn{4}{|l|}{ Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents } \\ \hline Net increase (decrease) in cash, cash equivalents, restricted cash and restricted cash equivalents during the year & 373 & (2,581) & 2,945 \\ \hline Cash, cash equivalents, restricted cash and restricted cash equivalents at beginning of year & 6,737 & 9,318 & 6,373 \\ \hline Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents at End of Year & 7,110 & 6,737 & 9,318 \\ \hline Less: Restricted cash and restricted cash equivalents at end of year & 315 & 257 & 241 \\ \hline Cash and Cash Equivalents at End of Year & $6,795 & $6,480 & $9,077 \\ \hline \end{tabular} THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF SHAREOWNERS' EQUITY (In millions except per share data) \begin{tabular}{|c|c|c|c|} \hline Year Ended December 31, & 2020 & 2019 & 2018 \\ \hline \multicolumn{4}{|l|}{ Equity Attributable to Shareowners of The Coca-Cola Company } \\ \hline \multicolumn{4}{|l|}{ Number of Common Shares Outstanding } \\ \hline Balance at beginning of year & 4,280 & 4,268 & 4,259 \\ \hline Treasury stock issued to employees related to stock-based compensation plans & 22 & 33 & 48 \\ \hline Purchases of stock for treasury & & (21) & (39) \\ \hline Balance at end of year & 4,302 & 4,280 & 4,268 \\ \hline Common Stock & $1,760 & $1,760 & $1,760 \\ \hline \multicolumn{4}{|l|}{ Capital Surplus } \\ \hline Balance at beginning of year & 17,154 & 16,520 & 15,864 \\ \hline Stock issued to employees related to stock-based compensation plans & 307 & 433 & 467 \\ \hline Stock-based compensation expense & 141 & 201 & 225 \\ \hline Other activities & (1) & - & (36) \\ \hline Balance at end of year & 17,601 & 17,154 & 16,520 \\ \hline \multicolumn{4}{|l|}{ Reinvested Earnings } \\ \hline Balance at beginning of year & 65,855 & 63,234 & 60,430 \\ \hline Adoption of accounting standards_1 & - & 546 & 3,014 \\ \hline Net income attributable to shareowners of The Coca-Cola Company & 7,747 & 8,920 & 6,434 \\ \hline Dividends (per share\$1.64, \$1.60 and \$1.56 in 2020, 2019 and 2018, respectively) & (7,047) & (6,845) & (6,644) \\ \hline Balance at end of year & 66,555 & 65,855 & 63,234 \\ \hline \multicolumn{4}{|l|}{ Accumulated Other Comprehensive Income (Loss) } \\ \hline Balance at beginning of year & (13,544) & (12,814) & (10,305) \\ \hline Adoption of accounting standards_1 & & (564) & (409) \\ \hline Net other comprehensive income (loss) & (1,057) & (166) & (2,100) \\ \hline Balance at end of year & (14,601) & (13,544) & (12,814) \\ \hline \multicolumn{4}{|l|}{ Treasury Stock } \\ \hline Balance at beginning of year & (52,244) & (51,719) & (50,677) \\ \hline Treasury stock issued to employees related to stock-based compensation plans & 228 & 501 & 704 \\ \hline Purchases of stock for treasury & & (1,026) & (1,746) \\ \hline Balance at end of year & (52,016) & (52,244) & (51,719) \\ \hline Total Equity Attributable to Shareowners of The Coca-Cola Company & $19,299 & $18,981 & $16,981 \\ \hline \multicolumn{4}{|l|}{ Equity Attributable to Noncontrolling Interests } \\ \hline Balance at beginning of year & $2,117 & $2,077 & $1,905 \\ \hline Net income attributable to noncontrolling interests & 21 & 65 & 42 \\ \hline Net foreign currency translation adjustments & (153) & 45 & 53 \\ \hline Dividends paid to noncontrolling interests & (18) & (48) & (31) \\ \hline Acquisition of interests held by noncontrolling owners & - & (84) & - \\ \hline Contributions by noncontrolling interests & 17 & 3 & - \\ \hline Business combinations & 1 & 59 & 101 \\ \hline Other activities & & & 7 \\ \hline Total Equity Attributable to Noncontrolling Interests & $1,985 & $2,117 & $2,077 \\ \hline \end{tabular} 1 Refer to Note 1 and Note 5. Consolidated Statement of Income PepsiCo, Inc. and Subsidiaries Fiscal years ended December 26, 2020, December 28, 2019 and December 29, 2018 (in millions except per share amounts) Consolidated Statement of Cash Flows PepsiCo, Inc. and Subsidiaries Fiscal years ended December 26, 2020, December 28, 2019 and December 29, 2018 (i Consolidated Balance Sheet PepsiCo, Inc. and Subsidiaries Consolidated Statement of Equity PepsiCo, Inc. and Subsidiaries

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

Financial Accounting

Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso, J. Mather

8th Edition

0470929383, 978-0470929384

More Books

Students also viewed these Accounting questions

Question

What is a job analysis?

Answered: 1 week ago

Question

What are the main provisions of the Fair Labor Standards Act?

Answered: 1 week ago