Rockwell Automation, Inc. (ROK)

Import this data to Google Sheets with:

=jivedata("ROK","financials")

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

Rockwell Automation, Inc.

ROK • CIK 0001024478

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Gross Profit	$3,717,000	$3,193,400	$4,016,000	$4,893,000
Selling, General and Administrative Expense	$2,023,700	$2,002,600	$1,914,000	$1,917,000
Research and Development Expense	$529,500	$477,300	$679,000	$716,000
Gain (Loss) on Investments	$279,300	$100	$-3,000	$-7,000
Goodwill and Intangible Asset Impairment	$0	$0	$224,000	$224,000
InterestExpenseNonoperating	—	$154,600	$156,000	$138,000
Income (Loss) from Continuing Operations before Income Taxes, Noncontrolling Interest	$1,608,500	$1,099,100	$917,000	$1,315,000
Income Tax Expense (Benefit)	$330,500	$151,800	$168,000	$224,000
Net Income (Loss), Including Portion Attributable to Noncontrolling Interest	$1,278,000	$947,300	$749,000	$1,091,000
Net Income (Loss) Attributable to Noncontrolling Interest	$-109,400	$-5,200	$-120,000	$-110,000
Net Income (Loss) Attributable to Parent	$1,387,400	$952,500	$869,000	$1,201,000
Revenue from Contract with Customer, Excluding Assessed Tax	$9,058,000	$8,264,200	$8,342,000	$8,973,000
Cost of Goods and Services Sold	$5,341,000	$5,070,800	$4,326,000	$4,080,000
Weighted Average Number of Shares Outstanding, Basic	114,800,000	114,000,000	112,700,000	111,700,000
Weighted Average Number of Shares Outstanding, Diluted	115,600,000	114,500,000	113,100,000	112,200,000
Antidilutive Securities Excluded from Computation of Earnings Per Share, Amount	400,000	500,000	500,000	-300,000
Participating Securities, Distributed and Undistributed Earnings (Loss), Diluted	$5,900	$4,300	$2,000	$2,000
Net Income (Loss) Available to Common Stockholders, Basic	$1,381,500	$948,200	$867,000	$1,199,000

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Cash and Cash Equivalents, at Carrying Value	$1,071,800	$471,000	$468,000	$479,000
Receivables, Net, Current	$2,167,400	$1,802,000	$1,931,000	$1,937,000
Property, Plant and Equipment, Net	$684,200	$776,700	$797,000	$839,000
Inventory, Net	$1,404,900	$1,293,100	$1,247,000	$1,243,000
Operating Lease, Right-of-Use Asset	$349,400	$422,600	$403,000	$346,000
Common Stock, Shares, Issued	181,400,000	181,400,000	141,400,000	141,400,000
Other Assets, Current	$266,700	$315,100	$265,000	$289,000
Goodwill	$3,529,200	$3,993,300	$3,839,000	$3,814,000
Assets, Current	$4,910,800	$3,881,200	$3,911,000	$3,948,000
Intangible Assets, Net (Excluding Goodwill)	$852,400	$1,066,300	$864,000	$710,000
Deferred Income Tax Assets, Net	$459,300	$517,000	$596,000	$620,000
Other Assets, Noncurrent	$361,600	$406,300	$809,000	$814,000
Assets	$11,304,000	$11,232,100	$11,219,000	$11,091,000
Long-term Debt, Excluding Current Maturities	—	—	$2,614,000	$2,570,000
Liability, Defined Benefit Plan, Noncurrent	$503,600	$549,100	$406,000	$406,000
Operating Lease, Liability, Noncurrent	$285,300	$355,600	$329,000	$268,000
Other Liabilities, Noncurrent	$543,500	$487,000	$714,000	$679,000
Stockholders' Equity Attributable to Noncontrolling Interest	$181,800	$176,900	$57,000	$2,000
Stockholders' Equity, Including Portion Attributable to Noncontrolling Interest	$3,743,400	$3,675,200	$3,711,000	$3,496,000
Short-term Debt	$94,700	$770,800	$608,000	$686,000
Long-term Debt, Current Maturities	$8,600	$307,400	$2,000	$2,000
Accounts Payable, Current	$1,150,200	$860,400	$930,000	$935,000
Employee-related Liabilities, Current	$499,900	$259,000	$432,000	$395,000
Contract with Customer, Liability, Current	$592,500	$584,100	$621,000	$651,000
Other Liabilities, Current	$567,400	$475,400	$505,000	$620,000
Liabilities, Current	$3,365,300	$3,603,900	$3,445,000	$3,672,000
Common Stock, Value, Issued	$181,400	$181,400	$141,000	$141,000
Additional Paid in Capital, Common Stock	$2,102,500	$2,188,600	$2,283,000	$2,364,000
Retained Earnings (Accumulated Deficit)	$9,255,200	$9,634,900	$5,422,000	$5,867,000
Accumulated Other Comprehensive Income (Loss), Net of Tax	$-790,100	$-772,400	$-657,000	$-669,000
Treasury Stock, Common, Value	—	—	$3,535,000	$4,209,000
Stockholders' Equity Attributable to Parent	$3,561,600	$3,498,300	$3,654,000	$3,494,000
Treasury Stock, Common, Shares	66,600,000	68,300,000	29,000,000	30,300,000

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Effect of Exchange Rate on Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$19,200	$12,100	$4,000	$1,000
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Period Increase (Decrease), Including Exchange Rate Effect	$572,500	$-609,400	$-3,000	$-16,000
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$1,080,400	$471,000	$468,000	$441,000
Cash and Cash Equivalents, at Carrying Value	$1,071,800	$471,000	$468,000	$441,000
Restricted Cash, Current	$8,600	$0	$0	$0
Net Income (Loss), Including Portion Attributable to Noncontrolling Interest	$1,278,000	$947,300	$749,000	$1,091,000
Depreciation	$133,800	$162,400	$173,000	$185,000
Amortization of Intangible Assets	$116,600	$155,000	$152,000	$137,000
Gain (Loss) on Investments	$279,300	$100	$-3,000	$-7,000
Share-based Payment Arrangement, Noncash Expense	$88,300	$99,800	$85,000	$89,000
Payment for Pension Benefits	$25,900	$28,300	$88,000	$85,000
Deferred Income Tax Expense (Benefit)	$-100,100	$-68,100	$-114,000	$-114,000
Gain (Loss) on Disposition of Property Plant Equipment	$-500	$400	$-13,000	$-13,000
Goodwill and Intangible Asset Impairment	$0	$0	$224,000	$224,000
Net Cash Provided by (Used in) Operating Activities	$1,374,600	$863,800	$1,544,000	$1,732,000
Payments to Acquire Productive Assets	—	$224,700	$186,000	$186,000
Payments to Acquire Businesses, Net of Cash Acquired	$168,400	$749,200	$0	$0
Payments to Acquire Investments	$27,100	$10,000	$14,000	$15,000
Proceeds from Sale of Debt Securities, Available-for-sale	$1,210,400	$200	$0	$0
Payments for (Proceeds from) Other Investing Activities	$100	$-1,200	$16,000	$6,000
Net Cash Provided by (Used in) Investing Activities	$854,300	$-982,500	$-216,000	$-256,000
Proceeds from (Repayments of) Short-term Debt, Maturing in Three Months or Less	$-256,900	$655,200	$-134,000	$-134,000
Proceeds from Other Short-term Debt	$0	$18,800	$513,000	$33,000
Proceeds from Issuance of Long-term Debt	$0	—	$14,000	$2,000
Repayments of Short-term Debt	$18,800	$0	$500,000	$570,000
Repayments of Long-term Debt	$599,800	$0	$303,000	$65,000
Payments of Dividends	$542,400	$571,000	$591,000	$611,000
Payments for Repurchase of Common Stock	$311,500	$594,900	$425,000	$823,000
Proceeds from Stock Options Exercised	$88,500	$39,400	$101,000	$116,000
Proceeds from (Payments for) Other Financing Activities	$-34,700	$-50,300	$-10,000	$-1,000
Net Cash Provided by (Used in) Financing Activities	$-1,675,600	$-502,800	$-1,335,000	$-1,493,000
Increase (Decrease) in Receivables	$368,700	$-405,200	$117,000	$110,000
Increase (Decrease) in Inventories	$295,900	$-131,500	$-55,000	$38,000
Increase (Decrease) in Accounts Payable	$70,200	$-290,700	$53,000	$99,000
Increase (Decrease) in Contract with Customer, Liability	$106,800	$-7,400	$39,000	$15,000
Increase (Decrease) in Employee Related Liabilities	$209,100	$-254,900	$168,000	$55,000
Increase (Decrease) in Income Taxes	$104,100	$-236,600	$-54,000	$-16,000
Increase (Decrease) in Other Operating Assets and Liabilities, Net	$-54,300	$168,800	$-69,000	$-94,000
Operating Lease, Payments	$101,700	$110,200	$117,000	$117,000
Finance Lease, Principal Payments	$5,500	$10,000	$6,000	$68,000
Right-of-Use Asset Obtained in Exchange for Operating Lease Liability	$93,300	$163,200	$68,000	$68,000
Right-of-Use Asset Obtained in Exchange for Finance Lease Liability	$0	$9,300	$0	$0

Loading financial statements…

Import this data to Google Sheets with:

=jivedata("ROK","financials")

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