Discounted Cash Flow

Rockwell Automation, Inc.

ROK · Based on 10 years of SEC filings

Average annual growth rates

Metric 10-Year 5-Year 3-Year
Sales
Free Cash Flow
Average (FCF & NI)
Net Income

Average annual growth is the mean year-over-year change across each period.

Endpoint CAGR (better for long term trend)

Metric 10-Year 5-Year 3-Year
Sales
Free Cash Flow
Average (FCF & NI)
Net Income

Endpoint CAGR is the compound annual rate from the first to last year in each period.

Projections use average year-over-year growth. Change this in Settings.

Projected growth rate

Free cash flow growth
10-year: — 5-year: — 3-year: —
Averaged growth (FCF & NI)
10-year: — 5-year: — 3-year: —
Net income growth
10-year: — 5-year: — 3-year: —
Sales growth (not added to calculations)
10-year: — 5-year: — 3-year: —

Click a greyed-out slider to switch metrics. Slide between the 10-year, 5-year, and 3-year historic growth rates for FCF, net income, or their average.

%
%

Historical inputs (10 fiscal years)

YEAR Sales Net Income Free Cash Flow Net Margin EPS (diluted)
2016 $5.9b $729.7m $830.4m 12.4% $5.60
2017 $6.3b (7.3%) $825.7m (13.2%) $892.3m (7.5%) 13.1% (5.4%) $6.42 (14.6%)
2018 $6.7b (5.6%) $535.5m (-35.1%) $1.2b (31.6%) 8.0% (-38.6%) $4.27 (-33.5%)
2019 $6.7b (0.4%) $695.8m (29.9%) $1.0b (-10.7%) 10.4% (29.4%) $5.88 (37.7%)
2020 $6.3b (-5.5%) $1.0b (47.1%) $1.0b (-4.1%) 16.2% (55.6%) $8.83 (50.2%)
2021 $7.0b (10.5%) $1.4b (32.7%) $1.1b (13.3%) 19.4% (20.0%) $11.69 (32.4%)
2022 $7.8b (10.9%) $932.2m (-31.4%) $682.0m (-40.2%) 12.0% (-38.1%) $8.02 (-31.4%)
2023 $9.1b (16.7%) $1.4b (48.8%) $1.2b (78.0%) 15.3% (27.5%) $12.03 (50.0%)
2024 $8.3b (-8.8%) $952.5m (-31.3%) $639.1m (-47.4%) 11.5% (-24.8%) $8.32 (-30.8%)
2025 $8.3b (0.9%) $869.0m (-8.8%) $1.4b (112.5%) 10.4% (-9.6%) $7.69 (-7.6%)

Base FCF: (latest fiscal year)

Discount rate: %

Terminal growth:

Projection period: years

Alt A decline yrs:

Alt B total yrs:

Values abbreviated: b = billions, m = millions, k = thousands.

Projected cash flows

Year Projected cash flow Discount Factor Present Value

PV of projected FCF:

Terminal FCF:

Terminal value:

PV of terminal value:

Enterprise value (DCF):

DCF price per share:

Current price:

Alternative DCF Models

Model Fair Value Upside PV(FCFs) PV(Terminal) Total Years
Standard (10yr→TV) 10 + TV
Alt A (Gradual Decline)
Alt B (30yr Hard Stop) N/A

This is a simplified DCF model for illustration. It uses reported free cash flow, a single growth assumption, fixed WACC, and a Gordon Growth terminal value. It is not investment advice.

+ 10YR Financials Balance Sheet (10YR) Cash Flow (10YR) DCF Model