Balance Sheet Data
Xcel Energy Inc. (XEL)
$67.82
-1.06 (-1.54%)
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 | 83 | 147 | 248 | 129 | 166 | 182.52 | 190.55 | 198.93 | 207.68 | 216.82 |
---|---|---|---|---|---|---|---|---|---|---|
Total Cash (%) | ||||||||||
Account Receivables | 1,561 | 1,615 | 1,550 | 1,630 | 1,880 | 1,942.61 | 2,028.08 | 2,117.31 | 2,210.46 | 2,307.71 |
Account Receivables (%) | ||||||||||
Inventories | 610 | 548 | 544 | 535 | 631 | 677.46 | 707.27 | 738.39 | 770.87 | 804.79 |
Inventories (%) | ||||||||||
Accounts Payable | 1,243 | 1,237 | 1,294 | 1,237 | 1,409 | 1,516.29 | 1,583 | 1,652.65 | 1,725.36 | 1,801.27 |
Accounts Payable (%) | ||||||||||
Capital Expenditure | -3,319 | -3,957 | -4,225 | -5,369 | -4,244 | -4,998.23 | -5,218.13 | -5,447.72 | -5,687.40 | -5,937.63 |
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.