Stock Analysis on Net
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
Jun 30, 2026 78.84% = 18.77% × 4.20
Mar 31, 2026 81.02% = 21.68% × 3.74
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-Q (reporting date: 2026-06-30), 10-Q (reporting date: 2026-03-31), 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 Return on Equity (ROE) exhibits a cyclical trajectory over the observed period, characterized by an initial contraction, a period of mid-term volatility, and a subsequent strong expansion phase. The overall trend reflects a transition in the primary drivers of shareholder returns.

Return on Assets (ROA)
ROA maintained stability in early 2022 before entering a downward trend throughout 2023, reaching a trough of 8.19% in December 2023. Following this period, a consistent and significant acceleration is observed, with ROA climbing to a peak of 21.68% by March 2026. This indicates a substantial improvement in the company's ability to generate profit from its asset base.
Financial Leverage
The financial leverage ratio fluctuated between 4.65 and 5.94 during the first half of the period, peaking in December 2023. A distinct deleveraging trend emerged starting in mid-2025, with the ratio declining from 5.52 in June 2025 to a period low of 3.74 by March 2026, before a slight uptick in June 2026.
ROE Disaggregation and Drivers
The analysis of the two-component disaggregation reveals a shift in the quality of ROE. During the decline in ROE between March 2022 and September 2023, the erosion of ROA was the primary driver, as the decrease in asset efficiency outweighed the modest increases in financial leverage. Conversely, the surge in ROE from 2024 through 2026 was driven exclusively by the rapid expansion of ROA. The observation that ROE reached its maximum of 81.02% in March 2026 while financial leverage was at its minimum suggests that the growth in shareholder returns is now fundamentally driven by operational performance and asset productivity rather than financial engineering.

AI Ask an analyst for more


Three-Component Disaggregation of ROE

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

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Jun 30, 2026 78.84% = 33.53% × 0.56 × 4.20
Mar 31, 2026 81.02% = 34.99% × 0.62 × 3.74
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-Q (reporting date: 2026-06-30), 10-Q (reporting date: 2026-03-31), 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 Return on Equity (ROE) experienced a period of volatility between early 2022 and late 2023, reaching a trough of 44.46% in September 2023, before entering a sustained growth phase that peaked at 81.02% by March 2026. The analysis of the three DuPont components reveals that this recovery and subsequent expansion were primarily driven by significant improvements in profitability rather than asset efficiency or increased financial risk.

Net Profit Margin
A notable U-shaped trend is observed in profitability. After maintaining margins around 20% in 2022, there was a contraction to a low of 15.36% in December 2023. This was followed by a consistent and aggressive expansion, with margins climbing to 34.99% by March 2026. This component serves as the primary catalyst for the overall increase in ROE during the latter half of the period.
Asset Turnover
Asset utilization remained relatively stagnant and exhibited a slight downward bias. The ratio fluctuated within a narrow range, starting at 0.62 in early 2022 and ending at 0.56 in June 2026. The lack of significant growth in this metric indicates that the increase in ROE was not a result of improved operational efficiency or higher revenue generation per unit of asset.
Financial Leverage
The company's use of debt as a multiplier for equity showed varying trends. Leverage peaked at 5.94 in December 2023, coinciding with the period of lowest profit margins. However, a steady deleveraging trend is evident from early 2024 onward, with the ratio declining to 3.74 by March 2026. This suggests a strategic reduction in financial risk.
Synthesis of ROE Drivers
The data indicates a transition in the drivers of shareholder returns. While ROE in the early period was supported by higher financial leverage and moderate margins, the later surge in ROE was achieved despite a reduction in leverage. The ability to increase ROE while simultaneously decreasing the leverage ratio underscores the strength of the net profit margin expansion as the dominant driver of financial performance.

AI Ask an analyst for more


Two-Component Disaggregation of ROA

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

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Jun 30, 2026 18.77% = 33.53% × 0.56
Mar 31, 2026 21.68% = 34.99% × 0.62
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-Q (reporting date: 2026-06-30), 10-Q (reporting date: 2026-03-31), 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 Return on Assets (ROA) exhibits a cyclical trajectory characterized by an initial contraction followed by a period of significant expansion. The metric transitioned from a stable range of 12% to 13% throughout 2022 to a trough of 8.19% in December 2023, before ascending to a peak of 21.68% by March 2026.

Net Profit Margin
A volatile but ultimately ascending trend is observed in profitability. After maintaining levels between 19.58% and 21.88% in 2022, the margin experienced a notable contraction during 2023, reaching a low of 15.36% in December. From early 2024, a consistent growth phase emerged, with the margin expanding aggressively to peak at 34.99% in March 2026. This suggests a substantial increase in pricing power or a significant reduction in the cost of goods sold relative to revenue.
Asset Turnover
Asset utilization remained relatively stagnant with a slight downward bias. The ratio began at 0.62 in early 2022 and trended lower, oscillating between 0.52 and 0.62 for the remainder of the period. The lack of a sustained upward trend in asset turnover indicates that the company did not significantly increase its sales volume relative to its asset base during this timeframe.
ROA Disaggregation Synthesis
The analysis of the two components reveals that the fluctuations in Return on Assets are almost exclusively driven by the Net Profit Margin. Because Asset Turnover remained largely flat or slightly declined, the recovery and subsequent surge in ROA starting in 2024 were catalyzed by the expansion of profit margins. This indicates that the improvement in overall asset productivity is a result of enhanced profitability per dollar of sales rather than increased operational efficiency in asset deployment.

AI Ask an analyst for more