Royal Dutch Shell (RDSB)

Company name:	Royal Dutch Shell Plc
Company Description:	A group engaged worldwide in the principal activities of the oil and natural gas industry. The group also has interests in chemicals as well as interests in power generation and renewable energy
EPIC:	RDSB	Trading Currency:	GBX
Market Sector:	FE10	ISIN:	GB00B03MM408
Market Segment:	SET1	Share Type:	DE
WWW Address:	http://www.shell.com/	Description:	'B' ORD EUR0.07
Industry Sector:	OIL & GAS PRODUCERS

Price	Price Change [%]	Bid	Offer	Open	High	Low	Volume
1,404.20	16.6 [1.20]	1,403.80	1,404.20	1,415.00	1,422.40	1,388.60	12,608,754
Market Cap. [m]	Shares In Issue [m]	Beta	EPS	DPS	PE Ratio	Yield	52-Wks-Range
52,042.23	3,706.18	1.33	-199.62	47.76	-	3.40	1,783.00 - 845.40

Royal Dutch Shell Key Figures

(at previous day's close)
Market Cap.	52,042.23	m
Shares In Issue	3,706.18	m
Prev. Close	1,387.60
PE Ratio	-
Dividend Yield	3.40	%
EPS - basic	-199.62	p
Dividend PS	47.76	p
Dividend Cover	-
Cash Flow PS	673.07	p
Return On Equity (ROE)	-1.40	%
Operating Margin	-14.94	%
PEG Factor	-
EPS Growth Rate	-241.12	%
Dividends PS Growth Rate	-65.27	%
Net Debt	138,165.09	m
Gross Gearing	58.20	%
Quick Assets	65,393.27	m
Net Working Capital	25,536.04	m
Intangibles / Fixed Assets	8.44	%
Turnover PS	3,563.03	p
Pre-Tax Profit PS	-532.18	p
Retained Profit PS	-189.30	p
Cash PS	628.17	p
Net Cash PS	-831.24	p
Net Tangible Asset Value PS *	2,614.66	p
Net Asset Value PS	3,128.74	p
Spread	0.40 (0.03%)
* Calculation based on Ordinary Capital figure as contained in last annual report, and the most recent shares in issue figure. Therefore the ratio might be exposed to inaccuracies.

Royal Dutch Shell Balance Sheet

Share Price Performance

Sample Period ^†	High	Low
1 week	1,462.60	1,332.40
4 weeks	1,462.60	1,227.00
12 weeks	1,462.60	1,227.00
1 year	1,783.00	845.40

Share Price Chart (5 years)

Royal Dutch Shell Historic Returns

Period ^†	Open	Change	%	Open Avg.	Avg. Daily Vol [m]	Total Vol [m]	VWAP
1 week	1,345.40	58.80	4.37	1,332.40	13.88		1,392.01
4 weeks	1,281.40	122.80	9.58	1,227.00	9.71		1,349.05
12 weeks	1,354.20	50.00	3.69	1,227.00	7.52		1,353.41
26 weeks	1,056.80	347.40	32.87	845.40	7.91		1,185.35
1 year	1,738.00	-333.80	-19.21	845.40	10.14		1,221.18
3 years	2,314.50	-910.30	-39.33	845.40	6.90		1,818.18
5 years	1,641.50	-237.30	-14.46	845.40	6.56		1,924.55
† periods calculated are whole weeks rather than calendar months

Royal Dutch Shell Key Management Ratios

Royal Dutch Shell Investment Ratios

(Market value analysis) at previous day's close
PQ Ratio	1.41
PE Ratio	-
Tobin's Q Ratio	0.13
Tobin's Q Ratio (excl. intangibles)	0.14
Dividend Yield	3.40	%
Market-to-Book Ratio	0.46
Price-to-Pre-Tax Profit PS	-2.64
Price-to-Retained Profit PS	-7.42
Price-to-Cash Flow PS	2.09
Price-to-Sales PS	0.39
Price-to-Net Tangible Asset Value PS	0.52
Price-to-Cash PS	2.24
Net Working Capital PS	689.01
Price Pct to Working Capital PS	2.04	%
Earnings Yield	-	%
Average PE	19.00
Years in average	4
PE to PE average	-	%

Royal Dutch Shell Financial Ratios

(Leverage Ratios)
Debt Ratio	48.07	%
Debt-to-Equity Ratio	0.93
Debt-to-Equity Ratio (excl. Intgbl)	1.08
Debt-to-Equity Market Value	2.06
Net Gearing	49.81	%
Net Gearing (excl. Intangibles)	53.00	%
Gross Gearing	58.20	%
Gross Gearing (excl. Intangibles)	61.93	%
Gearing Under 1 Year	19.50	%
Gearing Under 1 Year (excl. Intgbl)	20.75	%
Assets/Equity	2.39
Cash/Equity	20.08
(Liquidity Ratios)
Net Working Capital to Total Assets	9.21	%
Current Ratio	1.47
Quick Ratio (Acid Test)	1.21
Liquidity Ratio	0.43
Cash & Equiv/Current Assets	29.24	%
(Solvency Ratios)
Enterprise Value	138,479.16	m
CFO/Sales	0.19
CFO/Attributable Profit	-
CFO/Assets	0.09
CFO/Debt	0.15
Total Debt/Equity Market Value	3.10
Total Debt/Sales	1.22
Total Debt/Pre-Tax Profit	-8.19
Total Debt	161,446.16	m
Total Debt/Net Current Assets	6.32	%
(Dodds - Graham Ratios)
3 yr Compound Earnings Growth	-	%
5 yr Compound Earnings Growth	-	%
10 yr Compound Earnings Growth	-	%
Earn drops > 5% in 10yrs	11

Beta (60-Mnth)	Beta (36-Mnth)
1.3263	1.5525

Royal Dutch Shell Operating Ratios

(Profitability Ratios)
Return On Capital Employed (ROCE)	-8.83	%
Return On Assets (ROA)	-0.40	%
Net Profit Margin	-1.20	%
Assets Turnover	0.34
Return On Equity (ROE)	-1.40	%
Return On Investment (ROI)	-0.50	%
Dividend Payout Ratio	-	%
Plowback Ratio	100.00	%
Growth from Plowback Ratio	-	%
Net Income Of Revenues	-5.31	%
(Asset Utilisation Multiples)
Shareholders Equity Turnover	0.77
Fixed Assets Turnover	0.46
Current Assets Turnover	1.24
Net Working Capital Turnover
Inventory Turnover	6.07
(Other Operating Ratios)
Total Assets-to-Sales	2.97
Debtors-to-Sales	45.28	%
Debt Collection Period	165.29	Days

Royal Dutch Shell Dividends

Announcement Date	Type	Curr.	Dividend Amount	Period Start	Period End	Ex Date	Record Date	Payment Date	Total Dividend Amount
04 Feb 2021	Final	USX	16.65	31/12/2019	31/12/2020	18/02/2021	19/02/2021	29/03/2021	65.30
29 Oct 2020	Quarterly	USX	16.65	31/12/2019	31/12/2020	12/11/2020	13/11/2020	16/12/2020	-
30 Jul 2020	Quarterly	USX	16.00	31/12/2019	31/12/2020	13/08/2020	14/08/2020	21/09/2020	-
30 Apr 2020	Quarterly	USX	16.00	31/12/2019	31/12/2020	14/05/2020	15/05/2020	22/06/2020	-
30 Jan 2020	Final	USX	47.00	31/12/2018	31/12/2019	13/02/2020	14/02/2020	23/03/2020	188.00
31 Oct 2019	Quarterly	USX	47.00	31/12/2018	31/12/2019	14/11/2019	15/11/2019	18/12/2019	-
01 Aug 2019	Quarterly	USX	47.00	31/12/2018	31/12/2019	15/08/2019	16/08/2019	23/09/2019	-
02 May 2019	Quarterly	USX	47.00	31/12/2018	31/12/2019	16/05/2019	17/05/2019	24/06/2019	-
04 Feb 2019	Final	USX	47.00	31/12/2017	31/12/2018	14/02/2019	15/02/2019	25/03/2019	188.00
01 Nov 2018	Quarterly	USX	47.00	31/12/2017	31/12/2018	15/11/2018	16/11/2018	19/12/2018	-
26 Jul 2018	Quarterly	USX	47.00	31/12/2017	31/12/2018	09/08/2018	10/08/2018	17/09/2018	-
26 Apr 2018	Quarterly	USX	47.00	31/12/2017	31/12/2018	10/05/2018	11/05/2018	18/06/2018	-
01 Feb 2018	Final	USX	47.00	31/12/2016	31/12/2017	15/02/2018	16/02/2018	26/03/2018	188.00
02 Nov 2017	Quarterly	USX	47.00	31/12/2016	31/12/2017	16/11/2017	17/11/2017	20/12/2017	-
27 Jul 2017	Quarterly	USX	47.00	31/12/2016	31/12/2017	10/08/2017	11/08/2017	18/09/2017	-
04 May 2017	Quarterly	USX	47.00	31/12/2016	31/12/2017	18/05/2017	19/05/2017	26/06/2017	-
02 Feb 2017	Final	USX	47.00	31/12/2015	31/12/2016	16/02/2017	17/02/2017	27/03/2017	188.00
01 Nov 2016	Quarterly	USX	47.00	31/12/2015	31/12/2016	01/11/2016	11/11/2016	16/12/2016	-
28 Jul 2016	Quarterly	USX	47.00	31/12/2015	31/12/2016	11/08/2016	12/08/2016	19/09/2016	-
04 May 2016	Quarterly	USX	47.00	31/12/2015	31/12/2016	19/05/2016	20/05/2016	27/06/2016	-
04 Feb 2016	Final	USX	47.00	31/12/2014	31/12/2015	18/02/2016	19/02/2016	29/03/2016	188.00
29 Oct 2015	Quarterly	USX	47.00	31/12/2014	31/12/2015	12/11/2015	13/11/2015	18/12/2015	-
30 Jul 2015	Quarterly	USX	47.00	31/12/2014	31/12/2015	13/08/2015	14/08/2015	21/09/2015	-
30 Apr 2015	Quarterly	USX	47.00	31/12/2014	31/12/2015	14/05/2015	15/05/2015	22/06/2015	-
29 Jan 2015	Final	USX	47.00	31/12/2013	31/12/2014	12/02/2015	13/02/2015	20/03/2015	188.00
30 Oct 2014	Quarterly	USX	47.00	31/12/2013	31/12/2014	13/11/2014	14/11/2014	22/12/2014	-
31 Jul 2014	Quarterly	USX	47.00	31/12/2013	31/12/2014	13/08/2014	15/08/2014	25/09/2014	-
30 Apr 2014	Quarterly	USX	47.00	31/12/2013	31/12/2014	14/05/2014	16/05/2014	26/06/2014	-
30 Jan 2014	Final	USX	45.00	31/12/2012	31/12/2013	12/02/2014	14/02/2014	27/03/2014	180.00
31 Oct 2013	Quarterly	USX	45.00	31/12/2012	31/12/2013	13/11/2013	15/11/2013	23/12/2013	-
01 Aug 2013	Quarterly	USX	45.00	31/12/2012	31/12/2013	14/08/2013	16/08/2013	26/09/2013	-
02 May 2013	Quarterly	USX	45.00	31/12/2012	31/12/2013	15/05/2013	17/05/2013	27/06/2013	-
31 Jan 2013	Final	USX	43.00	31/12/2011	31/12/2012	13/02/2013	15/02/2013	28/03/2013	172.00
01 Nov 2012	Quarterly	USX	43.00	31/12/2011	31/12/2012	14/11/2012	16/11/2012	20/12/2012	-
26 Jul 2012	Quarterly	USX	43.00	31/12/2011	31/12/2012	08/08/2012	10/08/2012	20/09/2012	-
26 Apr 2012	Quarterly	USX	43.00	31/12/2011	31/12/2012	09/05/2012	11/05/2012	21/06/2012	-
02 Feb 2012	Final	USX	42.00	31/12/2010	31/12/2011	15/02/2012	17/02/2012	22/03/2012	168.00
27 Oct 2011	Quarterly	USX	42.00	31/12/2010	31/12/2011	02/11/2011	04/11/2011	16/12/2011	-
28 Jul 2011	Quarterly	USX	42.00	31/12/2010	31/12/2011	03/08/2011	05/08/2011	19/09/2011	-
28 Apr 2011	Quarterly	USX	42.00	31/12/2010	31/12/2011	11/05/2011	13/05/2011	27/06/2011	-
03 Feb 2011	Final	USX	42.00	31/12/2009	31/12/2010	09/02/2011	11/02/2011	25/03/2011	168.00
28 Oct 2010	Quarterly	USX	42.00	31/12/2009	31/12/2010	03/11/2010	05/11/2010	17/12/2010	-
29 Jul 2010	Quarterly	USX	42.00	31/12/2009	31/12/2010	04/08/2010	06/08/2010	08/09/2010	-
28 Apr 2010	Quarterly	USX	42.00	31/12/2009	31/12/2010	05/05/2010	07/05/2010	09/06/2010	-
04 Feb 2010	Final	USX	42.00	31/12/2008	31/12/2009	04/02/2010	06/02/2010	11/03/2010	168.00
29 Oct 2009	Quarterly	USX	42.00	31/12/2008	31/12/2009	04/11/2009	06/11/2009	09/12/2009	-
30 Jul 2009	Quarterly	USX	42.00	31/12/2008	31/12/2009	05/08/2009	07/08/2009	09/09/2009	-
29 Apr 2009	Quarterly	USX	42.00	31/12/2008	31/12/2009	06/05/2009	08/05/2009	10/06/2009	-
29 Jan 2009	Final	USX	40.00	31/12/2007	31/12/2008	04/02/2009	06/02/2009	11/03/2009	160.00
30 Oct 2008	Quarterly	USX	40.00	31/12/2007	31/12/2008	05/11/2008	07/11/2008	10/12/2008	-
31 Jul 2008	Quarterly	USX	40.00	31/12/2007	31/12/2008	06/08/2008	08/08/2008	10/09/2008	-
28 Apr 2008	Quarterly	USX	40.00	31/12/2007	31/12/2008	14/05/2008	16/05/2008	11/06/2008	-
31 Jan 2008	Final	USX	36.00	31/12/2006	31/12/2007	06/02/2008	08/02/2008	12/03/2008	144.00
25 Oct 2007	Quarterly	USX	36.00	31/12/2006	31/12/2007	31/10/2007	02/11/2007	12/12/2007	-
26 Jul 2007	Quarterly	USX	36.00	31/12/2006	31/12/2007	01/08/2007	03/08/2007	12/09/2007	-
03 May 2007	Quarterly	USX	36.00	31/12/2006	31/12/2007	09/05/2007	11/05/2007	13/06/2007	-
01 Feb 2007	Final	USX	32.50	31/12/2005	31/12/2006	07/02/2007	09/02/2007	14/03/2007	128.50
26 Oct 2006	Quarterly	USX	32.00	31/12/2005	31/12/2006	01/11/2006	03/11/2006	13/12/2006	-
27 Jul 2006	Quarterly	USX	32.00	31/12/2005	31/12/2006	02/08/2006	04/08/2006	13/09/2006	-
04 May 2006	Quarterly	USX	32.00	31/12/2005	31/12/2006	10/05/2006	12/05/2006	14/06/2006	-
02 Feb 2006	Final	USX	27.80	31/12/2004	31/12/2005	08/02/2006	10/02/2006	15/03/2006	111.07
27 Oct 2005	Quarterly	USX	27.78	31/12/2004	31/12/2005	02/11/2005	04/11/2005	15/12/2005	-
28 Jul 2005	Quarterly	USX	27.69	31/12/2004	31/12/2005	03/08/2005	05/08/2005	15/09/2005	-
28 Apr 2005	Quarterly	USX	27.80	31/12/2004	31/12/2005	11/05/2005	13/05/2005	15/06/2005	-
03 Feb 2005	Final	USX	10.70	31/12/2003	31/12/2004	09/02/2005	11/02/2005	15/03/2005	16.95
29 Jul 2004	Interim	USX	6.25	30/12/2003	30/06/2004	11/08/2004	13/08/2004	15/09/2004	-
05 Feb 2004	Final	USX	9.65	31/12/2002	31/12/2003	31/03/2004	02/04/2004	06/05/2004	15.75
24 Jul 2003	Interim	USX	6.10	30/12/2002	30/06/2003	13/08/2003	15/08/2003	17/09/2003	-
06 Feb 2003	Final	USX	9.30	31/12/2001	31/12/2002	02/04/2003	04/04/2003	06/05/2003	15.25
01 Aug 2002	Interim	USX	5.95	30/12/2001	30/06/2002	14/08/2002	16/08/2002	18/09/2002	-
07 Feb 2002	Final	USX	8.95	31/12/2000	31/12/2001	17/04/2002	19/04/2002	22/05/2002	14.80
02 Aug 2001	Interim	USX	5.85	30/12/2000	30/06/2001	15/08/2001	17/08/2001	19/09/2001	-
08 Feb 2001	Final	USX	8.90	31/12/1999	31/12/2000	18/04/2001	20/04/2001	23/05/2001	14.60
03 Aug 2000	Interim	USX	5.70	30/12/1999	30/06/2000	14/08/2000	18/08/2000	20/09/2000	-
10 Feb 2000	Final	USX	8.50	31/12/1998	31/12/1999	10/04/2000	14/04/2000	16/05/2000	14.00
05 Aug 1999	Interim	USX	5.50	30/12/1998	30/06/1999	27/09/1999	01/10/1999	01/11/1999	-
11 Feb 1999	Final	USX	8.20	31/12/1997	31/12/1998	19/04/1999	23/04/1999	14/05/1999	13.50
10 Sep 1998	Interim	USX	5.30	30/12/1997	30/06/1998	28/09/1998	02/10/1998	02/11/1998	-
12 Feb 1998	Final	USX	8.00	31/12/1996	31/12/1997	20/04/1998	24/04/1998	15/05/1998	13.10

Royal Dutch Shell Fundamentals

	31 Dec 2017 (USD)		31 Dec 2018 (USD)		31 Dec 2019 (USD)		31 Dec 2020 (USD)
turnover	305,179.00	100.00%	388,179.00	100.00%	344,877.01	100.00%	180,543.00	100.00%	m
pre tax profit	18,130.00	5.94%	35,621.00	9.18%	25,486.00	7.39%	-26,966.00	-14.94%	m
attributable profit	12,977.00	4.25%	23,352.00	6.02%	15,843.00	4.59%	-2,168.00	-1.20%	m
retained profit	2,100.00	0.69%	7,677.00	1.98%	645.00	0.19%	-9,592.00	-5.31%	m
eps - basic	158.00		282.00		197.00		-278.00
eps - diluted	156.00		280.00		195.00		-278.00
dividends per share	188.00		188.00		188.00		65.30

Royal Dutch Shell Balance Sheet

	31 Dec 2017 (USD)		31 Dec 2018 (USD)		31 Dec 2019 (USD)		31 Dec 2020 (USD)


	31 Dec 2017 (USD)		31 Dec 2018 (USD)		31 Dec 2019 (USD)		31 Dec 2020 (USD)
ASSETS
fixed assets	226,380.01	55.61%	223,175.00	55.91%	238,348.99	58.95%	210,847.01	55.59%	m
intangibles	24,180.00	5.94%	23,586.00	5.91%	23,486.00	5.81%	22,822.00	6.02%	m
fixed investments	37,948.00	9.32%	42,221.00	10.58%	38,352.00	9.49%	36,735.00	9.69%	m
current assets - other	-	-%	-	-%	-	-%	-	-%	m
stocks	25,223.00	6.20%	21,117.00	5.29%	24,071.00	5.95%	19,457.00	5.13%	m
debtors	73,054.00	17.95%	62,354.00	15.62%	62,024.00	15.34%	57,576.00	15.18%	m
cash & securities	20,312.00	4.99%	26,741.00	6.70%	18,054.00	4.47%	31,830.00	8.39%	m

TOTAL	407,097.01	100%	399,194.00	100%	404,335.99	100%	379,267.01	100%	m

LIABILITIES
creditors - short	79,767.00	19.59%	77,813.00	19.49%	79,624.00	19.69%	73,950.00	19.50%	m
creditors - long	129,518.00	31.82%	118,847.00	29.77%	134,249.00	33.20%	146,780.00	38.70%	m
creditors - other	-	-%	-	-%	-	-%	-	-%	m
subordinated loans	-	-%	-	-%	-	-%	-	-%	m
insurance funds	-	-%	-	-%	-	-%	-	-%	m

TOTAL	209,285.01	51.41%	196,659.99	49.26%	213,873.00	52.89%	220,730.00	58.20%	m

EQUITY
ord cap, reserves	194,356.00	47.74%	198,646.01	49.76%	186,476.00	46.12%	155,310.00	40.95%	m
prefs, minorities	3,456.00	0.85%	3,888.00	0.97%	3,987.00	0.99%	3,227.00	0.85%	m

TOTAL	197,812.00	48.59%	202,534.01	50.74%	190,463.00	47.11%	158,537.00	41.80%	m

OTHER
NAV Basic	-		-		-		-
NAV Diluted	-		-		-		-

Royal Dutch Shell Cash Flow Statement

	31 Dec 2017 (USD)	31 Dec 2018 (USD)	31 Dec 2019 (USD)	31 Dec 2020 (USD)
Operating CF	35,650.00	53,085.00	42,179.00	34,105.00	m
Pre-Financing CF	27,621.00	27,621.00	26,400.00	20,828.00	m
Retained CF	1,182.00	1,182.00	-8,687.00	13,775.00	m

Royal Dutch Shell Brokers

Name	Activity	Type	Mnemonic	Code
Evolution Securities Limited	Market Maker(MME)	Broker/Dealer	EVO	EVBGGB21MMT
Nyenburgh Holding B.V.	Market Maker(MME)	Broker/Dealer	NYBB	NYENNL2B
Winterflood Securities Ltd	Market Maker(MME)	Broker/Dealer	WINS	WNTSGB2LBIC