Microsoft Excel LibreOffice Calc

Long-term (Investment) Activity Analysis

Difficulty: Beginner


Ratios (Summary)

Exxon Mobil Corp., long-term (investment) activity ratios

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Net fixed asset turnover 0.94 0.90 1.03 1.56 1.73
Total asset turnover 0.68 0.66 0.77 1.13 1.21
Equity turnover 1.26 1.31 1.52 2.26 2.42

Source: Based on data from Exxon Mobil Corp. Annual Reports

Ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Exxon Mobil Corp.'s net fixed asset turnover deteriorated from 2015 to 2016 but then slightly improved from 2016 to 2017.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Exxon Mobil Corp.'s total asset turnover deteriorated from 2015 to 2016 but then slightly improved from 2016 to 2017.
Equity turnover An activity ratio calculated as total revenue divided by shareholders' equity. Exxon Mobil Corp.'s equity turnover deteriorated from 2015 to 2016 and from 2016 to 2017.

Net Fixed Asset Turnover

Exxon Mobil Corp., net fixed asset turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (USD $ in millions)
Sales and other operating revenue 237,162  218,608  259,488  394,105  420,836 
Property, plant and equipment, at cost, less accumulated depreciation and depletion 252,630  244,224  251,605  252,668  243,650 
Ratio
Net fixed asset turnover1 0.94 0.90 1.03 1.56 1.73
Benchmarks
Net Fixed Asset Turnover, Competitors
Chevron Corp. 0.76 0.60 0.69 1.09 1.34
ConocoPhillips 0.64 0.41 0.44 0.70 0.75
EOG Resources Inc. 0.44 0.30 0.36 0.62 0.55
Occidental Petroleum Corp. 0.40 0.31 0.39 0.49 0.44
Phillips 66 4.77 4.04 5.02 9.29 11.14
Net Fixed Asset Turnover, Sector
Oil & Gas Producers 0.95 0.81 0.93 1.42 1.57
Net Fixed Asset Turnover, Industry
Oil & Gas 0.96 0.82 0.95 1.42 1.55

Source: Based on data from Exxon Mobil Corp. Annual Reports

2017 Calculations

1 Net fixed asset turnover = Sales and other operating revenue ÷ Property, plant and equipment, at cost, less accumulated depreciation and depletion
= 237,162 ÷ 252,630 = 0.94

Ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Exxon Mobil Corp.'s net fixed asset turnover deteriorated from 2015 to 2016 but then slightly improved from 2016 to 2017.

Total Asset Turnover

Exxon Mobil Corp., total asset turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (USD $ in millions)
Sales and other operating revenue 237,162  218,608  259,488  394,105  420,836 
Total assets 348,691  330,314  336,758  349,493  346,808 
Ratio
Total asset turnover1 0.68 0.66 0.77 1.13 1.21
Benchmarks
Total Asset Turnover, Competitors
Chevron Corp. 0.53 0.42 0.49 0.75 0.87
ConocoPhillips 0.40 0.26 0.30 0.45 0.46
EOG Resources Inc. 0.38 0.26 0.32 0.52 0.47
Occidental Petroleum Corp. 0.30 0.23 0.29 0.34 0.35
Phillips 66 1.88 1.63 2.04 3.31 3.45
Total Asset Turnover, Sector
Oil & Gas Producers 0.66 0.57 0.66 0.97 1.04
Total Asset Turnover, Industry
Oil & Gas 0.60 0.52 0.61 0.89 0.96

Source: Based on data from Exxon Mobil Corp. Annual Reports

2017 Calculations

1 Total asset turnover = Sales and other operating revenue ÷ Total assets
= 237,162 ÷ 348,691 = 0.68

Ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Exxon Mobil Corp.'s total asset turnover deteriorated from 2015 to 2016 but then slightly improved from 2016 to 2017.

Equity Turnover

Exxon Mobil Corp., equity turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (USD $ in millions)
Sales and other operating revenue 237,162  218,608  259,488  394,105  420,836 
Total ExxonMobil share of equity 187,688  167,325  170,811  174,399  174,003 
Ratio
Equity turnover1 1.26 1.31 1.52 2.26 2.42
Benchmarks
Equity Turnover, Competitors
Chevron Corp. 0.91 0.76 0.85 1.29 1.48
ConocoPhillips 0.95 0.68 0.74 1.01 1.04
EOG Resources Inc. 0.69 0.55 0.68 1.02 0.94
Occidental Petroleum Corp. 0.61 0.47 0.51 0.55 0.57
Phillips 66 4.08 3.76 4.28 7.47 7.82
Equity Turnover, Sector
Oil & Gas Producers 1.23 1.12 1.27 1.86 1.99
Equity Turnover, Industry
Oil & Gas 1.17 1.04 1.20 1.73 1.91

Source: Based on data from Exxon Mobil Corp. Annual Reports

2017 Calculations

1 Equity turnover = Sales and other operating revenue ÷ Total ExxonMobil share of equity
= 237,162 ÷ 187,688 = 1.26

Ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders' equity. Exxon Mobil Corp.'s equity turnover deteriorated from 2015 to 2016 and from 2016 to 2017.