Balance Sheet Data

Rockwell Automation, Inc. (ROK)

$265.49

-1.26 (-0.47%)

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Total Cash 909.701,058704.60662.20490.70910.82948.23987.181,027.741,069.95
Total Cash (%)
Account Receivables 1,190.101,178.701,249.101,424.501,736.701,582.381,647.381,715.051,785.501,858.85
Account Receivables (%)
Inventories 581.60575.70584798.101,054.20832.81867.02902.63939.71978.31
Inventories (%)
Accounts Payable 920893.80687.80889.801,0281,033.831,076.291,120.511,166.531,214.45
Accounts Payable (%)
Capital Expenditure -125.50-132.80-113.90-120.30-141.10-148.71-154.82-161.18-167.80-174.69
Capital Expenditure (%)



To support growth, companies need to keep investing in capital items – including property, plants and equipment.
To calculate this net investment,we take capital expenditure (found in the company’s statement of cash flows) and subtract non-cash depreciation (found on the income statement).
Working capital refers to the cash a company needs for day-to-day operations.
The faster a company expands, the more cash it will need.
To calculate working capital, we take current assets and subtract current liabilities.
You can find both of these on a company’s balance sheet, which is published in its quarterly and annual financial statements.