THE SHERWIN-WILLIAMS COMPANY SHW Balance Sheet

The sherwin-williams company (SHW)

Balance Sheet / TTM

Mar'20	Dec'19	Sep'19	Jun'19	Mar'19	Dec'18	Sep'18	Jun'18	Mar'18	Dec'17	Sep'17	Jun'17	Mar'17	Dec'16	Sep'16	Jun'16	Mar'16	Dec'15	Sep'15	Jun'15	Mar'15	Dec'14	Sep'14	Jun'14	Mar'14	Dec'13	Sep'13	Jun'13	Mar'13	Dec'12	Sep'12	Jun'12	Mar'12	Dec'11	Sep'11	Jun'11	Mar'11	Dec'10	Sep'10	Jun'10	Mar'10	Dec'09	Sep'09	Jun'09	Mar'09	Dec'08	Sep'08	Jun'08	Dec'07
Assets
Current assets:
Cash and cash equivalents
238	161	189	145	94	155	181	154	158	204	207	210	1,017	889	702	402	70	205	91	75	64	40	261	267	366	744	1,035	741	613	862	55	46	25	32	46	71	53	58	64	48	91	69	32	49	42	26	40	45	27
Accounts Receivable, after Allowance for Credit Loss, Current
2,291	2,088	2,479	2,659	2,339	2,018	2,584	2,625	2,326	2,104	2,426	2,377	1,356	1,230	1,458	1,473	1,290	1,114	1,413	1,454	1,234	1,130	1,408	1,402	1,174	1,097	1,348	1,299	1,130	1,032	1,263	1,237	1,135	989	1,173	1,183	1,012	916	1,069	986	797	696	901	908	785	769	1,072	1,092	870
Inventories:
Finished goods
-	-	1,474	1,531	-	1,426	1,369	1,384	1,510	1,356	1,333	1,468	1,069	898	947	975	972	840	871	945	981	841	866	892	898	779	818	809	821	732	787	851	833	730	743	853	862	743	713	666	673	630	641	681	734	749	745	799	756
Work in process and raw materials
-	-	350	362	-	388	432	431	432	386	370	386	178	169	165	176	175	177	181	186	179	191	179	198	198	191	199	175	191	187	176	179	183	196	223	213	201	173	145	127	114	107	84	88	104	114	118	121	131
Inventory, Net
1,954	1,889	1,824	1,894	1,993	1,815	1,802	1,815	1,942	1,742	1,704	1,854	1,247	1,068	1,112	1,152	1,147	1,018	1,052	1,131	1,161	1,033	1,046	1,091	1,096	970	1,017	984	1,013	920	963	1,031	1,017	926	966	1,067	1,064	917	858	793	787	738	726	769	838	864	863	920	887
Deferred Income Tax Assets, Net
-	-	-	-	-	-	-	-	-	-	-	-	-	57	148	155	97	87	107	107	107	109	101	102	102	104	128	129	132	126	149	148	148	149	127	128	128	127	121	120	121	121	99	98	97	97	103	105	104
Other current assets
443	491	414	390	387	354	410	382	400	355	345	411	254	381	286	300	282	230	257	234	196	251	260	244	227	240	240	187	196	207	178	159	150	163	195	187	208	193	209	190	152	144	162	151	143	151	195	203	179
Total current assets
4,928	4,631	4,907	5,089	4,815	4,344	4,979	4,978	4,827	4,407	4,683	4,854	3,876	3,627	3,708	3,483	2,888	2,657	2,922	3,003	2,764	2,565	3,079	3,108	2,967	3,158	3,770	3,342	3,086	3,149	2,609	2,624	2,477	2,261	2,509	2,638	2,466	2,213	2,325	2,139	1,950	1,770	1,922	1,977	1,907	1,909	2,276	2,367	2,069
Property, plant and equipment:
Land
-	-	239	243	-	244	249	245	248	254	252	259	116	115	118	119	120	119	120	122	121	125	129	131	129	125	101	99	102	102	103	101	105	105	106	107	106	106	94	104	84	85	84	86	85	85	86	84	83
Buildings
-	-	1,006	1,010	-	979	955	919	955	962	992	961	721	714	709	708	704	696	694	696	691	698	703	711	705	715	698	718	680	677	670	665	672	668	671	684	674	668	662	605	594	600	596	593	585	580	580	578	561
Machinery and equipment
-	-	2,837	2,816	-	2,668	2,623	2,589	2,604	2,573	2,642	2,595	2,205	2,153	2,118	2,109	2,071	2,026	1,965	1,980	1,946	1,952	1,916	1,916	1,871	1,838	1,872	1,812	1,779	1,750	1,726	1,702	1,694	1,657	1,643	1,658	1,629	1,617	1,641	1,571	1,514	1,512	1,526	1,522	1,521	1,564	1,566	1,570	1,516
Construction in progress
-	-	179	136	-	147	143	143	171	177	149	134	70	117	111	100	89	81	82	69	63	59	48	40	48	62	44	39	44	56	50	47	36	41	46	39	32	34	26	23	24	23	22	17	21	26	44	62	65
Total gross property, plant and equipment
-	-	4,263	4,207	-	4,040	3,972	3,897	3,979	3,966	4,037	3,951	3,114	3,100	3,057	3,038	2,986	2,923	2,862	2,868	2,822	2,835	2,797	2,798	2,754	2,741	2,717	2,669	2,607	2,587	2,550	2,516	2,509	2,472	2,467	2,490	2,442	2,426	2,425	2,305	2,218	2,221	2,229	2,219	2,213	2,256	2,277	2,296	2,226
Less allowances for depreciation
-	-	2,464	2,433	-	2,263	2,206	2,121	2,139	2,089	2,142	2,061	2,051	2,005	1,973	1,966	1,929	1,881	1,847	1,863	1,824	1,814	1,783	1,792	1,750	1,719	1,706	1,717	1,652	1,621	1,607	1,578	1,558	1,516	1,527	1,531	1,496	1,474	1,512	1,477	1,410	1,402	1,397	1,377	1,365	1,396	1,392	1,391	1,327
Property, Plant and Equipment, Net
1,829	1,835	1,798	1,773	1,763	1,776	1,766	1,776	1,840	1,877	1,895	1,889	1,063	1,095	1,083	1,072	1,057	1,041	1,015	1,005	998	1,021	1,013	1,006	1,004	1,021	1,010	952	954	965	943	938	950	956	939	958	946	952	912	827	807	818	832	842	848	860	884	904	899
Goodwill
6,958	7,004	6,958	6,961	6,956	6,956	6,963	6,994	6,819	6,814	6,915	7,178	1,129	1,126	1,144	1,144	1,147	1,143	1,146	1,151	1,149	1,158	1,167	1,174	1,174	1,178	1,175	1,171	1,156	1,156	1,122	1,122	1,113	1,108	1,106	1,113	1,112	1,102	1,085	1,011	1,014	1,014	1,011	1,011	1,009	1,006	1,002	1,000	996
Intangible assets
4,585	4,734	4,889	5,043	5,127	5,201	5,289	5,463	5,956	6,002	6,471	6,002	252	255	255	247	250	255	265	273	277	289	295	306	312	313	307	311	339	347	316	314	303	305	316	319	322	320	339	276	273	279	298	300	299	299	337	329	351
Operating lease right-of-use assets
1,683	1,685	1,659	1,667	1,663	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Deferred pension assets
-	-	33	34	-	270	305	301	298	296	224	224	224	225	246	246	246	244	252	251	250	250	304	304	303	302	252	250	250	249	235	232	230	228	264	253	250	248	250	248	247	245	215	215	214	215	412	408	400
Other assets
585	604	617	614	636	584	617	581	566	502	589	568	442	421	479	471	449	436	487	442	412	415	457	440	427	407	405	379	378	366	397	394	381	368	353	350	345	332	267	235	215	195	169	154	132	124	154	154	138
Assets
20,570	20,496	20,864	21,186	20,961	19,134	19,921	20,095	20,308	19,899	20,779	20,717	6,988	6,752	6,917	6,665	6,038	5,778	6,088	6,128	5,852	5,699	6,317	6,341	6,189	6,382	6,921	6,408	6,166	6,234	5,625	5,626	5,456	5,229	5,490	5,633	5,443	5,169	5,180	4,740	4,509	4,323	4,449	4,502	4,412	4,415	5,069	5,165	4,855
Liabilities and Shareholders’ Equity
Current liabilities:
Short-term borrowings
1,051	204	435	808	824	328	650	650	920	633	164	51	41	40	50	59	128	39	36	1,159	1,405	679	55	64	87	96	295	50	68	69	330	604	677	346	517	571	678	388	354	199	245	22	410	499	765	516	715	933	657
Accounts payable
1,958	1,876	2,028	2,067	1,894	1,799	2,165	2,049	1,975	1,791	1,832	1,783	1,221	1,034	1,224	1,289	1,152	1,157	1,216	1,253	1,174	1,042	1,266	1,244	1,130	998	1,121	1,117	1,023	922	1,034	1,102	999	965	996	1,019	954	909	927	881	705	674	728	704	629	738	882	874	740
Compensation and taxes withheld
438	552	538	418	400	504	500	405	417	508	500	395	296	398	379	311	284	338	330	267	249	360	344	264	232	337	305	218	204	314	300	231	198	251	234	227	174	253	233	205	140	176	180	172	127	194	183	178	224
Accrued taxes
106	85	94	154	128	80	98	173	113	79	280	320	158	76	145	230	115	81	187	193	77	86	192	190	76	79	187	170	77	52	157	126	66	120	142	120	75	62	139	134	62	76	140	117	51	58	204	169	70
Current portion of long-term debt
429	429	429	1,437	303	307	310	1	1	1	701	701	700	700	1	2	2	3	3	3	3	3	502	502	502	502	2	2	3	3	3	4	6	7	10	9	10	7	6	9	12	12	10	10	14	13	13	11	14
California litigation accrual
12	12	12	136	136	136	136	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Current portion of operating lease liabilities
371	371	364	361	356	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Other accruals
853	989	961	957	955	1,141	980	910	900	972	891	898	519	578	714	733	578	522	519	479	468	508	507	458	423	513	494	407	404	513	465	462	446	471	452	441	434	442	462	403	391	430	415	398	373	415	410	403	433
Total current liabilities
5,220	4,521	4,865	6,342	5,000	4,297	4,842	4,190	4,327	3,987	4,371	4,151	2,939	2,829	2,515	2,625	2,262	2,141	2,294	3,357	3,379	2,680	2,868	2,725	2,452	2,528	2,406	1,967	1,782	1,876	2,292	2,531	2,395	2,162	2,354	2,389	2,327	2,063	2,125	1,833	1,557	1,393	1,886	1,903	1,962	1,936	2,410	2,570	2,141
Long-term debt
8,289	8,050	8,043	7,209	8,702	8,708	8,710	9,722	9,891	9,885	10,083	10,751	1,211	1,211	1,909	1,909	1,908	1,907	1,907	1,116	1,116	1,115	1,122	1,122	1,122	1,122	1,631	1,631	1,632	1,632	635	635	637	639	641	644	650	648	705	699	783	782	289	291	297	303	297	294	293
Postretirement benefits other than pensions
262	263	260	259	258	257	277	276	275	274	262	253	252	250	253	251	250	248	280	279	278	277	273	272	270	268	320	320	320	320	299	298	298	297	297	296	296	295	285	284	284	283	250	250	249	248	265	264	262
Deferred income taxes
949	969	1,096	1,114	1,128	1,130	1,356	1,365	1,480	1,419	2,611	2,467	15	73	132	131	-	138	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Long-term operating lease liabilities
1,373	1,370	1,352	1,362	1,371	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Other long-term liabilities
1,185	1,196	1,222	1,149	1,039	1,009	803	837	689	684	709	702	505	509	508	501	615	474	630	617	609	628	700	696	690	688	693	621	618	614	619	620	617	612	547	556	561	551	421	391	388	372	320	323	321	321	357	371	372
Shareholders’ equity:
Common stock
119	119	119	118	118	118	118	117	117	117	117	117	116	116	116	116	116	115	115	115	115	114	114	114	113	112	112	112	112	111	110	109	108	107	106	106	106	231	230	230	229	228	228	227	227	227	226	226	225
Preferred stock - convertible, no par value: 40,406 shares outstanding at December 31, 2013
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	5	21	40	54	68	82	101	115	128	143	160	175	194	203	216	216	216	216	216	216	216	216	216	216	216	324
Unearned ESOP compensation
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	5	21	40	54	68	82	101	115	128	143	160	175	194	203	216	216	216	216	216	216	216	216	216	216	-216	324
Other capital
3,215	3,153	3,079	3,010	2,945	2,896	2,851	2,795	2,761	2,723	2,654	2,606	2,547	2,488	2,451	2,412	2,372	2,330	2,287	2,241	2,187	2,079	2,019	1,980	1,951	1,847	1,798	1,773	1,729	1,673	1,552	1,429	1,391	1,297	1,304	1,289	1,261	1,222	1,182	1,161	1,101	1,068	1,069	1,042	1,026	1,016	956	939	897
Retained earnings
7,562	7,366	7,224	6,752	6,386	6,246	6,226	5,953	5,630	5,458	4,685	4,448	4,209	4,049	3,924	3,616	3,316	3,228	3,093	2,780	2,493	2,424	2,345	2,072	1,834	1,774	1,708	1,496	1,290	1,226	1,198	1,003	816	756	779	637	497	4,824	4,790	4,653	4,511	4,518	4,492	4,358	4,241	4,245	4,235	4,099	3,935
Treasury stock, at cost
6,707	5,836	5,632	5,504	5,358	4,900	4,655	4,621	4,528	4,266	4,263	4,262	4,258	4,235	4,236	4,236	4,235	4,220	3,950	3,863	3,798	3,150	2,754	2,326	1,917	1,639	1,361	1,101	950	849	724	654	471	276	237	41	-	4,390	4,268	4,190	4,040	4,007	3,753	3,526	3,499	3,472	3,459	-3,417	3,074
Accumulated other comprehensive loss
-901	-679	-767	-630	-632	-629	-610	-542	-335	-384	-452	-519	-549	-540	-658	-662	-568	-587	-569	-516	-528	-471	-371	-315	-329	-321	-389	-412	-368	-370	-357	-349	-336	-367	-317	-245	-257	-278	-292	-323	-306	-317	-334	-368	-414	-410	-221	-182	-198
Stockholders' Equity Attributable to Parent
3,289	4,123	4,022	3,747	3,460	3,730	3,930	3,702	3,645	3,647	2,740	2,391	2,065	1,878	1,597	1,246	1,000	867	976	757	469	996	1,351	1,524	1,653	1,774	1,869	1,867	1,812	1,791	1,779	1,539	1,508	-	1,635	-	-	-	1,643	1,531	1,495	-	1,702	1,733	1,581	1,605	1,738	1,665	1,785
Noncontrolling interest
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	14	-	-	-	0	-	-	-	-	-	-	-	-	-	-
Total shareholders equity
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,516	1,649	1,746	1,607	1,609	1,643	-	-	1,490	-	-	-	-	-	-	-
Total liabilities and shareholders’ equity
20,570	20,496	20,864	21,186	20,961	19,134	19,921	20,095	20,308	19,899	20,779	20,717	6,988	6,752	6,917	6,665	6,038	5,778	6,088	6,128	5,852	5,699	6,317	6,341	6,189	6,382	6,921	6,408	6,166	6,234	5,625	5,626	5,456	5,229	5,490	5,633	5,443	5,169	5,180	4,740	4,509	4,323	4,449	4,502	4,412	4,415	5,069	5,165	4,855
Common stock, shares outstanding
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	117	-
Preferred stock, shares outstanding
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-