Consolidated Statement of Cash Flows In millions Years ended December 31, 2019 2018 2017 Operating activities Net income Adjustmehts to reconcile to cash provided by operations $ 6,025.4 $ 5,924.3 $ 5,192.3 Charges and credits: Depreciation and amortization Deferred income taxes Share-based compensation Net gain on sale of restaurant businesses Other Changes in working capital items: Accounts receivable Inventories, prepaid expenses and other current assets Accounts payable Income taxes Other accrued liabilities Cash provided by operations 1,617.9 149.7 109.6 1,482.0 102.6 125.1 1,363.4 (36.4) 117.5 (1,155.8) 1,050.7 (128.2) 49.2 (308.8) 114.2 27.0 (479.4) (340.7) (37.3) (59.7) (396.4) (146.4) 5,551.2 128.8 (1.9) 129.4 (26.8) 173.4 (3.9) 8,122.1 (33.4) (87.4) 6,966.7 Investing activities Capital expenditures Purchases of restaurant and other businesses Sales of restaurant businesses Proceeds from sale of businesses in China and Hong Kong Sales of property Other (2,393.7) (540.9) 340.8 (2,741.7) (101.7) 530.8 (1,853.7) (77.0) 974.8 1,597.0 151.2 (628.5) (3,071.1) 160.4 166.8 Cash provided by (used for) investing activities (302.9) (2,455.1) (245.9) 562.0 Financing activities Net short-term borrowings Long-term financing issuances Long-term financing repayments Treasury stock purchases Common stock dividends Proceeds from stock option exercises Other L 799.2 95.9 -4,499.0 (2,061.9) (4,976.2) (3,581.9) 350.5 3,794.5 (1,759.6) (5,207.7) (3,255.9) 403.2 (1,050.3) 4,727.5 (1,649.4) (4,685.7) (3,089.2) 456.8 Cash (used for) financing activities Effect of exchange rates on cash and equivalents (23.5) (4,994.8) (23.7) 32.5 (20.0) (5,949.6) (159.8) (1,597.8) (20.5) (5,310.8) 264.0 Cash and equivalents increase (decrease) Change in cash balances of businesses held for sale Cash and equivalents at beginning of year Cash and equivalents at end of year Supplemental cash flow disclosures Interest paid Income taxes paid 1,066.4 .*.. 866.0 $ 898.5 $ 174.0 1,223.4 866.0 $ 2,463.8 2,463.8 ......... $ 1,066.5 $ 1,589.7 959.6 $ 1,734.4 885.2 2,786.3

Consolidated Statement of Cash Flows In millions Years ended December 31, 2019 2018 2017 Operating activities Net income Adjustmehts to reconcile to cash provided by operations $ 6,025.4 $ 5,924.3 $ 5,192.3 Charges and credits: Depreciation and amortization Deferred income taxes Share-based compensation Net gain on sale of restaurant businesses Other Changes in working capital items: Accounts receivable Inventories, prepaid expenses and other current assets Accounts payable Income taxes Other accrued liabilities Cash provided by operations 1,617.9 149.7 109.6 1,482.0 102.6 125.1 1,363.4 (36.4) 117.5 (1,155.8) 1,050.7 (128.2) 49.2 (308.8) 114.2 27.0 (479.4) (340.7) (37.3) (59.7) (396.4) (146.4) 5,551.2 128.8 (1.9) 129.4 (26.8) 173.4 (3.9) 8,122.1 (33.4) (87.4) 6,966.7 Investing activities Capital expenditures Purchases of restaurant and other businesses Sales of restaurant businesses Proceeds from sale of businesses in China and Hong Kong Sales of property Other (2,393.7) (540.9) 340.8 (2,741.7) (101.7) 530.8 (1,853.7) (77.0) 974.8 1,597.0 151.2 (628.5) (3,071.1) 160.4 166.8 Cash provided by (used for) investing activities (302.9) (2,455.1) (245.9) 562.0 Financing activities Net short-term borrowings Long-term financing issuances Long-term financing repayments Treasury stock purchases Common stock dividends Proceeds from stock option exercises Other L 799.2 95.9 -4,499.0 (2,061.9) (4,976.2) (3,581.9) 350.5 3,794.5 (1,759.6) (5,207.7) (3,255.9) 403.2 (1,050.3) 4,727.5 (1,649.4) (4,685.7) (3,089.2) 456.8 Cash (used for) financing activities Effect of exchange rates on cash and equivalents (23.5) (4,994.8) (23.7) 32.5 (20.0) (5,949.6) (159.8) (1,597.8) (20.5) (5,310.8) 264.0 Cash and equivalents increase (decrease) Change in cash balances of businesses held for sale Cash and equivalents at beginning of year Cash and equivalents at end of year Supplemental cash flow disclosures Interest paid Income taxes paid 1,066.4 .*.. 866.0 $ 898.5 $ 174.0 1,223.4 866.0 $ 2,463.8 2,463.8 ......... $ 1,066.5 $ 1,589.7 959.6 $ 1,734.4 885.2 2,786.3

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter21: Cash Budgeting (cashbud)

Section: Chapter Questions

Problem 2R: Open the file CASHBUD from the website for this book at cengagebrain.com. Enter the eight formulas...

See similar textbooks