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

276.95
 
USD
  
1.39
  
(0.50%)
Optionable: Yes  Market Cap: 31,665 M  90-day average vol: 1,153,210

Previous close: 275.56  Open: 272.84  Bid: 272.75  Ask: 287.28
52 week range    
252.11   
   348.52
Peers   
EMR / 
HON / 
AZPN / 
AME / 
PH / 
MSFT / 
ABB / 
Last updated: Friday 26th April 2024
37
MarketXLS Rank
55
Value
7
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

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

ABB

AME

0.005932 B34.3135.26

AZPN

10 B39.5143.09

EMR

0.021555 B24.195.73

HOLI

1 B11.613.91

HON

0.0204141 B26.3192.48

MSFT

0.00812,315 B33.1300.95

PH

0.013641 B21.7303.77
Financials

ROK Income Statement

Annual
Sep-14Sep-15Sep-16Sep-17Sep-18Sep-19Sep-20Sep-21Sep-22Sep-23
Amortization of intangibles1,051 M1,029 M1,074 M-10 M1,076 M1,071 M1,650 M3,626 M3,524 M3,529 M
Basic EPS from continuing operations5.986.155.66.424.275.888.8311.698.0212.03
Basic EPS total5.986.155.66.424.275.888.8311.698.0212.03
Basic weighted shares outstanding138 M135 M130 M128 M125 M118 M116 M116 M116 M115 M
Cost of sales3,870 M3,605 M3,404 M3,687 M3,781 M3,795 M3,735 M4,100 M4,658 M5,341 M
Depreciation153 M163 M172 M169 M165 M152 M173 M190 M239 M250 M
DepreciationAndAmortization153 M163 M172 M169 M165 M152 M173 M190 M239 M250 M
Diluted EPS total5.916.095.566.354.215.838.7711.587.9711.95
Diluted normalized net income/share5.916.095.566.354.215.838.7711.587.9711.95
Diluted weighted shares outstanding140 M136 M131 M130 M127 M119 M117 M117 M117 M116 M
Dividends paid per share2.322.62.93.043.513.884.084.284.484.72
Earnings from equity interest-16 M-1 M
EarningsFromEquityInterestNetOfTax-16 M-1 M
GainOnSaleOfBusiness61 M
GainOnSaleOfPPE-600000.0100000.0
GainOnSaleOfSecurity-368 M154 M397 M-137 M279 M
GeneralAndAdministrativeExpense1,570 M1,506 M1,467 M1,592 M1,588 M1,539 M1,480 M1,680 M1,767 M2,024 M
Gross operating profit2,754 M2,703 M2,476 M2,624 M2,885 M2,900 M2,595 M2,898 M3,102 M3,717 M
ImpairmentOfCapitalAssets158 M
Income before tax1,134 M1,128 M943 M1,037 M1,331 M901 M1,136 M1,526 M1,074 M1,609 M
Income taxes307 M300 M213 M212 M795 M205 M113 M182 M155 M331 M
Interest income10 M11 M13 M20 M24 M11 M6 M2 M4 M10 M
InterestExpenseNonOperating59 M64 M71 M76 M73 M98 M104 M95 M123 M135 M
InterestExpenseOperating-58 M-61 M-69 M-74 M-75 M-97 M-102 M-92 M-120 M-133 M
MinorityInterests404 M200000.014 M13 M109 M
MiscOtherSpecialCharges3 M3 M3 M9 M10 M342 M9 M256 M373 M424 M
Net income from total operations827 M828 M730 M826 M536 M696 M1,023 M1,358 M932 M1,387 M
NetIncomeCommonStockholders817 M833 M723 M745 M429 M690 M1,053 M1,352 M934 M1,459 M
NetIncomeContinuousOperations827 M828 M730 M826 M536 M696 M1,023 M1,358 M932 M1,387 M
NetNonOperatingInterestIncomeExpense-59 M-64 M-71 M-76 M-73 M-98 M-103 M-95 M-123 M-135 M
NonRecurringOperationExpense-8 M-70 M
Normalized income730 M733 M613 M614 M1,051 M712 M-5,602 M1,340 M
Operating income1,184 M1,197 M1,008 M1,033 M1,297 M1,362 M1,115 M1,218 M1,335 M1,693 M
Operating income before depreciation (EBITDA)1,288 M1,293 M1,117 M1,208 M1,493 M1,054 M1,311 M1,719 M1,315 M1,861 M
OperatingExpense1,570 M1,506 M1,467 M1,592 M1,588 M1,539 M1,480 M1,680 M1,767 M2,024 M
Other income net-2 M-3 M-3 M-70 M-100 M369 M-154 M-397 M137 M-279 M
OtherGandA1,570 M1,506 M1,467 M1,592 M1,588 M1,539 M1,480 M1,680 M1,767 M2,024 M
OtherOperatingExpenses-1000000.0-2 M-2 M-2 M120 M-100000.0-100000.0-4 M
RentAndLandingFees122 M117 M116 M115 M120 M119 M
Research & development expense290 M307 M319 M348 M372 M379 M372 M423 M441 M530 M
ResearchExpense290 M307 M319 M348 M372 M379 M372 M423 M441 M530 M
Revenue per share1,051 M1,029 M1,074 M-10 M1,076 M1,071 M1,652 M3,628 M3,531 M3,527 M
SalariesAndWages-13 M-13 M-13 M-12 M-10 M-7 M-8 M-9 M-11 M-15 M
Selling Gen & administrative expense1,570 M1,506 M1,467 M1,592 M1,588 M1,539 M1,480 M1,680 M1,767 M2,024 M
Special income/charges8 M70 M-157 M
Total Income available for interest expense (EBIT)1,135 M1,130 M945 M1,039 M1,328 M902 M1,138 M1,529 M1,076 M1,611 M
Total common shares outstanding136 M132 M128 M129 M121 M116 M116 M116 M115 M115 M
Total net income827 M828 M730 M826 M536 M696 M1,023 M1,358 M932 M1,387 M
Total ordinary shares115 M115 M115 M115 M115 M115 M115 M115 M115 M115 M
Total revenues6,624 M6,308 M5,880 M6,311 M6,666 M6,695 M6,330 M6,997 M7,760 M9,058 M
TotalExpenses5,440 M5,111 M4,871 M5,279 M5,369 M5,333 M5,214 M5,780 M6,425 M7,365 M
TotalRevenue6,624 M6,308 M5,880 M6,311 M6,666 M6,695 M6,330 M6,997 M7,760 M9,058 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