Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Rockwell Automation Inc. logo

Rockwell Automation Inc.

Sector: Industrials   

Industry: Diversified Industrials

272.04
 
USD
  
-5.35
  
(-1.93%)
Optionable: Yes  Market Cap: 31,050 M  90-day average vol: 1,014,068

Previous close: 277.39  Open: 270.0  Bid: 262.01  Ask: 277.0
52 week range    
252.11   
   348.52
Peers   
EMR / 
HON / 
AZPN / 
AME / 
PH / 
MSFT / 
ABB / 
Last updated: Wednesday 8th May 2024
45
MarketXLS Rank
55
Value
30
Technical
50
Quality

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Financials

ROK Cash Flow

Annual
Sep-14Sep-15Sep-16Sep-17Sep-18Sep-19Sep-20Sep-21Sep-22Sep-23
(Increase) Decrease in inventories13 M-2 M5 M-30 M-37 M-5 M30 M-203 M-293 M-296 M
(Increase) Decrease in other current liabilities-8 M21 M12 M21 M13 M12 M43 M104 M102 M107 M
(Increase) Decrease in other working capital-18 M-5 M25 M-15 M15 M-2 M40 M-15 M112 M54 M
(Increase) Decrease in payables-21 M17 M32 M81 M67 M15 M-5 M185 M172 M70 M
(Increase) Decrease in receivables-54 M73 M-19 M-53 M-92 M-10 M-9 M-138 M-416 M-369 M
Acquisitions-81 M-21 M-139 M-1 M-10 M-21 M-551 M-2,488 M-17 M-168 M
Amortization of intangibles30 M29 M29 M30 M28 M26 M50 M66 M112 M117 M
AssetImpairmentCharge158 M
CapitalExpenditureReported141 M123 M117 M142 M126 M133 M114 M120 M141 M161 M
Cash at beginning of period1,201 M1,191 M1,427 M1,526 M1,411 M619 M1,018 M730 M679 M508 M
Cash at end of period1,191 M1,427 M1,526 M1,411 M619 M1,018 M730 M679 M508 M1,080 M
Cash flow1,033 M1,188 M947 M1,034 M1,300 M1,182 M1,121 M1,261 M823 M1,375 M
CashFlowFromContinuingInvestingActivities-483 M-247 M-440 M-517 M-170 M225 M-618 M-2,627 M-8 M854 M
ChangeInAccountPayable-21 M17 M32 M81 M67 M15 M-5 M185 M172 M70 M
ChangeInPayablesAndAccruedExpense-21 M17 M32 M81 M67 M15 M-5 M185 M172 M70 M
ChangeInWorkingCapital-88 M104 M54 M4 M-34 M10 M100 M-67 M-322 M-433 M
CommonStockDividendPaid-320 M-350 M-378 M-391 M-441 M-460 M-473 M-497 M-519 M-542 M
CommonStockPayments-486 M-598 M-508 M-343 M-1,482 M-1,009 M-264 M-300 M-301 M-311 M
Current deferred income taxes-7 M-29 M-70 M34 M171 M-29 M-66 M-184 M-34 M-100 M
Deferred income taxes-7 M-29 M-70 M34 M171 M-29 M-66 M-184 M-34 M-100 M
Depreciation123 M133 M143 M139 M136 M126 M123 M124 M127 M134 M
Depreciation unreconciled153 M163 M172 M169 M165 M152 M173 M190 M239 M250 M
DepreciationAndAmortization153 M163 M172 M169 M165 M152 M173 M190 M239 M250 M
Effect of exchange rate changes-38 M-97 M-10 M17 M-33 M-21 M8 M17 M-53 M19 M
ExcessTaxBenefitFromStockBasedCompensation-30 M-12 M-3 M
FinancingCashFlow-522 M-608 M-398 M-650 M-1,889 M-986 M-799 M1,298 M-934 M-1,676 M
Free cash flow893 M1,067 M831 M893 M1,175 M1,054 M1,022 M1,141 M682 M1,214 M
GainLossOnInvestmentSecurities-36 M22 M-425 M137 M-279 M
GainLossOnSaleOfBusiness-61 M
GainLossOnSaleOfPPE600000.0-100000.02 M100000.03 M2 M-12 M500000.0600000.0500000.0
Issuance of debt146 M-325 M449 M-98 M201 M-551 M24 M485 M-150 M-276 M
IssuanceOfDebt146 M269 M449 M-98 M-49 M437 M-277 M1,970 M-150 M-875 M
Net cash from financing activities-522 M-608 M-398 M-650 M-1,889 M-986 M-799 M1,298 M-934 M-1,676 M
Net cash from investing activities-483 M-247 M-440 M-517 M-170 M225 M-618 M-2,627 M-8 M854 M
Net cash from operating activities1,033 M1,188 M947 M1,034 M1,300 M1,182 M1,121 M1,261 M823 M1,375 M
Net change in cash & cash equivalents-10 M236 M99 M-115 M-792 M400 M-288 M-51 M-171 M573 M
Net income from continuing operations827 M828 M730 M826 M536 M696 M1,023 M1,344 M919 M1,278 M
NetBusinessPurchaseAndSale-81 M-21 M-139 M93 M-10 M-21 M-551 M-2,488 M-17 M-168 M
NetCommonStockIssuance-486 M-598 M-508 M-343 M-1,482 M-1,009 M-264 M-300 M-301 M-311 M
NetInvestmentPropertiesPurchaseAndSale-261 M-105 M-184 M-469 M-35 M374 M32 M-18 M150 M1,183 M
NetInvestmentPurchaseAndSale-261 M-105 M-184 M-469 M-35 M374 M32 M-18 M150 M1,183 M
NetIssuancePaymentsOfDebt146 M269 M449 M-98 M-49 M437 M-277 M1,970 M-150 M-875 M
NetLongTermDebtIssuance-250 M988 M-301 M1,486 M-600 M
NetPPEPurchaseAndSale-141 M-121 M-116 M-141 M-125 M-128 M-99 M-120 M-141 M-160 M
Operating (gains) losses2 M-75 M-124 M-191 M-25 M-110 M-119 M-286 M6 M-96 M
Other financing charges net30 M11 M3 M2 M-1 M800000.0-30 M-21 M-35 M
Other investing changes net-3 M-1 M-5 M-500000.0-100000.0
Other non-cash items147 M198 M185 M192 M489 M464 M10 M264 M15 M475 M
Payment of cash dividends321 M350 M378 M391 M441 M460 M473 M497 M519 M542 M
PensionAndEmployeeBenefitExpense1 M-75 M-125 M-130 M-28 M-76 M-129 M139 M-132 M183 M
ProceedsFromStockOptionExercised109 M60 M36 M182 M82 M47 M214 M155 M58 M89 M
Purchase of Float term investments-706 M-868 M-1,071 M-1,444 M-1,297 M-5 M-11 M-14 M-60 M-27 M
Purchase of property plant & equipment-141 M-121 M-116 M-141 M-125 M-128 M-99 M-120 M-141 M-160 M
Purchase of short term investments988 M1,486 M
PurchaseOfInvestment-706 M-868 M-1,071 M-1,444 M-1,297 M-5 M-11 M-14 M-60 M-27 M
PurchaseOfPPE-141 M-123 M-117 M-142 M-125 M-133 M-114 M-120 M-141 M-160 M
Repayment of debt-250 M-301 M-600 M
RepaymentOfDebt-250 M-701 M-2 M-210 M-619 M
Repurchase of capital stock-486 M-598 M-508 M-343 M-1,482 M-1,009 M-264 M-300 M-301 M-311 M
Revenue per share30 M29 M29 M30 M28 M26 M50 M66 M112 M117 M
Sale of short term investments448 M763 M886 M975 M1,261 M379 M44 M600000.0210 M1,210 M
SaleOfBusiness94 M
SaleOfInvestment448 M763 M886 M975 M1,261 M379 M44 M600000.0210 M1,210 M
SaleOfPPE400000.02 M400000.01 M500000.05 M15 M400000.0600000.0
ShortTermDebtIssuance146 M-325 M449 M-98 M201 M-551 M424 M487 M60 M-257 M
ShortTermDebtPayments-400 M-2 M-210 M-19 M
StockBasedCompensation43 M42 M41 M39 M39 M43 M46 M52 M68 M88 M
UnrealizedGainLossOnInvestmentSecurities-90 M369 M-154 M-397 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University