Balance Sheet Data

PepsiCo, Inc. (PEP)

$168.16

-0.10 (-0.06%)

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 5,7389,5515,9885,34810,0039,248.019,994.6810,801.6411,673.7512,616.28
Total Cash (%)
Account Receivables 7,8228,4048,68010,16310,81511,486.2612,413.6413,415.9014,499.0915,669.72
Account Receivables (%)
Inventories 3,3384,1724,3475,2225,3345,584.036,034.876,522.127,048.717,617.81
Inventories (%)
Accounts Payable 8,0138,8539,83410,73211,63512,263.1613,253.2814,323.3315,479.7816,729.59
Accounts Payable (%)
Capital Expenditure -4,232-4,240-4,625-5,207-5,518-5,971.80-6,453.96-6,975.04-7,538.20-8,146.83
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.