Stock Analysis on Net

Royal Dutch Shell PLC (NYSE:RDSA)

This company has been moved to the archive! The financial data has not been updated since March 12, 2015.

Analysis of Long-term (Investment) Activity Ratios

Microsoft Excel

Long-term Activity Ratios (Summary)

Royal Dutch Shell PLC, long-term (investment) activity ratios

Microsoft Excel
Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011 Dec 31, 2010
Net fixed asset turnover 2.19 2.35 2.71 3.09 2.58
Total asset turnover 1.19 1.26 1.30 1.36 1.14
Equity turnover 2.45 2.51 2.48 2.77 2.49

Based on: 20-F (reporting date: 2014-12-31), 20-F (reporting date: 2013-12-31), 20-F (reporting date: 2012-12-31), 20-F (reporting date: 2011-12-31), 20-F (reporting date: 2010-12-31).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Royal Dutch Shell PLC net fixed asset turnover ratio deteriorated from 2012 to 2013 and from 2013 to 2014.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Royal Dutch Shell PLC total asset turnover ratio deteriorated from 2012 to 2013 and from 2013 to 2014.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Royal Dutch Shell PLC equity turnover ratio improved from 2012 to 2013 but then deteriorated significantly from 2013 to 2014.

Net Fixed Asset Turnover

Royal Dutch Shell PLC, net fixed asset turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011 Dec 31, 2010
Selected Financial Data (US$ in millions)
Revenue 421,105 451,235 467,153 470,171 368,056
Property, plant and equipment 192,472 191,897 172,293 152,081 142,705
Long-term Activity Ratio
Net fixed asset turnover1 2.19 2.35 2.71 3.09 2.58
Benchmarks
Net Fixed Asset Turnover, Competitors2
Chevron Corp.
ConocoPhillips
Exxon Mobil Corp.
Marathon Petroleum Corp.
Occidental Petroleum Corp.
Valero Energy Corp.

Based on: 20-F (reporting date: 2014-12-31), 20-F (reporting date: 2013-12-31), 20-F (reporting date: 2012-12-31), 20-F (reporting date: 2011-12-31), 20-F (reporting date: 2010-12-31).

1 2014 Calculation
Net fixed asset turnover = Revenue ÷ Property, plant and equipment
= 421,105 ÷ 192,472 = 2.19

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Royal Dutch Shell PLC net fixed asset turnover ratio deteriorated from 2012 to 2013 and from 2013 to 2014.

Total Asset Turnover

Royal Dutch Shell PLC, total asset turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011 Dec 31, 2010
Selected Financial Data (US$ in millions)
Revenue 421,105 451,235 467,153 470,171 368,056
Total assets 353,116 357,512 360,325 345,257 322,560
Long-term Activity Ratio
Total asset turnover1 1.19 1.26 1.30 1.36 1.14
Benchmarks
Total Asset Turnover, Competitors2
Chevron Corp.
ConocoPhillips
Exxon Mobil Corp.
Marathon Petroleum Corp.
Occidental Petroleum Corp.
Valero Energy Corp.

Based on: 20-F (reporting date: 2014-12-31), 20-F (reporting date: 2013-12-31), 20-F (reporting date: 2012-12-31), 20-F (reporting date: 2011-12-31), 20-F (reporting date: 2010-12-31).

1 2014 Calculation
Total asset turnover = Revenue ÷ Total assets
= 421,105 ÷ 353,116 = 1.19

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Royal Dutch Shell PLC total asset turnover ratio deteriorated from 2012 to 2013 and from 2013 to 2014.

Equity Turnover

Royal Dutch Shell PLC, equity turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011 Dec 31, 2010
Selected Financial Data (US$ in millions)
Revenue 421,105 451,235 467,153 470,171 368,056
Equity attributable to Royal Dutch Shell plc shareholders 171,966 180,047 188,494 169,517 148,013
Long-term Activity Ratio
Equity turnover1 2.45 2.51 2.48 2.77 2.49
Benchmarks
Equity Turnover, Competitors2
Chevron Corp.
ConocoPhillips
Exxon Mobil Corp.
Marathon Petroleum Corp.
Occidental Petroleum Corp.
Valero Energy Corp.

Based on: 20-F (reporting date: 2014-12-31), 20-F (reporting date: 2013-12-31), 20-F (reporting date: 2012-12-31), 20-F (reporting date: 2011-12-31), 20-F (reporting date: 2010-12-31).

1 2014 Calculation
Equity turnover = Revenue ÷ Equity attributable to Royal Dutch Shell plc shareholders
= 421,105 ÷ 171,966 = 2.45

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Royal Dutch Shell PLC equity turnover ratio improved from 2012 to 2013 but then deteriorated significantly from 2013 to 2014.