Balance Sheet Data
Alphabet Inc. (GOOG)
$136.64
-1.81 (-1.31%)
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 | 109,140 | 119,675 | 136,694 | 139,649 | 113,762 | 220,184.92 | 265,323.66 | 319,716.01 | 385,259 | 464,238.55 |
|---|---|---|---|---|---|---|---|---|---|---|
| Total Cash (%) | ||||||||||
| Account Receivables | 21,193 | 27,492 | 31,384 | 40,270 | 40,258 | 54,213 | 65,326.87 | 78,719.13 | 94,856.85 | 114,302.86 |
| Account Receivables (%) | ||||||||||
| Inventories | 1,107 | 999 | 728 | 1,170 | 2,670 | 2,197.11 | 2,647.53 | 3,190.28 | 3,844.30 | 4,632.40 |
| Inventories (%) | ||||||||||
| Accounts Payable | 4,378 | 5,561 | 5,589 | 6,037 | 5,128 | 9,443.33 | 11,379.24 | 13,712.03 | 16,523.05 | 19,910.34 |
| Accounts Payable (%) | ||||||||||
| Capital Expenditure | -25,139 | -23,548 | -22,281 | -24,640 | -31,485 | -44,868.92 | -54,067.22 | -65,151.20 | -78,507.44 | -94,601.77 |
| 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.