Stock Analysis on Net

Eli Lilly & Co. (NYSE:LLY)

Adjustments to Financial Statements

Microsoft Excel

Adjustments to Current Assets

Eli Lilly & Co., adjusted current assets

US$ in thousands

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
As Reported
Current assets 32,739,700 25,727,000 18,034,500 18,452,400 17,462,100
Adjustments
Add: Allowances 14,900 14,800 16,000 22,500 25,900
Add: LIFO reserve1 (62,900) (102,400) (8,900) (34,200) (34,800)
After Adjustment
Adjusted current assets 32,691,700 25,639,400 18,041,600 18,440,700 17,453,200

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 LIFO reserve. See details »


Adjustments to Total Assets

Eli Lilly & Co., adjusted total assets

US$ in thousands

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
As Reported
Total assets 78,714,900 64,006,300 49,489,800 48,806,000 46,633,100
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1
Add: Allowances 14,900 14,800 16,000 22,500 25,900
Add: LIFO reserve2 (62,900) (102,400) (8,900) (34,200) (34,800)
Less: Deferred tax assets3 8,000,600 5,477,300 2,792,900 2,489,300 2,830,400
After Adjustment
Adjusted total assets 70,666,300 58,441,400 46,704,000 46,305,000 43,793,800

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 Operating lease right-of-use asset (before adoption of FASB Topic 842). See details »

2 LIFO reserve. See details »

3 Deferred tax assets. See details »


Adjustments to Total Liabilities

Eli Lilly & Co., adjusted total liabilities

US$ in thousands

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
As Reported
Total liabilities 64,443,300 53,142,600 38,714,400 39,651,200 40,807,900
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)1
Less: Deferred tax liabilities2 73,900 103,900 87,300 1,733,700 2,099,900
After Adjustment
Adjusted total liabilities 64,369,400 53,038,700 38,627,100 37,917,500 38,708,000

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 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Deferred tax liabilities. See details »


Adjustments to Stockholders’ Equity

Eli Lilly & Co., adjusted total Eli Lilly and Company shareholders’ equity

US$ in thousands

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
As Reported
Total Eli Lilly and Company shareholders’ equity 14,192,100 10,771,900 10,649,800 8,979,200 5,641,600
Adjustments
Less: Deferred tax assets (liabilities), net1 7,926,700 5,373,400 2,705,700 755,900 730,500
Add: Allowances 14,900 14,800 16,000 22,500 25,900
Add: LIFO reserve2 (62,900) (102,400) (8,900) (34,200) (34,800)
Add: Noncontrolling interests 79,500 91,800 125,600 175,600 183,600
After Adjustment
Adjusted total equity 6,296,900 5,402,700 8,076,800 8,387,200 5,085,800

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 Deferred tax assets (liabilities), net. See details »

2 LIFO reserve. See details »


Adjustments to Capitalization Table

Eli Lilly & Co., adjusted capitalization table

US$ in thousands

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
As Reported
Short-term borrowings and current maturities of long-term debt 5,117,100 6,904,500 1,501,100 1,538,300 8,700
Long-term debt, excluding current maturities 28,527,100 18,320,800 14,737,500 15,346,400 16,586,600
Total reported debt 33,644,200 25,225,300 16,238,600 16,884,700 16,595,300
Total Eli Lilly and Company shareholders’ equity 14,192,100 10,771,900 10,649,800 8,979,200 5,641,600
Total reported capital 47,836,300 35,997,200 26,888,400 25,863,900 22,236,900
Adjustments to Debt
Add: Operating lease liability (before adoption of FASB Topic 842)1
Add: Operating lease liabilities, current portion (included in Other current liabilities)2 175,700 156,300 154,200 148,400 150,900
Add: Operating lease liabilities, noncurrent portion (included in Other noncurrent liabilities)3 970,900 948,500 574,000 537,300 512,800
Adjusted total debt 34,790,800 26,330,100 16,966,800 17,570,400 17,259,000
Adjustments to Equity
Less: Deferred tax assets (liabilities), net4 7,926,700 5,373,400 2,705,700 755,900 730,500
Add: Allowances 14,900 14,800 16,000 22,500 25,900
Add: LIFO reserve5 (62,900) (102,400) (8,900) (34,200) (34,800)
Add: Noncontrolling interests 79,500 91,800 125,600 175,600 183,600
Adjusted total equity 6,296,900 5,402,700 8,076,800 8,387,200 5,085,800
After Adjustment
Adjusted total capital 41,087,700 31,732,800 25,043,600 25,957,600 22,344,800

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 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Operating lease liabilities, current portion (included in Other current liabilities). See details »

3 Operating lease liabilities, noncurrent portion (included in Other noncurrent liabilities). See details »

4 Deferred tax assets (liabilities), net. See details »

5 LIFO reserve. See details »


Adjustments to Reported Income

Eli Lilly & Co., adjusted net income

US$ in thousands

Microsoft Excel
12 months ended: Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
As Reported
Net income 10,590,000 5,240,400 6,244,800 5,581,700 6,193,700
Adjustments
Add: Deferred income tax expense (benefit)1 (2,683,100) (2,341,000) (2,185,200) (802,300) (134,500)
Add: Increase (decrease) in allowances 100 (1,200) (6,500) (3,400) 3,500
Add: Increase (decrease) in LIFO reserve2 39,500 (93,500) 25,300 600 16,400
Add: Other comprehensive income (loss), net of tax 5,100 (482,400) 498,500 2,153,300 27,200
After Adjustment
Adjusted net income 7,951,600 2,322,300 4,576,900 6,929,900 6,106,300

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 Deferred income tax expense (benefit). See details »

2 Increase (decrease) in LIFO reserve. See details »