Microsoft Excel LibreOffice Calc

Caterpillar Inc. (CAT)

Long-term (Investment) Activity Analysis
Quarterly Data

Difficulty: Beginner

Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.

Ratios (Summary)

Caterpillar Inc., long-term (investment) activity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
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 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Net fixed asset turnover 3.82 3.70 3.51 3.28 3.01 2.77 2.57 2.45 2.33 2.37 2.45 2.57 2.74 2.97 3.09 3.17 3.15 – – –
Total asset turnover 0.66 0.64 0.61 0.59 0.55 0.50 0.47 0.47 0.48 0.49 0.50 0.52 0.56 0.60 0.61 0.63 0.62 – – –
Equity turnover 3.69 3.18 3.25 3.01 3.12 2.52 2.65 2.66 2.72 2.38 2.56 2.61 2.98 2.98 2.91 3.04 3.11 – – –

Based on: 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), 10-K (filing date: 2015-02-17), 10-Q (filing date: 2014-10-31), 10-Q (filing date: 2014-08-01), 10-Q (filing date: 2014-05-02).

Ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Caterpillar Inc.’s net fixed asset turnover improved from Q2 2018 to Q3 2018 and from Q3 2018 to Q4 2018.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Caterpillar Inc.’s total asset turnover improved from Q2 2018 to Q3 2018 and from Q3 2018 to Q4 2018.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Caterpillar Inc.’s equity turnover deteriorated from Q2 2018 to Q3 2018 but then improved from Q3 2018 to Q4 2018 exceeding Q2 2018 level.

Net Fixed Asset Turnover

Caterpillar Inc., net fixed asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data (USD $ in millions)
Sales of Machinery, Energy & Transportation 13,630  12,763  13,279  12,150  12,194  10,713  10,639  9,130  8,885  8,463  9,645  8,780  10,318  10,285  11,583  11,961  13,500  12,758  13,391  12,493 
Property, plant and equipment, net 13,574  13,607  13,752  13,912  14,155  14,187  14,420  14,727  15,322  15,680  15,916  15,935  16,090  15,955  16,136  16,277  16,577  16,431  16,690  16,716 
Ratio
Net fixed asset turnover1 3.82 3.70 3.51 3.28 3.01 2.77 2.57 2.45 2.33 2.37 2.45 2.57 2.74 2.97 3.09 3.17 3.15 – – –

Based on: 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), 10-K (filing date: 2015-02-17), 10-Q (filing date: 2014-10-31), 10-Q (filing date: 2014-08-01), 10-Q (filing date: 2014-05-02).

Q4 2018 Calculations

1 Net fixed asset turnover = (Sales of Machinery, Energy & TransportationQ4 2018 + Sales of Machinery, Energy & TransportationQ3 2018 + Sales of Machinery, Energy & TransportationQ2 2018 + Sales of Machinery, Energy & TransportationQ1 2018) ÷ Property, plant and equipment, net
= (13,630 + 12,763 + 13,279 + 12,150) ÷ 13,574 = 3.82

Ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Caterpillar Inc.’s net fixed asset turnover improved from Q2 2018 to Q3 2018 and from Q3 2018 to Q4 2018.

Total Asset Turnover

Caterpillar Inc., total asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data (USD $ in millions)
Sales of Machinery, Energy & Transportation 13,630  12,763  13,279  12,150  12,194  10,713  10,639  9,130  8,885  8,463  9,645  8,780  10,318  10,285  11,583  11,961  13,500  12,758  13,391  12,493 
Total assets 78,509  78,209  78,987  78,014  76,962  78,560  78,510  77,549  74,704  76,402  78,300  78,307  78,497  78,969  82,242  82,490  84,681  84,488  87,827  84,397 
Ratio
Total asset turnover1 0.66 0.64 0.61 0.59 0.55 0.50 0.47 0.47 0.48 0.49 0.50 0.52 0.56 0.60 0.61 0.63 0.62 – – –

Based on: 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), 10-K (filing date: 2015-02-17), 10-Q (filing date: 2014-10-31), 10-Q (filing date: 2014-08-01), 10-Q (filing date: 2014-05-02).

Q4 2018 Calculations

1 Total asset turnover = (Sales of Machinery, Energy & TransportationQ4 2018 + Sales of Machinery, Energy & TransportationQ3 2018 + Sales of Machinery, Energy & TransportationQ2 2018 + Sales of Machinery, Energy & TransportationQ1 2018) ÷ Total assets
= (13,630 + 12,763 + 13,279 + 12,150) ÷ 78,509 = 0.66

Ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Caterpillar Inc.’s total asset turnover improved from Q2 2018 to Q3 2018 and from Q3 2018 to Q4 2018.

Equity Turnover

Caterpillar Inc., equity turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data (USD $ in millions)
Sales of Machinery, Energy & Transportation 13,630  12,763  13,279  12,150  12,194  10,713  10,639  9,130  8,885  8,463  9,645  8,780  10,318  10,285  11,583  11,961  13,500  12,758  13,391  12,493 
Shareholders’ equity attributable to common shareholders 14,039  15,850  14,879  15,206  13,697  15,627  14,009  13,588  13,137  15,645  15,232  15,676  14,809  15,896  17,092  16,962  16,746  18,823  20,856  20,305 
Ratio
Equity turnover1 3.69 3.18 3.25 3.01 3.12 2.52 2.65 2.66 2.72 2.38 2.56 2.61 2.98 2.98 2.91 3.04 3.11 – – –

Based on: 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), 10-K (filing date: 2015-02-17), 10-Q (filing date: 2014-10-31), 10-Q (filing date: 2014-08-01), 10-Q (filing date: 2014-05-02).

Q4 2018 Calculations

1 Equity turnover = (Sales of Machinery, Energy & TransportationQ4 2018 + Sales of Machinery, Energy & TransportationQ3 2018 + Sales of Machinery, Energy & TransportationQ2 2018 + Sales of Machinery, Energy & TransportationQ1 2018) ÷ Shareholders’ equity attributable to common shareholders
= (13,630 + 12,763 + 13,279 + 12,150) ÷ 14,039 = 3.69

Ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Caterpillar Inc.’s equity turnover deteriorated from Q2 2018 to Q3 2018 but then improved from Q3 2018 to Q4 2018 exceeding Q2 2018 level.