THE SHERWIN-WILLIAMS COMPANY (SHW)

Import this data to Google Sheets with:

=jivedata("SHW","financials")

Full statements spill as a table. For one cell: =jivedata("SHW","Revenue") or =jivedata("SHW","Revenue","TTM"). Install the Jive Data add-on, then paste into a cell.

THE SHERWIN-WILLIAMS COMPANY

SHW • CIK 0000089800

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Cash and Cash Equivalents, at Carrying Value	$276,800	$210,400	$207,200	$293,500
Accounts Receivable, after Allowance for Credit Loss, Current	$2,467,900	$2,388,800	$2,791,200	$3,571,200
Property, Plant and Equipment, Net	$2,836,800	$3,533,200	$4,137,400	$4,219,400
Inventory, Net	$2,329,800	$2,288,100	$2,318,200	$2,529,700
Goodwill	$7,626,000	$7,580,100	$8,036,600	$8,023,200
Other Assets, Current	$438,400	$513,500	$690,800	$604,800
Intangible Assets, Net (Excluding Goodwill)	$3,880,500	$3,533,200	$3,966,100	$3,803,700
Assets, Current	$5,512,900	$5,400,800	$6,007,400	$6,999,200
Operating Lease, Right-of-Use Asset	$1,887,400	$1,953,800	$1,995,200	$2,059,900
Other Assets, Noncurrent	$1,210,800	$1,631,500	$1,759,000	$1,846,000
Assets	$22,954,400	$23,632,600	$25,901,700	$26,951,400
Long-term Debt, Excluding Current Maturities	$8,377,900	$8,176,800	$9,320,700	$8,327,300
Liability, Other Postretirement Defined Benefit Plan, Noncurrent	$133,200	$120,700	$129,800	$133,400
Deferred Income Tax Liabilities, Net	$683,100	$607,500	$765,300	$757,200
Operating Lease, Liability, Noncurrent	$1,509,500	$1,558,300	$1,591,500	$1,656,800
Other Liabilities, Noncurrent	$1,908,000	$2,309,400	$2,575,800	$2,595,000
Short-term Debt	$374,200	$662,400	$1,200,500	$2,246,400
Accounts Payable, Current	$2,315,000	$2,253,200	$2,354,200	$2,826,400
Employee-related Liabilities, Current	$862,700	$842,800	$839,400	$768,400
Taxes Payable, Current	$197,400	$174,300	$187,400	$405,400
Long-term Debt, Current Maturities	$1,098,800	$1,049,200	$350,100	$1,498,400
Operating Lease, Liability, Current	$449,300	$466,600	$479,800	$486,500
Other Liabilities, Current	$1,329,500	$1,360,200	$1,508,900	$1,395,500
Liabilities, Current	$6,626,900	$6,808,700	$6,920,300	$9,627,000
Common Stock, Value, Issued	$91,800	$92,500	$83,100	$83,300
Additional Paid in Capital	$4,193,600	$4,576,200	$4,204,500	$4,322,100
Retained Earnings (Accumulated Deficit)	$5,288,300	$7,246,300	$1,029,400	$2,013,100
Treasury Stock, Common, Value	$5,233,600	$6,988,600	$84,300	$1,969,700
Accumulated Other Comprehensive Income (Loss), Net of Tax	$-624,300	$-875,200	$-634,400	$-594,100
Stockholders' Equity Attributable to Parent	$3,715,800	$4,051,200	$4,598,300	$3,854,700
Common Stock, Shares, Outstanding	254,500,000	251,300,000	247,700,000	242,800,000

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Net Income (Loss) Attributable to Parent	$2,388,800	$2,681,400	$2,568,500	$2,688,200
IncreaseDecreaseInOperatingLeaseLiability	—	$-460,700	$-503,700	$-481,900
Effect of Exchange Rate on Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$20,000	$-6,200	$-9,900	$-23,600
Payments for Environmental Liabilities	$35,300	$24,100	$35,100	$32,900
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Period Increase (Decrease), Including Exchange Rate Effect	$78,000	$-66,400	$-3,200	$23,700
Payments for Restructuring	—	—	$71,300	$71,300
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$276,800	$210,400	$207,200	$224,300
Other Operating Activities, Cash Flow Statement	$-251,700	$-140,100	$8,500	$10,300
Net Cash Provided by (Used in) Operating Activities	$3,521,900	$3,153,200	$3,451,600	$3,886,700
Depreciation	$292,300	$297,400	$340,300	$377,900
Payments to Acquire Productive Assets	$888,400	$1,070,000	$797,600	$673,500
Payments to Acquire Businesses, Net of Cash Acquired	$264,700	$78,900	$1,211,300	$1,154,800
Amortization of Intangible Assets	$330,200	$326,600	$336,600	$348,600
Proceeds from Divestiture of Businesses	$103,700	$0	$0	$0
Gain (Loss) on Disposition of Business	$20,100	$0	$0	$0
Proceeds from Sale of Productive Assets	$70,100	$11,600	$10,700	$16,300
Gain (Loss) on Extinguishment of Debt	$-12,800	$0	$0	$0
Payments for (Proceeds from) Other Investing Activities	$60,000	$59,000	$68,100	$75,200
Asset Impairment Charges	$57,900	$0	$17,800	$17,800
Net Cash Provided by (Used in) Investing Activities	$-1,039,300	$-1,196,300	$-2,066,300	$-1,887,200
Other Increase (Decrease) in Environmental Liabilities	$80,700	$-1,300	$15,300	$15,200
Restructuring Costs	$15,300	$0	$111,000	$111,000
Deferred Income Tax Expense (Benefit)	$-88,900	$-74,900	$153,200	$181,100
Share-based Payment Arrangement, Noncash Expense	$115,900	$138,100	$123,500	$120,200
Amortization Method Qualified Affordable Housing Project Investments, Amortization	—	$75,000	$104,000	$112,700
Gain (Loss) on Disposition of Property Plant Equipment	$-900	$49,900	$20,800	$18,900
Other Noncash Income (Expense)	$-7,000	$-6,100	$-2,600	$10,500
Increase (Decrease) in Accounts Receivable	$-85,600	$10,700	$162,800	$162,800
Proceeds from (Repayments of) Short-term Debt	$-603,900	$288,600	$537,400	$547,600
Increase (Decrease) in Inventories	$-323,400	$32,900	$-132,500	$-132,500
Proceeds from Issuance of Long-term Debt	$0	$848,700	$1,499,200	$1,999,200
Increase (Decrease) in Accounts Payable	$-241,100	$21,800	$-37,800	$-37,800
Repayments of Long-term Debt	$136,400	$1,100,000	$1,050,000	$1,150,000
Increase (Decrease) in Income Taxes Payable	$-8,900	$-14,300	$-22,500	$-22,500
Payments of Debt Issuance Costs	$0	$8,600	$13,500	$13,500
Increase (Decrease) in Accrued Salaries	$75,700	$-7,900	$-25,900	$-25,900
Payments of Dividends	$623,700	$723,400	$789,800	$786,100
Increase (Decrease) in Income Taxes Receivable	$-25,800	$-800	$16,100	$16,100
Proceeds from Stock Options Exercised	$111,600	$242,000	$140,600	$155,600
Increase (Decrease) in Other Operating Assets and Liabilities, Net	$-306,700	$20,700	$74,800	$74,800
Payments for Repurchase of Equity	$1,432,000	$1,738,800	$1,656,400	$2,623,200
Proceeds from (Payments for) Other Financing Activities	$-46,700	$-69,800	$-86,800	$-81,800
Net Cash Provided by (Used in) Financing Activities	$-2,424,600	$-2,017,100	$-1,378,600	$-1,952,200
Income Taxes Paid	$816,700	$779,800	$592,700	$458,000
Interest Paid, Excluding Capitalized Interest, Operating Activities	$416,500	$406,900	$453,000	$509,100

Loading financial statements…

Import this data to Google Sheets with:

=jivedata("SHW","financials")

Full statements spill as a table. For one cell: =jivedata("SHW","Revenue") or =jivedata("SHW","Revenue","TTM"). Install the Jive Data add-on, then paste into a cell.