Stock Analysis on Net

Eli Lilly & Co. (NYSE:LLY)

Financial Reporting Quality: Aggregate Accruals 

Microsoft Excel

Earnings can be decomposed into cash and accrual components. The accrual component (aggregate accruals) has been found to have less persistence than the cash component, and therefore (1) earnings with higher accrual component are less persistent than earnings with smaller accrual component, all else equal; and (2) the cash component of earnings should receive a higher weighting evaluating company performance.


Balance-Sheet-Based Accruals Ratio

Eli Lilly & Co., balance sheet computation of aggregate accruals

US$ in thousands

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Operating Assets
Total assets 78,714,900 64,006,300 49,489,800 48,806,000 46,633,100
Less: Cash and cash equivalents 3,268,400 2,818,600 2,067,000 3,818,500 3,657,100
Less: Short-term investments 154,800 109,100 144,800 90,100 24,200
Operating assets 75,291,700 61,078,600 47,278,000 44,897,400 42,951,800
Operating Liabilities
Total liabilities 64,443,300 53,142,600 38,714,400 39,651,200 40,807,900
Less: Short-term borrowings and current maturities of long-term debt 5,117,100 6,904,500 1,501,100 1,538,300 8,700
Less: Long-term debt, excluding current maturities 28,527,100 18,320,800 14,737,500 15,346,400 16,586,600
Operating liabilities 30,799,100 27,917,300 22,475,800 22,766,500 24,212,600
 
Net operating assets1 44,492,600 33,161,300 24,802,200 22,130,900 18,739,200
Balance-sheet-based aggregate accruals2 11,331,300 8,359,100 2,671,300 3,391,700
Financial Ratio
Balance-sheet-based accruals ratio3 29.18% 28.84% 11.38% 16.60%
Benchmarks
Balance-Sheet-Based Accruals Ratio, Competitors4
AbbVie Inc. 13.10% -22.39% -14.27% -9.69%
Amgen Inc. -10.36% 57.08% 4.07% 0.70%
Bristol-Myers Squibb Co. -3.21% -7.12% -3.86% -13.40%
Danaher Corp. -3.94% 3.48% -1.55% 16.41%
Gilead Sciences Inc. -11.79% 1.04% -2.92% -2.34%
Johnson & Johnson 10.61% -21.13% 19.84% 3.75%
Merck & Co. Inc. 6.20% 3.16% 0.46% 25.14%
Pfizer Inc. -11.48% 30.66% 24.95% -7.11%
Regeneron Pharmaceuticals Inc. 25.51% 1.17% 11.07% 43.54%
Thermo Fisher Scientific Inc. 2.28% 4.96% -1.78% 43.38%
Vertex Pharmaceuticals Inc. 42.13% 61.24% 14.07% 18.20%
Balance-Sheet-Based Accruals Ratio, Sector
Pharmaceuticals, Biotechnology & Life Sciences 1.64% 7.36% 4.84% 6.18%
Balance-Sheet-Based Accruals Ratio, Industry
Health Care 5.49% 7.80% 5.29% 5.94%

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).

1 2024 Calculation
Net operating assets = Operating assets – Operating liabilities
= 75,291,70030,799,100 = 44,492,600

2 2024 Calculation
Balance-sheet-based aggregate accruals = Net operating assets2024 – Net operating assets2023
= 44,492,60033,161,300 = 11,331,300

3 2024 Calculation
Balance-sheet-based accruals ratio = 100 × Balance-sheet-based aggregate accruals ÷ Avg. net operating assets
= 100 × 11,331,300 ÷ [(44,492,600 + 33,161,300) ÷ 2] = 29.18%

4 Click competitor name to see calculations.


Net Operating Assets
There is a consistent and significant upward trend in net operating assets over the years. Starting from approximately 22.1 billion US dollars at the end of 2021, the figure increased to 24.8 billion in 2022, then jumped substantially to 33.2 billion in 2023, and further reached about 44.5 billion by the end of 2024. This pattern suggests ongoing asset growth, indicating expansion or increased investment in operating assets over the analyzed period.
Balance-sheet-based Aggregate Accruals
The aggregate accruals have demonstrated a volatile but rising pattern. Beginning at approximately 3.4 billion US dollars in 2021, the figure decreased to around 2.7 billion in 2022 which might indicate some reduction in accruals activity or adjustments. However, the accruals sharply increased afterward, reaching about 8.4 billion in 2023 and further rising to approximately 11.3 billion in 2024. This rise points to growing accounting adjustments affecting net operating assets, which could reflect more aggressive earning management or changing business conditions.
Balance-sheet-based Accruals Ratio
The accruals ratio, representing aggregate accruals as a percentage of net operating assets, follows a consistent pattern corresponding with the accruals value changes. It decreased from 16.6% in 2021 to 11.38% in 2022, reflecting a relative reduction in accruals compared to operating assets. Subsequently, the ratio increased significantly, reaching 28.84% in 2023 and slightly rising to 29.18% in 2024. This indicates that accruals are comprising a larger portion of net operating assets over time, signaling a potential increase in financial reporting complexity or changes in accounting practices affecting asset composition.
Overall Interpretation
The data depicts a clear expansion in operating assets accompanied by a marked increase in accrual accounting components both in absolute terms and relative proportion. The decreasing ratio in 2022 followed by rapid growth implies shifting dynamics in accruals management. This trend could have implications for the quality and interpretation of financial reports, suggesting heightened attention to accrual-based earnings components in recent years.

Cash-Flow-Statement-Based Accruals Ratio

Eli Lilly & Co., cash flow statement computation of aggregate accruals

US$ in thousands

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Net income 10,590,000 5,240,400 6,244,800 5,581,700 6,193,700
Less: Net cash provided by operating activities 8,817,900 4,240,100 7,084,400 7,260,700 6,499,600
Less: Net cash used for investing activities (9,301,500) (7,152,700) (3,261,600) (2,762,300) (2,258,900)
Cash-flow-statement-based aggregate accruals 11,073,600 8,153,000 2,422,000 1,083,300 1,953,000
Financial Ratio
Cash-flow-statement-based accruals ratio1 28.52% 28.13% 10.32% 5.30%
Benchmarks
Cash-Flow-Statement-Based Accruals Ratio, Competitors2
AbbVie Inc. 10.32% -24.89% -16.25% -10.28%
Amgen Inc. -11.16% 52.47% 8.81% -12.87%
Bristol-Myers Squibb Co. -4.97% -5.99% -9.10% -12.73%
Danaher Corp. -1.25% 8.20% 1.44% 18.48%
Gilead Sciences Inc. -18.05% -0.19% -4.95% -4.86%
Johnson & Johnson 10.58% 13.66% 10.78% 8.23%
Merck & Co. Inc. 5.00% 2.23% 0.61% 29.09%
Pfizer Inc. -5.24% 19.96% 18.46% 13.18%
Regeneron Pharmaceuticals Inc. 12.04% 14.35% 18.61% 49.24%
Thermo Fisher Scientific Inc. 4.71% 3.80% -0.06% 34.69%
Vertex Pharmaceuticals Inc. 43.34% 62.03% -14.45% 1.38%
Cash-Flow-Statement-Based Accruals Ratio, Sector
Pharmaceuticals, Biotechnology & Life Sciences 2.07% 9.68% 2.52% 8.19%
Cash-Flow-Statement-Based Accruals Ratio, Industry
Health Care 4.00% 8.59% 4.25% 7.53%

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).

1 2024 Calculation
Cash-flow-statement-based accruals ratio = 100 × Cash-flow-statement-based aggregate accruals ÷ Avg. net operating assets
= 100 × 11,073,600 ÷ [(44,492,600 + 33,161,300) ÷ 2] = 28.52%

2 Click competitor name to see calculations.


Net Operating Assets
The net operating assets have demonstrated a consistent and substantial increase over the four-year period. Starting at approximately 22.13 billion US dollars in 2021, the figure rose to about 24.80 billion in 2022, followed by a more pronounced growth to 33.16 billion in 2023. By 2024, net operating assets reached 44.49 billion US dollars, indicating significant expansion in the operational capital base.
Cash-Flow-Statement-Based Aggregate Accruals
Aggregate accruals have shown a marked upward trend. The values increased more than twofold from 1.08 billion US dollars in 2021 to 2.42 billion in 2022. Thereafter, there was a sharp rise to 8.15 billion in 2023, followed by a further increase to 11.07 billion US dollars in 2024. This pattern signals growing accrual accounting activity, which could affect earnings quality and operational cash flow comparability.
Cash-Flow-Statement-Based Accruals Ratio
The accruals ratio exhibits a pronounced and continuous increase, reflecting the relative size of aggregate accruals to net operating assets. Beginning at 5.3% in 2021, the ratio nearly doubled to 10.32% in 2022. This upward trajectory accelerated in the subsequent years, reaching 28.13% in 2023 and slightly rising to 28.52% in 2024. The elevated accruals ratio may suggest increasing reliance on accrual-based measures, which warrants careful evaluation for potential earnings management or shifts in financial reporting policies.