Stock Analysis on Net
Stock Analysis on Net

Sherwin-Williams Co. (NYSE:SHW)

Balance Sheet: Assets
Quarterly Data

Beginner level

The balance sheet provides creditors, investors, and analysts with information on company’s resources (assets) and its sources of capital (its equity and liabilities). It normally also provides information about the future earnings capacity of a company’s assets as well as an indication of cash flows that may come from receivables and inventories.

Assets are resources controlled by the company as a result of past events and from which future economic benefits are expected to flow to the entity.

Sherwin-Williams Co., consolidated balance sheet: assets (quarterly data)

US$ in thousands

Microsoft Excel LibreOffice Calc
Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015
Cash and cash equivalents 619,900  188,100  238,500  161,800  189,645  145,577  94,393  155,505  181,511  154,973  158,613  204,213  207,937  210,049  1,017,808  889,793  702,569  402,656  70,548  205,744  91,029  75,068  64,013 
Accounts receivable, net 2,454,500  2,472,500  2,291,500  2,088,900  2,479,043  2,659,051  2,339,551  2,018,768  2,584,280  2,625,066  2,326,411  2,104,555  2,426,222  2,377,874  1,356,851  1,230,987  1,458,073  1,473,078  1,290,749  1,114,275  1,413,946  1,454,045  1,234,612 
Inventories 1,672,800  1,788,600  1,954,800  1,889,600  1,824,969  1,894,865  1,993,437  1,815,275  1,861,328  1,874,651  2,001,630  1,801,375  1,704,213  1,854,937  1,247,688  1,068,326  1,112,512  1,152,232  1,147,361  1,018,530  1,052,830  1,131,976  1,161,250 
Deferred income taxes —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  57,162  148,550  155,407  97,562  87,883  107,063  107,902  107,869 
Other current assets 428,400  434,000  443,200  491,400  414,082  390,471  387,763  354,939  410,913  382,515  400,249  355,697  345,532  411,141  254,317  381,030  286,527  300,569  282,405  232,442  259,368  236,137  198,046 
Current assets 5,175,600  4,883,200  4,928,000  4,631,700  4,907,739  5,089,964  4,815,144  4,344,487  5,038,032  5,037,205  4,886,903  4,465,840  4,683,904  4,854,001  3,876,664  3,627,298  3,708,231  3,483,942  2,888,625  2,658,874  2,924,236  3,005,128  2,765,790 
Property, plant and equipment, net 1,780,000  1,798,600  1,829,500  1,835,200  1,798,301  1,773,586  1,762,998  1,776,839  1,766,354  1,776,378  1,840,005  1,877,115  1,895,549  1,889,917  1,063,095  1,095,888  1,083,922  1,072,257  1,057,025  1,041,862  1,015,167  1,005,319  998,432 
Goodwill 7,005,600  6,976,800  6,958,700  7,004,800  6,958,681  6,961,787  6,956,394  6,956,702  6,963,198  6,994,206  6,819,976  6,814,345  6,915,028  7,178,113  1,129,783  1,126,892  1,144,738  1,144,700  1,147,047  1,143,333  1,146,726  1,151,720  1,149,121 
Intangible assets 4,498,700  4,533,700  4,585,400  4,734,500  4,889,275  5,043,692  5,127,133  5,201,579  5,289,986  5,463,518  5,956,301  6,002,361  6,471,527  6,002,534  252,934  255,010  255,159  247,070  250,574  255,371  265,113  273,882  277,919 
Operating lease right-of-use assets 1,738,600  1,696,600  1,683,400  1,685,600  1,659,010  1,667,517  1,663,444  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  — 
Deferred pension assets —  —  —  43,000  33,468  34,812  35,997  270,664  305,979  301,664  298,455  296,743  224,330  224,695  224,212  225,529  246,051  246,090  246,035  244,882  252,188  251,684  250,463 
Other assets 611,200  605,600  585,300  561,400  617,865  614,778  600,531  584,008  617,147  581,761  566,046  502,023  589,319  568,138  442,215  421,904  479,670  471,618  449,003  447,533  498,593  446,931  417,525 
Long-term assets 15,634,100  15,611,300  15,642,300  15,864,500  15,956,600  16,096,172  16,146,497  14,789,792  14,942,664  15,117,527  15,480,783  15,492,587  16,095,753  15,863,397  3,112,239  3,125,223  3,209,540  3,181,735  3,149,684  3,132,981  3,177,787  3,129,536  3,093,460 
Total assets 20,809,700  20,494,500  20,570,300  20,496,200  20,864,339  21,186,136  20,961,641  19,134,279  19,980,696  20,154,732  20,367,686  19,958,427  20,779,657  20,717,398  6,988,903  6,752,521  6,917,771  6,665,677  6,038,309  5,791,855  6,102,023  6,134,664  5,859,250 

Based on: 10-Q (filing date: 2020-10-27), 10-Q (filing date: 2020-07-28), 10-Q (filing date: 2020-04-29), 10-K (filing date: 2020-02-21), 10-Q (filing date: 2019-10-22), 10-Q (filing date: 2019-07-24), 10-Q (filing date: 2019-04-25), 10-K (filing date: 2019-02-22), 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-25), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-02-23), 10-Q (filing date: 2017-10-25), 10-Q (filing date: 2017-07-26), 10-Q (filing date: 2017-04-21), 10-K (filing date: 2017-02-22), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-02-24), 10-Q (filing date: 2015-10-29), 10-Q (filing date: 2015-07-22), 10-Q (filing date: 2015-04-22).


Assets: Selected Items

Balance sheet item Description The company
Current assets Sum of the carrying amounts as of the balance sheet date of all assets that are expected to be realized in cash, sold, or consumed within one year (or the normal operating cycle, if longer). Assets are probable future economic benefits obtained or controlled by an entity as a result of past transactions or events. Sherwin-Williams Co.’s current assets decreased from Q1 2020 to Q2 2020 but then increased from Q2 2020 to Q3 2020 exceeding Q1 2020 level.
Property, plant and equipment, net Amount after accumulated depreciation, depletion and amortization of physical assets used in the normal conduct of business to produce goods and services and not intended for resale. Examples include, but are not limited to, land, buildings, machinery and equipment, office equipment, and furniture and fixtures. Sherwin-Williams Co.’s property, plant and equipment, net decreased from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.
Long-term assets Sum of the carrying amounts as of the balance sheet date of all assets that are expected to be realized in cash, sold or consumed after one year or beyond the normal operating cycle, if longer. Sherwin-Williams Co.’s long-term assets decreased from Q1 2020 to Q2 2020 but then increased from Q2 2020 to Q3 2020 not reaching Q1 2020 level.
Total assets Sum of the carrying amounts as of the balance sheet date of all assets that are recognized. Assets are probable future economic benefits obtained or controlled by an entity as a result of past transactions or events. Sherwin-Williams Co.’s total assets decreased from Q1 2020 to Q2 2020 but then increased from Q2 2020 to Q3 2020 exceeding Q1 2020 level.

Current Assets: Selected Items

Balance sheet item Description The company
Cash and cash equivalents Amount of currency on hand as well as demand deposits with banks or financial institutions. Includes other kinds of accounts that have the general characteristics of demand deposits. Also includes short-term, highly liquid investments that are both readily convertible to known amounts of cash and so near their maturity that they present insignificant risk of changes in value because of changes in interest rates. Excludes cash and cash equivalents within disposal group and discontinued operation. Sherwin-Williams Co.’s cash and cash equivalents decreased from Q1 2020 to Q2 2020 but then increased from Q2 2020 to Q3 2020 exceeding Q1 2020 level.
Accounts receivable, net Amount due from customers or clients, within one year of the balance sheet date (or the normal operating cycle, whichever is longer), for goods or services (including trade receivables) that have been delivered or sold in the normal course of business, reduced to the estimated net realizable fair value by an allowance established by the entity of the amount it deems uncertain of collection. Sherwin-Williams Co.’s accounts receivable, net increased from Q1 2020 to Q2 2020 but then slightly decreased from Q2 2020 to Q3 2020.
Inventories Amount after valuation and LIFO reserves of inventory expected to be sold, or consumed within one year or operating cycle, if longer. Sherwin-Williams Co.’s inventories decreased from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.