RDSA

Royal Dutch Shell (RDSA)

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
COD:	RDSA	Trading Currency:	GBX
Market Sector:	FE10	ISIN:	GB00B03MLX29
Market Segment:	SET1	Share Type:	DE
WWW Address:	http://www.shell.com/	Description:	'A' ORD EUR0.07
Industry Sector:	OIL & GAS PRODUCERS

Price	Variação [%]	Bid	Offer	Abertura	MAX	MIN	Volume
1,747.20	-60.2 [-3.33]	1,748.60	1,749.00	1,798.40	1,815.80	1,733.80	12,394,357
Market Cap. [m]	Shares In Issue [m]	Beta	EPS	DPS	PE Ratio	Yield	52 Semanas
71,656.86	4,101.24	1.14	-205.15	47.76	-	2.73	1,889.40 - 1,289.40

Royal Dutch Shell Key Figures

Key Figures
(at previous day's close)
Market Cap.	71,656.86	m
Shares In Issue	4,101.24	m
Prev. Close	1,807.40
PE Ratio	-
Dividend Yield	2.73	%
EPS - basic	-205.15	p
Dividend PS	47.76	p
Dividend Cover	-
Cash Flow PS	608.23	p
Return On Equity (ROE)	-13.87	%
Operating Margin	-149.36	%
PEG Factor	-
EPS Growth Rate	-241.12	%
Dividends PS Growth Rate	-65.27	%
Dívida Líquida	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	321.98	p
Pre-Tax Profit PS	-480.91	p
Retained Profit PS	-516.44	p
Cash PS	567.66	p
Net Cash PS	-751.17	p
Net Tangible Asset Value PS *	2,362.80	p
Net Asset Value PS	2,827.36	p
Spread	0.40 (0.02%)
* 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

%1$s Balance Sheet

Share Price Performance

Share Price Performance
Sample Period ^†	MAX	MIN
1 Semana	1,889.40	1,733.80
4 Semanas	1,889.40	1,607.20
12 Semanas	1,889.40	1,534.20
1 Ano	1,889.40	1,289.40

Share Price Chart (5 years)

Royal Dutch Shell Historic Returns

%1$s Historic Returns
Período ^†	Abertura	VAB	%	Abertura Média	Vol Diário Médio [m]	Volume [m]	VWAP
1 Semana	1,822.80	-75.60	-4.15	1,733.80	6.91		1,847.57
4 Semanas	1,646.00	101.20	6.15	1,607.20	6.87		1,776.54
12 Semanas	1,676.20	71.00	4.24	1,534.20	8.68		1,680.50
26 Semanas	1,354.60	392.60	28.98	1,349.80	7.35		1,615.86
1 Ano	1,420.80	326.40	22.97	1,289.40	8.18		1,499.21
3 Anos	2,257.00	-509.80	-22.59	878.30	8.70		1,705.80
5 Anos	2,203.00	-455.80	-20.69	878.30	7.77		1,909.06
† periods calculated are whole weeks rather than calendar months

Royal Dutch Shell Key Management Ratios

DEEPER ANALYSIS

Royal Dutch Shell Investment Ratios

%1$s Investment Ratios
(Market value analysis) at previous day's close
PQ Ratio	1.94
PE Ratio	-
Tobin's Q Ratio	0.18
Tobin's Q Ratio (excl. intangibles)	0.19
Dividend Yield	2.73	%
Market-to-Book Ratio	0.63
Price-to-Pre-Tax Profit PS	-3.63
Price-to-Retained Profit PS	-3.38
Price-to-Cash Flow PS	2.87
Price-to-Sales PS	5.43
Price-to-Net Tangible Asset Value PS	0.72
Price-to-Cash PS	3.08
Net Working Capital PS	622.64
Price Pct to Working Capital PS	2.81	%
Earnings Yield	-	%
Average PE	18.44
Years in average	4
PE to PE average	-	%

Royal Dutch Shell Financial Ratios

%1$s 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	1.50
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	158,093.78	m
CFO/Sales	1.89
CFO/Attributable Profit	-
CFO/Assets	0.09
CFO/Debt	0.15
Total Debt/Equity Market Value	2.25
Total Debt/Sales	12.23
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 coefficients
Beta (60-Mnth)	Beta (36-Mnth)
1.1388	0.9366

Royal Dutch Shell Operating Ratios

%1$s Operating Ratios
(Profitability Ratios)
Return On Capital Employed (ROCE)	-8.83	%
Return On Assets (ROA)	-4.02	%
Net Profit Margin	-119.27	%
Assets Turnover	0.03
Return On Equity (ROE)	-13.87	%
Return On Investment (ROI)	-5.00	%
Dividend Payout Ratio	-	%
Plowback Ratio	100.00	%
Growth from Plowback Ratio	-	%
Net Income Of Revenues	-160.39	%
(Asset Utilisation Multiples)
Shareholders Equity Turnover	0.08
Fixed Assets Turnover	0.05
Current Assets Turnover	0.12
Net Working Capital Turnover
Inventory Turnover	0.61
(Other Operating Ratios)
Total Assets-to-Sales	29.67
Debtors-to-Sales	452.85	%
Debt Collection Period	1,652.90	Dias

Royal Dutch Shell Dividends

%1$s Dividends
Data	Type	Curr.	Dividend Amount	Period Start	Period End	Ex Date	Record Date	Payment Date	Total Dividend Amount
29 Jul 2021	Quarterly	USX	24.00	31/12/2020	31/12/2021	12/08/2021	13/08/2021	20/09/2021	-
29 Abr 2021	Quarterly	USX	17.35	31/12/2020	31/12/2021	13/05/2021	14/05/2021	21/06/2021	-
04 Fev 2021	Final	USX	16.65	31/12/2019	31/12/2020	18/02/2021	19/02/2021	29/03/2021	65.30
29 Out 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 Abr 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 Out 2019	Quarterly	USX	47.00	31/12/2018	31/12/2019	14/11/2019	15/11/2019	18/12/2019	-
01 Ago 2019	Quarterly	USX	47.00	31/12/2018	31/12/2019	15/08/2019	16/08/2019	23/09/2019	-
02 Mai 2019	Quarterly	USX	47.00	31/12/2018	31/12/2019	16/05/2019	17/05/2019	24/06/2019	-
31 Jan 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 Abr 2018	Quarterly	USX	47.00	31/12/2017	31/12/2018	10/05/2018	11/05/2018	18/06/2018	-
01 Fev 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 Mai 2017	Quarterly	USX	47.00	31/12/2016	31/12/2017	18/05/2017	19/05/2017	26/06/2017	-
02 Fev 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	10/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 Mai 2016	Quarterly	USX	47.00	31/12/2015	31/12/2016	19/05/2016	20/05/2016	27/06/2016	-
04 Fev 2016	Final	USX	47.00	31/12/2014	31/12/2015	18/02/2016	19/02/2016	29/03/2016	188.00
29 Out 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 Abr 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 Out 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 Abr 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 Out 2013	Quarterly	USX	45.00	31/12/2012	31/12/2013	13/11/2013	15/11/2013	23/12/2013	-
01 Ago 2013	Quarterly	USX	45.00	31/12/2012	31/12/2013	14/08/2013	16/08/2013	26/09/2013	-
02 Mai 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 Abr 2012	Quarterly	USX	43.00	31/12/2011	31/12/2012	09/05/2012	11/05/2012	21/06/2012	-
02 Fev 2012	Final	USX	42.00	31/12/2010	31/12/2011	15/02/2012	17/02/2012	22/03/2012	168.00
27 Out 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 Abr 2011	Quarterly	USX	42.00	31/12/2010	31/12/2011	11/05/2011	13/05/2011	27/06/2011	-
03 Fev 2011	Final	USX	42.00	31/12/2009	31/12/2010	09/02/2011	11/02/2011	25/03/2011	168.00
28 Out 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 Abr 2010	Quarterly	USX	42.00	31/12/2009	31/12/2010	05/05/2010	07/05/2010	09/06/2010	-
04 Fev 2010	Final	USX	42.00	31/12/2008	31/12/2009	04/02/2010	06/02/2010	11/03/2010	168.00
29 Out 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 Abr 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
31 Out 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	-
29 Abr 2008	Quarterly	USX	40.00	31/12/2007	31/12/2008	14/05/2008	16/05/2008	11/06/2008	-
31 Mar 2008	Final	USX	36.00	31/12/2006	31/12/2007	06/02/2008	08/02/2008	12/03/2008	144.00
01 Fev 2007	Final	USX	25.00	31/12/2005	31/12/2006	07/02/2007	09/02/2007	14/03/2007	100.00
26 Out 2006	Quarterly	USX	25.00	31/12/2005	31/12/2006	01/11/2006	03/11/2006	13/12/2006	-
27 Jul 2006	Quarterly	USX	25.00	31/12/2005	31/12/2006	02/08/2006	04/08/2006	13/09/2006	-
04 Mai 2006	Quarterly	USX	25.00	31/12/2005	31/12/2006	10/05/2006	12/05/2006	14/06/2006	-
11 Out 2005	Quarterly	USX	23.00	30/05/2005	30/09/2005	02/11/2005	04/11/2005	15/12/2005	-
04 Ago 2005	Quarterly	USX	23.00	02/03/2005	30/06/2005	03/08/2005	05/08/2005	15/09/2005	-

Royal Dutch Shell Fundamentals

Profit and Loss Account
	31 Dez 2017 (USD)		31 Dez 2018 (USD)		31 Dez 2019 (USD)		31 Dez 2020 (USD)
turnover	305,179.00	100.00%	388,179.00	100.00%	344,877.01	100.00%	18,054.30	100.00%	m
pre tax profit	18,130.00	5.94%	35,621.00	9.18%	25,486.00	7.39%	-26,966.00	-149.36%	m
attributable profit	12,977.00	4.25%	23,352.00	6.02%	15,843.00	4.59%	-21,534.00	-119.27%	m
retained profit	2,100.00	0.69%	7,677.00	1.98%	645.00	0.19%	-28,958.00	-160.39%	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

Balance Sheet
	31 Dez 2017 (USD)		31 Dez 2018 (USD)		31 Dez 2019 (USD)		31 Dez 2020 (USD)


	31 Dez 2017 (USD)		31 Dez 2018 (USD)		31 Dez 2019 (USD)		31 Dez 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

%1$s Cash Flow Statement
	31 Dez 2017 (USD)	31 Dez 2018 (USD)	31 Dez 2019 (USD)	31 Dez 2020 (USD)
Operating CF	35,650.00	53,085.00	42,179.00	34,105.00	m
Pre-Financing CF	27,621.00	39,426.00	26,400.00	20,828.00	m
Retained CF	1,182.00	6,429.00	-8,687.00	13,775.00	m

Royal Dutch Shell Brokers

%1$s 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