Stock Analysis on Net

Eli Lilly & Co. (NYSE:LLY)

Analysis of Debt

Microsoft Excel

Total Debt (Carrying Amount)

Eli Lilly & Co., balance sheet: debt

US$ in thousands

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Short-term borrowings and current maturities of long-term debt 6,904,500 1,501,100 1,538,300 8,700 1,499,300
Long-term debt, excluding current maturities 18,320,800 14,737,500 15,346,400 16,586,600 13,817,900
Total debt (carrying amount) 25,225,300 16,238,600 16,884,700 16,595,300 15,317,200

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

Debt item Description The company
Total debt (carrying amount) Sum of the carrying values as of the balance sheet date of all debt plus capital lease obligations. Eli Lilly & Co. total debt decreased from 2021 to 2022 but then increased from 2022 to 2023 exceeding 2021 level.

Total Debt (Fair Value)

Microsoft Excel
Dec 31, 2023
Selected Financial Data (US$ in thousands)
Short-term commercial paper borrowings 6,166,400
Long-term debt, including current portion 17,221,700
Total debt (fair value) 23,388,100
Financial Ratio
Debt, fair value to carrying amount ratio 0.93

Based on: 10-K (reporting date: 2023-12-31).


Weighted-average Interest Rate on Debt

Weighted-average effective borrowing rate: 3.58%

Interest rate Debt amount1 Interest rate × Debt amount Weighted-average interest rate2
5.39% 6,189,400 333,609
0.15% 714,600 1,072
7.13% 217,500 15,497
2.75% 560,600 15,417
5.00% 750,000 37,500
1.63% 830,700 13,499
5.50% 364,300 20,037
3.10% 401,500 12,447
0.45% 476,400 2,144
3.38% 930,600 31,408
0.42% 162,500 683
2.13% 830,700 17,652
0.63% 664,600 4,154
4.70% 1,000,000 47,000
0.50% 664,600 3,323
0.56% 65,800 368
6.77% 158,600 10,737
5.55% 444,700 24,681
5.95% 266,800 15,875
3.88% 240,300 9,312
1.63% 318,500 5,176
4.65% 38,300 1,781
3.70% 386,800 14,312
3.95% 347,000 13,707
3.95% 958,200 37,849
1.70% 1,107,600 18,829
0.97% 54,200 526
2.25% 1,250,000 28,125
1.13% 553,800 6,230
4.88% 1,250,000 60,938
4.15% 591,300 24,539
2.50% 850,000 21,250
1.38% 775,300 10,660
4.95% 1,000,000 49,500
Total 25,415,200 909,832
3.58%

Based on: 10-K (reporting date: 2023-12-31).

1 US$ in thousands

2 Weighted-average interest rate = 100 × 909,832 ÷ 25,415,200 = 3.58%