Balance Sheet Data

T. Rowe Price Spectrum Conservative... (PPIPX)

$18.52

-0.05 (0.00%)

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,20412,1309,74019,2233,7397,568.406,978.846,435.205,933.925,471.68
Total Cash (%)
Account Receivables 27,71624,24722,26914,89514,40715,191.7814,008.3712,917.1611,910.9410,983.11
Account Receivables (%)
Inventories 2,7712,8643,6953,3253,1232,416.782,228.522,054.931,894.851,747.25
Inventories (%)
Accounts Payable 27,01829,64031,83629,51131,10122,759.5120,986.6019,351.8017,844.3416,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.