Balance Sheet Data

PepsiCo, Inc. (PEP)

$182.865

+0.69 (+0.38%)

Year
A/P
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Total Cash 19,5108,9935,7389,5515,98812,494.8713,224.8813,997.5314,815.3315,680.91
Total Cash (%)
Account Receivables 7,0247,1427,8228,4048,6809,524.2710,080.7210,669.6811,293.0511,952.84
Account Receivables (%)
Inventories 2,9473,1283,3384,1724,3474,348.024,602.054,870.925,155.505,456.71
Inventories (%)
Accounts Payable 6,7277,2138,0138,8539,8349,863.5510,439.8311,049.7711,695.3412,378.64
Accounts Payable (%)
Capital Expenditure -2,969-3,282-4,232-4,240-4,625-4,692.96-4,967.14-5,257.35-5,564.50-5,889.61
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.