Balance Sheet Data
Rockwell Automation, Inc. (ROK)
$278.53
+0.64 (+0.23%)
Year A/P | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Actual | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected | 2028 Projected |
| Total Cash | 1,058 | 704.60 | 662.20 | 490.70 | 1,071.80 | 1,069.14 | 1,156.60 | 1,251.21 | 1,353.56 | 1,464.28 |
|---|---|---|---|---|---|---|---|---|---|---|
| Total Cash (%) | ||||||||||
| Account Receivables | 1,178.70 | 1,249.10 | 1,424.50 | 1,736.70 | 2,167.40 | 2,038.27 | 2,205 | 2,385.36 | 2,580.48 | 2,791.57 |
| Account Receivables (%) | ||||||||||
| Inventories | 575.70 | 584 | 798.10 | 1,054.20 | 1,404.90 | 1,143.06 | 1,236.56 | 1,337.71 | 1,447.13 | 1,565.50 |
| Inventories (%) | ||||||||||
| Accounts Payable | 694.60 | 687.80 | 889.80 | 1,028 | 1,150.20 | 1,173.96 | 1,269.99 | 1,373.87 | 1,486.25 | 1,607.83 |
| Accounts Payable (%) | ||||||||||
| Capital Expenditure | -132.80 | -113.90 | -120.30 | -141.10 | -160.50 | -178.19 | -192.77 | -208.54 | -225.59 | -244.05 |
| 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.