Balance Sheet Data
Agilent Technologies, Inc. (A)
$127.59
+2.88 (+2.31%)
Year A/P | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected | 2028 Projected |
Total Cash | 1,382 | 1,441 | 1,575 | 1,053 | 1,606.76 | 1,726.94 | 1,856.10 | 1,994.92 | 2,144.12 | 2,304.49 |
---|---|---|---|---|---|---|---|---|---|---|
Total Cash (%) | ||||||||||
Account Receivables | 930 | 1,038 | 1,172 | 1,405 | 1,307.13 | 1,404.90 | 1,509.97 | 1,622.91 | 1,744.29 | 1,874.75 |
Account Receivables (%) | ||||||||||
Inventories | 679 | 720 | 830 | 1,038 | 938.34 | 1,008.52 | 1,083.94 | 1,165.02 | 1,252.15 | 1,345.80 |
Inventories (%) | ||||||||||
Accounts Payable | 354 | 354 | 446 | 580 | 495.64 | 532.71 | 572.56 | 615.38 | 661.40 | 710.87 |
Accounts Payable (%) | ||||||||||
Capital Expenditure | -156 | -119 | -189 | -291 | -213.37 | -229.33 | -246.48 | -264.92 | -284.73 | -306.03 |
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.