Supplemental Financial Data

(For Quarter Ended March 31, 2021

Published April 28, 2021

Rockwell Automation Global Headquarters

1201 South Second Street

Milwaukee, WI 53204

Investor Relations Contacts

Jessica Kourakos

Aijana Zellner

Head of Investor Relations

Director, Investor Relations

Phone: 414.382.8510

Phone: 414-382-2003

Email: jkourak@ra.rockwell.com

Email: azellner@ra.rockwell.com

Website

www.rockwellautomation.com

Copyright © 2019 Rockwell Automation, Inc. All Rights Reserved.

Table of Contents

  • Condensed Sales & Earnings Information
  • Sales and Earnings Information by Segment
  • Historic Sales Growth Rates
  • Quarterly Sales and Earnings Information by Segment
  • Quarterly Reconciliation of Adjusted Income, Adjusted EPS and Adjusted Effective Tax Rate
  • Sales by Geographic Region
  • Condensed Balance Sheet Information
  • Condensed Cash Flow Information
  • Return on Invested Capital
  • Other Supplemental Information

All information should be read in conjunction with the historical financial statements contained in Rockwell Automation's Annual Report on Form 10-K, periodic reports on Form 10-Q and Form 8-K, and public announcements of financial information. Copies of these reports are available on our website at www.rockwellautomation.comor upon request from Rockwell Automation.

Copyright © 2019 Rockwell Automation, Inc. All Rights Reserved.

Condensed Consolidated Statement of Operations

(in millions, except per share amounts)

(unaudited)

Year Ended September 30,

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

Sales

$

6,329.8

$

6,694.8

$

6,666.0

$

6,311.3

$

5,879.5

$

6,307.9

$

6,623.5

$

6,351.9

$

6,259.4

$

6,000.4

$

4,857.0

$

4,332.5

Cost of sales(1)

(3,734.6)

(3,794.7)

(3,781.1)

(3,643.4)

(3,366.6)

(3,575.8)

(3,841.6)

(3,736.9)

(3,719.4)

(3,595.2)

(2,911.6)

(2,769.0)

Gross profit

2,595.2

2,900.1

2,884.9

2,667.9

2,512.9

2,732.1

2,781.9

2,615.0

2,540.0

2,405.2

1,945.4

1,563.5

Selling, general and administrative expenses(1)

(1,479.8)

(1,538.5)

(1,587.9)

(1,557.6)

(1,437.0)

(1,481.3)

(1,545.7)

(1,502.9)

(1,477.1)

(1,448.7)

(1,315.7)

(1,233.1)

Change in fair value of investments

153.9

(368.5)

90.0

-

-

-

-

-

-

-

-

-

Other income (expense)(1)

(29.7)

6.1

16.8

3.3

(61.5)

(59.6)

(42.7)

(70.3)

(36.9)

(29.4)

(25.0)

4.4

Interest expense

(103.5)

(98.2)

(73.0)

(76.2)

(71.3)

(63.7)

(59.3)

(60.9)

(60.1)

(59.5)

(60.5)

(60.9)

Income from continuing operations before income taxes

and accounting change

1,136.1

901.0

1,330.8

1,037.4

943.1

1,127.5

1,134.2

980.9

965.9

867.6

544.2

273.9

Income tax provision

(112.9)

(205.2)

(795.3)

(211.7)

(213.4)

(299.9)

(307.4)

(224.6)

(228.9)

(170.5)

(103.8)

(56.0)

Income from continuing operations before accounting change

1,023.2

695.8

535.5

825.7

729.7

827.6

826.8

756.3

737.0

697.1

440.4

217.9

Income from discontinued operations

-

-

-

-

-

-

-

-

-

0.7

23.9

2.8

Net income

1,023.2

695.8

535.5

825.7

729.7

827.6

826.8

756.3

737.0

697.8

464.3

220.7

Net (loss) income attributable to noncontrolling interests

(0.2)

-

-

-

-

-

-

-

-

-

-

-

Net income attributable to Rockwell Automation, Inc.

$

1,023.4

$

695.8

$

535.5

$

825.7

$

729.7

$

827.6

$

826.8

$

756.3

$

737.0

$

697.8

$

464.3

$

220.7

Diluted earnings per share(2)

Continuing operations before accounting change

$8.77

$5.83

$4.21

$6.35

$5.56

$

6.09

$

5.91

$

5.36

$

5.13

$

4.79

$

3.05

$

1.53

Discontinued operations

-

-

-

-

-

-

-

-

-

0.01

0.17

0.02

Net income

$

8.77

$

5.83

$

4.21

$

6.35

$

5.56

$

6.09

$

5.91

$

5.36

$

5.13

$

4.80

$

3.22

$

1.55

Adjusted EPS(3)

$

7.87

$

8.78

$

8.21

$

6.73

$

5.89

$

6.36

$

6.15

$

5.70

$

5.27

$

4.91

$

3.13

$

1.48

Average diluted shares for EPS calculation

116.6

119.3

126.9

129.9

131.1

135.7

139.7

140.9

143.4

145.2

144.0

142.5

  1. Beginning in fiscal 2019, we adopted a new pension standard (ASU 2017-07) regarding the presentation of net periodic pension and postretirement benefit costs. In accordance with this standard, the service cost component of net periodic benefit cost is included in Cost of sales and Selling, general and administrative expenses in the Consolidated Statement of Operations and all other components have been reclassified from Cost of sales and Selling, general and administrative expenses to Other income (expense). As a result, all prior period presentation on this page and those that follow have been restated to conform to this standard.
  2. Beginning in fiscal 2010, we changed our accounting for earnings per share as a result of the new guidance issued by FASB, which requires the calculation of EPS pursuant to the two-class method. This resulted in a reduction in earnings per share of $0.01 in certain periods.
  3. Adjusted EPS is a non-GAAP measure. See Other Supplemental Information: Adjusted Income, Adjusted EPS and Adjusted Effective Tax Rate for the definition and reasons why management believes this information is useful to investors.

1

Quarterly Condensed Consolidated Statement of Operations

(in millions, except per share amounts)

(unaudited)

Fiscal Year 2021

Qtr 1

Qtr 2

YTD

Sales

$

1,565.3

$

1,776.1

$

3,341.4

Cost of sales

(918.8)

(1,008.7)

(1,927.5)

Gross profit

646.5

767.4

1,413.9

Selling, general and administrative expenses

(374.6)

(421.3)

$

(795.9)

Change in fair value of investments

390.4

190.9

581.3

Other income (expense)

61.0

(6.0)

55.0

Interest expense

(22.6)

(23.3)

(45.9)

Income before income taxes

700.7

507.7

1,208.4

Income tax provision

(110.3)

(97.4)

(207.7)

Net income

$

590.4

$

410.3

$

1,000.7

Net income (loss) attributable to noncontrolling interests

(2.9)

(4.7)

(7.6)

Net income attributable to Rockwell Automation, Inc.

$

593.3

$

415.0

$

1,008.3

Diluted earnings per share

$

5.06

$

3.54

$

8.59

Adjusted EPS(1)

$

2.38

$

2.41

$

4.79

Average diluted shares for EPS calculation

117.1

117.1

117.1

  1. Adjusted EPS is a non-GAAP measure. See Other Supplemental Information: Adjusted Income, Adjusted EPS and Adjusted Effective Tax Rate for the definition and reasons why management believes this information is useful to investors.

2

Quarterly Condensed Consolidated Statement of Operations

(in millions, except per share amounts)

(unaudited)

Fiscal Year 2020

Qtr 1

Qtr 2

Qtr 3

Qtr 4

YTD

Sales

$

1,684.5

$

1,681.3

$

1,394.0

$

1,570.0

$

6,329.8

Cost of sales

(981.6)

(982.5)

(839.8)

(930.7)

(3,734.6)

Gross profit

702.9

698.8

554.2

639.3

2,595.2

Selling, general and administrative expenses

(403.2)

(352.0)

(370.2)

(354.4)

$

(1,479.8)

Change in fair value of investments

71.0

(144.8)

175.5

52.2

153.9

Other income (expense)

(9.7)

(9.1)

0.4

(11.3)

(29.7)

Interest expense

(26.4)

(25.5)

(25.4)

(26.2)

(103.5)

Income before income taxes

334.6

167.4

334.5

299.6

1,136.1

Income tax provision

(19.2)

(37.5)

(20.3)

(35.9)

(112.9)

Net income

$

315.4

$

129.9

$

314.2

$

263.7

$

1,023.2

Net income (loss) attributable to noncontrolling interests

4.7

(2.3)

(3.6)

1.0

(0.2)

Net income attributable to Rockwell Automation, Inc.

$

310.7

$

132.2

$

317.8

$

262.7

$

1,023.4

Diluted earnings per share

$

2.66

$

1.13

$

2.73

$

2.25

$

8.77

Adjusted EPS(1)

$

2.15

$

2.47

$

1.32

$

1.93

$

7.87

Average diluted shares for EPS calculation

116.6

116.6

116.4

116.9

116.6

  1. Adjusted EPS is a non-GAAP measure. See Other Supplemental Information: Adjusted Income, Adjusted EPS and Adjusted Effective Tax Rate for the definition and reasons why management believes this information is useful to investors.

3

This is an excerpt of the original content. To continue reading it, access the original document here.

Attachments

  • Original document
  • Permalink

Disclaimer

Rockwell Automation Inc. published this content on 28 April 2021 and is solely responsible for the information contained therein. Distributed by Public, unedited and unaltered, on 28 April 2021 21:12:08 UTC.