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.

Enterprise Value (EV)

Microsoft Excel

Current Enterprise Value (EV)

Royal Dutch Shell PLC, current enterprise value calculation

Microsoft Excel
Current share price (P) $58.66
No. shares of common stock outstanding 3,147,518,791
US$ in millions
Common equity (market value)1 184,633
Add: Non-controlling interest (per books) 820
Total equity 185,453
Add: Non-current debt (per books) 38,332
Add: Current debt (per books) 7,208
Total equity and debt 230,993
Less: Cash and cash equivalents 21,607
Enterprise value (EV) 209,386

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

1 Common equity (market value) = Share price × No. shares of common stock outstanding
= 58.66 × 3,147,518,791


Historical Enterprise Value (EV)

Royal Dutch Shell PLC, EV calculation

Microsoft Excel
Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011 Dec 31, 2010
Share price1, 2 $58.66 $71.05 $66.58 $71.46 $68.13
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
US$ in millions
Common equity (market value)3 184,633 223,645 209,923 222,244 209,643
Add: Non-controlling interest (book value) 820 1,101 1,433 1,486 1,767
Total equity 185,453 224,746 211,356 223,730 211,410
Add: Non-current debt (book value) 38,332 36,218 29,921 30,463 34,381
Add: Current debt (book value) 7,208 8,344 7,833 6,712 9,951
Total equity and debt 230,993 269,308 249,110 260,905 255,742
Less: Cash and cash equivalents 21,607 9,696 18,550 11,292 13,444
Enterprise value (EV) 209,386 259,612 230,560 249,613 242,298

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 Closing price as at the filing date of Royal Dutch Shell PLC Annual Report.

3 2014 Calculation
Common equity (market value) = Share price × No. shares of common stock outstanding
= 58.66 × 3,147,518,791

Item Description The company
EV Enterprise value is total company value (the market value of common equity, debt, and preferred equity) minus the value of cash and short-term investments. Royal Dutch Shell PLC EV increased from 2012 to 2013 but then decreased significantly from 2013 to 2014.