Microsoft Excel LibreOffice Calc

Occidental Petroleum Corp. (OXY)

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)

Occidental Petroleum Corp., long-term (investment) activity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
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 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Net fixed asset turnover 0.57 0.57 0.53 0.47 0.42 0.40 0.37 0.36 0.34 0.31 0.33 0.34 0.37 0.39 0.38 0.39 0.43 0.49 — — —
Net fixed asset turnover (including operating lease, right-of-use asset) 0.55 0.57 0.53 0.47 0.42 0.40 0.37 0.36 0.34 0.31 0.33 0.34 0.37 0.39 0.38 0.39 0.43 0.49 — — —
Total asset turnover 0.41 0.41 0.37 0.33 0.31 0.30 0.28 0.27 0.26 0.23 0.24 0.25 0.27 0.29 0.28 0.29 0.33 0.34 — — —
Equity turnover 0.85 0.84 0.77 0.68 0.64 0.61 0.57 0.54 0.52 0.47 0.45 0.46 0.48 0.51 0.47 0.47 0.51 0.55 — — —

Based on: 10-Q (filing date: 2019-05-06), 10-K (filing date: 2019-02-21), 10-Q (filing date: 2018-11-05), 10-Q (filing date: 2018-08-08), 10-Q (filing date: 2018-05-08), 10-K (filing date: 2018-02-23), 10-Q (filing date: 2017-11-01), 10-Q (filing date: 2017-08-02), 10-Q (filing date: 2017-05-04), 10-K (filing date: 2017-02-23), 10-Q (filing date: 2016-11-01), 10-Q (filing date: 2016-08-03), 10-Q (filing date: 2016-05-05), 10-K (filing date: 2016-02-26), 10-Q (filing date: 2015-10-30), 10-Q (filing date: 2015-08-04), 10-Q (filing date: 2015-05-06), 10-K (filing date: 2015-02-23), 10-Q (filing date: 2014-10-31), 10-Q (filing date: 2014-08-05), 10-Q (filing date: 2014-05-05).

Ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Occidental Petroleum Corp.’s net fixed asset turnover improved from Q3 2018 to Q4 2018 but then slightly deteriorated from Q4 2018 to Q1 2019.
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Occidental Petroleum Corp.’s net fixed asset turnover (including operating lease, right-of-use asset) improved from Q3 2018 to Q4 2018 but then slightly deteriorated from Q4 2018 to Q1 2019.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Occidental Petroleum Corp.’s total asset turnover improved from Q3 2018 to Q4 2018 and from Q4 2018 to Q1 2019.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Occidental Petroleum Corp.’s equity turnover improved from Q3 2018 to Q4 2018 and from Q4 2018 to Q1 2019.

Net Fixed Asset Turnover

Occidental Petroleum Corp., net fixed asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data (USD $ in millions)
Net sales 4,004  4,762  5,216  4,083  3,763  3,492  2,999  3,060  2,957  2,788  2,648  2,531  2,123  2,806  3,116  3,469  3,089  4,307  4,904  5,133  4,968 
Property, plant and equipment, net of accumulated depreciation, depletion and amortization 31,900  31,437  31,155  30,432  31,344  31,174  32,065  31,466  32,005  32,337  30,419  31,038  31,505  31,639  36,835  40,478  40,109  39,730  58,465  57,134  56,044 
Ratio
Net fixed asset turnover1 0.57 0.57 0.53 0.47 0.42 0.40 0.37 0.36 0.34 0.31 0.33 0.34 0.37 0.39 0.38 0.39 0.43 0.49 — — —

Based on: 10-Q (filing date: 2019-05-06), 10-K (filing date: 2019-02-21), 10-Q (filing date: 2018-11-05), 10-Q (filing date: 2018-08-08), 10-Q (filing date: 2018-05-08), 10-K (filing date: 2018-02-23), 10-Q (filing date: 2017-11-01), 10-Q (filing date: 2017-08-02), 10-Q (filing date: 2017-05-04), 10-K (filing date: 2017-02-23), 10-Q (filing date: 2016-11-01), 10-Q (filing date: 2016-08-03), 10-Q (filing date: 2016-05-05), 10-K (filing date: 2016-02-26), 10-Q (filing date: 2015-10-30), 10-Q (filing date: 2015-08-04), 10-Q (filing date: 2015-05-06), 10-K (filing date: 2015-02-23), 10-Q (filing date: 2014-10-31), 10-Q (filing date: 2014-08-05), 10-Q (filing date: 2014-05-05).

Q1 2019 Calculations

1 Net fixed asset turnover = (Net salesQ1 2019 + Net salesQ4 2018 + Net salesQ3 2018 + Net salesQ2 2018) ÷ Property, plant and equipment, net of accumulated depreciation, depletion and amortization
= (4,004 + 4,762 + 5,216 + 4,083) ÷ 31,900 = 0.57

Ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Occidental Petroleum Corp.’s net fixed asset turnover improved from Q3 2018 to Q4 2018 but then slightly deteriorated from Q4 2018 to Q1 2019.

Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset)

Occidental Petroleum Corp., net fixed asset turnover (including operating lease, right-of-use asset) calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data (USD $ in millions)
Net sales 4,004  4,762  5,216  4,083  3,763  3,492  2,999  3,060  2,957  2,788  2,648  2,531  2,123  2,806  3,116  3,469  3,089  4,307  4,904  5,133  4,968 
 
Property, plant and equipment, net of accumulated depreciation, depletion and amortization 31,900  31,437  31,155  30,432  31,344  31,174  32,065  31,466  32,005  32,337  30,419  31,038  31,505  31,639  36,835  40,478  40,109  39,730  58,465  57,134  56,044 
Operating lease assets 684  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  — 
Property, plant and equipment, net of accumulated depreciation, depletion and amortization (including operating lease, right-of-use asset) 32,584  31,437  31,155  30,432  31,344  31,174  32,065  31,466  32,005  32,337  30,419  31,038  31,505  31,639  36,835  40,478  40,109  39,730  58,465  57,134  56,044 
Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1 0.55 0.57 0.53 0.47 0.42 0.40 0.37 0.36 0.34 0.31 0.33 0.34 0.37 0.39 0.38 0.39 0.43 0.49 — — —

Based on: 10-Q (filing date: 2019-05-06), 10-K (filing date: 2019-02-21), 10-Q (filing date: 2018-11-05), 10-Q (filing date: 2018-08-08), 10-Q (filing date: 2018-05-08), 10-K (filing date: 2018-02-23), 10-Q (filing date: 2017-11-01), 10-Q (filing date: 2017-08-02), 10-Q (filing date: 2017-05-04), 10-K (filing date: 2017-02-23), 10-Q (filing date: 2016-11-01), 10-Q (filing date: 2016-08-03), 10-Q (filing date: 2016-05-05), 10-K (filing date: 2016-02-26), 10-Q (filing date: 2015-10-30), 10-Q (filing date: 2015-08-04), 10-Q (filing date: 2015-05-06), 10-K (filing date: 2015-02-23), 10-Q (filing date: 2014-10-31), 10-Q (filing date: 2014-08-05), 10-Q (filing date: 2014-05-05).

Q1 2019 Calculations

1 Net fixed asset turnover (including operating lease, right-of-use asset) = (Net salesQ1 2019 + Net salesQ4 2018 + Net salesQ3 2018 + Net salesQ2 2018) ÷ Property, plant and equipment, net of accumulated depreciation, depletion and amortization (including operating lease, right-of-use asset)
= (4,004 + 4,762 + 5,216 + 4,083) ÷ 32,584 = 0.55

Ratio Description The company
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Occidental Petroleum Corp.’s net fixed asset turnover (including operating lease, right-of-use asset) improved from Q3 2018 to Q4 2018 but then slightly deteriorated from Q4 2018 to Q1 2019.

Total Asset Turnover

Occidental Petroleum Corp., total asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data (USD $ in millions)
Net sales 4,004  4,762  5,216  4,083  3,763  3,492  2,999  3,060  2,957  2,788  2,648  2,531  2,123  2,806  3,116  3,469  3,089  4,307  4,904  5,133  4,968 
Total assets 44,380  43,854  44,957  44,067  42,808  42,026  41,443  41,982  42,465  43,109  41,630  42,395  42,018  43,437  50,089  54,369  53,389  56,259  71,510  70,293  69,275 
Ratio
Total asset turnover1 0.41 0.41 0.37 0.33 0.31 0.30 0.28 0.27 0.26 0.23 0.24 0.25 0.27 0.29 0.28 0.29 0.33 0.34 — — —

Based on: 10-Q (filing date: 2019-05-06), 10-K (filing date: 2019-02-21), 10-Q (filing date: 2018-11-05), 10-Q (filing date: 2018-08-08), 10-Q (filing date: 2018-05-08), 10-K (filing date: 2018-02-23), 10-Q (filing date: 2017-11-01), 10-Q (filing date: 2017-08-02), 10-Q (filing date: 2017-05-04), 10-K (filing date: 2017-02-23), 10-Q (filing date: 2016-11-01), 10-Q (filing date: 2016-08-03), 10-Q (filing date: 2016-05-05), 10-K (filing date: 2016-02-26), 10-Q (filing date: 2015-10-30), 10-Q (filing date: 2015-08-04), 10-Q (filing date: 2015-05-06), 10-K (filing date: 2015-02-23), 10-Q (filing date: 2014-10-31), 10-Q (filing date: 2014-08-05), 10-Q (filing date: 2014-05-05).

Q1 2019 Calculations

1 Total asset turnover = (Net salesQ1 2019 + Net salesQ4 2018 + Net salesQ3 2018 + Net salesQ2 2018) ÷ Total assets
= (4,004 + 4,762 + 5,216 + 4,083) ÷ 44,380 = 0.41

Ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Occidental Petroleum Corp.’s total asset turnover improved from Q3 2018 to Q4 2018 and from Q4 2018 to Q1 2019.

Equity Turnover

Occidental Petroleum Corp., equity turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data (USD $ in millions)
Net sales 4,004  4,762  5,216  4,083  3,763  3,492  2,999  3,060  2,957  2,788  2,648  2,531  2,123  2,806  3,116  3,469  3,089  4,307  4,904  5,133  4,968 
Equity attributable to common stock 21,236  21,330  21,489  20,931  20,722  20,572  20,669  21,037  21,079  21,497  22,296  23,101  23,789  24,350  29,882  33,302  34,164  34,959  43,479  43,289  42,998 
Ratio
Equity turnover1 0.85 0.84 0.77 0.68 0.64 0.61 0.57 0.54 0.52 0.47 0.45 0.46 0.48 0.51 0.47 0.47 0.51 0.55 — — —

Based on: 10-Q (filing date: 2019-05-06), 10-K (filing date: 2019-02-21), 10-Q (filing date: 2018-11-05), 10-Q (filing date: 2018-08-08), 10-Q (filing date: 2018-05-08), 10-K (filing date: 2018-02-23), 10-Q (filing date: 2017-11-01), 10-Q (filing date: 2017-08-02), 10-Q (filing date: 2017-05-04), 10-K (filing date: 2017-02-23), 10-Q (filing date: 2016-11-01), 10-Q (filing date: 2016-08-03), 10-Q (filing date: 2016-05-05), 10-K (filing date: 2016-02-26), 10-Q (filing date: 2015-10-30), 10-Q (filing date: 2015-08-04), 10-Q (filing date: 2015-05-06), 10-K (filing date: 2015-02-23), 10-Q (filing date: 2014-10-31), 10-Q (filing date: 2014-08-05), 10-Q (filing date: 2014-05-05).

Q1 2019 Calculations

1 Equity turnover = (Net salesQ1 2019 + Net salesQ4 2018 + Net salesQ3 2018 + Net salesQ2 2018) ÷ Equity attributable to common stock
= (4,004 + 4,762 + 5,216 + 4,083) ÷ 21,236 = 0.85

Ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Occidental Petroleum Corp.’s equity turnover improved from Q3 2018 to Q4 2018 and from Q4 2018 to Q1 2019.