Balance Sheet Data
Xcel Energy Inc. (XEL)
$61.85
-0.12 (-0.19%)
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 | 147 | 248 | 129 | 166 | 111 | 214.35 | 230.65 | 248.19 | 267.07 | 287.38 |
|---|---|---|---|---|---|---|---|---|---|---|
| Total Cash (%) | ||||||||||
| Account Receivables | 1,615 | 1,550 | 1,630 | 1,880 | 2,478 | 2,364.66 | 2,544.51 | 2,738.04 | 2,946.28 | 3,170.36 |
| Account Receivables (%) | ||||||||||
| Inventories | 548 | 544 | 535 | 631 | 803 | 792.52 | 852.80 | 917.66 | 987.46 | 1,062.56 |
| Inventories (%) | ||||||||||
| Accounts Payable | 1,237 | 1,294 | 1,237 | 1,409 | 1,804 | 1,810.60 | 1,948.31 | 2,096.49 | 2,255.94 | 2,427.52 |
| Accounts Payable (%) | ||||||||||
| Capital Expenditure | -3,957 | -4,225 | -5,369 | -4,244 | -4,638 | -5,911.65 | -6,361.27 | -6,845.09 | -7,365.70 | -7,925.91 |
| 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.