Microsoft Excel LibreOffice Calc

Caterpillar Inc. (CAT)

Long-term (Investment) Activity Analysis
Quarterly Data

Difficulty: Beginner

  • Annual Data
  • Quarterly Data

    • 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
    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 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013
    Net fixed asset turnover 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 3.18 3.13 3.15 3.09 – – –
    Total asset turnover 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 0.62 0.59 0.62 0.62 – – –
    Equity turnover 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 2.78 2.50 2.60 2.53 – – –
    Source: Based on data from Caterpillar Inc. Quarterly and Annual Reports
    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 Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018.
    Total asset turnover An activity ratio calculated as total revenue divided by total assets. Caterpillar Inc.'s total asset turnover improved from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018.
    Equity turnover An activity ratio calculated as total revenue divided by shareholders' equity. Caterpillar Inc.'s equity turnover deteriorated from Q4 2017 to Q1 2018 but then improved from Q1 2018 to Q2 2018 exceeding Q4 2017 level.

    Net Fixed Asset Turnover

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

    Microsoft Excel LibreOffice Calc
    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 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013
    Selected Financial Data (USD $ in millions)
    Sales of Machinery, Energy & Transportation 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  13,646  12,678  13,886  12,484 
    Property, plant and equipment, net 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  17,075  16,588  16,352  16,276 
    Ratio
    Net fixed asset turnover1 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 3.18 3.13 3.15 3.09 – – –
    Source: Based on data from Caterpillar Inc. Quarterly and Annual Reports

    Q2 2018 Calculations

    1 Net fixed asset turnover = (Sales of Machinery, Energy & TransportationQ2 2018 + Sales of Machinery, Energy & TransportationQ1 2018 + Sales of Machinery, Energy & TransportationQ4 2017 + Sales of Machinery, Energy & TransportationQ3 2017) ÷ Property, plant and equipment, net
    = (13,279 + 12,150 + 12,194 + 10,713) ÷ 13,752 = 3.51

    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 Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018.

    Total Asset Turnover

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

    Microsoft Excel LibreOffice Calc
    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 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013
    Selected Financial Data (USD $ in millions)
    Sales of Machinery, Energy & Transportation 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  13,646  12,678  13,886  12,484 
    Total assets 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  84,896  87,272  87,375  88,743 
    Ratio
    Total asset turnover1 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 0.62 0.59 0.62 0.62 – – –
    Source: Based on data from Caterpillar Inc. Quarterly and Annual Reports

    Q2 2018 Calculations

    1 Total asset turnover = (Sales of Machinery, Energy & TransportationQ2 2018 + Sales of Machinery, Energy & TransportationQ1 2018 + Sales of Machinery, Energy & TransportationQ4 2017 + Sales of Machinery, Energy & TransportationQ3 2017) ÷ Total assets
    = (13,279 + 12,150 + 12,194 + 10,713) ÷ 78,987 = 0.61

    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 Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018.

    Equity Turnover

    Caterpillar Inc., equity turnover calculation (quarterly data)

    Microsoft Excel LibreOffice Calc
    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 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013
    Selected Financial Data (USD $ in millions)
    Sales of Machinery, Energy & Transportation 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  13,646  12,678  13,886  12,484 
    Shareholders' equity attributable to common shareholders 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  20,811  18,110  17,621  18,274 
    Ratio
    Equity turnover1 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 2.78 2.50 2.60 2.53 – – –
    Source: Based on data from Caterpillar Inc. Quarterly and Annual Reports

    Q2 2018 Calculations

    1 Equity turnover = (Sales of Machinery, Energy & TransportationQ2 2018 + Sales of Machinery, Energy & TransportationQ1 2018 + Sales of Machinery, Energy & TransportationQ4 2017 + Sales of Machinery, Energy & TransportationQ3 2017) ÷ Shareholders' equity attributable to common shareholders
    = (13,279 + 12,150 + 12,194 + 10,713) ÷ 14,879 = 3.25

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