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
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 = ×
Dec 31, 2021 = ×
Sep 30, 2021 = ×
Jun 30, 2021 = ×
Mar 31, 2021 = ×
Dec 31, 2020 = ×
Sep 30, 2020 = ×
Jun 30, 2020 = ×
Mar 31, 2020 = ×

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


The analysis of the quarterly financial data reveals distinct trends in the key performance indicators Return on Assets (ROA), Financial Leverage, and Return on Equity (ROE) over the observed periods.

Return on Assets (ROA)
ROA data commences from December 31, 2020, exhibiting a generally fluctuating pattern. Initial values around 12-13% decline moderately in early 2023, reaching a low of approximately 8.19% in December 2023. Subsequent quarters show a recovery trend, with ROA increasing steadily to reach a high of about 13.67% by March 31, 2025. This demonstrates periods of efficiency improvements following a mid-term dip.
Financial Leverage
Financial leverage started at a high level above 13 times in March 2020, followed by a consistent declining trend through 2020 and early 2021, reaching its lowest points near 4.65 times around late 2022. From 2023 onward, leverage showed a gradual increase, stabilizing in the mid-range of 5 to 5.7 times by early 2025. This pattern suggests a strategic reduction in debt or liabilities relative to equity in the earlier period, with a cautious re-leveraging more recently.
Return on Equity (ROE)
ROE is recorded from December 2020, starting at a very elevated level near 110%, followed by a marked declining trend through 2021 and 2022, bottoming out between roughly 44% and 50% around late 2023. After this trough, ROE improves consistently, rising to approximately 75.5% by March 2025. Despite the volatility, ROE remains substantially high throughout the periods, indicating robust profitability relative to shareholder equity.

Overall, the data indicates an initial phase of high leverage and strong profitability metrics that moderated over time, followed by adjustments that led to optimized leverage and recovery in asset and equity returns. The observed fluctuations in ROE and ROA, alongside evolving financial leverage, may reflect responses to market conditions, operational changes, or capital structure management strategies.


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, 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 = × ×
Dec 31, 2021 = × ×
Sep 30, 2021 = × ×
Jun 30, 2021 = × ×
Mar 31, 2021 = × ×
Dec 31, 2020 = × ×
Sep 30, 2020 = × ×
Jun 30, 2020 = × ×
Mar 31, 2020 = × ×

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


The financial ratios analyzed over the quarters present notable trends and fluctuations in profitability, efficiency, leverage, and overall return performance.

Net Profit Margin (%)
The net profit margin, available from the first quarter of 2020 onward, shows an overall downward trend from 25.24% in March 2020 to a low point in the December 2023 quarter at 15.36%. This decline indicates a reduction in profitability relative to revenue over this period. However, following that trough, there is a clear recovery with net profit margins rising steadily to 25.91% by March 2025, suggesting improved cost control or pricing strategies leading to enhanced profit retention.
Asset Turnover (ratio)
Asset turnover remained relatively stable with minor fluctuations, peaking at 0.62 in the middle quarters of 2021 and 2022. There is a modest decrease after mid-2022, fluctuating between 0.52 and 0.57 through early 2025. This stability implies consistent efficiency in utilizing assets to generate revenue, but no significant improvements in asset utilization efficiency were observed.
Financial Leverage (ratio)
A distinct downward trend in financial leverage is evident as the ratio declines sharply from 13.35 in March 2020 to a range between approximately 4.65 and 5.67 in subsequent periods. This reduction indicates substantial deleveraging, suggesting the company has reduced debt relative to equity over time. The leverage ratio stabilizes around 5.5 from late 2022 through early 2025, pointing to a more conservative capital structure.
Return on Equity (ROE) (%)
ROE exhibits several fluctuations but with a general downward trend from an exceptionally high 109.79% reported in March 2020 to a level around mid to high 40s and 50s through 2021 and 2022. By late 2023, ROE dips further to a low of 44.46%, reflecting the impact of decreased profitability and reduced leverage. Thereafter, ROE improves significantly, rising above 70% by early 2025, potentially driven by a combination of higher profit margins and more efficient use of equity capital despite lower leverage.

In summary, the period under review reflects a phase of financial restructuring characterized by decreased financial leverage and temporarily reduced profit margins, which collectively contributed to lower ROE in the middle periods. The subsequent recovery in net profit margin and ROE toward the end of the period suggests a rebound in financial performance, supported by stable asset turnover and a moderated capital structure.


Two-Component Disaggregation of ROA

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

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

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


Net Profit Margin

The net profit margin demonstrates a fluctuating pattern over the observed periods. Starting from 25.24% in March 2020, there is a general declining trend reaching its lowest point at 15.36% in June 2023. After this trough, the margin recovers steadily, rising to 25.91% by June 2025. This suggests variability in profitability with a notable dip in mid-2023 followed by a significant rebound through 2024 into mid-2025.

Asset Turnover

The asset turnover ratio shows relative stability with minor fluctuations throughout the periods. Initially, the ratio increases from 0.53 in March 2020 to peak values around 0.62 between June 2021 and December 2022. Subsequently, there is a decline, stabilizing in the mid- to high 0.50s range, ending at 0.55 in June 2025. This indicates consistent efficiency in using assets to generate revenue, with slight declines after the peak phase.

Return on Assets (ROA)

ROA follows a trend somewhat aligned with the net profit margin but shows a more gradual decline from 13.28% in March 2020 to a low of 8.19% in June 2023. Thereafter, the ROA begins to improve, reaching 13.67% by June 2025. This pattern reflects changes in profitability and asset efficiency, highlighting a recovery phase after mid-2023.

Summary of Trends

Overall, the financial metrics reveal a period of declining profitability and asset returns culminating around mid-2023, followed by a recovery period through 2024 and into mid-2025. The asset turnover ratio maintains relative steadiness, implying that revenue generation from assets remained consistent despite profit and return variations. The simultaneous troughs and subsequent rebounds in net profit margin and ROA suggest external or operational factors influencing profitability and effective asset use, with a strong recovery phase evident in recent quarters.