Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Compute each companys (a) current cash debt coverage, (b) cash debt coverage, (c) current ratio, (d) acid-test ratio, (e) accounts receivable turnover, and (f) inventory

Compute each companys (a) current cash debt coverage, (b) cash debt coverage, (c) current ratio, (d) acid-test ratio, (e) accounts receivable turnover, and (f) inventory turnover for 2017. (Round answers to 2 decimal places, e.g. 52.75.) 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

image text in transcribed

2017 2016 2015 $ 1,283 $ 6,550 $ 7,366 THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME Year Ended December 31, (In millions) CONSOLIDATED NET INCOME Other comprehensive income: Net foreign currency translation adjustment Net gain (loss) on derivatives Net unrealized gain (loss) on available-for-sale securities Net change in pension and other benefit liabilities TOTAL COMPREHENSIVE INCOME (LOSS) Less: Comprehensive income (loss) attributable to noncontrolling interests TOTAL COMPREHENSIVE INCOME (LOSS) ATTRIBUTABLE TO SHAREOWNERS OF THE COCA-COLA COMPANY 861 (433) 188 322 2,221 (626) (382) 17 (53) (3,959) 142 (684) 86 2,951 (3) $ 2,954 5,506 73 $ 2,148 10 $ 5,496 THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED BALANCE SHEETS 2017 2016 S 6,006 9,352 15.358 5:317 3,66- 2,655 2,000 219 7:329 36,545 20,856 1,096 4.560 8,203 $ 8,555 9,595 18,150 4,051 3,856 2,675 2,481 2,797 6,729 34,010 16,260 989 4,248 10,635 6,097 3,676 10,629 726 $ 87,270 December 31 (In millions except par value) ASSETS 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 $477 and $466, respectively Inventories Prepaid expenses and other assets Assets held for sale Assets held for sale - discontinued operations TOTAL CURRENT ASSETS EQUITY METHOD INVESTMENTS OTHER INVESTMENTS OTHER ASSETS PROPERTY, PLANT AND EQUIPMENT - net TRADEMARKS WITH INDEFINITE LIVES BOTTLERS' FRANCHISE RIGHTS WITH INDEFINITE LIVES GOODWILL OTHER INTANGIBLE ASSETS TOTAL ASSETS LIABILITIES AND EQUITY CURRENT LIABILITIES Accounts payable and accrued expenses Loans and notes payable Current maturities of long-term debt Accrued income taxes Liabilities held for sale Liabilities held for sale - discontinued operations TOTAL CURRENT LIABILITIES LONG-TERM DEBT OTHER LIABILITIES DEFEREED INCOME TAXES THE COCA-COLA COMPANY SHAREOWNERS' EQUITY Common stock, $0.25 par value; Authorized 11,200 shares; Issued 7,040 and 7,040 shares, respectively Capital surplus Reinvested earnings Accumulated other comprehensive income (loss) Treasury stock, at cost - 2,781 and 2,752 shares, respectively EQUITY ATTRIBUTABLE TO SHAREOWNERS OF THE COCA-COLA COMPANY EQUITY ATTRIBUTABLE TO NONCONTROLLING INTERESTS TOTAL EQUITY TOTAL LIABILITIES AND EQUITY 138 9,401 368 $ 82.896 S $ 9.490 12.498 3:527 307 710 8,748 13,205 3,298 410 37 1,496 27.194 31,182 8,021 2,522 26,532 29,684 4,08: 3.753 1,-60 15.864 60,430 (10,305) (50,6--) 17.072 1,905 18,977 $ 87.896 1,760 14:993 65,502 (11,205) (47,988) 23,062 138 23,220 $ 87-270 THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF CASH FLOWS 2017 2016 2015 $ 6.550 $ 7,366 $ 1,283 (101) 1,182 1,260 219 (1,256) (628) 281 7366 1.970 236 6,550 1,787 258 (856) (449) 158 1,146 647 (224) (221) 8,796 1.459 1,218 (269) 3:529 6.995 73 (122) (137) (374) 929 744 (157) 10,528 Year Ended December 31, (In millions) OPERATING ACTIVITIES Consolidated net income (Income) loss from discontinued operations Net income from continuing operations Depreciation and amortization Stock-based compensation expense Deferred income taxes Equity (income) loss - net of dividends Foreign currency adjustments Significant (gains) losses on sales of assets - net Other operating charges Other items Net change in operating assets and liabilities Net cash provided by operating activities INVESTING ACTIVITIES Purchases of investments Proceeds from disposals of investments Acquisitions of businesses, equity method investments and nonmarketable securities Proceeds from disposals of businesses, equity method investments and nonmarketable securities Purchases of property, plant and equipment Proceeds from disposals of property, plant and equipment Other investing activities Net cash provided by (used in) investing activities FINANCING ACTIVITIES Issuances of debt Payments of debt suances of stock Purchases of stock for treasury Dividends Other financing activities Net cash provided by (used in) financing activities CASH FLOWS FROM DISCONTINUED OPERATIONS Net cash provided by (used in) operating activities from discontinued operations Net cash provided by (used in investing activities from discontinued operations Net cash provided by (used in) dancing activities from discontinued operations Net cash provided by (used in) discontinued operations EFFECT OF EXCHANGE RATE CHANGES ON CASH AND CASH EQUIVALENTS CASH AND CASH EQUIVALENTS Net increase (decrease) during the year Balance at beginning of year Balance at end of year (16,520) 15,911 (3,900) 3.821 (1,6-5) 104 (126) (2.385) (15,499) 16,624 (838) 1,035 (2,262) 150 (209) (999) (15,831) 14,079 (2-491) 565 (2,553) 85 (40) (6,186 40,434 (37.738) 1,245 29.85- (28,768) 1,595 (3,682) (6,320) (91) (7:409) 27,281 (25,613) 1.434 (3,681) (6,043) 79 (6,545) (3:564) (5.741) 251 (5,113) 111 (65) ) (38) 8 242 (6) (878) (2,549) 8.555 6,006 1.246 7,309 $ 8,555 (1,649) 8,958 $ $ 7,309 THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF SHAREOWNERS' EQUITY 2017 2016 2015 4.288 4,366 53 (82) 4:259 1,-60 4:324 50 (86) 4,288 $ 1,760 44 (86) 4:324 $ 1,760 s 14,993 655 14,016 589 130 258 13,154 532 94 236 219 (3) 15,864 14.993 14,016 Year Ended December 31 (In millions except per share data) EQUITY ATTRIBUTABLE TO SHAREOWNERS OF THE COCA-COLA COMPANY NUMBER OF COMMON SHARES OUTSTANDING Balance at beginning of year Treasury stock issued to employees related to stock compensation plans Purchases of stock for treasury Balance at end of year year COMMON STOCK CAPITAL SURPLUS Balance at beginning of year Stock issued to employees related to stock compensation plans Tax benefit (charge) from stock compensation plans Stock-based compensation expense Other activities Balance at end of year REINVESTED EARNINGS Balance at beginning of year Net income attributable to shareowners of The Coca-Cola Company Dividends (per share - $1.48, $1.40 and $1.32 in 2017, 2016 and 2015, respectively) Balance at end of year ACCUMULATED OTHER COMPREHENSIVE INCOME (LOSS) Balance at beginning of year Net other comprehensive income (Loss) Balance at end of year TREASURY STOCK Balance at beginning of year Treasury stock issued to employees related to stock compensation plans Purchases of stock for treasury Balance at end of year TOTAL EQUITY ATTRIBUTABLE TO SHAREOWNERS OF THE COCA-COLA COMPANY EQUITY ATTRIBUTABLE TO NONCONTROLLING INTERESTS Balance at beginning of year Net income attributable to noncontrolling interests Net foreign currency translation adjustment Dividends paid to noncontrolling interests Contributions by noncontrolling interests Business combinations Deconsolidation of certain entities Other activities TOTAL EQUITY ATTRIBUTABLE TO NONCONTROLLING INTERESTS 65,502 1,248 (6,320) 60.430 65.018 6,527 (6,043) 65,502 63,408 7,351 (5.741) 65,018 (11,205) 900 (10,305) (10,174) (1,031) (11,205) (5,777) (4.397) (10,174) (47.988) 909 (3,598) (50,677) $ 17,072 (45,066) 811 (3.733) (42,225) 696 (3,537) (47.988) (45.066) $ 23,062 $ 25,554 S 158 $ 210 S 35 38 23 (13) (25) ) 241 15 (18) ) ( (31) (15) 1 (3) 1,805 (157) 41 (34) (4) 158 6 $ 1,905 $ S $ 210 Consolidated Statement of Income PepsiCo, Inc. and Subsidiaries Fiscal years ended December 27, 2017, December 28, 2016 and December 29, 2015 (in millions except per share amounts) 2017 2016 62,799 $ 28,209 34,740 34,590 24,805 10,509 9.785 (1,342) 2015 63,056 28.731 34,325 24,613 1.259 8,353 (970) 59 7.442 1.941 5,501 49 5,452 110 Net Revenue $ 63,525 S Cost of sales 28.785 Gross profit Selling, general and administrative expenses 24,231 Venezuela impairment charges Operating Profit Interest expense (1:151) Interest income and other 244 Income before income taxes 9,602 Provision for income taxes (See Note 5) 4.694 Net income Less: Net income attributable to noncontrolling interests 51 Net Income Attributable to PepsiCo S 4,857 S Net Income Attributable to PepsiCo per Common Share Basic $ Diluted 3-38 $ Weighted-average common shares outstanding Basic 1,425 Diluted 1,438 Cash dividends declared per common share 3.1675 $ Consolidated Statement of Comprehensive Income PepsiCo, Inc. and Subsidiaries Fiscal years ended December 30, 2017, December 31, 2016 and December 26, 2015 (in millions) 4.908 8,553 2.174 6.379 50 6.329 $ 3.40 $ 4.39 $ 4.36 $ S 3.71 3.67 1,439 1,452 2.96 $ 1,469 1,485 2.7625 $ 2017 4,908 $ 2016 6,379 $ S 2015 5,501 Net income Other comprehensive income/(loss), net of taxes: Net currency translation adjustment Net change on cash flow hedges Net pension and retiree medical adjustments Net change on securities Other (2.827) 3 (302) 46 (316) (24) 171 1 1,109 (36) (159) (68) 16 862 5:770 (51) 5.719 $ Comprehensive income Comprehensive income attributable to noncontrolling interests Comprehensive Income Attributable to PepsiCo See accompanying notes to the consolidated financial statements. (596) 5,783 (54) 5.729 $ (2.652) 2,849 (47) 2,802 $ 2017 2016 2015 S 4,908 $ 2,369 292 295 (113) 6,379 $ 2,368 284 160 (125) 373 5:501 2,416 295 230 (208) 73 1,359 467 (205) 78 221 (220) 619 2,451 501 (695) 452 - (349) (5) (202) (168) 20 201 (338) (341) 9.994 10 997 329 64 10.673 (461) (244) (50) 1,692 55 (134) 10,864 (2,969) 180 (61) (3,040) 99 (212) (2.758) 86 (86) (568) 76 26- 85 Operating Activities Net income Depreciation and amortization Share-based compensation expense Restructuring and impairment charges Cash payments for restructuring charges Charges related to the transaction with Tingyi Venezuela impairment charges Pension and retiree medical plan expenses Pension and retiree medical plan contributions Deferred income taxes and other tax charges and credits Provisional net tax expense related to the TCJ Act Change in assets and liabilities: Accounts and notes receivable Inventories Prepaid expenses and other current assets Accounts payable and other current liabilities Income taxes payable Other, net Net Cash Provided by Operating Activities Investing Activities Capital spending Sales of property, plant and equipment Acquisitions and investments in noncontrolled affiliates Reduction of cash due to Venezuela deconsolidation Divestitures Short-term investments, by original maturity: More than three months - purchases More than three months - maturities More than three months - sales Three months or less, net Other investing net Net Cash Used for Investing Activities Financing Activities Proceeds from issuances of long-term debt Payments of long-term debt Debt redemptions Short-term borrowings, by original maturity: More than three months - proceeds More than three months - payments Three months or less, net Cash dividends paid Share repurchases - common Share repurchases - preferred Proceeds from exercises of stock options Withholding tax payments on RSUS, PSUs and PEPunits converted Other financing Net Cash Used for Financing Activities Effect of exchange rate changes on cash and cash equivalents Net Increase in Cash and Cash Equivalents Cash and Cash Equivalents, Beginning of Year Cash and Cash Equivalents, End of Year (18,385) 15:744 790 (12,504) 8,399 (4,428) 4,111 2 16 29 3 (6) (3.569) (4:403) (148) 2,818 7.509 (4:406) (3,105) (2,504) 8,702 (4:095) 59 (27) 1,505 (4,227) (3.000) 91 (128) (1,016) (4,472) (2.000) (5) 462 (145) (6) (4,186). 47 1,452 9.158 10,610$ 465 (130) (58) (3.211) (252) 62 15 (43) 53 (4,040) (5,000) (5) 504 (151) (52) (4.112) (221) 2,962 6.134 9,096 9.096 S 9.158 $ 2017 2016 S 9,158 6,967 6,694 2,723 908 26.450 ASSETS Current Assets Cash and cash equivalents Short-term investments Accounts and notes receivable, net Inventories Prepaid expenses and other current assets Total Current Assets Property, Plant and Equipment, net Amortizable Intangible Assets, net Goodwill Other nonamortizable intangible assets Nonamortizable Intangible Assets Investments in Noncontrolled Affiliates Other Assets Total Assets 16.591 10,610 $ 8.900 7,024 2.947 1,546 31,027 17,240 1,268 14:744 12.570 27:314 2,042 913 79,804 5 1.237 14:430 12.196 26,626 1,950 636 S 73.490 5,485 $ 15.017 20:502 33.-96 11,283 3.242 68,823 6,892 14,243 21.135 30,053 6,669 4.434 62,291 LIABILITIES AND EQUITY Current Liabilities Short-term debt obligations Accounts payable and other current liabilities Total Current Liabilities Long-Term Debt Obligations Other Liabilities Deferred Income Taxes Total Liabilities Commitments and contingencies Preferred Stock, no par value Repurchased Preferred Stock PepsiCo Common Shareholders' Equity Common stock, par value 1 per share (authorized 3,600 shares, issued, net of repurchased common stock at par value: 1,420 and 1,428 shares, respectively) Capital in excess of par value Retained earnings Accumulated other comprehensive loss Repurchased common stock, in excess of par value (446 and 438 shares, respectively) Total PepsiCo Common Shareholders' Equity Noncontrolling interests Total Equity Total Liabilities and Equity S 41 (197) 41 (192) 24 3.996 52.839 (13,057) (32.757) 11,045 92 10.981 79,804 $ 24 4,091 52.518 (13.919) (31.468) 11, 246 104 11,199 73,490 2017 2016 2015 Shares Amount Shares Amount Shares Amount 0.8 S 41 0.8 S 41 0.8 $ 41 (0.7) (192) (0.7) (186) (0.7) (181) (5) (6) (0.7) (197) (0.7) (192) (0.7) (186) 1,428 (8) 1,420 24 1-448 (20) 24 1428 1.488 (40) 24 1448 25 (1) 24 4,091 290 (236) (145) (4) 3.996 4,076 289 (138) (130) (6) 4,091 4,115 299 (182) (152) 4076 52.518 4.857 (4,536) 50,472 6,329 (4,282) 49,092 5.452 (4:07) Preferred Stock Balance, beginning of year Redemptions Balance, end of year Common Stock Balance, beginning of year Change in repurchased common stock Balance, end of year Capital in Excess of Par Value Balance, beginning of year Share-based compensation expense Stock option exercises RSUS, PSUs and PEPunits converted (2) Withholding tax on RSUS, PSUs and PEPunits converted Other Balance end of year Retained Earnings Balance, beginning of year Net income attributable to PepsiCo Cash dividends declared - common Cash dividends declared - preferred Balance, end of year Accumulated Other Comprehensive Loss Balance, beginning of year Other comprehensive income/(loss) attributable to PepsiCo Balance end of year Repurchased Common Stock Balance, beginning of year Share repurchases Stock option exercises, RSUS, PSUs and PEPunits converted Other Balance, end of year Total PepsiCo Common Shareholders' Equity Noncontrolling Interests Balance, beginning of year Net income attributable to noncontrolling interests Distributions to noncontrolling interests Currency translation adjustment Other, net Balance, end of year Total Equity 52.839 52.518 50.472 (13.919) 862 (13.057) (13,319) ( (600) (13.919) (10,669) (2.650) (13:319) (438) (18) 10 (29,185) (378) (3.000) (52) 712 12 (31,468) (418) (2.000) (29) 708 9 3 (32,757) (438) 11.045 (24,985) (4.999) 794 5 (29,185) 12,068 (446) 5 (31,468) 11,246 (418) 107 110 104 51 (62) 50 (55) 4 (2) 49 (48) (2) (1) 92 10,981 104 107 S S 11.199 S 12,030 THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF INCOME 2017 2016 2015 $ 44,294 $ 41,863 16,465 25,398 15.262 1,510 8,626 Year Ended December 31, (In millions except per share data) NET OPERATING REVENUES Cost of goods sold GROSS PROFIT Selling, general and administrative expenses Other operating charges OPERATING INCOME Interest income Interest expense Equity income (loss) net Other income (loss) - net INCOME FROM CONTINUING OPERATIONS BEFORE INCOME TAXES Income taxes from continuing operations NET INCOME FROM CONTINUING OPERATIONS Income from discontinued operations (net of income taxes of $47, $o and $o, respectively) CONSOLIDATED NET INCOME Less: Net income attributable to noncontrolling interests NET INCOME ATTRIBUTABLE TO SHAREOWNERS OF THE COCA-COLA COMPANY $ 35,410 13,256 22,154 12,496 2,157 7,501 677 841 1,071 (1,666) 6,742 5,560 1,182 642 733 835 (1,234) 17,482 26,812 16,427 1,657 8,728 613 856 489 631 9,605 2,239 7,366 8,136 1,586 6,550 101 7,366 1,283 35 1,248 6,550 23 $ 6,527 15 S S 7,351 S 0.28 S 1.51 $ 1.69 0.02 $ 0.293 S 1.51 $ 1.69 1.67 S 0.27 $ 1.49 $ Basic net income per share from continuing operations Basic net income per share from discontinued operations BASIC NET INCOME PER SHARE Diluted net income per share from continuing operations Diluted net income per share from discontinued operations DILUTED NET INCOME PER SHARE AVERAGE SHARES OUTSTANDING BASIC Effect of dilutive securities AVERAGE SHARES OUTSTANDING DILUTED 0.02 S S S 0.29 4,272 52 4,324 1.49 4,317 50 4:367 1.67 4,352 53 4,405

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

Basel III, The Devil And Global Banking

Authors: D. Chorafas

2nd Edition

0230353770, 9780230353770

More Books

Students also viewed these Accounting questions