Microsoft Excel LibreOffice Calc

Caterpillar Inc. (NYSE:CAT)


Cash Flow Statement
Quarterly Data

Beginner level

The cash flow statement provides information about a company’s cash receipts and cash payments during an accounting period, showing how these cash flows link the ending cash balance to the beginning balance shown on the company’s balance sheet.

The cash flow statement consists of three parts: cash flows provided by (used in) operating activities, cash flows provided by (used in) investing activities, and cash flows provided by (used in) financing activities.

Caterpillar Inc., consolidated cash flow statement (quarterly data)

US$ in millions

Microsoft Excel LibreOffice Calc
3 months ended Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015
Profit (loss) of consolidated and affiliated companies 1,093  1,097  1,494  1,619  1,884  1,049  1,727  1,705  1,667  (1,299) 1,061  803  194  (1,167) 283  553  272  (83) 371  711  1,114 
Depreciation and amortization 614  644  645  647  641  701  698  686  681  724  723  720  710  779  761  754  740  774  758  761  753 
Gain on remeasurement of a non-U.S. pension obligation (254) —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  — 
Provision (benefit) for deferred income taxes 20  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  — 
Goodwill impairment charge —  —  —  —  —  —  —  —  —  —  —  —  —  595  —  —  —  —  —  —  — 
Other 534  544  187  352  88  1,091  184  298  148  1,668  105  186  301  770  272  99  269  154  234  171  (51)
Adjustments for non-cash items 914  1,188  832  999  729  1,792  882  984  829  2,392  828  906  1,011  2,144  1,033  853  1,009  928  992  932  702 
Receivables, trade and other 500  (256) 593  (16) (150) (894) (22) (377) (326) (696) (13) (89) (353) (299) 555  559  14  150  231  377 
Inventories (541) 950  (189) 326  (813) 243  (614) (405) (803) 194  (801) (244) (444) 778  26  379  (74) 1,434  508  421  (89)
Accounts payable 90  (356) (803) (221) 355  213  (49) 59  486  107  258  381  732  (37) (371) (3) 211  (272) (567) (554) 228 
Accrued expenses (97) 58  (37) 16  135  133  (1) (97) 66  54  (130) 119  132  (48) (154) (32) 33  (174) 46  (106) 35 
Accrued wages, salaries and employee benefits (722) 101  121  206  (1,185) 256  350  342  (1,110) 225  321  281  360  19  16  109  (852) 315  97  226  (1,027)
Customer advances 116  (179) 155  (91) 105  (242) 113  (8) (46) (379) (12) 129  193  (13) (117) (81) 174  (465) (134) 73  25 
Other assets, net (50) (96) 224  (177) (44) (353) 220  165  (55) 143  (19) (261) 365  (14) 18  (145) (112) (193) (203) 288 
Other liabilities, net (173) (73) (1,621) (73) 105  (114) (1,214) (64) (2) (415) 113  (23) (97) (94) (44) (153) 90  155  211  (12)
Changes in assets and liabilities, net of acquisitions and divestitures (877) 149  (1,557) (30) (1,492) (758) (1,217) (541) (1,561) (552) (649) 671  336  668  (153) 905  (792) 966  143  445  (546)
Net cash provided by operating activities 1,130  2,434  769  2,588  1,121  2,083  1,392  2,148  935  541  1,240  2,380  1,541  1,645  1,163  2,311  489  1,811  1,506  2,088  1,270 
Capital expenditures, excluding equipment leased to others (305) (333) (244) (201) (278) (355) (276) (233) (412) (332) (195) (167) (204) (302) (227) (223) (357) (442) (290) (219) (437)
Expenditures for equipment leased to others (243) (480) (387) (477) (269) (432) (325) (538) (345) (367) (318) (448) (305) (426) (368) (642) (383) (622) (436) (426) (389)
Proceeds from disposals of leased assets and property, plant and equipment 216  341  390  213  209  204  193  281  258  300  301  329  234  327  189  210  173  287  106  200  167 
Additions to finance receivables (2,953) (3,324) (3,272) (3,566) (2,615) (3,091) (2,949) (3,522) (2,621) (3,707) (2,982) (3,142) (2,122) (2,428) (2,268) (2,629) (2,014) (2,830) (2,522) (2,455) (2,122)
Collections of finance receivables 3,153  3,039  3,242  3,084  2,818  2,869  2,627  2,734  2,671  3,486  3,024  3,236  2,272  2,401  2,502  2,419  2,047  2,398  2,372  2,236  2,241 
Proceeds from sale of finance receivables 31  52  64  75  44  61  292  55  69  29  15  66  17  72  13  32  10  35  27  31  43 
Investments and acquisitions, net of cash acquired (35) (41) (3) (1) (2) (35) (9) (8) (340) (12) (26) (3) (18) (119) (34) (26) (12) (260) (77) (34) (29)
Proceeds from sale of businesses and investments, net of cash sold —  38  —  —  —  12  91  —  —  —  —  —  167 
Proceeds from sale of securities 68  248  111  113  57  79  195  79  89  501  244  98  89  390  109  146  49  113  110  45  83 
Investments in securities (180) (127) (182) (136) (107) (89) (99) (121) (197) (454) (387) (142) (65) (52) (96) (181) (62) (189) (177) (49) (70)
Other, net 35  13  (2) (38) (11) 16  23  33  28  (23) (5) 19  (23) (38) (1) (37) (38)
Net cash used for investing activities (213) (574) (275) (898) (181) (798) (346) (1,268) (800) (526) (289) (54) (125) (142) (161) (885) (572) (1,544) (882) (707) (384)
Dividends paid (567) (568) (578) (492) (494) (507) (511) (466) (467) (464) (461) (454) (452) (451) (450) (450) (448) (448) (463) (422) (424)
Common stock issued, including treasury shares reissued (23) 179  20  44  (5) 21  36  107  149  213  270  102  (19) 31  (7) (2) (45) (1) 32 
Common shares repurchased (1,043) (764) (1,178) (1,354) (751) (1,798) (750) (750) (500) —  —  —  —  —  —  —  —  —  (1,500) (125) (400)
Excess tax benefit from stock-based compensation —  —  —  —  —  —  —  —  —  —  —  —  —  16  17 
Machinery, Energy & Transportation 15  —  1,479  —  —  10  47  —  —  (1) 360  —  —  —  — 
Financial Products 2,126  1,014  2,008  2,675  2,665  1,824  2,719  2,766  1,541  1,730  2,465  2,152  2,355  685  1,584  1,630  1,210  1,050  391  2,161  1,527 
Proceeds from debt issued, original maturities greater than three months 2,141  1,014  3,487  2,675  2,665  1,834  2,766  2,766  1,541  1,729  2,466  2,153  2,715  685  1,589  1,630  1,211  1,050  391  2,162  1,529 
Machinery, Energy & Transportation (6) (4) (4) (2) (2) (1) (3) (2) (1) (959) (1) (501) (4) (8) (518) (4) (3) (4) (4) (503) (6)
Financial Products (2,460) (2,231) (1,157) (2,332) (2,565) (2,186) (1,203) (2,025) (2,408) (1,205) (1,994) (1,747) (1,973) (955) (1,753) (1,621) (1,703) (1,516) (679) (3,267) (2,313)
Payments on debt, original maturities greater than three months (2,466) (2,235) (1,161) (2,334) (2,567) (2,187) (1,206) (2,027) (2,409) (2,164) (1,995) (2,248) (1,977) (963) (2,271) (1,625) (1,706) (1,520) (683) (3,770) (2,319)
Short-term borrowings, net, original maturities three months or less (40) 868  (570) 86  (522) 1,227  (1,952) 336  1,151  (655) (1,898) (1,123) 618  251  (502) (95) 486  1,100  (50) 1,022  950 
Other, net (1) (1) —  (1) (1) (22) (28) (1) (3) (2) (1) —  (6) —  (8) (1) —  —  —  (7)
Net cash provided by (used for) financing activities (1,999) (1,507) 20  (1,376) (1,675) (1,432) (1,645) (35) (538) (1,343) (1,619) (1,570) 879  (431) (1,641) (538) (502) 185  (2,302) (1,131) (622)
Effect of exchange rate changes on cash (80) (37) (13) (9) (49) (78) 10  (2) 27  (17) (12) (10) 11  (38) (97) (42)
Increase (decrease) in cash and short-term investments and restricted cash (1,162) 356  477  301  (732) (156) (648) 767  (393) (1,330) (641) 760  2,304  1,055  (651) 878  (574) 414  (1,775) 258  222 

Based on: 10-Q (filing date: 2020-05-06), 10-K (filing date: 2020-02-19), 10-Q (filing date: 2019-10-31), 10-Q (filing date: 2019-08-01), 10-Q (filing date: 2019-05-06), 10-K (filing date: 2019-02-14), 10-Q (filing date: 2018-10-31), 10-Q (filing date: 2018-08-07), 10-Q (filing date: 2018-05-02), 10-K (filing date: 2018-02-15), 10-Q (filing date: 2017-11-01), 10-Q (filing date: 2017-08-02), 10-Q (filing date: 2017-05-03), 10-K (filing date: 2017-02-15), 10-Q (filing date: 2016-11-02), 10-Q (filing date: 2016-08-03), 10-Q (filing date: 2016-05-02), 10-K (filing date: 2016-02-16), 10-Q (filing date: 2015-10-30), 10-Q (filing date: 2015-07-31), 10-Q (filing date: 2015-05-01).

Cash flow statement item Description The company
Net cash provided by operating activities Amount of cash inflow (outflow) from operating activities, excluding discontinued operations. Operating activity cash flows include transactions, adjustments, and changes in value not defined as investing or financing activities. Caterpillar Inc.’s net cash provided by operating activities increased from Q3 2019 to Q4 2019 but then slightly decreased from Q4 2019 to Q1 2020 not reaching Q3 2019 level.
Net cash used for investing activities Amount of cash inflow (outflow) of investing activities, excluding discontinued operations. Investing activity cash flows include making and collecting loans and acquiring and disposing of debt or equity instruments and property, plant, and equipment and other productive assets. Caterpillar Inc.’s net cash used for investing activities decreased from Q3 2019 to Q4 2019 but then increased from Q4 2019 to Q1 2020 exceeding Q3 2019 level.
Net cash provided by (used for) financing activities Amount of cash inflow (outflow) of financing activities, excluding discontinued operations. Financing activity cash flows include obtaining resources from owners and providing them with a return on, and a return of, their investment; borrowing money and repaying amounts borrowed, or settling the obligation; and obtaining and paying for other resources obtained from creditors on long-term credit. Caterpillar Inc.’s net cash provided by (used for) financing activities decreased from Q3 2019 to Q4 2019 and from Q4 2019 to Q1 2020.