Eli Lilly & Co. (NYSE:LLY)

The operational activity ratios exhibit a consistent trend toward reduced efficiency in the conversion of assets into cash over the analyzed period. The most prominent shift is observed in the significant elongation of the operating and cash conversion cycles, driven primarily by a substantial slowdown in inventory movement.

Inventory Management Efficiency

A sustained decline in inventory turnover is evident, falling from 1.93 in March 2022 to 0.78 by September 2026. This trend is mirrored by the average inventory processing period, which expanded from 189 days to 469 days. This indicates a marked increase in the time required to move products through the production and sales pipeline, suggesting either strategic stockpiling or a deceleration in sales relative to inventory accumulation.

Receivables and Payables Dynamics

Receivables turnover has remained relatively stable compared to inventory, though it shows a slight downward trajectory from 4.64 to 3.91. The average receivable collection period fluctuated moderately, ending at 93 days, which indicates a consistent ability to collect payments from customers. Conversely, payables turnover decreased from 5.24 to 2.44, while the average payables payment period more than doubled, rising from 70 days in March 2022 to 149 days by September 2026. This suggests a strategic shift toward extending payment terms with suppliers to preserve liquidity.

Operating and Cash Conversion Cycles

The operating cycle has expanded significantly, increasing from 268 days to 562 days. This expansion is almost entirely attributable to the increased inventory processing time. Despite the company's efforts to offset this by extending its payables payment period, the cash conversion cycle has still increased substantially, rising from 198 days to 413 days. This indicates a growing gap between the cash outflow for production and the cash inflow from sales.

Working Capital Utilization

Working capital turnover demonstrates extreme volatility throughout the period, with peaks reaching 31.84 and troughs falling to 2.71. This irregularity suggests significant fluctuations in the relationship between net sales and the investment in current assets minus current liabilities, reflecting potential shifts in short-term financing strategies or irregular spikes in operational volume.

In summary, the data reveals a widening gap in the cash conversion process. While receivables management remains stable, the substantial increase in the inventory processing period has become the primary driver of operational inefficiency, which is only partially mitigated by the strategic extension of supplier payment terms.

A sustained decline in inventory turnover is evident over the period from March 31, 2022, to September 30, 2026. While the cost of sales increased substantially over this timeframe, the growth in total inventories significantly outpaced the expansion of sales costs, leading to a consistent reduction in the efficiency of inventory movement.

Inventory Turnover Ratio Trends

The inventory turnover ratio exhibits a continuous downward trajectory, falling from 1.93 in March 2022 to 0.78 by September 2026. A critical threshold was crossed in the first quarter of 2025, where the ratio dropped below 1.00, indicating that the company's average inventory levels began to exceed its quarterly cost of sales. This trend suggests a lengthening of the cash-to-cash cycle and a potential increase in carrying costs.

Inventory Accumulation

Inventories grew aggressively, increasing from 3,893 million USD in March 2022 to 18,194 million USD by September 2026. The rate of accumulation accelerated sharply beginning in 2024, with inventories nearly doubling between December 2023 and December 2024, and continuing to rise steeply throughout 2025 and 2026. This rapid build-up indicates a strategic shift toward higher stock levels, possibly to support product launches or to mitigate supply chain risks.

Cost of Sales Analysis

The cost of sales showed a general upward trend, particularly from 2024 onwards. After fluctuating between 1,431 million USD and 2,072 million USD in 2022, expenditures rose to 3,933 million USD by September 2026. Despite this growth in operating volume, the cost of sales did not scale proportionally with the inventory investment, which directly contributed to the deterioration of the turnover ratio.

The divergence between the rapid expansion of inventory assets and the more moderate growth in cost of sales highlights a significant shift in operating activity. The transition from a turnover ratio of 1.93 to 0.78 reflects a move toward a much heavier inventory position, which may signal an anticipation of significantly higher future demand or an inefficiency in inventory management processes during the scaling phase.

The financial trajectory from March 2022 through September 2026 is characterized by substantial revenue expansion accompanied by a proportional increase in accounts receivable, resulting in a general contraction of the receivables turnover ratio over the long term.

Revenue and Accounts Receivable Growth

Revenue exhibited an aggressive upward trend, rising from 7,810 million US$ in March 2022 to 24,397 million US$ by September 2026. Parallel to this growth, accounts receivable increased from 6,323 million US$ to 22,089 million US$. Because the growth in receivables slightly outpaced the growth in revenue, the efficiency of converting credit sales into cash diminished over the analyzed period.

Receivables Turnover Ratio Dynamics

The receivables turnover ratio began at 4.64 in March 2022 and concluded at 3.91 in September 2026. A period of consistent decline was observed through March 2023, reaching 3.68. Although a sharp recovery to 4.56 occurred in March 2024, the ratio subsequently entered a period of volatility and stabilization, fluctuating between a low of 3.53 in June 2024 and a high of 4.09 in December 2023, before settling in the 3.90 range by late 2026.

Collection Efficiency Analysis

The overall decline in the turnover ratio indicates a lengthening of the average collection period. The divergence between the rapid escalation of revenue and the slower stabilization of the turnover ratio suggests that the company may be extending more liberal credit terms to support its growth or experiencing slower payment cycles from customers as the volume of business expands. Despite these pressures, the ratio remained relatively resilient, never falling below 3.53.

An analysis of the operating activity ratios reveals a consistent long-term decline in the payables turnover ratio, occurring alongside a significant expansion in both the cost of sales and total accounts payable.

Cost of Sales and Accounts Payable Trends

Cost of sales exhibited a sustained upward trajectory, rising from 2,072 million US$ in March 2022 to 3,933 million US$ by September 2026. During the same period, accounts payable grew more aggressively, increasing from 1,433 million US$ to 5,793 million US$. The disproportionate growth of liabilities relative to the cost of sales suggests a strategic shift in how the company manages its short-term obligations.

Payables Turnover Ratio Analysis

The payables turnover ratio experienced a marked decrease, falling from a high of 5.24 in March 2022 to a range between 2.16 and 2.47 during the final year of the observed period. The most significant contraction occurred between March 2022 and June 2023, where the ratio dropped from 5.24 to 2.65. From June 2023 onward, the ratio stabilized, fluctuating within a narrower band between 2.05 and 2.88.

Operational Implications

The steady decline in the turnover ratio indicates an extension of the payment cycle to suppliers. By reducing the frequency with which accounts payable are settled, the company has increased its days payable outstanding. This pattern is indicative of a working capital management strategy designed to preserve cash flow and leverage supplier credit to support operational growth.

The financial trajectory between March 2022 and September 2026 is characterized by substantial revenue growth coupled with a significant expansion in working capital, resulting in a general decline in working capital turnover efficiency.

Revenue Growth Trends

A consistent upward trend in revenue is observed, progressing from 7,810 million USD in March 2022 to 24,397 million USD by September 2026. The growth accelerated notably starting in June 2024, with quarterly revenues consistently exceeding 11,000 million USD from that point forward and peaking at the end of the analyzed period.

Working Capital Volatility and Expansion

Working capital exhibited extreme volatility in the initial phase, reaching a low of 896 million USD in December 2022 and dipping into negative territory (-1,566 million USD) in December 2023. However, a fundamental shift occurred in 2024 and 2025, where working capital scaled aggressively. The figure rose from 6,591 million USD in March 2024 to a peak of 21,930 million USD in September 2025, indicating a substantial increase in the net current assets utilized to support operations.

Working Capital Turnover Analysis

The turnover ratio showed high instability during 2022 and 2023, with peaks as high as 31.84. These spikes were primarily driven by periods of exceptionally low working capital relative to revenue. As working capital expanded rapidly from 2024 onward, the turnover ratio experienced a marked compression. The ratio declined from a high of 12.62 in June 2024 to a low of 2.71 in September 2025. While the ratio showed slight recovery and stabilization between 3.97 and 4.73 in 2026, it remained significantly lower than the levels seen in the early part of the period.

Operational Efficiency Insights

The inverse relationship between the surging working capital and the declining turnover ratio suggests that revenue growth is being supported by a disproportionately larger investment in short-term assets. The shift from a lean working capital model (characterized by high turnover ratios in 2022-2023) to a more capital-intensive model in 2025-2026 indicates a change in the operating cycle or a strategic accumulation of liquidity and inventory to sustain higher sales volumes.

The analysis reveals a significant and consistent deterioration in inventory efficiency over the observed period from March 2022 to September 2026. A clear inverse correlation exists between the inventory turnover ratio and the average inventory processing period, indicating a prolonged cycle in converting inventory into sales.

Inventory Turnover Ratio Trend

A continuous downward trajectory is observed, with the ratio declining from 1.93 in March 2022 to 0.78 by September 2026. This steady decrease suggests that inventory is being cycled through the business significantly slower than in previous periods, eventually falling below the 1.0 threshold during the final phases of the analyzed timeframe.

Average Inventory Processing Period Expansion

The number of days required to process inventory has increased substantially, rising from 189 days in March 2022 to 469 days by September 2026. This represents a total increase of 280 days in the processing cycle. The acceleration of this trend became particularly evident starting in March 2025, as the period surpassed 365 days and continued to climb toward the 469-day mark.

Operational Efficiency Insights

The simultaneous decline in turnover and the expansion of the processing period indicate a growing accumulation of inventory relative to the cost of goods sold. The transition from a processing period of approximately six months in early 2022 to over fifteen months by late 2026 suggests a fundamental shift in the operational cycle, potentially reflecting strategic stockpiling, production increases outpacing demand, or a change in the product lifecycle management.

The analysis of short-term operating activity reveals a general extension in the time required to convert accounts receivable into cash over the observed period. A correlation exists between the decline in receivables turnover and the corresponding increase in the average receivable collection period, suggesting a shift in the efficiency of credit collection processes.

Receivables Turnover Trends

A gradual decline in the turnover ratio is observed from the initial period of March 2022, where the ratio stood at 4.64, reaching a low of 3.68 by March 2023. While a temporary recovery occurred in March 2024 with a peak of 4.56, the ratio subsequently stabilized within a narrow range between 3.53 and 4.09 throughout the remainder of the period, ending at 3.91 in September 2026.

Average Receivable Collection Period

The collection period demonstrated a steady upward trajectory during the first year, rising from 79 days in March 2022 to 99 days in March 2023. Following this period of increase, the metric exhibited significant volatility in 2024, fluctuating from a low of 80 days in March to a peak of 103 days in June. From December 2024 through September 2026, the collection period remained relatively stable, consistently oscillating between 90 and 99 days.

Operational Efficiency Analysis

The transition from a sub-80-day collection cycle in early 2022 to a consistent 90-plus-day cycle by 2026 indicates a slowing of the cash conversion cycle regarding receivables. The peak of 103 days in June 2024 represents the lowest point of efficiency in receivable management within the analyzed timeframe. Despite subsequent fluctuations, the company has not returned to the lower collection thresholds observed in 2022.

The operational efficiency regarding the conversion of assets into cash has experienced a significant decline over the analyzed period, characterized by a substantial and consistent extension of the overall operating cycle.

Average Inventory Processing Period

A pronounced upward trend is observed in the time required to process inventory. From a starting point of 189 days in March 2022, the period increased to 469 days by September 2026. The data indicates that the inventory processing timeframe more than doubled over the analyzed duration. Notable accelerations in this trend occurred between March 2024 and September 2025, where the period climbed from 312 days to 441 days, suggesting a marked slowdown in inventory turnover.

Average Receivable Collection Period

The collection period for receivables has remained relatively stable, exhibiting only minor fluctuations. Starting at 79 days in March 2022 and ending at 93 days in September 2026, the values generally oscillated between a low of 79 days and a peak of 103 days in June 2024. This relative constancy indicates that the efficiency of credit collections and accounts receivable management has not been the primary driver of changes in the overall operational cycle.

Operating Cycle

The total operating cycle expanded significantly from 268 days in March 2022 to 562 days by September 2026. This expansion is almost entirely attributable to the increase in the average inventory processing period. While the cycle showed brief periods of contraction—most notably in March 2024 and March 2026—the overarching trajectory is one of substantial growth, indicating a longer duration of capital being tied up in the operating process before being converted back into cash.

The analysis of short-term operating activity reveals a consistent expansion in the time required to settle obligations with suppliers over the observed period. There is a clear inverse correlation between the payables turnover ratio and the average payables payment period, with the former trending downward while the latter trends upward.

Payables Turnover Trend

A significant decline in the payables turnover ratio is observed, falling from 5.24 in March 2022 to 2.44 by September 2026. The most rapid deceleration occurred throughout 2022, where the ratio dropped from 5.24 to 3.43. Following this initial decline, the ratio entered a period of relative stability between 2.56 and 3.07 throughout 2023 and 2024, before reaching a low of 2.05 in December 2025.

Average Payables Payment Period Expansion

The average payables payment period exhibits a marked upward trajectory, increasing from 70 days in March 2022 to a peak of 178 days in December 2025. This represents more than a twofold increase in the duration the company takes to pay its creditors. The expansion progressed through several stages: an initial jump to 106 days by the end of 2022, a sustained increase to the 130-140 day range during 2023 and 2024, and a final surge toward the end of 2025.

Recent Volatility and Stabilization

In the final quarters of the data set, a reversal of the expansion trend is evident. After peaking at 178 days in December 2025, the payment period decreased to 148 days in March 2026, rose slightly to 169 days in June 2026, and settled at 149 days by September 2026. This indicates a potential stabilization of supplier payment terms or a strategic adjustment in working capital management toward the end of the analysis period.

The operational efficiency regarding working capital management exhibits a significant downward trend, characterized by a substantial extension of the cash conversion cycle. From March 2022 to September 2026, the cycle expanded from 198 days to 413 days, indicating a marked increase in the time required to convert resource inputs into cash flows.

Average Inventory Processing Period

A consistent and aggressive upward trend is observed in inventory holding times. The period rose from 189 days in March 2022 to 469 days by September 2026. This sustained increase represents the primary driver of the lengthening cash conversion cycle, suggesting a significant accumulation of inventory or a decline in inventory turnover rates over the period.

Average Receivable Collection Period

The collection of receivables remained relatively stable. While fluctuations occurred—ranging from a minimum of 79 days to a peak of 103 days in June 2024—the period concluded at 93 days. This stability indicates that credit and collection policies have remained consistent and have not contributed meaningfully to the overall deterioration of the cash cycle.

Average Payables Payment Period

A notable increase is observed in the duration taken to settle obligations with suppliers. The payment period expanded from 70 days in March 2022 to 149 days in September 2026. This extension suggests an effort to utilize supplier financing to mitigate the liquidity pressures created by rising inventory levels.

Cash Conversion Cycle Dynamics

The net result of these components is a cash conversion cycle that more than doubled over the analyzed timeframe. Although the extension of the payables payment period provided a partial offset, it was insufficient to counteract the aggressive growth in the inventory processing period. Consequently, a significantly larger volume of capital is now tied up in the operating cycle than was required at the start of the period.