DCF Tool

ROK

Rockwell Automation Inc – Other Measuring and Controlling Device Manufacturing
Rockwell Automation, Inc. is an American provider of industrial automation whose brands include Allen-Bradley, FactoryTalk software and LifecycleIQ Services. Its solutions include hardware and software products, and services.
Analysis Results
Intrinsic Value $140.88
Latest Price $286.23
Relative Value 103% overvalued
Thoughts on this result? Let us know.
Ad
Cash Flow (Billions)
Analysis Parameters
%
%
%
New Ticker
Ad
Analysis Details
Growth Rate Projection

An exponential growth model was fit to the past cash flow data, giving more weight to more recent years. This model determined a growth rate estimate of 4.9%.

Weighted Average Cost of Capital (WACC)

The calculated WACC is 9.3%. This value is used as the default discount rate.

Value of Future Flows

Assuming a growth rate of 4.9%, the cash flows for the next 5 years are projected.

The present value of each year's flow is adjusted to present value using the discount rate.

Year Future flow (billion) Present value (billion)
2023 1.15 1.05
2024 1.2 1.01
2025 1.26 0.966
2026 1.32 0.927
2027 1.39 0.89
Terminal Value

Assuming a growth rate after the projection years of 2.0%, the terminal value of the company would be 19.4 billion. This corresponds to a present value of 11.3 billion.

Intrinsic Value Per Share

The total present value of the projected cash flows is 4.84 billion. Adding in the terminal value gives a total present value of 16.2 billion.

There are presently 115.0 million outstanding shares, so the intrinsic value per share is 140.88.

Financial Statements

The following data was to determine the past cash flows.

Current Assets 3,610,700,000
Current Cash 490,700,000
Current Liabilities 3,572,200,000
Current Debt 968,400,000
Non-Cash Working Capital (NCWC) 516,200,000
Change in NCWC 597,500,000
EBIT 1,335,300,000
Tax Provision 154,500,000
Depreciation and Amortization 238,900,000
Capital Expenditure -141,100,000
Unlevered Free Cash Flow 1,838,439,185
Current Assets 3,063,400,000
Current Cash 662,200,000
Current Liabilities 2,992,200,000
Current Debt 509,700,000
Non-Cash Working Capital (NCWC) -81,300,000
Change in NCWC -276,300,000
EBIT 1,217,700,000
Tax Provision 181,900,000
Depreciation and Amortization 189,800,000
Capital Expenditure -120,300,000
Unlevered Free Cash Flow 865,768,542
Current Assets 2,685,800,000
Current Cash 704,600,000
Current Liabilities 1,810,800,000
Current Debt 24,600,000
Non-Cash Working Capital (NCWC) 195,000,000
Change in NCWC -96,400,000
EBIT 1,115,400,000
Tax Provision 112,900,000
Depreciation and Amortization 172,700,000
Capital Expenditure -113,900,000
Unlevered Free Cash Flow 966,957,063
Current Assets 2,985,700,000
Current Cash 1,058,000,000
Current Liabilities 1,936,800,000
Current Debt 300,500,000
Non-Cash Working Capital (NCWC) 291,400,000
Change in NCWC 56,300,000
EBIT 1,361,600,000
Tax Provision 205,200,000
Depreciation and Amortization 152,200,000
Capital Expenditure -132,800,000
Unlevered Free Cash Flow 1,127,199,755
Current Assets 2,830,700,000
Current Cash 909,700,000
Current Liabilities 2,236,900,000
Current Debt 551,000,000
Non-Cash Working Capital (NCWC) 235,100,000
Change in NCWC -104,700,000
EBIT 1,273,200,000
Tax Provision 795,300,000
Depreciation and Amortization 164,600,000
Capital Expenditure -125,500,000
Unlevered Free Cash Flow 446,722,362
Current Assets 4,420,700,000
Current Cash 2,535,500,000
Current Liabilities 2,145,800,000
Current Debt 600,400,000
Non-Cash Working Capital (NCWC) 339,800,000
Change in NCWC 111,300,000
EBIT 1,032,700,000
Tax Provision 211,700,000
Depreciation and Amortization 168,900,000
Capital Expenditure -141,700,000
Unlevered Free Cash Flow 960,459,118
Current Assets 4,185,000,000
Current Cash 2,429,200,000
Current Liabilities 1,975,900,000
Current Debt 448,600,000
Non-Cash Working Capital (NCWC) 228,500,000
Change in NCWC -342,600,000
EBIT 1,008,100,000
Tax Provision 213,400,000
Depreciation and Amortization 172,200,000
Capital Expenditure -116,900,000
Unlevered Free Cash Flow 492,692,121
Current Assets 4,048,000,000
Current Cash 2,149,200,000
Current Liabilities 1,327,700,000
Current Debt 0
Non-Cash Working Capital (NCWC) 571,100,000
Change in NCWC -176,200,000
EBIT 1,196,700,000
Tax Provision 299,900,000
Depreciation and Amortization 162,500,000
Capital Expenditure -122,900,000
Unlevered Free Cash Flow 741,793,720
Current Assets 3,934,200,000
Current Cash 1,819,800,000
Current Liabilities 1,692,100,000
Current Debt 325,000,000
Non-Cash Working Capital (NCWC) 747,300,000
Change in NCWC 6,700,000
EBIT 1,186,300,000
Tax Provision 307,400,000
Depreciation and Amortization 152,500,000
Capital Expenditure -141,000,000
Unlevered Free Cash Flow 882,979,439
Current Assets 3,679,900,000
Current Cash 1,573,600,000
Current Liabilities 1,544,700,000
Current Debt 179,000,000
Non-Cash Working Capital (NCWC) 740,600,000
Change in NCWC -18,400,000
EBIT 1,039,400,000
Tax Provision 224,600,000
Depreciation and Amortization 145,200,000
Capital Expenditure -146,200,000
Unlevered Free Cash Flow 782,005,056
Current Assets 3,387,500,000
Current Cash 1,253,900,000
Current Liabilities 1,531,600,000
Current Debt 157,000,000
Non-Cash Working Capital (NCWC) 759,000,000
Change in NCWC 2,700,000
EBIT 1,033,300,000
Tax Provision 228,900,000
Depreciation and Amortization 138,600,000
Capital Expenditure -139,600,000
Unlevered Free Cash Flow 790,127,476

This analysis is provided for informational purposes only and does not constitute financial or investing advice. For more information on the advantages and limitations of DCF analysis see background. This information is provided on an "as is" basis. No warranty, expressed or implied, is made regarding accuracy, adequacy, completeness, legality, reliability or usefulness of any information. By using this site you agree that under no circumstances shall Valuation Tools LLC be held liable for any loss or damage caused by information obtained from this website including any articles, data, videos, its social media accounts, or any other materials.