Stock Analysis on Net

Eli Lilly & Co. (NYSE:LLY)

Selected Financial Data 
since 2005

Microsoft Excel

Income Statement

Eli Lilly & Co., selected items from income statement, long-term trends

US$ in thousands

Microsoft Excel

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31), 10-K (reporting date: 2011-12-31), 10-K (reporting date: 2010-12-31), 10-K (reporting date: 2009-12-31), 10-K (reporting date: 2008-12-31), 10-K (reporting date: 2007-12-31), 10-K (reporting date: 2006-12-31), 10-K (reporting date: 2005-12-31).


The revenue exhibited an overall upward trajectory from 2005 through 2024, increasing from approximately $14.6 billion to $45 billion, reflecting a significant long-term growth of over threefold. However, there were some fluctuations within this period. Notably, revenue peaked in 2011 at about $24.3 billion before experiencing a decline in 2012 and 2013. Another decrease appeared in 2014 with revenue dropping to roughly $19.6 billion, followed by a period of recovery and steady increase in subsequent years. From 2016 onward, revenue consistently increased with an especially sharp rise observed in the last two years, reaching the highest point in 2024.

In terms of net income, the company showed generally positive profitability with considerable volatility. Starting at nearly $2 billion in 2005, net income increased to its initial peak of approximately $3 billion by 2007. A notable deviation occurred in 2008 when the company recorded a net loss of around $2 billion, marking a significant financial setback. Profitability quickly rebounded in 2009, reaching the highest net income to date within the observed range at about $4.3 billion, followed by peaks and troughs throughout the subsequent years.

From 2010 to 2017, net income displayed fluctuations but generally remained positive, with occasional dips such as the loss in 2017, which deviated from the trend with a recorded net loss of approximately $204 million. After that, net income resumed growth, seeing a substantial increase in 2019 with approximately $8.3 billion, followed by a decline in 2020 and 2021 to around $6.2 billion and $5.6 billion respectively. Despite this dip, profitability improved again in 2022 and 2023, culminating in a markedly strong net income of about $10.6 billion in 2024.

The data reveals periods of both strong growth and challenges, characterized by transient losses and recovery phases. The overall pattern demonstrates the company’s ability to regain profitability after downturns and maintain a strong revenue growth momentum, particularly evident in the recent years where both revenue and net income have reached record highs.


Balance Sheet: Assets

Eli Lilly & Co., selected items from assets, long-term trends

US$ in thousands

Microsoft Excel

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31), 10-K (reporting date: 2011-12-31), 10-K (reporting date: 2010-12-31), 10-K (reporting date: 2009-12-31), 10-K (reporting date: 2008-12-31), 10-K (reporting date: 2007-12-31), 10-K (reporting date: 2006-12-31), 10-K (reporting date: 2005-12-31).


The analysis of the financial data reveals significant fluctuations and overall growth trends in the company's asset structure over the period from 2005 to 2024.

Current Assets
Current assets initially decreased from approximately 10.8 billion US dollars in 2005 to about 9.7 billion in 2006. This was followed by a general upward trend, reaching a peak near 20.5 billion by the end of 2018. There was a notable dip in 2019 to around 13.7 billion, but values recovered strongly in subsequent years, culminating in a substantial increase to approximately 32.7 billion by 2024. This indicates a significant strengthening in liquidity or short-term asset holdings over the long term, despite some intermittent volatility.
Total Assets
Total assets exhibited an overall upward trajectory beginning at roughly 24.6 billion in 2005, despite some short-term declines such as in 2006 and again around 2009. From 2010 onward, a steady increase is evident, with total assets crossing the 40 billion mark in 2016 and continuing to grow to an estimated 78.7 billion by 2024. The growth trend highlights continuous asset accumulation and expansion in the company's asset base, reinforcing an ability to support larger operational scale or investment capacity over time.
Comparative Insights
The ratio of current assets to total assets suggests variability in asset composition. While both categories increased, current assets' growth outpaced total assets notably after 2018. This may imply a strategic shift towards more liquid or short-term assets or could indicate changes in working capital management or operating cycle dynamics. The sharp rises in recent years, particularly from 2022 onwards, could reflect enhanced asset acquisition, revaluation, or improved operational earnings reinvestment.
Overall Observations
The data portrays a positive long-term evolution in asset size, with periods of adjustment likely reflecting economic, operational, or strategic factors influencing asset holdings. The pronounced increase in asset values towards the end of the timeline signals robust growth and possibly improved financial strength and market positioning.

Balance Sheet: Liabilities and Stockholders’ Equity

Eli Lilly & Co., selected items from liabilities and stockholders’ equity, long-term trends

US$ in thousands

Microsoft Excel

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31), 10-K (reporting date: 2011-12-31), 10-K (reporting date: 2010-12-31), 10-K (reporting date: 2009-12-31), 10-K (reporting date: 2008-12-31), 10-K (reporting date: 2007-12-31), 10-K (reporting date: 2006-12-31), 10-K (reporting date: 2005-12-31).


Liabilities Overview

Current liabilities demonstrated significant volatility over the period analyzed. They increased sharply in 2008, more than doubling from the previous year, followed by fluctuations with a general upward trend from 2011 onward. Notably, there was a steep rise in the later years, from 17.1 billion in 2022 to 27.3 billion in 2023 and slightly higher in 2024.

Total liabilities followed a broadly increasing pattern, with a marked jump in 2008, peaking at 33.3 billion in 2017. This was followed by some decline and stabilization before rising sharply again to 64.4 billion by 2024. The growth in total liabilities in later years notably outpaces the earlier periods, indicating a significant increase in the company's obligations.

Total Debt

Total debt exhibited volatility with two distinct peaks. Initially, after a decrease from 6.5 billion in 2005 to 3.7 billion in 2006, it surged again to over 10 billion in 2008. Following fluctuations, it rose substantially from 13.6 billion in 2017 to a notable 25.2 billion in 2023 and further increased to 33.6 billion in 2024. This trend of rising debt levels in recent years demonstrates enhanced leverage or increased borrowing activities by the company.

Shareholders’ Equity

Shareholders’ equity experienced notable fluctuations and a generally less stable trajectory compared to liabilities and debt. After growing from approximately 10.8 billion in 2005 to a peak of around 17.6 billion in 2013, equity dropped sharply to 2.6 billion by 2019. Subsequently, equity recovered moderately to about 14.2 billion in 2024. The sharp decline and subsequent recovery could reflect changes in retained earnings, capital structure adjustments, or other equity-related factors within the company.

Overall Financial Structure Insights

The company’s financial structure shows increased leverage over time, especially post-2017, as seen by rising total debt and total liabilities. While shareholders’ equity has partially recovered after a significant dip around 2019, it remains lower than the peak levels seen earlier in the period. The increasing liabilities and debt levels accompanied by fluctuating equity imply a shift in the funding mix towards more debt financing in recent years, which may impact financial risk and capital costs.

The patterns suggest strategic financing activities, potential investments, or operational funding needs driving changes in liabilities and debt. Close monitoring of debt servicing capabilities and equity base is advisable given the elevated leverage.


Cash Flow Statement

Eli Lilly & Co., selected items from cash flow statement, long-term trends

US$ in thousands

Microsoft Excel

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31), 10-K (reporting date: 2011-12-31), 10-K (reporting date: 2010-12-31), 10-K (reporting date: 2009-12-31), 10-K (reporting date: 2008-12-31), 10-K (reporting date: 2007-12-31), 10-K (reporting date: 2006-12-31), 10-K (reporting date: 2005-12-31).


The analysis of the annual cash flow data reveals notable fluctuations and trends across operating, investing, and financing activities over the observed period.

Operating Activities
The net cash provided by operating activities exhibited considerable volatility, starting at approximately 1,913,600 thousand US dollars at the beginning of the period and reaching a peak of about 7,295,600 thousand in 2008. Following this high point, a downward trend persisted until 2015, with the lowest value around 2,772,800 thousand US dollars. Subsequently, operating cash flow showed a recovery pattern, reaching a secondary peak near 7,260,700 thousand in 2021 before declining again in the last years observed. Overall, despite fluctuations, the operating cash flow generally maintained positive values, signifying ongoing cash inflows from core business operations.
Investing Activities
The net cash flow associated with investing activities was predominantly negative throughout the period, indicating consistent investment outflows. There were exceptions, notably in 2006 and 2018, where positive cash inflows of 608,400 and 1,906,000 thousand US dollars respectively were recorded. The largest investment outflows occurred in 2019 and 2024, with values near -8,082,900 and -9,301,500 thousand US dollars, suggesting substantial capital expenditures or acquisitions during these years. Generally, this pattern indicates sustained investment activity with significant cash usage.
Financing Activities
Cash flows from financing activities demonstrated significant variability, starting with negative values in most years, which reflect cash outflows likely related to debt repayments, share repurchases, or dividend payments. Notable positive inflows were observed in 2008, 2017, 2023, and 2024, with cash inflows of 2,346,000, 142,600, 3,495,600, and 1,230,100 thousand US dollars respectively, indicating episodes of raising capital via debt or equity issuance. The largest outflows occurred in 2009 and 2018 with values approximately -5,533,700 and -5,904,900 thousand US dollars respectively, suggesting significant repayments or distributions during those years. The overall pattern reflects active capital structuring with periods of both financing outflows and inflows.

Per Share Data

Eli Lilly & Co., selected data per share, long-term trends

US$

Microsoft Excel

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31), 10-K (reporting date: 2011-12-31), 10-K (reporting date: 2010-12-31), 10-K (reporting date: 2009-12-31), 10-K (reporting date: 2008-12-31), 10-K (reporting date: 2007-12-31), 10-K (reporting date: 2006-12-31), 10-K (reporting date: 2005-12-31).

1, 2, 3 Data adjusted for splits and stock dividends.


The analysis of the annual financial data reveals several noteworthy trends in the earnings and dividend performance over the examined periods.

Basic and Diluted Earnings Per Share (EPS)
Both basic and diluted EPS exhibit a largely similar pattern, showing a general upward trend from 2005 through 2024 with notable fluctuations. Initial EPS values increased from approximately 1.82 US$ in 2005 to a peak of 4.58 US$ in 2010. However, 2008 and 2017 showed negative EPS values (-1.89 US$ and -0.19 US$, respectively), indicating periods of financial loss or extraordinary expenses. The years following 2017 demonstrate a strong recovery and growth, highlighted by a significant increase reaching 11.76 US$ in 2024. This pattern suggests volatility in certain years, but overall strong growth in earnings performance.
Dividend Per Share
Dividends per share display consistent growth throughout the entire period. Starting at 1.54 US$ in 2005, dividends increased steadily almost every year, reaching 5.40 US$ by 2024. The dividend increments are particularly smooth and stable, without any declines or irregular drops, indicating a commitment to returning value to shareholders through dividends despite fluctuations in earnings.

In summary, the EPS data indicates periodic challenges with temporary losses but a marked recovery and substantial growth in the most recent years. In contrast, the dividend policy appears conservative and progressively increasing, reflecting confidence in ongoing profitability and long-term shareholder value creation. The divergence between volatility in earnings and steady dividend increases may imply strong cash flow management and a strategic approach to shareholder distributions.