PC CONNECTION INC (CNXN) FY 2023 MD&A
This page reproduces the company's own Item 7 MD&A text from the linked SEC filing. It is filer text, not grepcent analysis, scoring, or investment advice.
Item 7. Management’s Discussion and Analysis of Financial Condition and Results of Operations
The following Management’s Discussion and Analysis of Financial Condition and Results of Operations, or MD&A, is intended to promote an understanding of our results of operations and financial condition. MD&A is provided as a supplement to, and should be read in conjunction with, our consolidated financial statements and the accompanying notes thereto included in Part II, Item 8 of this Annual Report on Form 10-K. This section discusses the results of operations for the year ended December 31, 2023 and year-to-year comparison between the year ended December 31, 2023 and the year ended December 31, 2022. Discussion of the year ended December 31, 2022 and the year-to-year comparison between the year ended December 31, 2022 and the year ended December 31, 2021 can be found in Part II, Item 7 “Management’s Discussions and Analysis of Financial Condition and Results of Operations” of our Annual Report on Form 10-K for the year ended December 31, 2022. Our MD&A also includes discussion of certain forward-looking trends and other statements that predict or anticipate future business or financial results that are subject to important factors that could cause our actual results to differ materially from those indicated. See “Cautionary Note Concerning Forward-Looking Statements” and “Item 1A. Risk Factors.”
OVERVIEW
We are a Fortune 1000 Global Solutions Provider that simplifies the IT customer experience, guiding the connection between people and technology. Our dedicated account managers partner with customers to design, deploy, and support cutting-edge IT environments using the latest hardware, software, and services. We provide a wide range of IT solutions, from the desktop to the cloud—including computer systems, data center solutions, software and peripheral equipment, networking communications, and other products and accessories that we purchase from manufacturers, distributors, and other suppliers. In 2023, we restructured and combined our Technology Solutions Group and Technical Sales Organization into one organization to be referred to as our TSO. Our TSO and state-of-the-art TIDC, with ISO 9001:2015 certified technical configuration lab offer end-to-end services related to the design, configuration, and implementation of IT solutions. Our team also provides a comprehensive portfolio of managed services and professional services. These services are performed by our personnel and by third-party providers. Our GlobalServe offering ensures worldwide coverage for our multinational customers, delivering global procurement solutions through our network of in-country suppliers in over 150 countries.
The “Connection®” brand includes Connection Enterprise Solutions, Connection Business Solutions, and Connection Public Sector Solutions, which provide IT solutions and services to enterprise, SMBs, and public sector markets.
Financial results for each of our segments are included in the financial statements attached hereto. We generate sales through (i) outbound inside sales and field sales contacts by sales representatives focused on the business, educational, healthcare, retail, manufacturing, and government markets, (ii) our websites, and (iii) direct responses from customers responding to our advertising media. We offer a broad selection of over 460,000 products at competitive prices, including products from vendors like Apple, Cisco, Dell Inc., Hewlett-Packard Inc., Hewlett-Packard Enterprise, Intel, Lenovo, Microsoft Corporation, and VMware, and we partner with more than 2,500 suppliers. We are able to leverage our state-of-the art logistic capabilities to rapidly ship product to customers.
As a value-added reseller in the IT supply chain, we do not manufacture IT hardware or software products. We are dependent on our suppliers—manufacturers and distributors that historically have only sold to resellers rather than directly to end users. However, certain manufacturers have, on multiple occasions, sold or attempted to sell directly to our customers, and in some cases, have restricted our ability to sell their products directly to certain customers, thereby attempting to and, in some cases successfully, eliminate our role. We believe that the success of these direct sales efforts by manufacturers will depend on their ability to meet our customers’ ongoing demands and provide solutions to meet their needs. We believe more of our customers are seeking out comprehensive and integrated IT solutions, rather than the ability to acquire specific IT products on a one-off basis. Our advantage is our ability to be product-neutral and provide a broader combination of products, services, and advice tailored to our customers’ individual needs. By providing customers with customized solutions from a variety of manufacturers, we believe we can mitigate the negative impact of continued direct sales initiatives from individual manufacturers. Through the formation of our TSO, we are able to provide customers complete IT solutions, from identifying their needs, to designing, developing, and managing the
30
Table of Contents
integration of products and services to implement their IT projects. Such service offerings carry higher margins than traditional product sales. Additionally, the technical certifications of our service engineers permit us to offer higher-end, more complex products that generally carry higher gross margins. We expect these service offerings and technical certifications to continue to play a role in sales generation and gross margin improvements in this competitive environment.
The primary challenges we continue to face in effectively managing our business are (1) increasing our product and service revenues while at the same time improving our gross margin in all three segments, (2) recruiting, retaining, and improving the productivity of our sales and technical support personnel, and (3) effectively controlling our SG&A expenses while making major investments in our IT systems and solution selling personnel, especially in relation to changing revenue levels.
To support future growth, we have invested and expect to continue to invest in our IT solutions business, which requires the addition of highly skilled service engineers. Although we expect to realize the ultimate benefit of higher-margin service revenues under this multi-year initiative, we believe that our cost of services will increase as we add additional service engineers. If our service revenues do not grow enough to offset the cost of these headcount additions, our operating results may be negatively impacted.
Market conditions and technology advances significantly affect the demand for our products and services. Virtual delivery of software products and advanced Internet technology providing customers enhanced functionality have substantially increased customer expectations, requiring us to invest on an ongoing basis in our own IT infrastructure to meet these new demands.
Our investments in IT infrastructure are designed to enable us to operate more efficiently and provide our customers enhanced functionality.
Trends and Key Factors Affecting our Financial Performance
| Column 1 | Column 2 | Column 3 |
|---|---|---|
| ● | As the AI market continues to evolve, it is difficult to predict and forecast its potential impact on our business and results of operations in the future. We may be required to make significant investments to keep up with increasing competition surrounding AI. Additionally, potential issues with the AI products we sell could have an adverse effect on our business and results of operations in the future. |
| Column 1 | Column 2 | Column 3 |
|---|---|---|
| ● | Inflation due to, among other things, higher interest rates and the uncertain economic environment, impacts product costs and wages. The increased product costs and wages due to inflation may adversely affect our business, financial condition and results of operations. If product costs and wages increase significantly or for an extended period of time, we may not be able to adjust prices to sufficiently offset the effect of the various cost increases without negatively impacting customer demand. |
| Column 1 | Column 2 | Column 3 |
|---|---|---|
| ● | The Federal Reserve increased interest rates in 2023, but it is anticipated that interest rates will remain steady and potentially decrease in 2024. Although we don’t have any borrowing under our credit facility, should we need to borrow in the future, we may be exposed to high interest rates. Additionally, if interest rates were to decrease, our interest income on our cash equivalents and short-term investments would also decrease. |
31
Table of Contents
RESULTS OF OPERATIONS
The following table sets forth information derived from our statements of income expressed as a percentage of net sales for the periods indicated:
| | | | | | | | | | | |
|---|---|---|---|---|---|---|---|---|---|---|
| | | Years Ended December 31, | ||||||||
| | | | 2023 | | | 2022 | | 2021 | | |
| Net sales (in millions) | | $ | 2,850.6 | | $ | 3,125.0 | | $ | 2,892.6 | |
| Gross margin | | | 18.0 | % | | 16.8 | % | | 16.1 | % |
| Selling, general and administrative expenses | | 14.2 | | 13.0 | | 12.7 | | |||
| Income from operations | | 3.6 | | 3.9 | | 3.3 | |
Net sales of $2,850.6 million in 2023 reflected a decrease of $274.4 million compared to 2022, which was driven by lower net sales for our Enterprise Solutions and Business Solutions segments as shown in the table on page 34 of this Annual Report on Form 10-K. The decrease in net sales was primarily driven by a decrease in demand for end-point devices resulting in a decrease in net sales of notebooks/mobility of $205.2 million. Net sales of accessories, displays and sound, and desktops also decreased year-over-year, as shown in Note 2 of the Consolidated Financial Statements. Gross profit decreased year-over-year by $14.5 million as shown in the table on page 34 of this Annual Report on Form 10-K, primarily due to the decrease in net sales. Gross margin increased year-over-year by 120 basis points as shown in the above table primarily due to an increase in net sales of higher margin products, such as software and services, which are recognized on a net basis, and net/com products, relative to lower margin products, such as notebooks/mobility and desktops, as evidenced in the below product mix table. SG&A expenses remained consistent year-over-year in dollars but increased as a percentage of net sales primarily due to the decrease in net sales. Operating income decreased year-over-year both in dollars and as a percentage of net sales by $17.4 million and 60 basis points, respectively, primarily as a result of the decrease in net sales.
Sales Distribution
The following table sets forth our percentage of net sales by operating segment and product mix:
| | | | | | | | |
|---|---|---|---|---|---|---|---|
| | | Years Ended December 31, | |||||
| | | 2023 | 2022 | 2021 | |||
| Operating Segment | | | | | | | |
| Enterprise Solutions | | 42 | % | 42 | % | 43 | % |
| Business Solutions | | 38 | 40 | 38 | | ||
| Public Sector Solutions | | 20 | 18 | 19 | | ||
| Total | | 100 | % | 100 | % | 100 | % |
| | | | | | | | |
| Product Mix | | | | | | | |
| Notebooks/Mobility | | 33 | % | 37 | % | 38 | % |
| Desktops | | 9 | | 10 | | 9 | |
| Software | | 12 | | 9 | | 10 | |
| Servers/Storage | | 7 | | 7 | | 7 | |
| Net/Com Products | | 10 | 7 | 7 | | ||
| Displays and Sound | | 9 | 10 | 10 | | ||
| Accessories | | 11 | 13 | 12 | | ||
| Other Hardware/Services | | 9 | 7 | 7 | | ||
| Total | | 100 | % | 100 | % | 100 | % |
32
Table of Contents
Gross Margins
The following table summarizes our overall gross margins, as a percentage of net sales, for the last three years:
| | | | | | | | |
|---|---|---|---|---|---|---|---|
| | | Years Ended December 31, | |||||
| | | 2023 | 2022 | 2021 | |||
| Operating Segment | | | | | | | |
| Enterprise Solutions | | 14.9 | % | 14.7 | % | 14.5 | % |
| Business Solutions | | 23.0 | 20.1 | 19.2 | | ||
| Public Sector Solutions | | 14.9 | 14.4 | 13.3 | | ||
| Total Company | | 18.0 | % | 16.8 | % | 16.1 | % |
Cost of Sales
Cost of sales includes the invoice cost of the product, direct employee and third-party cost of services, direct costs of packaging, inbound and outbound freight, and provisions for inventory obsolescence, adjusted for discounts, rebates, and other vendor allowances.
Operating Expenses
The following table reflects our most significant operating expenses for the last three years (dollars in millions):
| | | | | | | | | | | |
|---|---|---|---|---|---|---|---|---|---|---|
| | | Years Ended December 31, | ||||||||
| ($ in millions) | | 2023 | 2022 | 2021 | ||||||
| Personnel costs | | $ | 311.6 | | $ | 308.4 | | $ | 277.8 | |
| Advertising | | 22.4 | | 20.2 | | 15.8 | | |||
| Service contracts/subscriptions | | | 21.0 | | 19.7 | | 17.3 | | ||
| Professional fees | | 12.9 | | 15.3 | | 16.4 | | |||
| Depreciation and amortization | | 12.7 | | 12.0 | | 12.2 | | |||
| Facilities operations | | 8.2 | | 8.6 | | 8.3 | | |||
| Credit card fees | | 6.7 | | 6.9 | | 7.0 | | |||
| Other | | 10.4 | | 14.5 | | 13.3 | | |||
| Total SG&A expense | | $ | 405.9 | | $ | 405.6 | | $ | 368.1 | |
| As a percentage of net sales | | | 14.2 | % | | 13.0 | % | | 12.7 | % |
Restructuring and other charges
During the year ended December 31, 2023, we undertook actions to lower our cost structure. In connection with these initiatives, we incurred restructuring and other charges of $2.7 million for the year ended December 31, 2023. These restructuring charges were primarily related to an involuntary reduction in our headquarter workforce and included cash severance and other related termination benefits. These costs will be paid within a year of termination and any unpaid balances are included in accrued expenses and other liabilities on the consolidated balance sheets as of December 31, 2023. The Company is currently evaluating additional restructuring activities for 2024 and beyond. There were no restructuring related costs incurred for the years ended December 31, 2022 and 2021.
33
Table of Contents
YEAR-OVER-YEAR COMPARISONS
Year Ended December 31, 2023 Compared to Year Ended December 31, 2022
Changes in net sales and gross profit by operating segment are shown in the following table (dollars in millions):
| | | | | | | | | | | | | | | | | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| | | Years Ended December 31, | | | | | | |||||||||
| | | 2023 | | 2022 | | | | | | |||||||
| | | | | % of | | | % of | $ | | % | ||||||
| | | Amount | | Net Sales | | Amount | | Net Sales | | Change | | Change | ||||
| Net Sales: | | | | | | | | | | | | | | | | |
| Enterprise Solutions | | $ | 1,201.1 | 42.2 | % | $ | 1,324.4 | 42.4 | % | $ | (123.3) | | (9.3) | % | ||
| Business Solutions | | | 1,075.6 | | 37.7 | | | 1,245.3 | | 39.8 | | | (169.7) | | (13.6) | |
| Public Sector Solutions | | 573.9 | 20.1 | | 555.3 | 17.8 | 18.6 | | 3.3 | | ||||||
| Total | | $ | 2,850.6 | | 100.0 | % | $ | 3,125.0 | | 100.0 | % | $ | (274.4) | | (8.8) | % |
| Gross Profit: | | | | | | | | | | | | | | | | |
| Enterprise Solutions | | $ | 178.9 | 14.9 | % | $ | 195.1 | 14.7 | % | $ | (16.2) | | (8.3) | % | ||
| Business Solutions | | | 247.1 | | 23.0 | | | 250.9 | | 20.1 | | | (3.8) | | (1.5) | |
| Public Sector Solutions | | 85.7 | 14.9 | | 80.2 | 14.4 | 5.5 | | 7.0 | | ||||||
| Total | | $ | 511.7 | | 18.0 | % | $ | 526.2 | | 16.8 | % | $ | (14.5) | | (2.7) | % |
Net sales decreased by 8.8% to $2,850.6 million in 2023 from $3,125.0 million in 2022, as explained below:
| Column 1 | Column 2 |
|---|---|
| ● | Net sales of $1,201.1 million for the Enterprise Solutions segment reflect a decrease of $123.3 million, or 9.3%, year-over-year, primarily due to a decrease in demand of end-point devices. Net sales of notebooks/mobility, accessories, desktops, and displays and sound decreased year-over-year by $70.5 million, $47.0 million, $27.8 million, and $25.9 million, respectively. These decreases were partially offset by increases in net sales of net/com products, software, and other hardware/services of $26.5 million, $16.2 million, and $4.8 million, respectively. |
| Column 1 | Column 2 |
|---|---|
| ● | Net sales of $1,075.6 million for the Business Solutions segment reflect a decrease of $169.7 million, or 13.6% year-over-year, primarily due to a decrease in demand of end-point devices. Net sales of notebooks/mobility, displays and sound, accessories, desktops, servers/storage, and other hardware/services decreased year-over-year by $121.3 million, $26.5 million, $21.5 million, $14.8 million, $13.0 million, and $5.6 million, respectively. These decreases were partially offset by increases in net sales of net/com products and software of $23.0 million and $9.9 million, respectively. |
| Column 1 | Column 2 |
|---|---|
| ● | Net sales of $573.9 million for the Public Sector Solutions segment reflect an increase of $18.6 million, or 3.3%, year-over-year. The increase was primarily driven by an increase in sales to federal governments, partially offset by a decrease of sales to state and local government and educational institutions. Net sales of net/com products, software, and other hardware/services increased year-over-year by $29.9 million, $11.3 million, and $6.8 million, respectively. These increases were partially offset by decreases in net sales of notebooks/mobility, accessories, and displays and sound of $13.5 million, $8.4 million, and $7.6 million, respectively. |
Gross profit decreased by 2.7% to $511.7 million in 2023, while gross margin increased by 120 basis points to 18.0% in 2023, as explained below:
| Column 1 | Column 2 |
|---|---|
| ● | Gross profit for the Enterprise Solutions segment decreased $16.2 million, or 8.3% year-over-year as referenced in the above table. This decrease was primarily due to the 9.3% decrease in net sales. Gross margin increased 20 basis points compared to the prior year primarily due to an increase in net sales of higher margin products, such as net/com products and software, which is recognized on a net basis, relative to lower margin products, such as notebooks/mobility and accessories. |
| Column 1 | Column 2 |
|---|---|
| ● | Gross profit for the Business Solutions segment decreased $3.8 million, or 1.5% year-over-year as referenced in the above table. This decrease was primarily a result of a 13.6% decrease in net sales. Gross margin increased 290 basis |
34
Table of Contents
| Column 1 | Column 2 |
|---|---|
| points compared to the prior year primarily due to an increase in net sales of higher margin products, such as software, which is recognized on a net basis, and net/com products, relative to lower margin products, such as notebooks/mobility and displays and sound. |
| Column 1 | Column 2 |
|---|---|
| ● | Gross profit for the Public Sector Solutions segment increased by $5.5 million, or 7.0% year-over-year as referenced in the table on the previous page, primarily as a result of higher net sales in the current period. Gross margin increased 50 basis points compared to the prior year primarily due to an increase in net sales of higher margin products, such as net/com products and software, which is recognized on a net basis, relative to lower margin products, such as notebooks/mobility, accessories, and displays and sound. |
SG&A expense in 2023 remained consistent year-over-year in dollars but increased as a percentage of net sales. SG&A expenses attributable to our three operating segments and the remaining unallocated Headquarters/Other group expenses are summarized below (dollars in millions):
| | | | | | | | | | | | | | | | | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| | | Years Ended December 31, | | | | | | |||||||||
| | | 2023 | | 2022 | | | | | | |||||||
| | | | | % of | | | % of | $ | | % | ||||||
| | | Amount | | Net Sales | | Amount | | Net Sales | | Change | | Change | ||||
| Enterprise Solutions | | $ | 138.5 | 11.5 | % | $ | 141.5 | 10.7 | % | $ | (3.0) | | (2.1) | % | ||
| Business Solutions | | | 170.9 | | 15.9 | | | 171.5 | | 13.8 | | | (0.6) | | (0.3) | |
| Public Sector Solutions | | 83.6 | 14.6 | | 79.1 | 14.2 | 4.5 | | 5.7 | | ||||||
| Headquarters/Other, unallocated | | 12.9 | | | | 13.5 | | | (0.6) | | (4.5) | | ||||
| Total | | $ | 405.9 | | 14.2 | % | $ | 405.6 | | 13.0 | % | $ | 0.3 | | 0.1 | % |
| Column 1 | Column 2 |
|---|---|
| ● | SG&A expenses for the Enterprise Solutions segment decreased in dollars but increased as a percentage of net sales. The year-over-year decrease in SG&A dollars was primarily attributable to decreases in the use of Headquarter services, personnel costs, and other expenses of $1.8 million, $1.8 million, and $1.1 million, respectively. The Headquarter services include services related to finance, distribution center, human resources, IT, marketing, and product management. These decreases were partially offset by an increase in advertising costs of $2.4 million. SG&A expenses as a percentage of net sales were 11.5% for the Enterprise Solutions segment for the year ended December 31, 2023, which reflects an increase of 80 basis points and is primarily due to the decrease in net sales. |
| Column 1 | Column 2 |
|---|---|
| ● | SG&A expenses for the Business Solutions segment remained consistent in dollars but increased as a percentage of net sales. The year-over-year increase in personnel costs of $3.8 million related to investments in resources to strengthen our sales organization was offset by decreases in the use of Headquarter services, other expenses, and advertising costs of $2.4 million, $0.7 million, and $0.6 million, respectively. SG&A expenses as a percentage of net sales were 15.9% for the Business Solutions segment for the year ended December 31, 2023, which reflects an increase of 210 basis points and is primarily due to the decrease in net sales. |
| Column 1 | Column 2 |
|---|---|
| ● | SG&A expenses for the Public Sector Solutions segment increased in dollars and as a percentage of net sales. The increase in SG&A dollars year-over-year is primarily attributable to an increase in personnel costs of $5.0 million related to investments in resources to strengthen our sales organization. This increase was partially offset by a decrease in the use of Headquarter services of $1.2 million. SG&A expenses as a percentage of net sales were 14.6% for the Public Sector Solutions segment for the year ended December 31, 2023, which reflects an increase of 40 basis points and is consistent with the 5.7% increase in SG&A expenses compared to just a 3.3% increase in net sales. |
| Column 1 | Column 2 |
|---|---|
| ● | SG&A expenses for the Headquarters/Other group decreased by $0.6 million primarily due to decreases in personnel costs and professional fees of $3.9 million and $2.5 million, respectively. These decreases were partially offset by an increase in unallocated Headquarter services of $5.4 million. |
Income from operations for the year ended December 31, 2023 decreased to $103.2 million, compared to $120.6 million for the same period in the prior year, primarily due to the decreases in net sales and gross profit explained above.
35
Table of Contents
Income from operations as a percentage of net sales decreased to 3.6% for the year ended December 31, 2023, compared to 3.9% of net sales for the same period in the prior year, primarily due to the decreases in net sales and gross profit.
Other income, net for the year ended December 31, 2023 increased to $10.0 million, compared to $1.1 million for the same period in the prior year, primarily due to an increase in interest income of $8.9 million as a result of higher cash equivalent balances and interest rates on short-term investments.
Income taxes. Our provision for income taxes for the year ended December 31, 2023 was $29.8 million, compared to $32.4 million for the same period in the prior year. The decrease in our provision for income taxes was primarily due to the decrease in income from operations, partially offset by the increase in other income, net. Our effective tax rate was 26.4% for the year-ended December 31, 2023, compared to 26.7% for the year ended December 31, 2022.
Net income decreased by $5.9 million to $83.3 million for the year ended December 31, 2023, from $89.2 million in the prior year, primarily due to the decreases in net sales and gross profit, partially offset by an increase in other income, net in the current year, as explained above.
LIQUIDITY AND CAPITAL RESOURCES
Liquidity Overview
Our primary sources of liquidity are internally generated funds from operations, short-term investments, and borrowings under our credit facility. We have historically used and expect to use in the future those funds to meet our capital requirements, which consist primarily of working capital for operational needs, capital expenditures for computer equipment and software used in our business, repurchases of common stock for treasury, dividend payments, and as opportunities arise, possible acquisitions of new businesses.
We believe that funds generated from operations, together with available capacity under our credit facility, will be sufficient to finance our working capital, capital expenditures, and other requirements for at least the next twelve calendar months and beyond such twelve calendar month period. Our investments in IT systems and infrastructure are designed to enable us to operate more efficiently and to provide our customers enhanced functionality.
We expect to meet our cash requirements for 2024 and beyond through a combination of cash on hand, short-term investments, cash generated from operations, and borrowings under our credit facility, as follows:
| Column 1 | Column 2 |
|---|---|
| ● | Cash on Hand. As of December 31, 2023, we had $145.0 million in cash and cash equivalents. |
| Column 1 | Column 2 |
|---|---|
| ● | Short-term Investments. As of December 31, 2023, we had $152.2 million in short-term investments. |
| Column 1 | Column 2 |
|---|---|
| ● | Cash Generated from Operations. We expect to generate cash flows from operations in excess of operating cash needs by generating earnings and managing net changes in inventories and receivables with changes in payables to generate positive cash flow. |
| Column 1 | Column 2 |
|---|---|
| ● | Credit facility. As of December 31, 2023, no borrowings were outstanding under our $50.0 million credit facility, which is available until March 2025. Accordingly, our entire line of credit was available for borrowing as of December 31, 2023. This line of credit can be increased, at our option, to $80.0 million for approved acquisitions or other uses authorized by the bank. Borrowings are, however, limited by certain minimum collateral and earnings requirements, as described more fully below. As of December 31, 2023, we were in compliance with the covenants of our credit facility. |
Our ability to continue funding our planned growth, both internally and externally, is dependent upon our ability to generate sufficient cash flow from operations or to obtain additional funds through equity or debt financing, or from other sources of financing, as may be required. While we do not anticipate needing any additional sources of financing to fund our operations at this time, if demand for IT products declines, or our customers are materially adversely impacted by the developing macroeconomic trends characterized by inflation and increased interest rates, our cash flows from
36
Table of Contents
operations may be substantially affected. For additional discussion see related risks listed under “Item 1A. Risk Factors” of this Annual Report on Form 10-K.
Summary Sources and Uses of Cash
The following table summarizes our sources and uses of cash over the last three years (in millions):
| | | | | | | | | | | |
|---|---|---|---|---|---|---|---|---|---|---|
| | | Years Ended December 31, | ||||||||
| | | 2023 | 2022 | 2021 | ||||||
| Net cash provided by operating activities | | $ | 197.9 | | $ | 34.9 | | $ | 57.8 | |
| Net cash used in investing activities | | (160.2) | | (9.1) | | (8.7) | | |||
| Net cash used in financing activities | | (15.7) | | (11.2) | | (36.4) | | |||
| Increase in cash and cash equivalents | | $ | 22.0 | | $ | 14.6 | | $ | 12.7 | |
Cash provided by operating activities was $197.9 million for the year ended December 31, 2023, which resulted primarily from $83.3 million of net income, $18.4 million of other non-cash charges added back to net income (including $12.7 million of depreciation and amortization and $7.0 million of stock-based compensation expense), an $84.5 million decrease in inventory, and a $31.1 million increase in accounts payable. These factors that contributed to the positive inflow of cash from operating activities were partially offset by a decrease in accrued expenses and other liabilities of $11.8 million and an increase in prepaid expenses and other current assets of $8.5 million. The decrease in inventory was primarily due to a decrease in the amount of inventory we purchased, combined with the delivery of inventory held associated with the continued fulfillment of orders in 2023 that were in backlog during 2022. The increase in accounts payable was primarily driven by the timing of payments. Cash provided by operating activities for the year ended December 31, 2022 resulted primarily from cash provided by net income of $89.2 million and $19.6 million of other non-cash charges added back to net income, including $12.0 million of depreciation and amortization, partially offset by increases in account payable and accrued expenses of $49.1 million and $14.7 million, respectively.
In order to manage our working capital and operating cash needs, we monitor our cash conversion cycle, defined as days of sales outstanding in accounts receivable plus days of supply in inventory minus days of purchases outstanding in accounts payable, based on a rolling three-month average. Components of our cash conversion cycle are as follows:
| | | | | | | |
|---|---|---|---|---|---|---|
| | | December 31, | ||||
| (in days) | | 2023 | | 2022 | ||
| Days of sales outstanding (DSO)(1) | | | 73 | | | 70 |
| Days of supply in inventory (DIO)(2) | | | 20 | | | 31 |
| Days of purchases outstanding (DPO)(3) | | | (42) | | | (35) |
| Cash conversion cycle | | | 51 | | | 66 |
(1) Represents the trade receivable at the end of the period divided by average daily net sales for the same three-month period.
(2) Represents the merchandise inventory balance at the end of the period divided by average daily cost of sales for the same three-month period.
(3) Represents the accounts payable balance at the end of the period divided by average daily cost of sales for the same three-month period.
The cash conversion cycle decreased to 51 days for the quarter ended December 31, 2023, compared to 66 days for the quarter ended December 31, 2022, as evidenced in the above cash conversion table. The increase in DSO is primarily due to increased netted product sales which reduces the revenue, but not the receivable balance. The decrease in DIO is consistent with the decrease in inventory discussed above. The increase in DPO is consistent with the increase in accounts payable discussed above.
37
Table of Contents
Cash used in investing activities for the year ended December 31, 2023 consisted of $150.6 million of purchases of short-term U.S. Government treasury securities and $9.6 million of purchases of property and equipment. The property and equipment expenditures were primarily for computer equipment and capitalized internally-developed software in connection with investments in our IT infrastructure. Cash used in investing activities for the prior year consisted of $9.1 million of purchases of property and equipment.
Cash used in financing activities for the year ended December 31, 2023 consisted of $88.2 million of aggregate borrowings and repayments under our credit facility, $5.4 million of treasury repurchases, $8.4 million of dividend payments, $1.1 million of issuances of stock under the 1997 Employee Stock Purchase Plan, and $3.0 million of payroll taxes on stock-based compensation through shares withheld. In the prior year period, financing activities consisted primarily of $8.9 million in special dividend payments.
Debt Instruments, Contractual Agreements, and Related Covenants
Below is a summary of certain provisions of our credit facilities and other contractual obligations. For more information about the restrictive covenants in our debt instruments and inventory financing agreements, see “Factors Affecting Sources of Liquidity” below. For more information about our obligations, commitments, and contingencies, see our consolidated financial statements and the accompanying notes included in this annual report.
Credit facility. Our credit facility extends until March 2025 and is collateralized by our accounts receivable. As of December 31, 2023, our borrowing capacity under the credit facility was up to $50.0 million. Amounts outstanding under this facility bear interest at the greatest of (i) the prime rate (8.50% at December 31, 2023), (ii) the federal funds effective rate plus 0.50% per annum and (iii) the daily Bloomberg Short-Term Bank Yield Index, or BSBY Rate, plus 1.00% per annum, provided that the rate shall at no time be less than 0% per annum. In addition, we have the option to increase our borrowing capacity under the credit facility up to an additional $30.0 million provided that we meet certain additional borrowing requirements and obtain the consent of the administrative agent. Our credit facility is subject to certain covenant requirements which are described below under “Factors Affecting Sources of Liquidity”. We did not have any borrowings outstanding under the credit facility as of December 31, 2023.
Cash receipts are automatically applied against any outstanding borrowings. Any excess cash on account may either remain on account to generate earned credits to offset up to 100% of cash management fees, or may be invested in short-term qualified investments. Borrowings under the line of credit are classified as current in our consolidated balance sheet. As of December 31, 2023, the entire $50.0 million facility was available for borrowing.
Operating Leases. We lease facilities from our principal stockholders and facilities from third parties under non-cancelable operating leases. Certain leases require us to pay real estate taxes, insurance, and common area maintenance charges. See “Item 2. Properties” of this Annual Report on Form 10-K for additional information regarding our operating leases.
Factors Affecting Sources of Liquidity
Internally Generated Funds. The key factors affecting our internally generated funds are our ability to manage costs and fully achieve our operating efficiencies, timely collection of our customer receivables, and management of our inventory levels.
Credit facility. Our credit facility extends until March 2025 and is collateralized by our accounts receivable. As of December 31, 2023, the entire $50.0 million facility was available for borrowing. Our credit facility contains certain financial ratios and operational covenants and other restrictions (including restrictions on additional debt, guarantees, and other distributions, investments, and liens) with which we and all of our subsidiaries must comply. Any failure to comply with these covenants would constitute a default and could prevent us from borrowing additional funds under this line of credit. This credit facility contains two financial tests:
| Column 1 | Column 2 |
|---|---|
| ● | The funded debt ratio (defined as the average outstanding advances under the line for the quarter, divided by the consolidated trailing twelve months Adjusted Earnings Before Interest Expense, Taxes, Depreciation, Amortization, |
38
Table of Contents
| Column 1 | Column 2 |
|---|---|
| and Special Charges, or Adjusted EBITDA, for the trailing four quarters) must not be more than 2.0 to 1.0. We did not have any outstanding borrowings under the credit facility during the fourth quarter of 2023, and accordingly, the funded debt ratio did not limit potential borrowings as of December 31, 2023. Future decreases in our consolidated trailing twelve months Adjusted EBITDA could limit our potential borrowings under the line of credit. |
| Column 1 | Column 2 |
|---|---|
| ● | Minimum Consolidated Net Worth (defined as our consolidated total assets less our consolidated total liabilities) must be at least $346.7 million, plus 50% of consolidated net income for each quarter, beginning with the quarter ended December 31, 2016 (loss quarters not counted). Such amount was calculated as $603.1 million at December 31, 2023, whereas our actual consolidated stockholders’ equity at that date was $840.8 million. |
Capital Markets. Our ability to raise additional funds in the capital market depends upon, among other things, general economic conditions, the condition of the IT industry, our financial performance and stock price, and the state of the capital markets. In addition, market volatility, inflation and interest rate fluctuations may increase our cost of financing or restrict our access to potential sources of future liquidity.
APPLICATION OF CRITICAL ACCOUNTING POLICIES AND ESTIMATES
A critical accounting policy has been defined as one that is both important to the portrayal of the registrant’s financial condition and results and requires management’s most difficult, subjective or complex judgments, often as a result of the need to make estimates about the effect of matters that are inherently uncertain. Further, “critical accounting policies” are those that are reflective of significant judgments and uncertainties, and potentially result in materially different results under different assumptions and conditions.
We believe that our accounting policies described below meet the definition of critical accounting policies and estimates.
Revenue Recognition
Revenue is recognized upon transfer of control of promised products or services to customers in an amount that reflects the consideration we expect to receive in exchange for those products or services. We enter into contracts that can include various combinations of products and services, which are generally capable of being distinct and accounted for as separate performance obligations. In most instances, when several performance obligations are aggregated into one single transaction, these performance obligations are fulfilled at the same point in time. We account for an arrangement when it has approval and commitment from both parties, the rights are identified, the contract has commercial substance, and collectability of consideration is probable. We generally obtain oral or written purchase authorizations from our customers for a specified amount of product at a specified price, which constitutes an arrangement. Revenue is recognized at the amount expected to be collected, net of any taxes collected from customers, which are subsequently remitted to governmental authorities. We generally invoice for our products at the time of shipping, and accordingly there is not a significant financing component included in our arrangements.
Nature of Products and Services
IT products typically represent a distinct performance obligation, and revenue is recognized at the point in time when control is transferred to the customer which is generally upon delivery to the customer. We recognize revenue as the principal in the transaction with the customer (i.e., on a gross basis), as we control the product prior to delivery to the customer and derive the economic benefits from the sales transaction given our control over customer pricing.
We do not recognize revenue for goods that remain in our physical possession before the customer has the ability to direct the use of, and obtain substantially all of the remaining benefits from the products, the goods are ready for physical transfer to and identified as belonging to the customer, and when we have no ability to use the product or to direct it to another customer.
Licenses for on-premise software provide the customer with a right to take possession of the software. Customers may purchase perpetual licenses or enter into subscriptions to the licensed software. We are the principal in these
39
Table of Contents
transactions and recognize revenue for the on-premise license at the point in time when the software is made available to the customer and the commencement of the term of the software license or when the renewal term begins, as applicable.
For certain on-premise licenses for security software, the customer derives substantially all of the benefit from these arrangements through the third-party delivered software maintenance, which provides software updates and other support services. We do not have control over the delivery of these performance obligations, and accordingly we are the agent in these transactions. We recognize revenue for security software net of the related cost of sales at the point in time when our vendor and customer accept the terms and conditions in the sales arrangement. Cloud products allow customers to use hosted software over the contractual period without taking possession of the software and are provided on a subscription basis. We do not exercise control over these products or services and therefore are an agent in these transactions. We recognize revenue for cloud products net of the related costs of sales at the point in time when our vendor and customer accept the terms and conditions in the sales arrangements.
We use our own engineering personnel to assist in projects involving the design and installation of systems and networks, and we also engage third-party service providers to perform warranty maintenance, implementations, asset disposal, and other services. Service revenue is recognized in general over time as we perform the underlying services and satisfy our performance obligations. We evaluate such engagements to determine whether we are the principal or the agent in each transaction. For those transactions in which we do not control the service, we act as an agent and recognize the transaction revenue on a net basis at a point in time when the vendor and customer accept the terms and conditions in the sales arrangement.
Similarly, we recognize revenue from agency sales transactions on a net sales basis. In agency sales transactions, we facilitate product sales by equipment and software manufacturers directly to our customers and receive agency, or referral, fees for such transactions. We do not take title to the products or assume any maintenance or return obligations in these transactions; title is passed directly from the supplier to our customer.
Amounts recognized on a net basis included in net sales for such third-party services, agency sales, and off-premise software transactions were $141.8 million, $127.5 million, and $103.5 million for the years ended December 31, 2023, 2022, and 2021, respectively.
Certain software sales include on-premise licenses that are combined with software maintenance. Software maintenance conveys rights to updates, bug fixes and help desk support, and other support services transferred over the underlying contract period. On-premise licenses are considered distinct performance obligations when sold with the software maintenance, as we sell these items separately. We recognize revenue related to the software maintenance as the agent in these transactions because we do not have control over the on-going software maintenance service. Revenue allocated to software maintenance is recognized at the point in time when our vendor and customer accept the terms and conditions in the sales arrangements.
Certain of our larger customers are offered the opportunity by vendors to purchase software licenses and maintenance under enterprise agreements, or EAs. Under EAs, customers are considered to be compliant with applicable license requirements for the ensuing year, regardless of changes to their employee base. Customers are charged an annual true-up fee for changes in the number of users over the year. With most EAs, our vendors will transfer the license and bill the customer directly, paying resellers, such as us, an agency fee or commission on these sales. We record these agency fees as a component of net sales as earned and there is no corresponding cost of sales amount. In certain instances, we invoice the customer directly under an EA and account for the individual items sold based on the nature of each item. Our vendors typically dictate how the EA will be sold to the customer.
We also offer extended service plans, or ESPs, on IT products, both as part of the initial arrangement and separately from the IT products. We recognize revenue related to ESPs as the agent in the transaction because we do not have control over the on-going ESPs service and do not provide any service after the sale. Revenue allocated to ESPs is recognized at the point in time when our vendor and customer accept the terms and conditions in the sales arrangement.
All amounts billed to a customer in a sales transaction related to shipping and handling, if any, represent revenues earned for the goods provided, and these amounts have been included in net sales. Costs related to shipping and handling
40
Table of Contents
billing are classified as cost of sales. Sales are reported net of sales, use, or other transaction taxes that are collected from customers and remitted to taxing authorities.
Critical Accounting Estimates
Our contracts with customers often include promises to transfer multiple products or services to a customer. Determining whether we are the agent or the principal and whether products and services are considered distinct performance obligations that should be accounted for separately versus together may require significant judgment.
We estimate the standalone selling price, or SSP, for each distinct performance obligation when a single arrangement contains multiple performance obligations and the fulfillment occurs at different points in time. We maximize the use of observable inputs in the determination of the estimate for SSP for the items that we do not sell separately, including on-premise licenses sold with software maintenance, and IT products sold with ESPs. In instances where SSP is not directly observable, such as when we do not sell the product or service separately, we determine the SSP using information that may include market conditions and other observable inputs.
We provide our customers with a limited thirty-day right of return, which is generally limited to defective merchandise, and gives rise to variable consideration. Revenue is recognized based on the most likely amount to which we are expected to be entitled. The estimated variable consideration is included in the transaction price to the extent it is probable that a significant reversal of cumulative revenue recognized will not occur once the uncertainty is resolved. We make estimates of product returns based on significant historical experience. We record our sales return reserve as a reduction of revenues and either as reduction of accounts receivable or, for customers who have already paid, as accrued expenses and as a reduction of cost of sales and an associated right of return asset. At December 31, 2023, we recorded sales reserves of $3.1 million and $0.1 million as components of accounts receivable and accrued expenses, respectively. At December 31, 2022, we recorded sales reserves of $3.8 million and $0.1 million as components of accounts receivable and accrued expenses, respectively.
We regularly evaluate the adequacy of our estimates for product returns. Future market conditions and product transitions may require us to take action to change such programs and related estimates. When the variables used to estimate these reserves change, or if actual results differ significantly from the estimates, we would be required to increase or reduce revenue to reflect the impact.
Accounts Receivable
We perform ongoing credit evaluations of our customers and adjust credit limits based upon payment history and current creditworthiness. Our allowance for credit losses is generally computed by (1) applying specific percentage reserves on accounts that are past due, and (2) specifically reserving for customers known to be in financial difficulty. Therefore, if the financial conditions of certain customers were to deteriorate, or if we noted there was a lengthening of the timing of the settlement of receivables that was symptomatic of a general deterioration in the ability of our customers to pay, we would have to increase our allowance for credit losses. This would negatively impact our earnings. Our cash flows would be impacted to the extent that receivables could not be collected.
We continued to improve on our collection efforts in 2023. Our bad debt expense for the year ended December 31, 2023 decreased to $1.8 million, compared to $3.3 million for the year ended December 31, 2022.
In addition to accounts receivable from customers, we record receivables from our vendors/suppliers for cooperative advertising, price protection, supplier reimbursements, rebates, and other similar arrangements. A portion of such receivables is estimated based on information available from our vendors at discrete points in time. While such estimates have historically approximated actual cash received, a change in estimates could give rise to a reduction in the receivable. This could negatively impact our earnings and our cash flows.
Our trade receivables are charged off in the period in which they are deemed uncollectible. Recoveries of trade receivables previously charged are recorded when received. Write offs of customer and vendor receivables totaled $3.3 million in 2023 and $2.8 million in 2022.
41
Table of Contents
Considerable estimates are used in assessing the ultimate realization of customer receivables and vendor/supplier receivables, including reviewing the financial stability of a customer, vendor information, and gauging current market conditions. If our evaluations are incorrect, we may incur additional charges in the future on our consolidated statements of income.
Inventories
Inventories (all finished goods) are stated at cost (which approximates the first-in, first-out method) or net realizable value, whichever is lower. Inventory quantities on hand are reviewed regularly, and provisions are made for obsolete, slow moving, and non-saleable inventory, based primarily on management’s forecast of customer demand for those products in inventory.
Estimates are used to determine the quarterly inventory allowance provision. Actual future write-offs of inventory for salability and obsolescence reasons may differ from estimates and calculations used to determine valuation allowances due to changes in customer demand, customer negotiations, technology shifts and other factors. The IT industry is characterized by rapid technological change and new product development that could result in increased obsolescence of inventory on hand. Increased obsolescence or decreased customer demand beyond management’s expectations could require additional provisions, which could negatively impact our earnings. Our provision for inventory obsolescence was $2.4 million, $4.3 million, and $3.5 million for the years ended December 31, 2023, 2022, and 2021, respectively. We recorded obsolescence charges of $2.8 million, $3.3 million, and $3.0 million for the years ended December 31, 2023, 2022 and 2021, respectively. Historically, there have been no unusual charges precipitated by specific technological or forecast issues.
Goodwill and Long-Lived Assets, Including Intangibles
We carry a variety of long-lived assets on our consolidated balance sheet, which are all currently classified as held for use. These include property and equipment, identifiable intangibles, an internet domain name, which is an indefinite-lived intangible asset not subject to amortization, and goodwill. An impairment review is undertaken on (1) an annual basis for goodwill and an indefinite-lived intangible; and (2) on an event-driven basis for all long-lived assets when facts and circumstances suggest that cash flows from such assets may be diminished. We have historically reviewed the carrying value of all these assets based partly on our projections of cash flows. Any impairment charge that is recorded negatively impacts our earnings.
Our Enterprise Solutions and Business Solutions segments hold $66.2 million and $7.4 million of goodwill, respectively. We test goodwill for impairment each year and more frequently if potential impairment indicators arise. In 2023 and 2022, we performed a “step 0” qualitative analysis. Accounting Standards Codification 350—Intangible – Goodwill and Other states that an entity may assess qualitative factors to determine whether it is more likely than not that the fair value of a reporting unit is less than its carrying amount, including goodwill. This analysis allows the Company to consider qualitative factors that might impact the carrying amount of its goodwill to determine whether a more detailed quantitative analysis would be necessary. Factors considered when performing the impairment assessment included the Company’s performance relative to historical and projected future operating results, macroeconomic conditions, industry and market trends, cost factors that may have a negative impact on earnings and cash flows, changes in the Company’s stock price and market capitalization, and other relevant entity-specific events. Based on the qualitative analysis, the Company determined goodwill was not impaired as of December 31, 2023 and 2022. While we believe that our conclusions are reasonable, different assumptions could materially affect our valuations and result in impairment charges against the carrying values of those remaining assets in our Enterprise Solutions and Business Solutions segments.
Please see Note 4, “Goodwill and Other Intangible Assets” to the Consolidated Financial Statements included in Item 8 of Part II of this report for a discussion of the significant assumptions used in our annual impairment test analysis.
42
Table of Contents
RECENTLY ISSUED FINANCIAL ACCOUNTING STANDARDS
Recently issued financial accounting standards are detailed in Note 1, “Summary of Significant Accounting Policies,” in the Notes to Consolidated Financial Statements included in Item 8 of this Annual Report on Form 10-K.