Balance Sheet Data
T. Rowe Price Spectrum Conservative... (PPIPX)
$18.57
+0.11 (+0.60%)
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 | 5,204 | 12,130 | 9,740 | 19,223 | 3,739 | 7,568.40 | 6,978.84 | 6,435.20 | 5,933.92 | 5,471.68 |
|---|---|---|---|---|---|---|---|---|---|---|
| Total Cash (%) | ||||||||||
| Account Receivables | 27,716 | 24,247 | 22,269 | 14,895 | 14,407 | 15,191.78 | 14,008.37 | 12,917.16 | 11,910.94 | 10,983.11 |
| Account Receivables (%) | ||||||||||
| Inventories | 2,771 | 2,864 | 3,695 | 3,325 | 3,123 | 2,416.78 | 2,228.52 | 2,054.93 | 1,894.85 | 1,747.25 |
| Inventories (%) | ||||||||||
| Accounts Payable | 27,018 | 29,640 | 31,836 | 29,511 | 31,101 | 22,759.51 | 20,986.60 | 19,351.80 | 17,844.34 | 16,454.31 |
| Accounts Payable (%) | ||||||||||
| Capital Expenditure | -21,251 | -19,635 | -14,690 | -15,545 | -19,626 | -13,672.67 | -12,607.60 | -11,625.50 | -10,719.90 | -9,884.85 |
| 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.