Balance Sheet Data
Canadian Pacific Railway Limited (CP.TO)
$105.66
+3.03 (+2.95%)
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 | 61 | 133 | 147 | 69 | 451 | 192.72 | 202.07 | 211.86 | 222.14 | 232.91 |
|---|---|---|---|---|---|---|---|---|---|---|
| Total Cash (%) | ||||||||||
| Account Receivables | 815 | 805 | 825 | 819 | 1,016 | 997 | 1,045.34 | 1,096.03 | 1,149.17 | 1,204.89 |
| Account Receivables (%) | ||||||||||
| Inventories | 173 | 182 | 208 | 235 | 284 | 250.62 | 262.77 | 275.51 | 288.87 | 302.88 |
| Inventories (%) | ||||||||||
| Accounts Payable | 474 | 453 | 401 | 432 | 504.54 | 529 | 554.65 | 581.54 | 609.74 | 639.30 |
| Accounts Payable (%) | ||||||||||
| Capital Expenditure | -1,551 | -1,647 | -1,671 | -1,532 | -1,557 | -1,863.75 | -1,954.11 | -2,048.86 | -2,148.20 | -2,252.36 |
| 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.