Eli Lilly & Co. (NYSE:LLY)

The analyzed period reveals a systemic deceleration in short-term operating efficiency, characterized by a significant lengthening of the cash conversion cycle and a marked slowdown in inventory movement. While receivables management remains relatively stable, there is a clear trend toward extended payment terms for suppliers and a substantial increase in the time required to process inventory.

Inventory Management

A persistent downward trend is observed in inventory turnover, which declined from 1.93 in March 2022 to 0.79 by June 2026. Correspondingly, the average inventory processing period expanded significantly, rising from 189 days to 463 days. This indicates a substantial increase in the volume of capital tied up in unsold stock and a decrease in the velocity of inventory throughput.

Receivables Management

Receivables turnover demonstrates relative stability compared to other activity ratios, fluctuating between a high of 4.64 and a low of 3.53. The average receivable collection period remained largely consistent, moving from 79 days in March 2022 to 92 days in June 2026, suggesting that the company has maintained a steady pace of collections from its customers despite other operational shifts.

Payables Management

A notable decline in payables turnover is evident, dropping from 5.24 to 2.16 over the period. This is reflected in the average payables payment period, which more than doubled from 70 days to 169 days. Such a trend suggests a strategic shift toward delaying payments to suppliers to preserve liquidity or a change in credit terms provided by vendors.

Operating and Cash Conversion Cycles

The operating cycle has experienced a sharp increase, growing from 268 days to 555 days, driven primarily by the deterioration in inventory turnover. Although the extension of the payables payment period partially offset this increase, the cash conversion cycle still expanded significantly from 198 days to 386 days. This indicates a widening gap between the cash outlay for raw materials and the cash recovery from sales.

Working Capital Efficiency

Working capital turnover exhibits high volatility throughout the period, with extreme peaks reaching 31.84 in December 2022 and September 2023. However, the long-term trend shows a regression toward lower values, ending at 4.71 in June 2026, which correlates with the overall increase in working capital requirements and slower asset turnover.

An analysis of short-term operating activity reveals a significant and sustained decline in inventory efficiency from March 2022 through June 2026. While both cost of sales and total inventory levels increased over this period, the rate of inventory accumulation substantially outpaced the growth in sales costs, resulting in a consistent downward trend in the inventory turnover ratio.

Cost of Sales Trends

Cost of sales demonstrated a general upward trajectory, rising from 2,072 million USD in March 2022 to 3,268 million USD by June 2026. A period of accelerated growth is evident starting in the first quarter of 2024, with the highest quarterly expenditure recorded in March 2026 at 3,577 million USD.

Inventory Accumulation

Inventory levels experienced an aggressive expansion, increasing from 3,893 million USD in March 2022 to 16,793 million USD by June 2026. The pace of growth intensified markedly starting in March 2024, as balances rose from 6,102 million USD to over 16 billion USD by the end of the observed period, representing more than a fourfold increase in total holdings.

Inventory Turnover Ratio Analysis

The inventory turnover ratio declined steadily from 1.93 in March 2022 to 0.79 in June 2026. The ratio fell below the 1.0 threshold in March 2025 and remained below this level through June 2026. This pattern indicates a widening gap between the acquisition or production of inventory and the realization of those goods through sales, suggesting a strategic build-up of stock or a decrease in the velocity of inventory movement relative to the scale of operations.

Analysis of short-term operating activity indicates a period of aggressive expansion in both revenue generation and the associated credit balance. Revenue increased from 7,810 million US dollars in March 2022 to 22,974 million US dollars by June 2026. Simultaneously, accounts receivable grew from 6,323 million US dollars to 20,083 million US dollars over the same period, reflecting a scaling of operations.

Receivables Turnover Volatility

The receivables turnover ratio exhibited a general downward trend during the first year of the analyzed period, declining from 4.64 in March 2022 to 3.68 by March 2023. While a temporary recovery to 4.56 occurred in March 2024, the ratio subsequently stabilized within a range between 3.53 and 4.09. This movement suggests a moderate decrease in the efficiency of receivable collections or a strategic shift toward more extended credit terms to support rapid sales growth.

Growth Correlation

A strong positive correlation is observed between the growth in revenue and the increase in accounts receivable. As revenue scaled, particularly after December 2023, the balance of outstanding receivables rose proportionally. The observation that the turnover ratio remained relatively stable, fluctuating primarily between 3.6 and 4.1 during the latter half of the period, indicates that the company maintained a consistent collection cycle despite the significant increase in the volume of sales.

Recent Performance Trends

In the final quarters ending March and June 2026, a slight upward trend in the turnover ratio is noted, moving from 3.92 to 3.97. This indicates a marginal improvement in the speed of converting receivables into cash, occurring even as revenue reached its peak of 22,974 million US dollars.

A comprehensive analysis of the operating activity ratios reveals a sustained downward trend in the payables turnover ratio from March 2022 through June 2026. This decline indicates a slowing rate of supplier payment and a systemic increase in the period during which the company holds onto its cash before settling obligations with vendors.

Payables Turnover Trajectory

The payables turnover ratio experienced a significant contraction, falling from a high of 5.24 in March 2022 to 2.16 by June 2026. The most rapid decline occurred between March 2022 and June 2023, where the ratio dropped from 5.24 to 2.65. Following this initial period of volatility, the ratio entered a phase of relative stabilization, fluctuating within a tighter range between 2.05 and 2.88 through the remainder of the analyzed period.

Analysis of Primary Drivers

The deterioration of the turnover ratio is primarily driven by a disproportionate growth in accounts payable relative to the cost of sales. While the cost of sales increased from 2,072 million in March 2022 to 3,268 million in June 2026, accounts payable grew at a far more aggressive rate, rising from 1,433 million to 6,112 million over the same period. This indicates that the growth in liabilities to suppliers significantly outpaced the growth in the actual cost of goods sold.

Working Capital Implications

The expansion of accounts payable suggests a strategic shift in working capital management. By extending the payment cycle, the organization has effectively increased its cash conversion efficiency by utilizing supplier credit as a source of short-term financing. The lowest turnover ratio of 2.05 was recorded in December 2025, coinciding with a peak in accounts payable of 5,379 million, highlighting a period of maximum leverage of supplier terms.

Operational Correlation

Despite fluctuations in the cost of sales—which saw a notable peak of 3,577 million in March 2026—the accounts payable balance maintained a consistent upward trajectory. This divergence suggests that the increase in payment terms is not merely a reaction to seasonal spikes in costs, but rather a long-term structural change in procurement and payment policies.

The financial data exhibits a period of significant expansion in both top-line revenue and the capital required to support operations. While revenue demonstrates a consistent upward trajectory, working capital has experienced extreme volatility and an eventual substantial increase, leading to a general decline in the working capital turnover ratio over the observed period.

Revenue Growth Patterns

A sustained growth trend is evident, with quarterly revenue increasing from 7,810 million US$ in March 2022 to 22,974 million US$ by June 2026. The growth acceleration becomes particularly pronounced starting in 2024, indicating a substantial scaling of commercial operations.

Working Capital Volatility and Expansion

Working capital displayed significant instability between 2022 and 2023, including a dip into negative territory (-1,566 million US$) by December 31, 2023. However, from 2024 onward, there is a marked shift toward aggressive capital accumulation. Working capital surged from 6,591 million US$ in March 2024 to a peak of 21,930 million US$ in September 2025, suggesting a strategic increase in current assets relative to current liabilities to support higher production or distribution demands.

Working Capital Turnover Analysis

The turnover ratio has transitioned from a state of high volatility to a structural decline. In 2022 and 2023, the ratio fluctuated sharply, reaching peaks above 31.00. However, as the company scaled, the ratio trended downward, falling to 2.71 by September 2025. This downward trend indicates that the growth in working capital has significantly outpaced the growth in revenue, resulting in a lower efficiency of working capital usage in generating sales.

Operational Implications

The divergence between the rising revenue and the declining turnover ratio suggests that the business is in a capital-intensive growth phase. The massive increase in working capital during 2025 and 2026 implies a heavier investment in short-term operating assets, which may be necessary to sustain the accelerated revenue growth observed in the final quarters of the analysis.

A consistent decline in inventory management efficiency is evident over the observed period from March 31, 2022, to June 30, 2026. There is a strong inverse correlation between the inventory turnover ratio and the average inventory processing period, with the former decreasing steadily while the latter increases significantly.

Inventory Turnover Trends

The inventory turnover ratio exhibits a persistent downward trajectory. Starting at 1.93 in March 2022, the ratio decreased to 1.54 by the end of 2022 and further declined to 1.23 by December 31, 2023. This trend accelerated in subsequent years, falling below the 1.0 threshold in early 2025 and reaching a period low of 0.79 by June 30, 2026. This indicates a slowing rate of inventory replacement.

Average Inventory Processing Period Expansion

The average inventory processing period has expanded substantially, reflecting a longer duration for inventory to be converted into sales. The period began at 189 days in March 2022 and rose to 237 days by December 31, 2022. A notable escalation occurred throughout 2023 and 2024, with the period crossing the 300-day threshold in March 2024 and peaking at 463 days by June 30, 2026.

Temporal Analysis of Efficiency Loss

The data reveals three distinct phases of deceleration. Between March 2022 and December 2022, the processing period grew by approximately 25%. From January 2023 to December 2024, the period experienced a steady climb, moving from 268 days to 329 days. The most aggressive increase occurred during 2025, where the processing period jumped from 379 days in March to 454 days in December, suggesting a significant shift in operational dynamics or inventory accumulation during this window.

Overall, the operational data indicates a systemic increase in the time required to process inventory. The transition from an average processing period of under 200 days to over 460 days suggests a marked decrease in short-term operating activity efficiency.

An overall expansion of the receivable collection cycle is observed from March 2022 through June 2026. The data indicates a transition from a more efficient collection process in early 2022 toward a lengthened cycle characterized by periodic volatility and a higher average number of days required to convert receivables into cash.

Average Receivable Collection Period Trends

A progressive increase in the collection period is evident throughout 2022, rising from 79 days in March to 88 days by December. This upward trend continued into early 2023, reaching 99 days. A notable spike occurred in June 2024, where the collection period peaked at 103 days, the highest value in the sequence. Following this peak, the duration fluctuated but remained generally elevated, stabilizing between 92 and 99 days throughout 2025 and the first half of 2026.

Receivables Turnover Dynamics

The receivables turnover ratio exhibits a consistent inverse correlation with the collection period, reflecting a decline in relative efficiency over the analyzed timeframe. The ratio began at a peak of 4.64 in March 2022 and trended downward, hitting a minimum of 3.53 in June 2024. Recent data from 2025 and 2026 show a partial recovery and stabilization of the turnover ratio between 3.67 and 3.97, although these levels remain below the efficiency benchmarks established in early 2022.

The analyzed period reflects a significant extension of the overall operating cycle, characterized by a substantial increase in the time required to convert current assets into cash. This expansion is primarily driven by a sharp rise in inventory holding times, while the collection of receivables has remained relatively stable in comparison.

Average Inventory Processing Period

A consistent and aggressive upward trend is observed in the inventory processing period, which rose from 189 days in March 2022 to 463 days by June 2026. The most pronounced acceleration occurred between December 2023 and June 2025, where the period expanded from 298 days to 435 days. This indicates a significant slowdown in inventory turnover, suggesting that goods are remaining in stock for more than double the duration seen at the start of the period.

Average Receivable Collection Period

The collection period exhibits moderate volatility but lacks a strong linear trend compared to inventory. Starting at 79 days in March 2022, the period fluctuated between a low of 79 days and a peak of 103 days in June 2024. By June 2026, the period settled at 92 days. While there is a slight overall increase, the receivable collection process has remained comparatively efficient and is not the primary driver of the extended operating cycle.

Operating Cycle

The total operating cycle has more than doubled, increasing from 268 days in March 2022 to 555 days by June 2026. The correlation between the operating cycle and the inventory processing period is nearly absolute, confirming that the lengthening of the cash-to-cash cycle is almost entirely attributable to inventory management or production lead times. This trend represents a significant increase in the company's working capital requirements over the observed timeframe.

The analysis of short-term operating activity reveals a consistent expansion in the timeframe required to settle accounts payable from March 2022 through June 2026. A clear inverse correlation exists between the payables turnover ratio and the average payment period, indicating a sustained trend toward extending supplier credit terms.

Payables Turnover Trend

A steady decline in the payables turnover ratio is observed, falling from 5.24 in March 2022 to 2.16 by June 2026. This downward trajectory indicates that the company is cycling through its accounts payable less frequently, which effectively slows the outflow of cash to suppliers.

Average Payables Payment Period Expansion

The average period for settling obligations demonstrates a significant upward trend, increasing from 70 days in March 2022 to 169 days by June 2026. A period of rapid acceleration is noted between March 2022 and June 2023, where the duration increased from 70 to 138 days. The payment period reached its peak of 178 days in December 2025, representing more than a twofold increase from the start of the analyzed period.

Analysis of Periodic Fluctuations

Despite the overall upward trajectory, intermittent contractions in the payment period are present. Notable dips occurred in March 2024 (127 days) and March 2026 (148 days). These variations suggest occasional accelerations in payment settlements, although they are insufficient to offset the broader trend of extending payment cycles.

Operational Implications

The progression from a 70-day to a 169-day payment cycle suggests an increase in the company's ability to leverage supplier financing. This shift results in higher current liabilities but enhances short-term liquidity by retaining cash within the organization for longer durations.

The cash conversion cycle has demonstrated a significant upward trajectory over the analyzed period, increasing from 198 days in March 2022 to 386 days by June 2026. This extension indicates a slower turnaround of working capital, primarily driven by a substantial increase in the time required to process inventory, which has been partially mitigated by an extension in the payment of accounts payable.

Average Inventory Processing Period

A consistent and pronounced increase is observed in the inventory processing period, which rose from 189 days in March 2022 to 463 days in June 2026. The growth was particularly accelerated between March 2024 and June 2026, where the period climbed from 312 days to 463 days. This trend suggests a significant accumulation of inventory or a slowing of inventory turnover rates.

Average Receivable Collection Period

The receivable collection period remained relatively stable compared to other operating metrics. While it fluctuated between a low of 79 days in March 2022 and a peak of 103 days in June 2024, it concluded the period at 92 days in June 2026. This stability indicates that credit collection efficiency has remained largely consistent despite the growth in other cycle components.

Average Payables Payment Period

There is a clear upward trend in the payables payment period, increasing from 70 days in March 2022 to 169 days in June 2026. This suggests a strategic shift toward extending payment terms with suppliers, which serves as a financing mechanism to offset the liquidity pressures caused by the lengthening inventory processing period.

Cash Conversion Cycle Dynamics

The overall expansion of the cash conversion cycle is the result of the inventory processing period increasing at a faster rate than the payables payment period. While the increase in payables provided a buffer, it was insufficient to neutralize the impact of the inventory build-up, leading to a net increase of 188 days in the total cycle over the period analyzed.