Stock Analysis on Net

Eli Lilly & Co. (NYSE:LLY)

$24.99

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

Microsoft Excel

Paying user area

The data is hidden behind: . Unhide it.

This is a one-time payment. There is no automatic renewal.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Two-Component Disaggregation of ROE

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

Microsoft Excel
ROE = ROA × Financial Leverage
Mar 31, 2026 = ×
Dec 31, 2025 = ×
Sep 30, 2025 = ×
Jun 30, 2025 = ×
Mar 31, 2025 = ×
Dec 31, 2024 = ×
Sep 30, 2024 = ×
Jun 30, 2024 = ×
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 = ×

Based on: 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) exhibited significant volatility between March 2022 and March 2026, characterized by a mid-period contraction followed by a sustained expansion. The overall trajectory indicates a fundamental shift in the drivers of shareholder returns, moving from a reliance on financial leverage to a primary dependence on operational asset efficiency.

Return on Assets (ROA)
Asset productivity underwent a period of decline throughout 2023, decreasing from 13.06% in March 2022 to a trough of 8.19% in December 2023. This downward trend reversed in early 2024, initiating a strong and consistent growth phase. ROA climbed steadily, reaching 21.68% by March 2026, which signifies a substantial improvement in the company's ability to generate earnings from its total asset base.
Financial Leverage
The financial leverage ratio remained relatively high and volatile during the first half of the period, peaking at 5.94 in December 2023. While the ratio remained above 5.0 for much of 2024 and early 2025, a sharp deleveraging trend emerged in the latter part of the period. The ratio fell precipitously from 5.52 in June 2025 to 3.74 by March 2026, reflecting a reduction in the use of debt to amplify returns.
ROE Disaggregation and Synthesis
The two-component analysis reveals a changing relationship between profitability and leverage. In 2023, the decline in ROE to a low of 44.46% was driven by the erosion of ROA, which was not sufficiently offset by the increase in financial leverage. In contrast, the subsequent rise in ROE to 81.02% by March 2026 was achieved despite the simultaneous reduction in financial leverage. This divergence confirms that the recent expansion in equity returns is driven exclusively by a surge in organic asset profitability rather than increased financial risk.

Three-Component Disaggregation of ROE

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

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Mar 31, 2026 = × ×
Dec 31, 2025 = × ×
Sep 30, 2025 = × ×
Jun 30, 2025 = × ×
Mar 31, 2025 = × ×
Dec 31, 2024 = × ×
Sep 30, 2024 = × ×
Jun 30, 2024 = × ×
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 = × ×

Based on: 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 exhibits a U-shaped trajectory over the observed period. After an initial decline from 65.69% in March 2022 to a minimum of 44.46% in September 2023, the metric demonstrates a sustained upward trend, culminating in a peak of 81.02% by March 2026.

Net Profit Margin
Profitability margins underwent a period of contraction and subsequent expansion. A downward trend is observed from June 2022 (19.58%) through December 2023, where the margin reached 15.36%. Following this trough, a significant and consistent increase occurred, with the margin rising to 34.99% by March 2026. This expansion suggests a substantial improvement in operational efficiency or pricing power.
Asset Turnover
Asset efficiency remained relatively constant, fluctuating within a narrow range between 0.52 and 0.62. Although a slight dip was noted between March 2022 and December 2023, the ratio recovered to 0.62 by March 2026. The stability of this ratio indicates that asset utilization was not a primary driver of the fluctuations in shareholder returns.
Financial Leverage
The leverage profile shows a divergent correlation with the return on equity in the latter half of the period. Financial leverage peaked at 5.94 in December 2023 and subsequently entered a steady decline, reaching 3.74 by March 2026. This reduction signifies a decrease in the use of debt to amplify returns toward the end of the analyzed timeframe.
Return on Equity Synthesis
The decomposition of the return on equity reveals that the growth observed from late 2023 to early 2026 is driven almost exclusively by the expansion of the net profit margin. Because this increase in ROE occurred simultaneously with a reduction in financial leverage, the growth is characterized as being driven by fundamental operational profitability rather than increased financial risk.

Two-Component Disaggregation of ROA

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

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Mar 31, 2026 = ×
Dec 31, 2025 = ×
Sep 30, 2025 = ×
Jun 30, 2025 = ×
Mar 31, 2025 = ×
Dec 31, 2024 = ×
Sep 30, 2024 = ×
Jun 30, 2024 = ×
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 = ×

Based on: 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) exhibited a cyclical trajectory over the analyzed period, characterized by an initial contraction followed by a period of aggressive growth. After maintaining a range between 12.09% and 13.06% throughout 2022, ROA declined to a minimum of 8.19% by December 31, 2023. From early 2024, a sustained recovery trend emerged, leading to a peak of 21.68% by March 31, 2026.

Net Profit Margin
Profitability margins acted as the primary driver of ROA volatility. Following a relatively stable period around 20% in 2022, a notable compression occurred during 2023, with the margin falling to 15.36% by year-end. Subsequently, a strong and consistent expansion phase began in 2024. Margins accelerated from 17.08% in March 2024 to 34.99% by March 31, 2026, indicating a substantial increase in bottom-line efficiency relative to revenue.
Asset Turnover
Asset utilization remained comparatively stable, fluctuating within a narrow range between 0.52 and 0.62. A slight downward trend was observed from March 2022 (0.62) to March 2023 (0.52), followed by a period of stagnation between 0.53 and 0.57 for several quarters. The ratio eventually returned to 0.62 by the end of the period. This stability suggests that the company's ability to generate sales from its assets remained constant, meaning the asset base grew roughly in proportion to revenue.
ROA Component Interaction
The disaggregation of ROA demonstrates that the overall improvement in asset returns during 2024 and 2025 was almost exclusively attributable to the expansion of net profit margins. While asset turnover provided a consistent but flat baseline, the sharp rise in ROA from 9.60% in March 2024 to 21.68% in March 2026 was fueled by the margin's increase of approximately 1,791 basis points over the same interval.