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.

Price to FCFE (P/FCFE)

Microsoft Excel

Free Cash Flow to Equity (FCFE)

Royal Dutch Shell PLC, FCFE calculation

US$ in millions

Microsoft Excel
12 months ended: Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011 Dec 31, 2010
Net cash from operating activities 43,738 39,308 44,905 35,302 26,174
Capital expenditure (31,854) (40,145) (32,576) (26,301) (26,940)
Proceeds from sale of property, plant and equipment and businesses 9,873 1,212 6,346 6,990 3,325
Net increase (decrease) in debt with maturity period within three months (3,332) 3,126 (165) (3,724) 4,647
Other debt, new borrowings 7,778 9,146 5,108 1,249 7,849
Other debt, repayments (4,089) (6,877) (4,960) (4,649) (3,240)
Free cash flow to equity (FCFE) 22,114 5,770 18,658 8,867 11,815

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).

Item Description The company
FCFE Free cash flow to equity is the cash flow available to Royal Dutch Shell PLC equity holders after all operating expenses, interest, and principal payments have been paid and necessary investments in working and fixed capital have been made. Royal Dutch Shell PLC FCFE decreased from 2012 to 2013 but then increased from 2013 to 2014 exceeding 2012 level.

Price to FCFE Ratio, Current

Royal Dutch Shell PLC, current P/FCFE calculation, comparison to benchmarks

Microsoft Excel
No. shares of common stock outstanding 3,147,518,791
Selected Financial Data (US$)
Free cash flow to equity (FCFE) (in millions) 22,114
FCFE per share 7.03
Current share price (P) 58.66
Valuation Ratio
P/FCFE 8.35
Benchmarks
P/FCFE, Competitors1
Chevron Corp. 19.32
ConocoPhillips 13.67
Exxon Mobil Corp. 14.46
Marathon Petroleum Corp. 5.66
Occidental Petroleum Corp. 9.92
Valero Energy Corp. 6.90

Based on: 20-F (reporting date: 2014-12-31).

1 Click competitor name to see calculations.

If the company P/FCFE is lower then the P/FCFE of benchmark then company is relatively undervalued.
Otherwise, if the company P/FCFE is higher then the P/FCFE of benchmark then company is relatively overvalued.


Price to FCFE Ratio, Historical

Royal Dutch Shell PLC, historical P/FCFE calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011 Dec 31, 2010
No. shares of common stock outstanding1 3,147,518,791 3,147,708,179 3,152,936,738 3,110,041,956 3,077,101,258
Selected Financial Data (US$)
Free cash flow to equity (FCFE) (in millions)2 22,114 5,770 18,658 8,867 11,815
FCFE per share3 7.03 1.83 5.92 2.85 3.84
Share price1, 4 58.66 71.05 66.58 71.46 68.13
Valuation Ratio
P/FCFE5 8.35 38.76 11.25 25.06 17.74
Benchmarks
P/FCFE, Competitors6
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 Data adjusted for splits and stock dividends.

2 See details »

3 2014 Calculation
FCFE per share = FCFE ÷ No. shares of common stock outstanding
= 22,114,000,000 ÷ 3,147,518,791 = 7.03

4 Closing price as at the filing date of Royal Dutch Shell PLC Annual Report.

5 2014 Calculation
P/FCFE = Share price ÷ FCFE per share
= 58.66 ÷ 7.03 = 8.35

6 Click competitor name to see calculations.

Valuation ratio Description The company
P/FCFE Price to free cash flow to equity is cash valuation indicator of stockholders’ equity. Royal Dutch Shell PLC P/FCFE ratio increased from 2012 to 2013 but then decreased significantly from 2013 to 2014.