Balance Sheet Data

PC Connection, Inc. (CNXN)

$59.9

+0.27 (+0.45%)

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.7090.0695.66108.31122.93116.76121.43126.30131.36136.62
Total Cash (%)
Account Receivables 448.62551.01610.10608.31610.28651.79677.90705.06733.30762.68
Account Receivables (%)
Inventories 119.19124.67140.87206.56208.68182.62189.93197.54205.45213.68
Inventories (%)
Accounts Payable 201.64235.64266.85281.84232.64281.56292.84304.57316.78329.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.