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.9991.7090.0695.66108.3191.2491.4091.5691.7291.88
Total Cash (%)
Account Receivables 453.61448.62551.01611.02608.31558.40559.37560.34561.32562.29
Account Receivables (%)
Inventories 106.75119.19124.67140.87206.56145.35145.61145.86146.11146.37
Inventories (%)
Accounts Payable 194.26201.64235.64266.85281.84246.54246.97247.40247.83248.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.