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. -7.12% -3.86% -13.40% -13.24%
Danaher Corp. 3.48% -1.55% 16.41% 52.50%
Gilead Sciences Inc. 1.04% -2.92% -2.34% 59.36%
Johnson & Johnson 10.61% -21.13% 19.84% 3.75%
Merck & Co. Inc. 3.16% 0.46% 25.14% 15.90%
Pfizer Inc. 30.66% 24.95% -7.11% -14.91%
Regeneron Pharmaceuticals Inc. 25.51% 1.17% 11.07% 43.54%
Thermo Fisher Scientific Inc. 4.97% -1.78% 43.38% 1.98%
Vertex Pharmaceuticals Inc. 61.24% 14.07% 18.20% -8.97%
Balance-Sheet-Based Accruals Ratio, Sector
Pharmaceuticals, Biotechnology & Life Sciences 0.00% 7.36% 4.84% 6.18%
Balance-Sheet-Based Accruals Ratio, Industry
Health Care 0.00% 8.13% 2.80% 4.68%

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.

Financial ratio Description The company
Balance-sheet-based accruals ratio Ratio is found by dividing balance-sheet-based aggregate accruals by average net operating assets. Using the balance-sheet-based accruals ratio, Eli Lilly & Co. deteriorated earnings quality from 2023 to 2024.

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. -5.99% -9.10% -12.73% -15.67%
Danaher Corp. 8.20% 1.44% 18.48% 42.90%
Gilead Sciences Inc. -0.19% -4.95% -4.86% 20.18%
Johnson & Johnson 10.58% 13.66% 10.78% 8.23%
Merck & Co. Inc. 2.23% 0.61% 29.09% 13.75%
Pfizer Inc. 19.96% 18.46% 13.18% 3.27%
Regeneron Pharmaceuticals Inc. 12.04% 14.35% 18.61% 49.24%
Thermo Fisher Scientific Inc. 3.80% -0.06% 34.69% -0.89%
Vertex Pharmaceuticals Inc. 62.03% -14.45% 1.38% -23.47%
Cash-Flow-Statement-Based Accruals Ratio, Sector
Pharmaceuticals, Biotechnology & Life Sciences 0.00% 9.68% 2.52% 8.19%
Cash-Flow-Statement-Based Accruals Ratio, Industry
Health Care 0.00% 8.44% 2.38% 5.78%

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.

Financial ratio Description The company
Cash-flow-statement-based accruals ratio Ratio is found by dividing cash-flow-statement-based aggregate accruals by average net operating assets. Using the cash-flow-statement-based accruals ratio, Eli Lilly & Co. deteriorated earnings quality from 2023 to 2024.