Balance Sheet Data
PC Connection, Inc. (CNXN)
$43.56
-0.70 (-1.58%)
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 | 49.99 | 91.70 | 90.06 | 95.66 | 108.31 | 91.24 | 91.40 | 91.56 | 91.72 | 91.88 |
---|---|---|---|---|---|---|---|---|---|---|
Total Cash (%) | ||||||||||
Account Receivables | 453.61 | 448.62 | 551.01 | 611.02 | 608.31 | 558.40 | 559.37 | 560.34 | 561.32 | 562.29 |
Account Receivables (%) | ||||||||||
Inventories | 106.75 | 119.19 | 124.67 | 140.87 | 206.56 | 145.35 | 145.61 | 145.86 | 146.11 | 146.37 |
Inventories (%) | ||||||||||
Accounts Payable | 194.26 | 201.64 | 235.64 | 266.85 | 281.84 | 246.54 | 246.97 | 247.40 | 247.83 | 248.26 |
Accounts Payable (%) | ||||||||||
Capital Expenditure | -11.80 | -21.24 | -25.66 | -11.03 | -10.30 | -16.71 | -16.74 | -16.77 | -16.80 | -16.83 |
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.