Stock Analysis on Net

Amphenol Corp. (NYSE:APH)

This company has been moved to the archive! The financial data has not been updated since April 26, 2024.

Common-Size Balance Sheet: Assets 
Quarterly Data

Amphenol Corp., common-size consolidated balance sheet: assets (quarterly data)

Microsoft Excel
Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Cash and cash equivalents 11.11 8.93 9.40 8.70 9.04 8.96 7.88 8.11 8.39 8.16 8.50 8.31 17.72 13.81 12.09 11.50 19.64 8.24 9.07 9.24 9.50
Short-term investments 0.64 1.12 1.60 1.17 0.70 0.40 0.42 0.80 0.35 0.30 0.23 0.23 0.26 0.29 0.30 0.23 0.09 0.16 0.16 0.14 0.18
Cash, cash equivalents and short-term investments 11.74% 10.05% 11.00% 9.86% 9.74% 9.36% 8.29% 8.90% 8.74% 8.46% 8.73% 8.53% 17.98% 14.10% 12.39% 11.73% 19.74% 8.40% 9.24% 9.38% 9.67%
Accounts receivable, less allowance for doubtful accounts 14.96 15.84 16.32 16.04 15.68 17.17 17.49 17.16 16.28 16.72 14.77 14.24 14.71 15.83 16.00 14.80 12.75 16.05 15.81 15.85 16.28
Inventories 12.87 13.11 13.32 13.11 13.69 13.66 13.78 13.64 13.38 12.90 13.08 12.17 11.92 11.86 11.83 12.16 10.97 12.11 11.92 11.99 11.99
Prepaid expenses and other current assets 2.53 2.36 2.34 2.47 2.46 2.09 2.35 2.41 2.67 2.51 2.63 2.56 2.50 2.75 2.63 2.53 2.22 2.37 2.65 2.49 2.48
Current assets held for sale 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7.16 7.09 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Current assets 42.11% 41.36% 42.98% 41.48% 41.57% 42.27% 41.91% 42.11% 41.07% 40.59% 46.36% 44.59% 47.11% 44.54% 42.85% 41.22% 45.68% 38.94% 39.61% 39.70% 40.43%
Property, plant and equipment, less accumulated depreciation 7.84 7.96 7.91 8.26 8.08 7.86 7.73 7.71 7.90 8.01 7.87 8.03 8.19 8.55 8.82 8.94 8.13 9.24 9.03 9.12 9.13
Goodwill 42.46 42.92 41.72 42.78 42.52 42.06 41.98 41.87 42.69 43.44 39.12 40.47 38.78 40.82 42.16 43.44 40.13 45.00 44.46 44.26 43.49
Other intangible assets, net 4.70 5.05 4.72 4.75 4.83 4.79 4.99 5.01 4.96 5.16 4.04 4.26 3.12 3.22 3.47 3.71 3.55 4.09 0.00 0.00 0.00
Other long-term assets 2.89 2.72 2.67 2.73 3.00 3.02 3.40 3.30 3.38 2.80 2.60 2.65 2.80 2.86 2.69 2.69 2.51 2.74 6.89 6.92 6.94
Long-term assets 57.89% 58.64% 57.02% 58.52% 58.43% 57.73% 58.09% 57.89% 58.93% 59.41% 53.64% 55.41% 52.89% 55.46% 57.15% 58.78% 54.32% 61.06% 60.39% 60.30% 59.57%
Total assets 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%

Based on: 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).


Cash and Cash Equivalents
The percentage of cash and cash equivalents in total assets experienced notable volatility, peaking at 19.64% in March 2020 and declining thereafter, generally fluctuating around 8% to 11% in recent quarters. This suggests periods of increased liquidity around early 2020 followed by a normalization to lower levels.
Short-term Investments
Short-term investments as a percentage of total assets remained relatively low but showed an increasing trend from mid-2021 onwards, rising from approximately 0.23% to a high of 1.6% in September 2023 before slightly retreating. This indicates a gradual strengthening allocation to short-term investment instruments in the company's asset composition.
Cash, Cash Equivalents and Short-term Investments Combined
The combined liquidity position mirrored the trends of cash equivalents and short-term investments, with a pronounced peak in March 2020 at nearly 20%, followed by a decline and stabilization around 8% to 12% in subsequent periods. The increase towards the end of the dataset, rising to 11.74% in March 2024, indicates a modest recent enhancement in liquid asset holdings.
Accounts Receivable (Net)
Accounts receivable as a share of total assets declined sharply from a high of over 16% in 2019 to around 12.75% in March 2020 but rebounded and generally maintained levels between 14% and 17% afterward. This suggests a temporary contraction possibly related to market conditions during early 2020, with recovery and stable receivables relative to total assets in later periods.
Inventories
The inventory proportion of total assets maintained a relatively stable profile, fluctuating within a narrow range of approximately 11% to 14%, with a slight upward drift particularly visible from 2021 through 2023. This stability points to consistent inventory management aligned with asset size over the period analyzed.
Prepaid Expenses and Other Current Assets
This category held fairly constant at roughly 2.3% to 2.7% of total assets, showing only minor quarter-to-quarter variations. It reflects steady management of prepaid and other short-term current assets without significant shifts over time.
Current Assets Held for Sale
Data for current assets held for sale appears only in the middle disclosure period, specifically around the middle of 2021, constituting about 7% of total assets, and is not reported in other periods. This indicates a temporary classification of assets for disposal during that timeframe.
Total Current Assets
Total current assets as a percentage of total assets displayed notable variations, peaking at 47.11% in March 2021, with a subsequent decrease and relative stabilization around 41% to 43% thereafter. The elevated level circa early 2021 may indicate heightened liquidity or working capital components during that interval.
Property, Plant and Equipment (Net)
This asset class hovered between 7.8% and 9.1% of total assets, showing a slight downward trend from 2019 through the end of 2023. The gradual reduction suggests either depreciation outpacing capital expenditures or potential asset disposals, leading to a modest decline in fixed asset intensity.
Goodwill
Goodwill represented a substantial and relatively stable portion of total assets, ranging mostly between 38% and 45%. Although there was a dip around early 2020, the figure generally hovered in the low 40s percentage-wise. This sizable intangible asset indicates significant acquisition activity or valuation from prior purchases sustaining overall goodwill levels.
Other Intangible Assets, Net
Other intangible assets showed growth over time, starting from a lower base around 3.12%-4.09% and increasing up to approximately 5% in recent periods. This upward movement points to an accumulation or revaluation of intangible assets aside from goodwill.
Other Long-term Assets
Other long-term assets comprised roughly 2.5% to 7% of total assets, with a notable drop from nearly 7% in 2019 to about 2.5%-3.5% range in subsequent years. This indicates a reclassification or divestment of certain long-term assets outside the core categories.
Total Long-term Assets
Total long-term assets as a proportion of total assets declined from approximately 60% in 2019 to about 57%-59% in the most recent quarters, reflecting the combined impact of reductions in property, plant and equipment, other long-term assets, and goodwill levels moving modestly downward.
Overall Asset Composition
The data reveals a relatively balanced asset structure, with current assets averaging around 40%-45% and long-term assets the complementary share. The fluctuations in cash and equivalents, accounts receivable, and goodwill highlight responsive adjustments in liquidity, credit management, and acquisition-related asset positioning. Stability in inventories and prepaid expenses suggests steady operating asset management.