Stock Analysis on Net

Eli Lilly & Co. (NYSE:LLY)

Analysis of Profitability Ratios 
Quarterly Data

Microsoft Excel

Profitability Ratios (Summary)

Eli Lilly & Co., profitability ratios (quarterly data)

Microsoft Excel
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
Return on Sales
Gross profit margin 81.70% 81.31% 80.91% 80.75% 80.16% 79.25% 78.67% 77.77% 77.67% 76.77% 75.61% 75.98% 74.40% 74.18% 74.85% 74.27% 75.88% 77.66%
Operating profit margin 28.74% 28.64% 24.81% 23.28% 20.80% 18.92% 18.42% 24.17% 22.45% 24.97% 24.65% 25.50% 25.94% 22.45% 23.17% 21.81% 22.06% 24.69%
Net profit margin 22.66% 23.51% 20.48% 18.86% 17.08% 15.36% 15.55% 22.01% 20.54% 21.88% 20.63% 19.58% 20.90% 19.71% 21.52% 22.71% 23.91% 25.24%
Return on Investment
Return on equity (ROE) 70.45% 74.62% 58.78% 54.14% 47.91% 48.65% 44.46% 58.73% 50.82% 58.64% 59.91% 66.61% 65.69% 62.16% 76.99% 94.20% 88.31% 109.79%
Return on assets (ROA) 12.42% 13.45% 11.07% 10.22% 9.60% 8.19% 8.61% 11.85% 10.70% 12.62% 12.71% 12.09% 13.06% 11.44% 12.39% 12.70% 13.01% 13.28%

Based on: 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 financial ratios over the reported periods reveals several notable trends and insights into the company's profitability and efficiency metrics.

Gross profit margin
The gross profit margin shows a consistent and steady upward trend from around 74% in early 2020 to over 81% by the first quarter of 2025. This improvement indicates enhanced control over production costs relative to revenue or stronger pricing power, contributing positively to overall profitability.
Operating profit margin
The operating profit margin experiences some fluctuation throughout the periods, beginning at approximately 24.7% in early 2020, dipping to lows near 18.4% toward the end of 2022, then steadily increasing again to reach nearly 28.7% by the first quarter of 2025. This pattern suggests periods of operational challenges or increased expenses followed by recovery and improved operational efficiency.
Net profit margin
The net profit margin displays variability across the periods, starting from about 25.2% in early 2020 and declining to just over 15.5% around late 2022, before showing signs of recovery to above 23% in early 2025. The decline and subsequent rise mirror changes seen in operating profitability but with additional factors such as tax effects, interest, and non-operating items influencing net outcomes.
Return on equity (ROE)
Return on equity exhibits significant volatility with particularly high values in early 2020 exceeding 100%, but a general downward trend through 2022 and late 2023, reaching a low around 44.5%. Subsequently, ROE improves markedly, peaking again close to 75% by the first quarter of 2025. These swings may reflect changes in leverage, profitability, or equity base adjustments over time.
Return on assets (ROA)
Return on assets remains more stable relative to other ratios, hovering between roughly 13% and 8.6% in the earlier and middle periods respectively, with a low during late 2022 and early 2023. From mid-2023 onward, ROA improves steadily to around 13.5% by early 2025. This suggests relatively consistent asset utilization with some periods of reduced efficiency followed by recovery.

Overall, the financial ratios depict a company that experienced some operational and profitability pressures during the 2021-2023 periods, particularly affecting operating and net margins as well as returns on equity and assets. However, there is clear evidence of recovery and strengthening performance from late 2023 onwards, highlighted by climbing margins and returns ratios. The continuous improvement in gross profit margin across the entire timeframe supports an underlying enhancement in cost management or product mix, while fluctuations in operating and net margins point to variability in operating expenses or external financial factors influencing profitability.


Return on Sales


Return on Investment


Gross Profit Margin

Eli Lilly & Co., gross profit margin calculation (quarterly data)

Microsoft Excel
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
Selected Financial Data (US$ in thousands)
Gross margin 10,504,300 11,129,000 9,268,300 9,132,600 7,094,500 7,565,400 7,638,500 6,504,700 5,333,300 5,753,700 5,362,500 5,057,500 5,737,900 5,949,700 5,342,000 4,786,900 4,927,000 5,720,200 4,414,200 4,277,400 4,644,700
Revenue 12,728,500 13,532,800 11,439,100 11,302,800 8,768,000 9,353,400 9,498,600 8,312,100 6,960,000 7,301,800 6,941,600 6,488,000 7,810,000 7,999,900 6,772,800 6,740,100 6,805,600 7,440,000 5,740,600 5,499,400 5,859,800
Profitability Ratio
Gross profit margin1 81.70% 81.31% 80.91% 80.75% 80.16% 79.25% 78.67% 77.77% 77.67% 76.77% 75.61% 75.98% 74.40% 74.18% 74.85% 74.27% 75.88% 77.66%
Benchmarks
Gross Profit Margin, Competitors2
AbbVie Inc. 70.69% 69.99% 67.21% 62.75% 62.28% 62.42% 65.76% 68.91% 69.43% 70.00% 69.62% 70.48% 69.53% 68.96% 67.72% 65.62% 64.82% 66.41%
Amgen Inc. 61.48% 59.85% 58.71% 61.56% 64.76% 68.60% 72.35% 72.87% 73.65% 74.17% 73.99% 74.00% 73.30% 73.44% 74.00% 73.97% 74.37% 74.59%
Bristol-Myers Squibb Co. 70.47% 71.08% 74.91% 75.38% 75.71% 76.24% 76.54% 77.01% 77.68% 78.04% 78.82% 79.13% 79.62% 78.57% 76.92% 75.88% 74.42% 72.31%
Danaher Corp. 59.74% 59.50% 59.37% 59.27% 58.39% 58.74% 58.77% 59.17% 60.22% 60.21% 60.65% 60.77% 60.77% 60.95% 60.44% 59.24% 57.60% 55.98%
Gilead Sciences Inc. 78.17% 78.15% 75.98% 75.56% 75.62% 75.87% 78.66% 79.27% 78.94% 79.03% 74.31% 75.30% 75.50% 75.56% 80.23% 79.90% 80.32% 81.23%
Johnson & Johnson 68.30% 69.07% 69.05% 69.06% 69.20% 68.82% 68.54% 68.06% 67.34% 67.26% 67.43% 67.86% 67.97% 68.16% 67.51% 67.00% 66.24% 65.58%
Merck & Co. Inc. 76.42% 76.32% 75.82% 75.25% 74.37% 73.17% 72.86% 72.96% 72.43% 70.63% 70.49% 70.41% 70.72% 72.02% 67.95% 67.48% 66.99% 67.74%
Pfizer Inc. 72.28% 71.94% 67.73% 58.18% 58.09% 58.10% 60.97% 69.61% 68.61% 65.77% 65.53% 62.18% 60.35% 62.08% 65.28% 70.96% 76.46% 79.26%
Regeneron Pharmaceuticals Inc. 85.79% 86.13% 86.12% 86.16% 86.32% 86.16% 85.96% 86.42% 86.96% 87.18% 85.39% 84.97% 84.65% 84.83% 86.65% 86.85% 86.84% 86.82%
Thermo Fisher Scientific Inc. 41.34% 41.28% 40.77% 40.76% 40.40% 39.90% 39.87% 39.75% 40.28% 42.24% 44.42% 46.63% 48.37% 50.08% 51.05% 51.29% 51.47% 49.67%
Vertex Pharmaceuticals Inc. 86.03% 86.11% 86.12% 86.45% 86.86% 87.21% 87.80% 87.92% 88.04% 87.90% 88.00% 88.13% 87.95% 88.06% 87.94% 87.89% 88.06% 88.14%

Based on: 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).

1 Q1 2025 Calculation
Gross profit margin = 100 × (Gross marginQ1 2025 + Gross marginQ4 2024 + Gross marginQ3 2024 + Gross marginQ2 2024) ÷ (RevenueQ1 2025 + RevenueQ4 2024 + RevenueQ3 2024 + RevenueQ2 2024)
= 100 × (10,504,300 + 11,129,000 + 9,268,300 + 9,132,600) ÷ (12,728,500 + 13,532,800 + 11,439,100 + 11,302,800) = 81.70%

2 Click competitor name to see calculations.


Revenue Trends
The revenue values show a pattern of fluctuations with a general upward trajectory over the observed periods. Starting from approximately 5,860,000 thousand USD in March 2020, there is a noticeable dip during the mid-2020 quarters, followed by recovery and growth, reaching around 12,728,500 thousand USD by March 2025. The most significant increases are observed from December 2023 onward, indicating improved sales performance or expansion activities.
Gross Margin Analysis
Gross margin figures exhibit variability but with an overall increasing trend. From a value near 4,644,700 thousand USD in March 2020, the margin saw fluctuations through 2020 and 2021 but rises significantly by the end of the observed horizon, peaking near 11,043,000 thousand USD by December 2024. The gross margin closely aligns with revenue changes, supporting the trend of growing business scale and profitability.
Gross Profit Margin Percentage
The gross profit margin percentage, available from March 2021 onward, displays a consistent upward trend, starting at approximately 77.66% in March 2021 and ascending steadily to 81.7% by March 2025. This improvement in gross profit margin percentage suggests enhanced operational efficiency, possibly due to better pricing strategies, cost control measures, or shifts toward higher-margin products.
Overall Insights
The synchronized increase in revenue, gross margin in absolute terms, and gross profit margin percentage reflects positively on the financial health over the observed periods. The company appears to be successfully expanding its revenue base while improving profitability and cost management. The consistent and steady improvement in the gross profit margin percentage further emphasizes the strengthening margin structure, which could contribute to more robust earnings and increased shareholder value moving forward.

Operating Profit Margin

Eli Lilly & Co., operating profit margin calculation (quarterly data)

Microsoft Excel
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
Selected Financial Data (US$ in thousands)
Operating income 3,695,100 5,148,800 1,526,400 3,714,800 2,509,000 2,387,800 450,400 2,125,700 1,494,000 1,836,400 1,676,500 1,210,100 2,404,300 1,917,200 1,881,200 1,403,400 1,155,300 1,992,100 1,278,300 1,196,800 1,590,800
Revenue 12,728,500 13,532,800 11,439,100 11,302,800 8,768,000 9,353,400 9,498,600 8,312,100 6,960,000 7,301,800 6,941,600 6,488,000 7,810,000 7,999,900 6,772,800 6,740,100 6,805,600 7,440,000 5,740,600 5,499,400 5,859,800
Profitability Ratio
Operating profit margin1 28.74% 28.64% 24.81% 23.28% 20.80% 18.92% 18.42% 24.17% 22.45% 24.97% 24.65% 25.50% 25.94% 22.45% 23.17% 21.81% 22.06% 24.69%
Benchmarks
Operating Profit Margin, Competitors2
AbbVie Inc. 17.56% 16.22% 24.89% 22.31% 23.50% 23.49% 27.32% 31.03% 28.49% 31.21% 30.59% 30.33% 32.68% 31.89% 30.09% 28.95% 23.63% 24.81%
Amgen Inc. 22.71% 22.66% 19.97% 20.96% 24.72% 29.35% 34.55% 37.50% 36.07% 38.57% 39.31% 38.04% 32.78% 31.44% 30.14% 30.72% 37.23% 37.70%
Bristol-Myers Squibb Co. 15.24% -15.50% -14.05% -14.39% -14.30% 16.18% 16.96% 17.29% 18.13% 17.96% 19.04% 18.19% 16.79% 15.91% -15.73% -17.02% -19.19% -21.60%
Danaher Corp. 20.26% 20.37% 20.11% 21.22% 21.05% 21.77% 23.83% 25.06% 27.02% 27.61% 27.35% 25.44% 25.23% 25.35% 24.63% 25.04% 22.30% 18.99%
Gilead Sciences Inc. 28.77% 5.81% 2.92% 9.26% 5.79% 28.24% 30.37% 31.18% 33.03% 27.17% 22.39% 25.78% 26.56% 36.72% 42.79% 37.20% 18.07% 16.72%
Johnson & Johnson 23.59% 23.42% 24.42% 25.31% 25.04% 24.90% 25.55% 25.61% 25.21% 24.63% 23.89% 23.47% 23.76% 24.95% 24.69% 25.23% 24.10% 23.60%
Merck & Co. Inc. 31.51% 31.03% 21.60% 24.75% 6.93% 3.92% 13.08% 10.34% 27.85% 30.27% 30.66% 33.04% 28.85% 25.74% 14.07% 10.64% 14.02% 16.47%
Pfizer Inc. 19.29% 19.51% 9.56% -4.19% -2.08% 2.15% 14.36% 28.13% 34.44% 34.83% 33.59% 30.37% 26.12% 23.91% 24.67% 24.12% 21.20% 19.47%
Regeneron Pharmaceuticals Inc. 27.20% 28.10% 28.69% 28.95% 29.40% 30.85% 32.23% 34.20% 35.79% 38.93% 45.45% 48.19% 55.08% 55.67% 55.19% 53.94% 43.37% 42.09%
Thermo Fisher Scientific Inc. 17.23% 17.11% 16.93% 17.01% 16.38% 16.00% 15.81% 15.42% 16.29% 18.69% 20.54% 22.51% 23.83% 25.57% 27.04% 28.00% 27.68% 24.19%
Vertex Pharmaceuticals Inc. -6.69% -2.11% -2.54% -3.37% 41.16% 38.83% 40.16% 41.72% 43.93% 48.23% 47.72% 48.85% 36.93% 36.73% 37.17% 33.93% 47.14% 46.03%

Based on: 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).

1 Q1 2025 Calculation
Operating profit margin = 100 × (Operating incomeQ1 2025 + Operating incomeQ4 2024 + Operating incomeQ3 2024 + Operating incomeQ2 2024) ÷ (RevenueQ1 2025 + RevenueQ4 2024 + RevenueQ3 2024 + RevenueQ2 2024)
= 100 × (3,695,100 + 5,148,800 + 1,526,400 + 3,714,800) ÷ (12,728,500 + 13,532,800 + 11,439,100 + 11,302,800) = 28.74%

2 Click competitor name to see calculations.


Revenue Trends
The revenue figures exhibit a generally increasing pattern over the observed periods. Starting at approximately 5.86 billion USD in the first quarter of 2020, revenue demonstrates fluctuations but maintains an upward trajectory, peaking near 13.5 billion USD by the first quarter of 2025. Despite some intermittent periods of decline or stagnation, particularly noticeable in the mid-2022 quarters and some quarters in 2023, the overall long-term growth suggests expanding market demand or successful sales strategies.
Operating Income Patterns
Operating income shows more volatility compared to revenue. It began at around 1.59 billion USD in the first quarter of 2020, experiencing notable declines mid-2020, followed by recoveries and several peaks and troughs throughout the subsequent years. The figure peaks significantly at approximately 5.15 billion USD in the first quarter of 2025, evidencing strong profitability growth during this period. However, some quarters reveal sharp decreases, such as in the third quarter of 2023, indicating possible operational challenges or one-off expenses impacting income.
Operating Profit Margin Analysis
The operating profit margin, available from late 2020 onward, reveals a relatively stable and moderately high margin ranging mostly in the low to mid-20 percentiles. This stability indicates consistent operational efficiency despite fluctuations in operating income and revenue. Margins fluctuate between roughly 18% to near 29%, with peaks occurring towards the later quarters, specifically in late 2024 and early 2025. This implies improved profitability or cost control measures in recent periods.
Overall Observations
The financial data displays a growth trend in both revenue and operating income over the analyzed quarters, albeit with some volatility in operating income. The operating profit margin remains fairly steady, supporting the interpretation that while income and revenue have variable behavior, the company maintains effective control over its operating costs relative to revenue. The significant increases in operating income and margins towards the latest quarters may highlight successful business developments or cost efficiencies implemented during this timeframe.

Net Profit Margin

Eli Lilly & Co., net profit margin calculation (quarterly data)

Microsoft Excel
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
Selected Financial Data (US$ in thousands)
Net income (loss) 2,759,300 4,409,800 970,300 2,967,000 2,242,900 2,189,700 (57,400) 1,763,200 1,344,900 1,937,700 1,451,700 952,500 1,902,900 1,726,100 1,110,100 1,390,200 1,355,300 2,116,800 1,208,400 1,412,000 1,456,500
Revenue 12,728,500 13,532,800 11,439,100 11,302,800 8,768,000 9,353,400 9,498,600 8,312,100 6,960,000 7,301,800 6,941,600 6,488,000 7,810,000 7,999,900 6,772,800 6,740,100 6,805,600 7,440,000 5,740,600 5,499,400 5,859,800
Profitability Ratio
Net profit margin1 22.66% 23.51% 20.48% 18.86% 17.08% 15.36% 15.55% 22.01% 20.54% 21.88% 20.63% 19.58% 20.90% 19.71% 21.52% 22.71% 23.91% 25.24%
Benchmarks
Net Profit Margin, Competitors2
AbbVie Inc. 7.31% 7.59% 9.22% 9.71% 11.02% 8.95% 11.81% 15.50% 13.37% 20.39% 23.19% 22.04% 22.00% 20.54% 13.66% 12.40% 10.28% 10.08%
Amgen Inc. 18.10% 12.77% 13.58% 10.60% 13.35% 24.96% 29.52% 31.52% 31.77% 26.42% 27.88% 26.73% 23.42% 24.25% 23.03% 23.80% 29.60% 29.97%
Bristol-Myers Squibb Co. 11.38% -18.53% -15.30% -14.06% -13.50% 17.83% 18.44% 17.62% 15.95% 13.71% 14.29% 14.04% 13.31% 15.08% -11.89% -11.44% -14.53% -21.20%
Danaher Corp. 15.81% 16.33% 16.39% 17.83% 18.54% 19.94% 22.89% 22.80% 23.32% 22.91% 21.65% 20.61% 21.32% 21.84% 20.97% 21.00% 19.17% 16.36%
Gilead Sciences Inc. 20.87% 1.68% 0.45% 3.82% 1.78% 21.03% 21.60% 20.18% 20.87% 17.02% 12.44% 15.22% 16.60% 23.05% 27.21% 19.62% 1.19% 0.51%
Johnson & Johnson 24.41% 15.84% 16.74% 43.91% 44.92% 41.28% 39.58% 14.52% 13.77% 18.90% 19.95% 19.21% 20.90% 22.26% 19.55% 19.92% 17.95% 17.82%
Merck & Co. Inc. 27.27% 26.68% 19.23% 21.98% 3.76% 0.61% 7.77% 5.34% 22.52% 24.49% 25.88% 29.00% 26.27% 26.79% 15.09% 11.83% 15.09% 14.72%
Pfizer Inc. 12.62% 12.62% 7.04% -4.62% -0.55% 3.56% 15.13% 27.38% 31.19% 31.27% 29.81% 28.94% 27.01% 27.04% 28.77% 23.86% 24.03% 22.95%
Regeneron Pharmaceuticals Inc. 31.94% 31.07% 33.61% 32.04% 29.45% 30.14% 30.47% 33.93% 33.81% 35.64% 39.17% 39.97% 48.06% 50.25% 51.65% 50.11% 43.53% 41.35%
Thermo Fisher Scientific Inc. 15.18% 14.77% 14.48% 14.69% 14.20% 13.99% 13.68% 13.14% 13.75% 15.47% 15.92% 17.37% 18.49% 19.70% 21.93% 22.47% 22.08% 19.79%
Vertex Pharmaceuticals Inc. -8.91% -4.86% -4.52% -4.74% 39.46% 36.68% 35.94% 35.40% 35.40% 37.20% 37.62% 38.26% 30.84% 30.92% 30.52% 29.80% 43.06% 43.70%

Based on: 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).

1 Q1 2025 Calculation
Net profit margin = 100 × (Net income (loss)Q1 2025 + Net income (loss)Q4 2024 + Net income (loss)Q3 2024 + Net income (loss)Q2 2024) ÷ (RevenueQ1 2025 + RevenueQ4 2024 + RevenueQ3 2024 + RevenueQ2 2024)
= 100 × (2,759,300 + 4,409,800 + 970,300 + 2,967,000) ÷ (12,728,500 + 13,532,800 + 11,439,100 + 11,302,800) = 22.66%

2 Click competitor name to see calculations.


The quarterly financial data reveals several notable trends and fluctuations in profitability and revenue over the observed periods.

Net Income (Loss)
The company's net income figures demonstrate variability across quarters, with values generally fluctuating between approximately 1.1 billion and 2.2 billion US dollars in earlier periods. There is a marked decline in Q3 2023, where net income turns negative (a loss of 57.4 million), indicating an exceptional event or downturn during that quarter. Following this, net income recovers sharply, reaching a peak of around 4.4 billion US dollars in Q1 2025, suggesting significant improvement in profitability towards the end of the timeline.
Revenue
Revenue figures show a generally increasing trend with some seasonal and cyclical variations. Starting from around 5.8 billion US dollars in Q1 2020, revenue experiences growth, particularly noticeable after mid-2022, peaking at over 13.5 billion US dollars in Q4 2024. Despite minor fluctuations, the overall trajectory is upwards, indicating expansion or increased sales volume in the most recent periods.
Net Profit Margin (%)
The net profit margin data, available from Q4 2020 onward, reveals a downward trend initially, declining from about 25.24% in Q4 2020 to 15.36% by Q1 2024. Subsequently, margins improve steadily, peaking above 23% by Q1 2025. The pattern suggests a period of reduced profitability efficiency followed by recovery and improved cost management or revenue quality.
Integrative Insights
The data underscores a period of volatility in earnings despite generally increasing revenues. The negative net income in Q3 2023 contrasts sharply with the overall strengthening revenue base, which may point to one-time charges or operational challenges during that quarter. The recovery in net income and margin in the final quarters implies effective corrective actions or favorable market conditions.

Return on Equity (ROE)

Eli Lilly & Co., ROE calculation (quarterly data)

Microsoft Excel
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
Selected Financial Data (US$ in thousands)
Net income (loss) 2,759,300 4,409,800 970,300 2,967,000 2,242,900 2,189,700 (57,400) 1,763,200 1,344,900 1,937,700 1,451,700 952,500 1,902,900 1,726,100 1,110,100 1,390,200 1,355,300 2,116,800 1,208,400 1,412,000 1,456,500
Total Eli Lilly and Company shareholders’ equity 15,764,800 14,192,100 14,240,000 13,562,000 12,812,200 10,771,900 11,220,400 11,063,800 11,190,400 10,649,800 10,070,100 8,544,700 9,330,800 8,979,200 7,757,000 6,444,400 6,898,700 5,641,600 4,826,900 4,092,900 3,078,800
Profitability Ratio
ROE1 70.45% 74.62% 58.78% 54.14% 47.91% 48.65% 44.46% 58.73% 50.82% 58.64% 59.91% 66.61% 65.69% 62.16% 76.99% 94.20% 88.31% 109.79%
Benchmarks
ROE, Competitors2
AbbVie Inc. 295.42% 128.66% 84.91% 78.77% 74.85% 46.94% 53.86% 67.50% 57.14% 68.60% 83.83% 86.24% 76.64% 74.91% 55.60% 53.01% 37.63% 35.30%
Amgen Inc. 95.59% 69.59% 56.20% 52.83% 74.93% 107.78% 98.82% 117.67% 148.04% 178.97% 187.11% 271.85% 624.78% 87.96% 68.26% 69.67% 75.91% 77.20%
Bristol-Myers Squibb Co. 31.16% -54.78% -42.34% -38.44% -37.28% 27.27% 28.57% 24.91% 22.97% 20.37% 20.44% 20.30% 19.79% 19.46% -14.52% -13.80% -16.54% -23.84%
Danaher Corp. 7.40% 7.87% 7.59% 8.42% 8.24% 8.91% 11.29% 12.30% 13.47% 14.39% 14.40% 13.63% 13.93% 14.24% 13.54% 13.12% 11.76% 9.17%
Gilead Sciences Inc. 31.13% 2.48% 0.69% 5.77% 2.77% 24.81% 26.33% 25.92% 26.59% 21.62% 15.82% 20.44% 22.66% 29.55% 34.44% 26.20% 1.59% 0.68%
Johnson & Johnson 27.92% 19.68% 20.93% 53.14% 54.95% 51.11% 48.61% 17.37% 17.95% 23.36% 25.68% 24.05% 26.54% 28.20% 25.44% 25.53% 22.96% 23.25%
Merck & Co. Inc. 36.07% 36.96% 27.30% 31.52% 5.71% 0.97% 11.17% 8.04% 27.82% 31.57% 34.32% 38.34% 34.68% 34.17% 20.10% 16.73% 26.08% 27.91%
Pfizer Inc. 8.73% 9.11% 4.61% -2.96% -0.33% 2.38% 10.81% 21.68% 28.77% 32.79% 32.14% 33.61% 30.29% 28.47% 26.28% 18.86% 16.23% 15.21%
Regeneron Pharmaceuticals Inc. 15.31% 15.03% 15.87% 15.32% 14.29% 15.22% 16.03% 17.90% 17.80% 19.14% 25.05% 27.49% 39.84% 43.03% 40.53% 41.02% 33.43% 31.86%
Thermo Fisher Scientific Inc. 13.19% 12.78% 12.52% 13.12% 13.26% 12.83% 13.11% 13.08% 14.26% 15.80% 16.15% 17.59% 18.56% 18.94% 22.13% 23.32% 22.60% 18.47%
Vertex Pharmaceuticals Inc. -5.99% -3.26% -3.07% -3.32% 21.67% 20.59% 21.01% 21.75% 22.59% 23.88% 25.12% 26.77% 22.47% 23.19% 22.83% 21.66% 30.76% 31.22%

Based on: 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).

1 Q1 2025 Calculation
ROE = 100 × (Net income (loss)Q1 2025 + Net income (loss)Q4 2024 + Net income (loss)Q3 2024 + Net income (loss)Q2 2024) ÷ Total Eli Lilly and Company shareholders’ equity
= 100 × (2,759,300 + 4,409,800 + 970,300 + 2,967,000) ÷ 15,764,800 = 70.45%

2 Click competitor name to see calculations.


Net Income (Loss)
The net income showed significant fluctuation over the observed quarters. Starting at 1,456,500 thousand US dollars in March 2020, it initially dropped to a low of 952,500 in June 2022 before experiencing a marked recovery and growth. Notably, there was a substantial loss recorded in September 2023 with a negative value of -57,400, interrupting the otherwise positive trend. Following this, net income recovered strongly, reaching 4,409,800 in March 2025, representing a significant upturn compared to earlier periods.
Total Shareholders’ Equity
Shareholders’ equity demonstrated a general upward trend throughout the period. Beginning at 3,078,800 thousand US dollars in March 2020, it grew steadily to peak at 15,764,800 by March 2025. There were some fluctuations, such as a decline from 11,190,400 in March 2023 to 10,771,900 in December 2023, but the overall trajectory was positive, indicating consistent growth in the company’s equity base.
Return on Equity (ROE)
ROE data is available from March 2021 onwards, showing an initially very high return of 109.79%, which then declined to more moderate levels throughout the time frame. Despite the decrease from the initial peak, ROE remained robust, generally ranging between 44.46% and 74.62%. There is a visible dip to 44.46% in December 2023, corresponding to the quarter with the net loss, but subsequent quarters show recovery and stabilization predominantly above 50%, reflecting sustained profitability relative to shareholders' equity.
Overall Analysis
The company’s financial performance over the periods analyzed reveals significant volatility in net income, including a rare loss in late 2023, followed by a strong rebound. Shareholders’ equity shows consistent growth, enhancing the company’s financial stability. ROE, while declining from an exceptionally high initial value, remains at levels indicative of strong profitability. The patterns suggest resilience in the company’s earnings capacity and equity growth, notwithstanding short-term earnings volatility.

Return on Assets (ROA)

Eli Lilly & Co., ROA calculation (quarterly data)

Microsoft Excel
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
Selected Financial Data (US$ in thousands)
Net income (loss) 2,759,300 4,409,800 970,300 2,967,000 2,242,900 2,189,700 (57,400) 1,763,200 1,344,900 1,937,700 1,451,700 952,500 1,902,900 1,726,100 1,110,100 1,390,200 1,355,300 2,116,800 1,208,400 1,412,000 1,456,500
Total assets 89,388,800 78,714,900 75,606,900 71,874,800 63,943,500 64,006,300 57,915,500 54,814,000 53,163,000 49,489,800 47,461,500 47,063,600 46,919,300 48,806,000 48,187,000 47,809,000 46,838,300 46,633,100 43,946,000 41,967,000 41,102,800
Profitability Ratio
ROA1 12.42% 13.45% 11.07% 10.22% 9.60% 8.19% 8.61% 11.85% 10.70% 12.62% 12.71% 12.09% 13.06% 11.44% 12.39% 12.70% 13.01% 13.28%
Benchmarks
ROA, Competitors2
AbbVie Inc. 3.08% 3.17% 3.57% 3.76% 4.03% 3.61% 4.78% 6.42% 5.64% 8.53% 9.49% 8.83% 8.71% 7.88% 5.06% 4.50% 3.43% 3.07%
Amgen Inc. 6.64% 4.45% 4.65% 3.44% 4.05% 6.91% 8.36% 8.84% 8.92% 10.06% 10.73% 11.09% 9.67% 9.63% 8.63% 9.61% 11.33% 11.54%
Bristol-Myers Squibb Co. 5.86% -9.66% -7.75% -6.91% -6.21% 8.43% 9.08% 8.52% 7.75% 6.53% 6.80% 6.59% 6.07% 6.40% -4.87% -4.58% -5.53% -7.61%
Danaher Corp. 4.76% 5.03% 4.83% 5.35% 5.28% 5.64% 6.74% 7.49% 8.15% 8.55% 8.35% 7.76% 7.74% 7.73% 7.13% 7.19% 6.30% 4.79%
Gilead Sciences Inc. 10.57% 0.81% 0.23% 1.97% 0.86% 9.12% 9.42% 8.80% 9.02% 7.27% 5.33% 6.58% 7.16% 9.16% 11.02% 7.59% 0.45% 0.18%
Johnson & Johnson 11.26% 7.81% 8.24% 20.99% 22.37% 20.98% 20.85% 6.81% 6.49% 9.57% 10.94% 10.33% 11.12% 11.47% 9.98% 10.07% 8.76% 8.41%
Merck & Co. Inc. 15.14% 14.62% 10.34% 12.20% 2.18% 0.34% 4.32% 2.98% 12.09% 13.30% 14.25% 15.48% 13.29% 12.35% 7.70% 6.14% 7.73% 7.72%
Pfizer Inc. 3.79% 3.76% 1.94% -1.20% -0.14% 0.94% 4.87% 9.75% 14.85% 15.91% 15.32% 15.01% 13.58% 12.11% 11.10% 7.78% 7.01% 6.23%
Regeneron Pharmaceuticals Inc. 11.98% 11.69% 12.43% 11.98% 11.22% 11.95% 12.41% 14.02% 13.91% 14.85% 19.40% 20.90% 30.11% 31.75% 29.55% 28.88% 22.53% 20.47%
Thermo Fisher Scientific Inc. 6.58% 6.51% 6.11% 6.32% 6.21% 6.07% 6.12% 6.08% 6.36% 7.15% 7.77% 8.21% 8.20% 8.12% 11.64% 12.70% 12.02% 9.23%
Vertex Pharmaceuticals Inc. -4.32% -2.38% -2.16% -2.43% 16.81% 15.92% 15.97% 16.54% 17.18% 18.30% 19.59% 20.50% 17.19% 17.44% 17.25% 16.30% 22.80% 23.07%

Based on: 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).

1 Q1 2025 Calculation
ROA = 100 × (Net income (loss)Q1 2025 + Net income (loss)Q4 2024 + Net income (loss)Q3 2024 + Net income (loss)Q2 2024) ÷ Total assets
= 100 × (2,759,300 + 4,409,800 + 970,300 + 2,967,000) ÷ 89,388,800 = 12.42%

2 Click competitor name to see calculations.


The financial data reveals several key trends over the analyzed periods. Net income demonstrates significant fluctuations with notable volatility, showing periods of both growth and decline. After peaking around December 2020, net income experienced a sharp decrease by mid-2022, reaching a negative value in the third quarter of 2023, followed by a substantial recovery and growth through the end of the observed period. This pattern suggests episodic challenges impacting profitability, but the overall trajectory in the later periods indicates resilience and recovery in earnings performance.

Total assets show a consistent and steady upward trend throughout the examined quarters. The asset base grew from approximately $41.1 billion in the first quarter of 2020 to nearly $89.4 billion by the first quarter of 2025. This consistent increase reflects ongoing asset accumulation and potential investment in long-term resources, contributing to the company's growing capacity and possibly supporting future operational expansion.

Return on assets (ROA) fluctuates with less pronounced volatility than net income but exhibits a gradual declining trend after reaching a high point near the end of 2020. Initial values around 13% began to trend downward into the low single digits by late 2023, before recovering slightly above 12% by the most recent periods. This suggests that while asset growth has been steady, the efficiency in generating returns from those assets has experienced some deterioration but shows signs of improvement again toward the end of the data range.

Net Income Trends
Volatile with sharp decreases and recoveries; peak profitability occurred in late 2020; a notable loss appeared in the third quarter of 2023 followed by strong rebound.
Total Assets Movement
Consistent growth over time, nearly doubling from early 2020 to early 2025, indicating sustained capital investment and asset accumulation.
Return on Assets (ROA) Behavior
ROA peaked around 13% in 2020, followed by a gradual decline into 2023 before partial recovery, reflecting fluctuating efficiency in asset utilization.