Stock Analysis on Net

Eli Lilly & Co. (NYSE:LLY)

Enterprise Value to FCFF (EV/FCFF) 

Microsoft Excel

Free Cash Flow to The Firm (FCFF)

Eli Lilly & Co., FCFF calculation

US$ in thousands

Microsoft Excel
12 months ended: 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
Net noncash charges 3,612,900 2,054,700 854,100 2,701,600 1,053,300
Other changes in operating assets and liabilities, net of acquisitions and divestitures (5,385,000) (3,055,000) (14,500) (1,022,600) (747,400)
Net cash provided by operating activities 8,817,900 4,240,100 7,084,400 7,260,700 6,499,600
Cash payments for interest on borrowings, net of tax1 482,270 323,158 296,995 306,498 296,247
Purchases of property and equipment (5,057,800) (3,447,600) (1,854,300) (1,309,800) (1,387,900)
Free cash flow to the firm (FCFF) 4,242,370 1,115,658 5,527,095 6,257,398 5,407,947

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


Net cash provided by operating activities
Over the five-year period, net cash provided by operating activities exhibited fluctuations with an overall upward trend. Starting at 6,499,600 thousand US dollars in 2020, it increased to a peak of 7,260,700 thousand US dollars in 2021. A slight decline followed in 2022, with cash flow dropping to 7,084,400 thousand US dollars. In 2023, there was a significant decrease to 4,240,100 thousand US dollars, representing a notable reduction in operating cash flow. However, the figure rebounded sharply in 2024, reaching 8,817,900 thousand US dollars, the highest level in the analyzed period.
Free cash flow to the firm (FCFF)
The free cash flow to the firm also showed variability but with a less consistent pattern compared to operating cash flow. It started at 5,407,947 thousand US dollars in 2020 and grew steadily to 6,257,398 thousand US dollars in 2021. The subsequent year saw a decline to 5,527,095 thousand US dollars. In 2023, FCFF dropped significantly to a low of 1,115,658 thousand US dollars, pointing to decreased free cash generation capacity. In 2024, there was a recovery to 4,242,370 thousand US dollars, though the value remained below that of earlier years, indicating partial restoration of free cash flow levels.
Overall Observations
Both key cash flow metrics demonstrated resilience with intermittent lows, particularly in 2023 where sharp declines were observed. Despite these dips, 2024 showed recovery trends, more pronounced in net operating cash flows than in FCFF. The divergence in the magnitude of recovery may reflect variations in capital expenditures, working capital requirements, or other investing activities during these periods. Continuous monitoring of these cash flows is advisable to understand the underlying drivers of volatility and to assess sustainability of cash flow generation.

Interest Paid, Net of Tax

Eli Lilly & Co., interest paid, net of tax calculation

US$ in thousands

Microsoft Excel
12 months ended: Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Effective Income Tax Rate (EITR)
EITR1 16.49% 20.05% 8.25% 9.32% 14.33%
Interest Paid, Net of Tax
Cash payments for interest on borrowings, before tax 577,500 404,200 323,700 338,000 345,800
Less: Cash payments for interest on borrowings, tax2 95,230 81,042 26,705 31,502 49,553
Cash payments for interest on borrowings, net of tax 482,270 323,158 296,995 306,498 296,247

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 See details »

2 2024 Calculation
Cash payments for interest on borrowings, tax = Cash payments for interest on borrowings × EITR
= 577,500 × 16.49% = 95,230


Effective Income Tax Rate (EITR)
The effective income tax rate demonstrated a decreasing trend from 14.33% in 2020 to a low of 8.25% in 2022, indicating a reduction in tax expense relative to income during this period. However, this trend reversed in 2023, with the rate increasing significantly to 20.05%, followed by a decrease to 16.49% in 2024. Overall, the tax rate exhibits some volatility with a notable spike in 2023.
Cash Payments for Interest on Borrowings, Net of Tax
Cash payments for interest on borrowings, net of tax, showed a generally upward trajectory over the five-year period. Beginning at $296,247 thousand in 2020, there was a slight increase in 2021 to $306,498 thousand, followed by a small decline in 2022 to $296,995 thousand. From 2022 onwards, the payments increased more substantially, reaching $323,158 thousand in 2023 and then rising sharply to $482,270 thousand in 2024. This increase suggests growing interest expenses, potentially reflecting higher debt levels or rising interest rates.

Enterprise Value to FCFF Ratio, Current

Eli Lilly & Co., current EV/FCFF calculation, comparison to benchmarks

Microsoft Excel
Selected Financial Data (US$ in thousands)
Enterprise value (EV) 762,776,948
Free cash flow to the firm (FCFF) 4,242,370
Valuation Ratio
EV/FCFF 179.80
Benchmarks
EV/FCFF, Competitors1
AbbVie Inc. 19.60
Amgen Inc. 15.44
Bristol-Myers Squibb Co. 8.69
Danaher Corp. 27.90
Gilead Sciences Inc. 14.20
Johnson & Johnson 17.92
Merck & Co. Inc. 11.80
Pfizer Inc. 14.98
Regeneron Pharmaceuticals Inc. 13.87
Thermo Fisher Scientific Inc. 21.00
Vertex Pharmaceuticals Inc.
EV/FCFF, Sector
Pharmaceuticals, Biotechnology & Life Sciences 21.88
EV/FCFF, Industry
Health Care 21.55

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

1 Click competitor name to see calculations.

If the company EV/FCFF is lower then the EV/FCFF of benchmark then company is relatively undervalued.
Otherwise, if the company EV/FCFF is higher then the EV/FCFF of benchmark then company is relatively overvalued.


Enterprise Value to FCFF Ratio, Historical

Eli Lilly & Co., historical EV/FCFF calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in thousands)
Enterprise value (EV)1 852,411,298 731,126,566 326,866,344 240,105,544 210,974,169
Free cash flow to the firm (FCFF)2 4,242,370 1,115,658 5,527,095 6,257,398 5,407,947
Valuation Ratio
EV/FCFF3 200.93 655.33 59.14 38.37 39.01
Benchmarks
EV/FCFF, Competitors4
AbbVie Inc. 20.05 14.89 12.15 13.18 13.95
Amgen Inc. 15.35 22.22 16.01 15.82 14.51
Bristol-Myers Squibb Co. 9.94 9.14 13.87 10.52 11.63
Danaher Corp. 28.93 36.34 25.74 28.25 30.66
Gilead Sciences Inc. 14.50 13.41 13.58 8.42 13.60
Johnson & Johnson 18.16 19.30 23.80 21.25 20.75
Merck & Co. Inc. 13.24 37.84 19.09 23.27 34.12
Pfizer Inc. 15.33 32.24 9.15 8.40 21.74
Regeneron Pharmaceuticals Inc. 19.30 23.99 17.96 9.81 25.74
Thermo Fisher Scientific Inc. 26.13 28.85 31.61 33.14 26.14
Vertex Pharmaceuticals Inc. 29.45 16.68 22.47 16.00
EV/FCFF, Sector
Pharmaceuticals, Biotechnology & Life Sciences 23.57 27.24 17.95 16.12 19.74
EV/FCFF, Industry
Health Care 23.63 24.95 17.94 17.18 18.55

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 See details »

2 See details »

3 2024 Calculation
EV/FCFF = EV ÷ FCFF
= 852,411,298 ÷ 4,242,370 = 200.93

4 Click competitor name to see calculations.


The financial data exhibits significant fluctuations across the analyzed periods. A notable upward trend is observed in the enterprise value (EV), which more than quadrupled from approximately 211 billion US dollars in 2020 to over 852 billion US dollars by the end of 2024. This rapid increase is especially pronounced between 2022 and 2023, where the EV more than doubled.

Conversely, the free cash flow to the firm (FCFF) does not follow a consistent upward trajectory. After peaking at around 6.26 billion US dollars in 2021, the FCFF declined in 2022 to approximately 5.53 billion US dollars. This decline is followed by a steep drop in 2023 to about 1.12 billion US dollars, partially recovering to 4.24 billion US dollars in 2024. The variability in FCFF suggests fluctuations in operational cash generation or changes in investment and financing activities that affect free cash flow.

The EV/FCFF ratio, an indicator of valuation relative to cash flow generation, reflects these divergent trends sharply. Initially stable around 39 in 2020 and 2021, it escalated dramatically to approximately 59 in 2022, then surged to an extraordinary 655 in 2023 before settling at about 201 in 2024. The extreme spike in 2023 indicates a substantial disconnect between enterprise value and free cash flow, likely signaling elevated market expectations, asset revaluations, or temporary operational challenges.

Enterprise Value (EV)
Exhibits a consistent and steep upward trend, increasing more than fourfold over five years, with a pronounced spike between 2022 and 2023.
Free Cash Flow to the Firm (FCFF)
Shows volatility with an initial increase, followed by a decline and partial recovery, indicating possible fluctuations in cash-generating efficiency or investment activities.
EV/FCFF Ratio
Displays marked volatility, remaining stable initially but then sharply increasing, peaking in 2023, which suggests a significant change in valuation relative to cash flow during this period.

Overall, the data points to a rapidly increasing enterprise valuation accompanied by unstable cash flow performance, resulting in elevated valuation multiples that may warrant closer examination of underlying drivers and potential risks.