Balance Sheet Data
PC Connection, Inc. (CNXN)
$63.98
+1.20 (+1.91%)
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 | 91.70 | 90.06 | 95.66 | 108.31 | 122.93 | 116.76 | 121.43 | 126.30 | 131.36 | 136.62 |
|---|---|---|---|---|---|---|---|---|---|---|
| Total Cash (%) | ||||||||||
| Account Receivables | 448.62 | 551.01 | 610.10 | 608.31 | 610.28 | 651.79 | 677.90 | 705.06 | 733.30 | 762.68 |
| Account Receivables (%) | ||||||||||
| Inventories | 119.19 | 124.67 | 140.87 | 206.56 | 208.68 | 182.62 | 189.93 | 197.54 | 205.45 | 213.68 |
| Inventories (%) | ||||||||||
| Accounts Payable | 201.64 | 235.64 | 266.85 | 281.84 | 232.64 | 281.56 | 292.84 | 304.57 | 316.78 | 329.46 |
| Accounts Payable (%) | ||||||||||
| Capital Expenditure | -21.24 | -25.66 | -11.03 | -10.30 | -9.08 | -18 | -18.72 | -19.47 | -20.25 | -21.06 |
| 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.