Stock Analysis on Net

Eli Lilly & Co. (NYSE:LLY)

DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin 
Quarterly Data

Microsoft Excel

Two-Component Disaggregation of ROE

Eli Lilly & Co., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
Dec 31, 2025 77.78% = 18.35% × 4.24
Sep 30, 2025 77.38% = 16.02% × 4.83
Jun 30, 2025 75.52% = 13.67% × 5.52
Mar 31, 2025 70.45% = 12.42% × 5.67
Dec 31, 2024 74.62% = 13.45% × 5.55
Sep 30, 2024 58.78% = 11.07% × 5.31
Jun 30, 2024 54.14% = 10.22% × 5.30
Mar 31, 2024 47.91% = 9.60% × 4.99
Dec 31, 2023 48.65% = 8.19% × 5.94
Sep 30, 2023 44.46% = 8.61% × 5.16
Jun 30, 2023 58.73% = 11.85% × 4.95
Mar 31, 2023 50.82% = 10.70% × 4.75
Dec 31, 2022 58.64% = 12.62% × 4.65
Sep 30, 2022 59.91% = 12.71% × 4.71
Jun 30, 2022 66.61% = 12.09% × 5.51
Mar 31, 2022 65.69% = 13.06% × 5.03

Based on: 10-K (reporting date: 2025-12-31), 10-Q (reporting date: 2025-09-30), 10-Q (reporting date: 2025-06-30), 10-Q (reporting date: 2025-03-31), 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 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).


The financial performance, as indicated by the provided metrics, exhibits notable fluctuations over the observed period. Return on Equity (ROE) demonstrates a generally decreasing trend from early 2022 through late 2023, followed by a substantial increase into 2025. This ROE movement is closely tied to the interplay between Return on Assets (ROA) and Financial Leverage.

Return on Assets (ROA)
ROA begins at 13.06% in March 2022 and experiences moderate variability, decreasing to 10.70% by March 2023. A recovery is then observed, with ROA reaching 13.45% by December 2024, and continuing to climb to 18.35% by December 2025. This suggests improving operational efficiency and asset utilization over the latter part of the period.
Financial Leverage
Financial Leverage shows an initial increase from 5.03 in March 2022 to a peak of 5.94 in December 2022. It then declines, reaching a low of 4.24 in December 2025. This indicates a shifting capital structure, with a reduction in the reliance on debt financing towards the end of the analyzed timeframe. The higher leverage in 2022 and early 2023 amplified the impact of ROA on ROE.
Return on Equity (ROE) – Two-Component Disaggregation
ROE starts at a high of 65.69% in March 2022. The subsequent decline to 50.82% by March 2023 is attributable to the combined effect of decreasing ROA and fluctuating Financial Leverage. The increase in ROE from late 2024 through 2025 is driven primarily by the substantial improvement in ROA, despite the concurrent decrease in Financial Leverage. The period between March 2024 and December 2025 shows a particularly strong positive correlation between ROA and ROE, indicating that asset efficiency is a key driver of shareholder returns.

The observed patterns suggest a strategic shift in financial management. While initially relying on higher leverage to boost ROE, the focus appears to have transitioned towards improving asset utilization and operational performance, as evidenced by the increasing ROA and decreasing reliance on financial leverage in the more recent periods. This shift has resulted in a renewed increase in ROE, demonstrating the effectiveness of the evolving strategy.


Three-Component Disaggregation of ROE

Eli Lilly & Co., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Dec 31, 2025 77.78% = 31.67% × 0.58 × 4.24
Sep 30, 2025 77.38% = 30.99% × 0.52 × 4.83
Jun 30, 2025 75.52% = 25.91% × 0.53 × 5.52
Mar 31, 2025 70.45% = 22.66% × 0.55 × 5.67
Dec 31, 2024 74.62% = 23.51% × 0.57 × 5.55
Sep 30, 2024 58.78% = 20.48% × 0.54 × 5.31
Jun 30, 2024 54.14% = 18.86% × 0.54 × 5.30
Mar 31, 2024 47.91% = 17.08% × 0.56 × 4.99
Dec 31, 2023 48.65% = 15.36% × 0.53 × 5.94
Sep 30, 2023 44.46% = 15.55% × 0.55 × 5.16
Jun 30, 2023 58.73% = 22.01% × 0.54 × 4.95
Mar 31, 2023 50.82% = 20.54% × 0.52 × 4.75
Dec 31, 2022 58.64% = 21.88% × 0.58 × 4.65
Sep 30, 2022 59.91% = 20.63% × 0.62 × 4.71
Jun 30, 2022 66.61% = 19.58% × 0.62 × 5.51
Mar 31, 2022 65.69% = 20.90% × 0.62 × 5.03

Based on: 10-K (reporting date: 2025-12-31), 10-Q (reporting date: 2025-09-30), 10-Q (reporting date: 2025-06-30), 10-Q (reporting date: 2025-03-31), 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 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).


The three-component DuPont analysis reveals fluctuating performance over the observed period. Return on Equity (ROE) experienced considerable variation, influenced by shifts in Net Profit Margin, Asset Turnover, and Financial Leverage. Initial values demonstrate a strong ROE, which subsequently declined before exhibiting renewed growth towards the end of the period.

Net Profit Margin
The Net Profit Margin generally remained strong, fluctuating between approximately 15% and 32% throughout the period. A dip in profitability is observed in the latter half of 2022 and the first half of 2023, with margins falling to around 15%. However, the margin demonstrates a consistent upward trend from the second half of 2023, peaking at 31.67% in December 2023 and sustaining at 31.67% and 30.99% in the subsequent periods. This suggests improving operational efficiency or pricing power.
Asset Turnover
Asset Turnover exhibited relative stability in the initial periods, hovering around 0.62. A gradual decline is then noted, reaching a low of 0.52 in September 2023. A modest recovery is observed in the latter part of the period, with the ratio increasing to 0.58 in December 2025. This indicates a slight improvement in the efficiency of asset utilization, but overall remains relatively consistent.
Financial Leverage
Financial Leverage demonstrated a more pronounced pattern of change. It initially increased from 5.03 to 5.51, then decreased to 4.65 before rising significantly to 5.94 in December 2023. Following this peak, leverage decreased steadily, reaching 4.24 in December 2025. This suggests a dynamic capital structure strategy, potentially involving increased debt financing followed by a period of deleveraging. The fluctuations in leverage significantly impacted ROE.

The interplay between these three components explains the observed ROE trends. The initial high ROE was supported by a combination of strong profitability, moderate asset turnover, and substantial leverage. The decline in ROE in 2023 was primarily driven by a decrease in Net Profit Margin and Asset Turnover, despite increased leverage. The subsequent recovery in ROE, particularly towards the end of the period, is attributable to the substantial improvement in Net Profit Margin, partially offset by declining leverage and relatively stable asset turnover.

The significant increase in Net Profit Margin in the most recent periods appears to be a key driver of improved financial performance. Monitoring the sustainability of this margin improvement, alongside the ongoing adjustments in financial leverage, will be crucial for assessing future ROE performance.


Two-Component Disaggregation of ROA

Eli Lilly & Co., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Dec 31, 2025 18.35% = 31.67% × 0.58
Sep 30, 2025 16.02% = 30.99% × 0.52
Jun 30, 2025 13.67% = 25.91% × 0.53
Mar 31, 2025 12.42% = 22.66% × 0.55
Dec 31, 2024 13.45% = 23.51% × 0.57
Sep 30, 2024 11.07% = 20.48% × 0.54
Jun 30, 2024 10.22% = 18.86% × 0.54
Mar 31, 2024 9.60% = 17.08% × 0.56
Dec 31, 2023 8.19% = 15.36% × 0.53
Sep 30, 2023 8.61% = 15.55% × 0.55
Jun 30, 2023 11.85% = 22.01% × 0.54
Mar 31, 2023 10.70% = 20.54% × 0.52
Dec 31, 2022 12.62% = 21.88% × 0.58
Sep 30, 2022 12.71% = 20.63% × 0.62
Jun 30, 2022 12.09% = 19.58% × 0.62
Mar 31, 2022 13.06% = 20.90% × 0.62

Based on: 10-K (reporting date: 2025-12-31), 10-Q (reporting date: 2025-09-30), 10-Q (reporting date: 2025-06-30), 10-Q (reporting date: 2025-03-31), 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 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).


The financial performance, as indicated by the two-component disaggregation of Return on Assets (ROA), reveals notable fluctuations over the observed period. Generally, the latter half of the period demonstrates strengthening profitability and efficiency. A detailed examination of the Net Profit Margin and Asset Turnover ratios provides further insight into these trends.

Net Profit Margin
The Net Profit Margin exhibited variability throughout the period. Initial values ranged between 19.58% and 21.88% in the first four quarters. A decline was observed in the first half of 2023, reaching a low of 20.54% and 22.01% respectively. However, a consistent upward trend commenced in the latter half of 2023, accelerating through 2024 and into the first half of 2025, culminating in a peak of 31.67% by December 2025. This suggests improving cost control or pricing power.
Asset Turnover
Asset Turnover remained relatively stable between 0.52 and 0.62 for the majority of the observed period. A slight downward trend was apparent from March 2022 through March 2023. The ratio then stabilized around 0.53-0.56 for several quarters before increasing to 0.58 by December 2025. This indicates a modest improvement in the efficiency with which assets are used to generate sales towards the end of the period.
Return on Assets (ROA)
The ROA mirrored the combined effect of the Net Profit Margin and Asset Turnover. It began at 13.06% in March 2022 and decreased to 10.70% by March 2023, reflecting the impact of lower profitability and asset utilization. A gradual recovery commenced in the latter half of 2023, continuing through 2024 and accelerating in 2025. By December 2025, the ROA reached 18.35%, representing a substantial improvement from the low point in early 2023. The increase in ROA is primarily driven by the significant rise in Net Profit Margin, with a modest contribution from the slight improvement in Asset Turnover.

In summary, the analysis indicates a period of initial stability followed by a notable improvement in financial performance. The substantial increase in Net Profit Margin appears to be the primary driver of the enhanced ROA, suggesting successful strategies in managing costs or increasing revenue. The modest improvement in Asset Turnover further supports the overall positive trend.