Signet Jewelers Limited - Financial Data.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Signet Jewelers Limited
2	in million
3	Fisacal Year (End of Jan.)	2009/01	2010/01	2011/01	2012/01	2013/01	2014/01	2015/01	2016/01	2017/01	2018/01	2019/01	2020/01	2021/01	2022/01

4	Revenue	3328.0	3273.6	3437.4	3749.2	3983.4	4209.2	5736.3	6550.2	6408.4	6253.0	6247.1	6137.1	5226.9	7826.0
5	Cost of Good	-2262.2	-2208.0	-2194.5	-2311.6	-2446.0	-2628.7	-3662.1	-4109.8	-4047.6	-4063.0	-4024.1	-3904.2	-3493.0	-4702.0
6	cost of sale - restructure charge											-62.2	-9.2	-1.4	0.0
7	Gross	1065.8	1065.6	1242.9	1437.6	1537.4	1580.5	2074.2	2440.4	2360.8	2190.0	2160.8	2223.7	1732.5	3124.0
8	Gross Margin	32.03%	32.55%	36.16%	38.34%	38.60%	37.55%	36.16%	37.26%	36.84%	35.02%	34.59%	36.23%	33.15%	39.92%
9	SGA	-969.20	-916.5	-980.4	-1056.7	-1138.3	-1196.7	-1712.9	-1987.6	-1880.2	-1872.2	-1985.1	-1918.2	-1587.4	-2230.9
10	Credit transaction. Net										1.3	-167.4
11	Restructure charge	-10.50										-63.7	-69.9	-46.2	3.3
12	Impairment	-516.90										-735.4	-47.7	-159.0	-1.5
13	Others	119.20	115.4	110	126.5	161.4	186.7	215.3	250.9	282.6	260.8	26.2	-29.6	2.4	8.5
14	OP Income	-311.6	264.5	372.5	507.4	560.5	570.5	576.6	703.7	763.2	579.9	-764.6	158.3	-57.7	903.4
15	OP margin	-9.4%	8.1%	10.8%	13.5%	14.1%	13.6%	10.1%	10.7%	11.9%	9.3%	-12.2%	2.6%	-1.1%	11.5%
16	Interest expense, net	-29.2	-34.0	-72.1	-5.3	-3.6	-4.0	-36.0	-45.9	-49.4	-52.7	-39.7	-35.6	-32.0	-16.9
17	Other non-operating income/(expense)											1.7	7.0	0.0	-2.1
18	Income before tax	-340.8	230.5	300.4	502.1	556.9	566.5	540.6	657.8	713.8	527.2	-802.6	129.7	-89.7	884.4
19	Incom tax	-61.8	-73.4	-100.0	-177.7	-197.0	-198.5	-159.3	-189.9	-170.6	-7.9	145.2	-24.2	74.5	-114.5
20	Income after tax	-402.6	157.1	200.4	324.4	359.9	368.0	381.3	467.9	543.2	519.3	-657.4	105.5	-15.2	769.9
21	Dividend on preferred shares									-11.9	-32.9	-32.9	-32.9	-33.5	-34.5
22	Net	-402.6	157.1	200.4	324.4	359.9	368.0	381.3	467.9	531.3	486.4	-690.3	72.6	-48.7	735.4
23		2009 OP income and Net were adjusted for $516.9 mln goodwill impairment and tax rate of 32%
24
25	Cash from operation	235.10	271.30	322.80	435.40	469.80	462.30	467.70	631.2	719.5	664.1	512.1	358.0	344.3	982.3
26	CapEx + Acquisition	139.4	113.3	55.6	97.8	190.9	160.4	1649.4	226.5	278.0	569.2	128.0	135.8	83.0	645.4
27	Free Cash Flow	95.7	158.0	267.2	337.6	278.9	301.9	-1181.7	404.7	441.5	94.9	384.1	222.2	261.3	336.9
28												Unpaid rent:		82.0
29												After adjustment:		179.3
30							Pandemic, adustment to include unpaid rent payment of $82 million.
31	As SIG's Merchandise Cost
32	Diamond	na	55%	50%	53%	45%	47%	45%	45%	45%	45%	na	na	na	na
33	Gold	na	20%	20%	17%	16%	15%	15%	14%	14%	14%	na	na	na	na
34
35	Invested Capital	2177.2	2121.7	1970.0	2279.1	2329.9	2582.4	4271.7	4448.9	3899.2	3232.0	1930.0	1834.1	1337.0	1711.1
36	ROIC		7.31%	9.80%	15.27%	15.62%	14.98%	11.13%	10.73%	12.73%	13.64%	-26.75%	3.86%	-3.07%	48.25%
37	Free cash flow return on invested capital		7.35%	13.06%	15.89%	12.10%	12.29%	-34.48%	9.28%	10.58%	2.66%	14.88%	11.81%	16.48%	22.11%
38
39	CEO Pay	4.185	5.293	13.159	7.657	3.769	2.383	5.401	7.400	6.009	13.554	8.896	9.222	12.185	12.953
40	% to Revenue	0.126%	0.162%	0.383%	0.204%	0.095%	0.057%	0.094%	0.113%	0.094%	0.217%	0.142%	0.150%	0.233%	0.166%
41	% to OP Income	-1.343%	2.001%	3.533%	1.509%	0.672%	0.418%	0.937%	1.052%	0.787%	2.337%	-1.164%	5.826%	-21.117%	1.434%
42	% to Net	-1.039%	3.369%	6.566%	2.360%	1.047%	0.648%	1.416%	1.582%	1.131%	2.787%	-1.289%	12.703%	-25.020%	1.761%
43			*Michael Barnes (Sept, 2010)				Mark Light (2014-)				Gina Drosos (Aug 2017-)
44
45	Executive Pay	8.993	13.665	19.342	15.922	12.033	10.378	12.839	15.374	12.092	21.437	16.218	18.809	23.310	26.017
46	% to Revenue	0.270%	0.417%	0.563%	0.425%	0.302%	0.247%	0.224%	0.235%	0.189%	0.343%	0.260%	0.306%	0.446%	0.332%
47	% to OP Income	-2.886%	5.166%	5.192%	3.138%	2.147%	1.819%	2.227%	2.185%	1.584%	3.697%	-2.121%	11.882%	-40.399%	2.880%
48	% to Net	-2.234%	8.698%	9.652%	4.908%	3.343%	2.820%	3.367%	3.286%	2.276%	4.407%	-2.349%	25.908%	-47.86%	3.538%
49
50	Director Pay	na	1.371	1.305	1.342	1.614	1.875	2.318	2.645	2.826	3.171	3.022	2.773	1.415	3.121
51	% to OP Income	#VALUE!	0.518%	0.350%	0.264%	0.288%	0.329%	0.402%	0.376%	0.370%	0.547%	-0.395%	1.752%	-2.452%	0.345%
52	% to Net	#VALUE!	0.873%	0.651%	0.414%	0.448%	0.510%	0.608%	0.565%	0.532%	0.652%	-0.438%	3.820%	-2.905%	0.424%
53
54	Fiscal Year
55	Share Repurchase (mn)	0.0	0.0	0.0	0.3	6.4	1.6	0.3	1.0	11.2	8.1	8.8	0.0	0.0	3.2
56	Amount (mn)				12.7	287.2	104.7	29.8	130.0	1000.0	460.0	485.0	0.0	0.0	261.8
57	Purchase price per share				$ 49.57	$ 44.70	$ 67.24	$ 103.37	$ 127.63	$ 89.10	$ 56.91	$ 56.91			$ 81.16
58	Price Range								$121-116	$121-78	$77-57	$57-39
59
60
61
62	US Jewelry + Watch Sale *
63	Calendar Year		2009	2010	2011	2012	2013	2014	2015	2016	2017
64	Billion		$ 58.80	$ 61.50	$ 67.30	$ 73.70	$ 76.90	$ 73.50	$ 75.00	$ 80.00	$ 91.00				Personal consumption expenditures: Durable goods: Jewelry and watches
65	SIG revenue to Industrial sale		5.57%	5.59%	5.57%	5.40%	5.47%	7.80%	8.73%	8.01%	6.87%
66	* According US Bureau of Economic Analysis
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100