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, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Operating Assets
Total assets 64,006,300 49,489,800 48,806,000 46,633,100 39,286,100
Less: Cash and cash equivalents 2,818,600 2,067,000 3,818,500 3,657,100 2,337,500
Less: Short-term investments 109,100 144,800 90,100 24,200 101,000
Operating assets 61,078,600 47,278,000 44,897,400 42,951,800 36,847,600
Operating Liabilities
Total liabilities 53,142,600 38,714,400 39,651,200 40,807,900 36,587,000
Less: Short-term borrowings and current maturities of long-term debt 6,904,500 1,501,100 1,538,300 8,700 1,499,300
Less: Long-term debt, excluding current maturities 18,320,800 14,737,500 15,346,400 16,586,600 13,817,900
Operating liabilities 27,917,300 22,475,800 22,766,500 24,212,600 21,269,800
 
Net operating assets1 33,161,300 24,802,200 22,130,900 18,739,200 15,577,800
Balance-sheet-based aggregate accruals2 8,359,100 2,671,300 3,391,700 3,161,400
Financial Ratio
Balance-sheet-based accruals ratio3 28.84% 11.38% 16.60% 18.42%
Benchmarks
Balance-Sheet-Based Accruals Ratio, Competitors4
AbbVie Inc. -22.39% -14.27% -9.69% 131.82%
Amgen Inc. 57.08% 4.07% 0.70% 3.47%
Bristol-Myers Squibb Co. -7.12% -3.86% -13.40% -13.24%
Gilead Sciences Inc. 1.04% -2.92% -2.34% 59.36%
Johnson & Johnson -21.13% 19.84% 3.75% 7.76%
Merck & Co. Inc. 3.16% 0.46% 25.14% 15.90%
Pfizer Inc. 30.66% 24.95% -7.11% -14.91%
Regeneron Pharmaceuticals Inc. 1.17% 11.07% 43.54% 16.50%
Thermo Fisher Scientific Inc. 4.97% -1.78% 43.38% 1.98%
Balance-Sheet-Based Accruals Ratio, Sector
Pharmaceuticals, Biotechnology & Life Sciences 7.31% 5.51% 4.99% 17.76%
Balance-Sheet-Based Accruals Ratio, Industry
Health Care 7.76% 2.32% 5.47% 10.63%

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

1 2023 Calculation
Net operating assets = Operating assets – Operating liabilities
= 61,078,60027,917,300 = 33,161,300

2 2023 Calculation
Balance-sheet-based aggregate accruals = Net operating assets2023 – Net operating assets2022
= 33,161,30024,802,200 = 8,359,100

3 2023 Calculation
Balance-sheet-based accruals ratio = 100 × Balance-sheet-based aggregate accruals ÷ Avg. net operating assets
= 100 × 8,359,100 ÷ [(33,161,300 + 24,802,200) ÷ 2] = 28.84%

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 2022 to 2023.

Cash-Flow-Statement-Based Accruals Ratio

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

US$ in thousands

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Net income 5,240,400 6,244,800 5,581,700 6,193,700 8,318,400
Less: Net cash provided by operating activities 4,240,100 7,084,400 7,260,700 6,499,600 4,836,600
Less: Net cash used for investing activities (7,152,700) (3,261,600) (2,762,300) (2,258,900) (8,082,900)
Cash-flow-statement-based aggregate accruals 8,153,000 2,422,000 1,083,300 1,953,000 11,564,700
Financial Ratio
Cash-flow-statement-based accruals ratio1 28.13% 10.32% 5.30% 11.38%
Benchmarks
Cash-Flow-Statement-Based Accruals Ratio, Competitors2
AbbVie Inc. -24.89% -16.25% -10.28% 44.98%
Amgen Inc. 52.47% 8.81% -12.87% 6.95%
Bristol-Myers Squibb Co. -5.99% -9.10% -12.73% -15.67%
Gilead Sciences Inc. -0.19% -4.95% -4.86% 20.18%
Johnson & Johnson 13.66% 10.78% 8.23% 17.00%
Merck & Co. Inc. 2.23% 0.61% 29.09% 13.75%
Pfizer Inc. 19.96% 18.46% 13.18% 3.27%
Regeneron Pharmaceuticals Inc. 14.35% 18.61% 49.24% 10.32%
Thermo Fisher Scientific Inc. 3.80% -0.06% 34.69% -0.89%
Cash-Flow-Statement-Based Accruals Ratio, Sector
Pharmaceuticals, Biotechnology & Life Sciences 9.39% 2.74% 7.09% 9.34%
Cash-Flow-Statement-Based Accruals Ratio, Industry
Health Care 8.32% 2.34% 6.45% 6.66%

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

1 2023 Calculation
Cash-flow-statement-based accruals ratio = 100 × Cash-flow-statement-based aggregate accruals ÷ Avg. net operating assets
= 100 × 8,153,000 ÷ [(33,161,300 + 24,802,200) ÷ 2] = 28.13%

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 2022 to 2023.