SHERWIN-WILLIAMS CO CEDEAR EACH 69 REPR 1 COM (USD) Financial Ratios — SHWD

Profitability (USD)

	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
As of date	12/31/2011	12/31/2012	12/31/2013	12/31/2014	12/31/2015	12/31/2016	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024	12/31/2025

Return on Common Equity (%)	32.14	41.42	43.95	63.42	113.05	82.49	62.53	30.05	39.25	52.51	61.65	72.94	70.07	69.05	59.39
Return on Assets (%)	8.5	11.01	11.93	14.33	18.36	18.08	12.97	5.68	7.78	9.93	9.08	9.34	10.49	11.51	10.37
Return on Capital (%)	18.09	22	22.77	28.93	39.05	37.36	- -	10.33	13.13	16.3	15.49	15.75	17.4	19.08	17.47
Return on Invested Capital (%)	15.79	19.33	20.43	25.08	33.92	32.62	- -	10.03	12.29	15.38	14.46	15.07	16.52	17.71	16.56
Gross Margin (%)	42.72	44.12	45.32	46.4	49.03	49.94	44.84	42.31	44.89	47.29	42.83	42.1	46.67	48.47	48.85
EBITDA Margin (%)	10.91	11.71	13.1	13.5	16	16.28	14.57	13.33	15.91	18.63	15.71	16.18	18.12	19.2	19.05
Operating Margin (%)	8.84	9.86	11.31	11.73	14.24	14.45	11.34	10.78	13.55	15.54	13.36	13.55	15.64	16.29	16.11
Incremental Operating Margin (%)	2.91	21.49	32.53	16.3	147.38	18.99	- -	7.5	146.06	93.04	- -	15.24	67.09	333.69	7.31
Pretax Margin (%)	8.46	9.52	10.66	11.31	13.66	13.46	9.81	7.75	11.07	13.72	11.27	11.62	13.49	14.94	14.16
Profit Margin (%)	5.04	6.62	7.39	7.78	9.29	9.55	11.53	6.32	8.61	11.06	9.35	9.12	10.36	11.61	10.9
Net Income to Common Margin (%)	5.04	6.62	7.39	7.78	9.29	9.55	11.53	6.32	8.61	11.06	9.35	9.12	10.36	11.61	10.9
Effective Tax Rate (%)	40.41	30.45	30.7	31.18	31.96	28.99	- -	18.46	22.23	19.4	17.09	21.49	23.19	22.32	23.06
Dvd Payout Ratio (%)	34.74	25.5	27.24	24.86	23.69	27.55	18.03	29.12	27.3	24.03	31.49	30.62	26.11	26.98	30.75
Sustainable Growth Rate (%)	20.98	30.85	31.98	47.65	86.27	59.76	51.26	21.3	28.53	39.89	42.24	50.61	51.78	50.42	41.13

Credit (USD)

Credit Ratios API ChatGPT

	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
As of date	12/31/2011	12/31/2012	12/31/2013	12/31/2014	12/31/2015	12/31/2016	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024	12/31/2025

Total Debt	993	1,705	1,722	1,799	1,950	1,953	10,521	9,344	10,428	10,114	11,495	12,508	11,810	11,913	12,943
ST Debt	354	73	599	683	43	741	635	636	1,006	413	1,434	1,404	1,922	2,178	2,030
LT Debt	639	1,632	1,122	1,116	1,907	1,211	9,886	8,708	9,421	9,701	10,062	11,104	9,887	9,735	10,912
Total Debt/EBITDA	1.04	1.53	1.29	1.2	1.07	1.01	4.82	4	3.66	2.96	3.67	3.49	2.83	2.69	2.88
Net Debt/EBITDA	1	0.75	0.73	1.17	0.96	0.55	4.73	3.93	2.99	2.36	3.02	2.89	2.29	2.18	2.38
Total Debt/EBIT	1.28	1.82	1.5	1.38	1.21	1.13	6.22	5.37	4.59	3.56	4.49	4.17	3.32	3.13	3.39
Net Debt/EBIT	1.24	0.9	0.85	1.35	1.08	0.61	6.1	5.28	3.75	2.84	3.69	3.45	2.69	2.54	2.8
EBITDA to Interest Expense	22.51	26.09	21.27	23.41	29.36	12.53	8.29	6.37	8.15	10.05	9.36	9.17	10.01	10.67	9.66
EBITDA-CapEx/Interest Expense	22.51	26.09	21.27	23.41	29.36	12.53	8.29	6.37	8.15	10.05	9.36	9.17	10.01	10.67	9.66
EBIT to Interest Expense	18.23	21.97	18.36	20.33	26.13	11.11	6.45	5.16	6.94	8.38	7.96	7.68	8.64	9.05	8.16
Interest Expense	42	43	63	64	62	154	264	367	349	340	335	391	418	416	465
Common Equity/Total Assets	25.94	27.12	27.17	17.48	15.02	27.82	18.33	19.5	20.12	17.7	11.79	13.73	16.19	17.14	17.75
Long-Term Debt/Equity (%)	42.14	91.09	63.25	111.99	219.76	64.49	271	233.42	228.49	268.67	412.83	357.95	266.09	240.3	237.31
Long-Term Debt/Capital (%)	25.46	46.68	32.1	39.93	67.69	31.62	69.77	66.6	64.75	70.68	72.22	71.13	63.68	60.98	62.21
Long-Term Debt/Total Assets (%)	12.22	26.18	17.59	19.58	33	17.94	49.68	45.51	45.97	47.55	48.69	49.15	43.07	41.19	42.13
Total Debt/Equity (%)	65.49	95.15	97.03	180.51	224.67	103.94	288.4	250.45	252.89	280.09	471.66	403.21	317.82	294.07	281.46
Total Debt/Capital (%)	39.57	48.76	49.25	64.35	69.2	50.97	74.25	71.47	71.66	73.69	82.51	80.13	76.07	74.62	73.79
Total Debt/Total Assets (%)	19	27.35	26.98	31.56	33.74	28.92	52.87	48.83	50.88	49.57	55.62	55.36	51.45	50.41	49.97
Net Debt to Equity	63.33	47.01	55.06	176.42	200.96	56.58	282.8	246.29	206.71	223.37	387.71	334.32	257.66	238.89	231.91
Net Debt/Capital (%)	38.77	31.98	35.51	63.82	66.77	36.13	73.88	71.12	59.24	59.75	68.64	67.29	62.79	61.43	61.52
EBITDA	956	1,116	1,334	1,503	1,814	1,930	2,183	2,338	2,847	3,421	3,133	3,584	4,177	4,436	4,490
EBITDA-CapEx	956	1,116	1,334	1,503	1,814	1,930	2,183	2,338	2,847	3,421	3,133	3,584	4,177	4,436	4,490
Operating Income (Loss)	775	940	1,152	1,305	1,615	1,713	1,699	1,890	2,425	2,854	2,665	3,001	3,606	3,762	3,797

Liquidity (USD)

Liquidity Ratios API ChatGPT

	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
As of date	12/31/2011	12/31/2012	12/31/2013	12/31/2014	12/31/2015	12/31/2016	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024	12/31/2025

Cash Ratio	0.02	0.46	0.29	0.02	0.1	0.31	0.05	0.04	0.04	0.05	0.03	0.03	0.04	0.03	0.03
Current Ratio	1.05	1.68	1.25	0.96	1.24	1.28	1.11	1.01	1.02	1	0.88	0.99	0.83	0.79	0.87
Quick Ratio	0.47	1.01	0.73	0.44	0.62	0.75	0.58	0.51	0.5	0.5	0.44	0.46	0.41	0.38	0.43
CFO/Avg Current Liab	0.35	0.44	0.49	0.42	0.6	0.53	0.55	0.47	0.53	0.75	0.44	0.33	0.56	0.47	0.5
Common Equity/Total Assets	25.94	27.12	27.17	17.48	15.02	27.82	18.33	19.5	20.12	17.7	11.79	13.73	16.19	17.14	17.75
Long-Term Debt/Equity (%)	42.14	91.09	63.25	111.99	219.76	64.49	271	233.42	228.49	268.67	412.83	357.95	266.09	240.3	237.31
Long-Term Debt/Capital (%)	25.46	46.68	32.1	39.93	67.69	31.62	69.77	66.6	64.75	70.68	72.22	71.13	63.68	60.98	62.21
Long-Term Debt/Total Assets (%)	12.22	26.18	17.59	19.58	33	17.94	49.68	45.51	45.97	47.55	48.69	49.15	43.07	41.19	42.13
Total Debt/Equity (%)	65.49	95.15	97.03	180.51	224.67	103.94	288.4	250.45	252.89	280.09	471.66	403.21	317.82	294.07	281.46
Total Debt/Capital (%)	39.57	48.76	49.25	64.35	69.2	50.97	74.25	71.47	71.66	73.69	82.51	80.13	76.07	74.62	73.79
Total Debt/Total Assets (%)	19	27.35	26.98	31.56	33.74	28.92	52.87	48.83	50.88	49.57	55.62	55.36	51.45	50.41	49.97
CFO/Total Liabilities	19.82	19.98	23.52	23	29.47	26.85	11.59	12.62	14.18	20.3	12.31	9.85	18.31	16.1	16.2
CFO/CapEx	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Altman's Z-Score	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -

Working Capital (USD)

Working Capital Ratios API ChatGPT

	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
As of date	12/31/2011	12/31/2012	12/31/2013	12/31/2014	12/31/2015	12/31/2016	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024	12/31/2025

Accounts Receivable Turnover	9.2	9.43	9.56	9.99	10.1	10.11	8.98	8.5	8.72	8.81	9	9.01	9.16	9.51	9.1
Days Sales Outstanding	39.69	38.71	38.17	36.54	36.13	36.1	40.63	42.92	41.88	41.42	40.54	40.51	39.83	38.37	40.1
Inventory Turnover	5.44	5.77	5.89	5.95	5.63	5.69	5.88	5.69	5.33	5.24	6.11	5.63	4.96	5.16	5.24
Days Inventory Outstanding	67.04	63.27	61.97	61.32	64.8	64.18	62.07	64.19	68.54	69.64	59.72	64.81	73.58	70.8	69.71
Accounts Payable Turnover	5.37	5.64	5.85	5.91	5.24	5.46	6.33	5.67	5.41	4.8	5.1	5.59	5.05	5.19	5.25
Accounts Payable Turnover Days	68.02	64.75	62.4	61.78	69.64	66.86	57.7	64.32	67.49	75.98	71.59	65.31	72.28	70.28	69.56
Cash Conversion Cycle	38.72	37.23	37.74	36.08	31.29	33.42	45	42.78	42.93	35.08	28.68	40	41.13	38.89	40.26
Inventory to Cash Days	-27.35	-24.56	-23.81	-24.78	-28.67	-28.08	-21.44	-21.27	-26.66	-28.23	-19.18	-24.3	-33.74	-32.43	-29.61
Inventories	927	920	971	1,034	1,019	1,068	1,743	1,815	1,890	1,804	1,927	2,627	2,330	2,288	2,318
Raw Materials	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Work In Process	196	188	192	192	178	170	386	389	380	377	548	669	519	536	534
Finished Goods	731	732	779	842	841	899	1,357	1,426	1,510	1,428	1,379	1,958	1,811	1,752	1,784
Other Inventory	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -

Enterprise Value (USD)

Enterprise Value API ChatGPT

	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
As of date	12/31/2011	12/31/2012	12/31/2013	12/31/2014	12/31/2015	12/31/2016	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024	12/31/2025

Market Capitalization	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
- Cash & Cash Equivalents	33	863	745	41	206	890	204	156	162	227	166	199	277	210	207
+ Preferred Equity and Hybrid Capital	160	101	40	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
+ Minority/Non Controlling Interest	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
+ Total Debt	993	1,705	1,722	1,799	1,950	1,953	10,521	9,344	10,428	10,114	11,495	12,508	11,810	11,913	12,943
Enterprise Value	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Total Capital	2,510	3,497	3,496	2,795	2,818	3,831	14,169	13,074	14,551	13,724	13,933	15,610	15,526	15,965	17,541
Total Debt/Capital (%)	39.57	48.76	49.25	64.35	69.2	50.97	74.25	71.47	71.66	73.69	82.51	80.13	76.07	74.62	73.79
Total Debt / EV	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/Sales	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/EBITDA	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/EBIT	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/Cash Flow to Firm	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/Free Cash Flow to Firm	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Diluted Market Cap	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Diluted Enterprise Value	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV per Share	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
TTM Sales	8,766	9,534	10,186	11,130	11,339	11,856	14,984	17,535	17,901	18,362	19,945	22,149	23,052	23,099	23,574
TTM EBITDA	956	1,116	1,334	1,503	1,814	1,930	2,183	2,338	2,847	3,421	3,133	3,584	4,177	4,436	4,490
TTM Operating Income	775	940	1,152	1,305	1,615	1,713	1,699	1,890	2,425	2,854	2,665	3,001	3,606	3,762	3,797
TTM Cash Flow to Firm	761	918	1,127	1,126	1,490	1,418	- -	2,243	2,593	3,683	2,522	2,227	3,843	3,476	3,809
TTM Free Cash Flow to Firm	761	918	1,127	1,126	1,490	1,418	- -	2,243	2,593	3,683	2,522	2,227	3,843	3,476	3,809

Multiples (USD)

Valuation Multiples API ChatGPT

No data availableFinancial data will appear here once available

Per Share Data Items (USD)

Per-Share Data API ChatGPT

	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
As of date	12/31/2011	12/31/2012	12/31/2013	12/31/2014	12/31/2015	12/31/2016	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024	12/31/2025

Shares Outstanding	20,295	20,180	19,567	18,507	18,026	18,176	18,346	18,196	18,006	17,501	17,010	16,863	16,580	16,369	16,135
Diluted Weighted Avg Shares	20,650	20,309	20,137	19,165	18,374	18,464	18,550	18,562	18,261	17,967	17,398	17,053	16,825	16,552	16,311
Basic Weighted Avg Shares	20,220	19,877	19,717	18,797	18,017	17,947	18,156	18,172	17,940	17,670	17,099	16,806	16,636	16,350	16,128
Revenue per Share	0.43	0.48	0.52	0.59	0.63	0.66	0.83	0.96	1	1.04	1.17	1.32	1.39	1.41	1.46
EBITDA per Share	0.05	0.06	0.07	0.08	0.1	0.11	0.12	0.13	0.16	0.19	0.18	0.21	0.25	0.27	0.28
Operating Income per Share	0.04	0.05	0.06	0.07	0.09	0.1	0.09	0.1	0.14	0.16	0.16	0.18	0.22	0.23	0.24
Basic EPS, GAAP	0.02	0.03	0.04	0.05	0.06	0.06	0.1	0.06	0.09	0.11	0.11	0.12	0.14	0.16	0.16
Basic EPS from Cont Ops	0.02	0.03	0.04	0.05	0.06	0.06	0.1	0.06	0.09	0.11	0.11	0.12	0.14	0.16	0.16
Diluted EPS, GAAP	0.02	0.03	0.04	0.05	0.06	0.06	0.09	0.06	0.08	0.11	0.11	0.12	0.14	0.16	0.16
Diluted EPS from Cont Ops	0.02	0.03	0.04	0.05	0.06	0.06	0.1	0.06	0.08	0.11	0.11	0.12	0.14	0.16	0.16
Dividend per Share	0.01	0.01	0.01	0.01	0.01	0.02	0.02	0.02	0.02	0.03	0.03	0.04	0.04	0.04	0.05
Cash Flow per Share	0.04	0.04	0.05	0.06	0.08	0.07	0.1	0.11	0.13	0.19	0.13	0.11	0.21	0.19	0.21
Free Cash Flow per Basic Share	0.04	0.04	0.05	0.06	0.08	0.07	0.1	0.11	0.13	0.19	0.13	0.11	0.21	0.19	0.21
Cash & Equivalents per Share	- -	0.04	0.04	- -	0.01	0.05	0.01	0.01	0.01	0.01	0.01	0.01	0.02	0.01	0.01
Book Value per Share	0.07	0.08	0.09	0.05	0.05	0.1	0.2	0.21	0.23	0.21	0.14	0.18	0.22	0.25	0.28
Tangible Book Value per Share	- -	0.01	0.01	-0.02	-0.03	0.03	-0.5	-0.46	-0.42	-0.45	-0.51	-0.5	-0.47	-0.43	-0.46