Using an unlevered Free Cash Flow to Firm (FCFF) model, we project Eli Lilly and Company's cash flows over 5 years with line-by-line expense modeling. Revenue is projected revenue growing from 28.8% to 8.6% annually, with expenses (COGS, SG&A, R&D) held at historical ratios. Depreciation is computed from a vintage matrix based on a 5-year useful life. Working capital is modeled using historical turnover days (DSO 111, DPO 130, DIO 307). At a 8.3% WACC with mid-year discounting, the terminal value (83% of enterprise value) is derived from the Gordon Growth Model on Year 6 FCFF at a 3.5% perpetual rate. After subtracting net debt, the equity value implies a fair price of $533.82 per share, suggesting LLY is overvalued by 43.7% at the current price of $948.45.
Adjust parameters to explore scenarios. Changes are for exploration only and do not affect saved valuations.
| 2026 | 2027 | 2028 | 2029 | 2030 | Terminal | |
|---|---|---|---|---|---|---|
| Profit Before Tax | 28,268 | 32,693 | 36,844 | 40,365 | 43,817 | 45,350 |
| (−) Net Interest | 1,131 | 1,309 | 1,475 | 1,616 | 1,754 | 1,815 |
| (+) D&A | 5,720 | 7,668 | 9,781 | 11,358 | 13,023 | 13,479 |
| EBITDA | 35,120 | 41,670 | 48,100 | 53,338 | 58,594 | 60,645 |
| (−) Tax | 4,178 | 4,832 | 5,445 | 5,966 | 6,476 | 6,702 |
| (−) CapEx | 11,718 | 13,552 | 15,273 | 16,733 | 18,164 | 18,799 |
| (−) ΔWC | 5,534 | 5,331 | 5,000 | 4,242 | 4,158 | 4,304 |
| Free Cash Flow (FCFF) | 13,690 | 17,955 | 22,381 | 26,398 | 29,796 | 30,839 |
| Terminal Value | 636,822 | |||||
| WACC / Discount Rate | 8.3% | |||||
| Long-term Growth Rate | 3.5% | |||||
| Timing of FCF (mid year) | 0.5 | 1.5 | 2.5 | 3.5 | 4.5 | 5 |
| Present Value of FCF | 13,152 | 15,921 | 18,318 | 19,942 | 20,776 | 426,599 |
| Enterprise Value | 514,710 | |||||
| Projection Period | 88,110 | 17.1% | ||||
| Terminal Value | 426,599 | 82.9% | ||||
| (−) Current Net Debt | 35,340 | |||||
| Equity Value | 479,370 | |||||
| (/) Outstanding Shares | 898 | |||||
| Fair Price | $533.82 | |||||
| WACC \ Terminal Growth Rate | 2.5% | 3.0% | 3.5% | 4.0% | 4.5% |
|---|---|---|---|---|---|
| 6.3% | $721 | $819 | $952 | $1142 | $1434 |
| 7.3% | $559 | $616 | $688 | $782 | $909 |
| 8.3% | $453 | $489 | $534 | $589 | $657 |
| 9.3% | $377 | $403 | $432 | $468 | $510 |
| 10.3% | $322 | $340 | $361 | $385 | $413 |
Current price: $948.45. Green = undervalued, Red = overvalued.
Using an unlevered Free Cash Flow to Firm (FCFF) model, we project Eli Lilly and Company's cash flows over 10 years with analyst estimates for the first 3–5 years, fading toward long-term GDP growth for the remaining years with line-by-line expense modeling. Revenue is projected revenue growing from 28.8% to 6.4% annually, with expenses (COGS, SG&A, R&D) held at historical ratios. Depreciation is computed from a vintage matrix based on a 5-year useful life. Working capital is modeled using historical turnover days (DSO 111, DPO 130, DIO 307). At a 8.3% WACC with mid-year discounting, the terminal value (73% of enterprise value) is derived from the Gordon Growth Model on Year 11 FCFF at a 3.5% perpetual rate. After subtracting net debt, the equity value implies a fair price of $805.67 per share, suggesting LLY is overvalued by 15.1% at the current price of $948.45.
Adjust parameters to explore scenarios. Changes are for exploration only and do not affect saved valuations.
| 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | Terminal | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Profit Before Tax | 28,268 | 32,693 | 36,844 | 40,365 | 43,817 | 52,497 | 61,131 | 69,131 | 75,853 | 80,678 | 83,502 |
| (−) Net Interest | 1,131 | 1,309 | 1,475 | 1,616 | 1,754 | 2,101 | 2,447 | 2,767 | 3,036 | 3,229 | 3,342 |
| (+) D&A | 5,720 | 7,668 | 9,781 | 11,358 | 13,023 | 15,088 | 17,097 | 19,454 | 22,131 | 25,073 | 25,951 |
| EBITDA | 35,120 | 41,670 | 48,100 | 53,338 | 58,594 | 69,686 | 80,675 | 91,352 | 101,020 | 108,981 | 112,795 |
| (−) Tax | 4,178 | 4,832 | 5,445 | 5,966 | 6,476 | 7,759 | 9,035 | 10,217 | 11,211 | 11,924 | 12,341 |
| (−) CapEx | 11,718 | 13,552 | 15,273 | 16,733 | 18,164 | 21,762 | 25,341 | 28,657 | 31,444 | 33,444 | 34,615 |
| (−) ΔWC | 5,534 | 5,331 | 5,000 | 4,242 | 4,158 | 10,456 | 10,402 | 9,637 | 8,098 | 5,813 | 6,017 |
| Free Cash Flow (FCFF) | 13,690 | 17,955 | 22,381 | 26,398 | 29,796 | 29,709 | 35,897 | 42,841 | 50,268 | 57,800 | 59,823 |
| Terminal Value | 1,235,322 | ||||||||||
| WACC / Discount Rate | 8.3% | ||||||||||
| Long-term Growth Rate | 3.5% | ||||||||||
| Timing of FCF (mid year) | 0.5 | 1.5 | 2.5 | 3.5 | 4.5 | 5.5 | 6.5 | 7.5 | 8.5 | 9.5 | 5 |
| Present Value of FCF | 13,152 | 15,921 | 18,318 | 19,942 | 20,776 | 19,120 | 21,324 | 23,489 | 25,439 | 26,998 | 554,351 |
| Enterprise Value | 758,830 | ||||||||||
| Projection Period | 204,480 | 26.9% | |||||||||
| Terminal Value | 554,351 | 73.1% | |||||||||
| (−) Current Net Debt | 35,340 | ||||||||||
| Equity Value | 723,490 | ||||||||||
| (/) Outstanding Shares | 898 | ||||||||||
| Fair Price | $805.67 | ||||||||||
| WACC \ Terminal Growth Rate | 2.5% | 3.0% | 3.5% | 4.0% | 4.5% |
|---|---|---|---|---|---|
| 6.3% | $1151 | $1291 | $1480 | $1751 | $2168 |
| 7.3% | $878 | $956 | $1054 | $1182 | $1354 |
| 8.3% | $700 | $748 | $806 | $877 | $966 |
| 9.3% | $576 | $607 | $644 | $688 | $740 |
| 10.3% | $484 | $506 | $531 | $559 | $593 |
Current price: $948.45. Green = undervalued, Red = overvalued.
Using an unlevered Free Cash Flow to Firm (FCFF) model, we project Eli Lilly and Company's cash flows over 5 years with line-by-line expense modeling. Revenue is projected revenue growing from 28.8% to 8.6% annually, with expenses (COGS, SG&A, R&D) held at historical ratios. Depreciation is computed from a vintage matrix based on a 5-year useful life. Working capital is modeled using historical turnover days (DSO 111, DPO 130, DIO 307). At a 8.3% WACC with mid-year discounting, the terminal value (86% of enterprise value) is derived by applying the industry peer median EV/EBITDA multiple of 13.7x to Year 6 EBITDA. After subtracting net debt, the equity value implies a fair price of $670.96 per share, suggesting LLY is overvalued by 29.3% at the current price of $948.45.
Adjust parameters to explore scenarios. Changes are for exploration only and do not affect saved valuations.
| 2026 | 2027 | 2028 | 2029 | 2030 | Terminal | |
|---|---|---|---|---|---|---|
| Profit Before Tax | 28,268 | 32,693 | 36,844 | 40,365 | 43,817 | 44,912 |
| (−) Net Interest | 1,131 | 1,309 | 1,475 | 1,616 | 1,754 | 1,798 |
| (+) D&A | 5,720 | 7,668 | 9,781 | 11,358 | 13,023 | 13,349 |
| EBITDA | 35,120 | 41,670 | 48,100 | 53,338 | 58,594 | 60,059 |
| (−) Tax | 4,178 | 4,832 | 5,445 | 5,966 | 6,476 | — |
| (−) CapEx | 11,718 | 13,552 | 15,273 | 16,733 | 18,164 | — |
| (−) ΔWC | 5,534 | 5,331 | 5,000 | 4,242 | 4,158 | — |
| Free Cash Flow (FCF) | 13,690 | 17,955 | 22,381 | 26,398 | 29,796 | — |
| Peers' EBITDA Multiple | 13.7x | |||||
| Terminal Value | 820,404 | |||||
| WACC / Discount Rate | 8.34% | |||||
| Timing of FCF (mid year) | 0.5 | 1.5 | 2.5 | 3.5 | 4.5 | 5 |
| Present Value of FCF | 13,152 | 15,921 | 18,318 | 19,942 | 20,776 | 549,579 |
| Enterprise Value | 637,689 | |||||
| Projection Period | 88,110 | 13.8% | ||||
| Terminal Value | 549,579 | 86.2% | ||||
| (−) Current Net Debt | 35,340 | |||||
| Equity Value | 602,349 | |||||
| (÷) Outstanding Shares | 898M | |||||
| Fair Price | $671 | -29.3% | ||||
| WACC \ EV/EBITDA Exit Multiple | 9.7x | 11.7x | 13.7x | 15.7x | 17.7x |
|---|---|---|---|---|---|
| 6.3% | $539 | $638 | $736 | $834 | $933 |
| 7.3% | $515 | $609 | $703 | $796 | $890 |
| 8.3% | $492 | $581 | $671 | $761 | $850 |
| 9.3% | $470 | $555 | $641 | $727 | $812 |
| 10.3% | $449 | $531 | $613 | $694 | $776 |
Current price: $948.45. Green = undervalued, Red = overvalued.
Based on default parameters
Using an unlevered Free Cash Flow to Firm (FCFF) model, we project Eli Lilly and Company's cash flows over 10 years with analyst estimates for the first 3–5 years, fading toward long-term GDP growth for the remaining years with line-by-line expense modeling. Revenue is projected revenue growing from 28.8% to 6.4% annually, with expenses (COGS, SG&A, R&D) held at historical ratios. Depreciation is computed from a vintage matrix based on a 5-year useful life. Working capital is modeled using historical turnover days (DSO 111, DPO 130, DIO 307). At a 8.3% WACC with mid-year discounting, the terminal value (77% of enterprise value) is derived by applying the industry peer median EV/EBITDA multiple of 13.7x to Year 11 EBITDA. After subtracting net debt, the equity value implies a fair price of $951.11 per share, suggesting LLY is fairly valued by 0.3% at the current price of $948.45.
Adjust parameters to explore scenarios. Changes are for exploration only and do not affect saved valuations.
| 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | Terminal | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Profit Before Tax | 28,268 | 32,693 | 36,844 | 40,365 | 43,817 | 52,497 | 61,131 | 69,131 | 75,853 | 80,678 | 82,695 |
| (−) Net Interest | 1,131 | 1,309 | 1,475 | 1,616 | 1,754 | 2,101 | 2,447 | 2,767 | 3,036 | 3,229 | 3,310 |
| (+) D&A | 5,720 | 7,668 | 9,781 | 11,358 | 13,023 | 15,088 | 17,097 | 19,454 | 22,131 | 25,073 | 25,700 |
| EBITDA | 35,120 | 41,670 | 48,100 | 53,338 | 58,594 | 69,686 | 80,675 | 91,352 | 101,020 | 108,981 | 111,705 |
| (−) Tax | 4,178 | 4,832 | 5,445 | 5,966 | 6,476 | 7,759 | 9,035 | 10,217 | 11,211 | 11,924 | — |
| (−) CapEx | 11,718 | 13,552 | 15,273 | 16,733 | 18,164 | 21,762 | 25,341 | 28,657 | 31,444 | 33,444 | — |
| (−) ΔWC | 5,534 | 5,331 | 5,000 | 4,242 | 4,158 | 10,456 | 10,402 | 9,637 | 8,098 | 5,813 | — |
| Free Cash Flow (FCF) | 13,690 | 17,955 | 22,381 | 26,398 | 29,796 | 29,709 | 35,897 | 42,841 | 50,268 | 57,800 | — |
| Peers' EBITDA Multiple | 13.7x | ||||||||||
| Terminal Value | 1,525,894 | ||||||||||
| WACC / Discount Rate | 8.34% | ||||||||||
| Timing of FCF (mid year) | 0.5 | 1.5 | 2.5 | 3.5 | 4.5 | 5.5 | 6.5 | 7.5 | 8.5 | 9.5 | 5 |
| Present Value of FCF | 13,152 | 15,921 | 18,318 | 19,942 | 20,776 | 19,120 | 21,324 | 23,489 | 25,439 | 26,998 | 684,745 |
| Enterprise Value | 889,224 | ||||||||||
| Projection Period | 204,480 | 23.0% | |||||||||
| Terminal Value | 684,745 | 77.0% | |||||||||
| (−) Current Net Debt | 35,340 | ||||||||||
| Equity Value | 853,884 | ||||||||||
| (÷) Outstanding Shares | 898M | ||||||||||
| Fair Price | $951 | +0.3% | |||||||||
| WACC \ EV/EBITDA Exit Multiple | 9.7x | 11.7x | 13.7x | 15.7x | 17.7x |
|---|---|---|---|---|---|
| 6.3% | $863 | $998 | $1132 | $1267 | $1401 |
| 7.3% | $792 | $915 | $1037 | $1160 | $1282 |
| 8.3% | $728 | $839 | $951 | $1063 | $1174 |
| 9.3% | $669 | $771 | $873 | $975 | $1077 |
| 10.3% | $616 | $709 | $802 | $895 | $988 |
Current price: $948.45. Green = undervalued, Red = overvalued.
Based on default parameters
Using the industry peer median P/E Multiples multiple (trailing + forward), Eli Lilly and Company (LLY) has a fair value of $507.71 based on 9 comparable companies in the Drug Manufacturers - General industry.
USD in millions except Fair Price. Subject company highlighted.
| Mkt Cap ($M) | Trailing P/E | Forward P/E | |
|---|---|---|---|
| Eli Lilly and CompanyLLY | 851,710 | 41.3x | 26.3x |
| Johnson & Johnson | 532,766 | 20.1x | 19.1x |
| AbbVie Inc. | 356,494 | 85.0x | 14.2x |
| AstraZeneca PLC | 283,469 | 28.0x | 17.8x |
| Novartis AG | 278,639 | 20.3x | 16.7x |
| Merck & Co., Inc. | 275,089 | 15.3x | 21.7x |
| Novo Nordisk A/S | 204,725 | 13.8x | 15.3x |
| Amgen Inc. | 179,021 | 23.3x | 14.8x |
| Gilead Sciences, Inc. | 163,009 | 19.4x | 15.4x |
| Pfizer Inc. | 150,628 | 19.5x | 8.9x |
| Industry Median | 20.1x | 15.4x | |
| (*) Profit after tax | 20,638 | 32,387 | |
| Equity Value | 414,113 | 497,730 | |
| (/) Outstanding shares | 898 | 898 | |
| Fair Price | $461 | $554 | |
Using the industry peer median EV/EBITDA multiple (trailing + forward), Eli Lilly and Company (LLY) has a fair value of $431.93 based on 9 comparable companies in the Drug Manufacturers - General industry.
USD in millions except Fair Price. Subject company highlighted.
| Mkt Cap ($M) | Trailing EV/EBITDA | Forward EV/EBITDA | |
|---|---|---|---|
| Eli Lilly and CompanyLLY | 851,710 | 31.8x | 24.7x |
| Johnson & Johnson | 532,766 | 13.7x | 12.8x |
| AbbVie Inc. | 356,494 | 23.8x | 21.7x |
| AstraZeneca PLC | 283,469 | 15.5x | 14.3x |
| Novartis AG | 278,639 | 13.2x | 12.8x |
| Merck & Co., Inc. | 275,089 | 10.6x | 10.3x |
| Novo Nordisk A/S | 204,725 | 10.5x | 10.9x |
| Amgen Inc. | 179,021 | 14.2x | 13.8x |
| Gilead Sciences, Inc. | 163,009 | 13.3x | 12.9x |
| Pfizer Inc. | 150,628 | 14.4x | 14.6x |
| Industry Median | 13.7x | 12.9x | |
| (*) EBITDA | 27,937 | 35,981 | |
| = Enterprise Value | 381,734 | 464,698 | |
| (-) Net Debt | 35,340 | 35,340 | |
| Equity Value | 346,394 | 429,358 | |
| (/) Outstanding shares | 898 | 898 | |
| Fair Price | $386 | $478 | |
Using the industry peer median EV/Revenue multiple (trailing + forward), Eli Lilly and Company (LLY) has a fair value of $412.03 based on 9 comparable companies in the Drug Manufacturers - General industry.
USD in millions except Fair Price. Subject company highlighted.
| Mkt Cap ($M) | Trailing EV/Revenue | Forward EV/Revenue | |
|---|---|---|---|
| Eli Lilly and CompanyLLY | 851,710 | 13.6x | 10.6x |
| Johnson & Johnson | 532,766 | 6.0x | 5.6x |
| AbbVie Inc. | 356,494 | 6.9x | 6.2x |
| AstraZeneca PLC | 283,469 | 5.2x | 4.8x |
| Novartis AG | 278,639 | 5.6x | 5.3x |
| Merck & Co., Inc. | 275,089 | 4.8x | 4.7x |
| Novo Nordisk A/S | 204,725 | 5.1x | 5.3x |
| Amgen Inc. | 179,021 | 6.1x | 5.9x |
| Gilead Sciences, Inc. | 163,009 | 6.1x | 6.0x |
| Pfizer Inc. | 150,628 | 3.5x | 3.5x |
| Industry Median | 5.6x | 5.3x | |
| (*) Revenue | 65,179 | 83,947 | |
| = Enterprise Value | 361,784 | 448,901 | |
| (-) Net Debt | 35,340 | 35,340 | |
| Equity Value | 326,444 | 413,561 | |
| (/) Outstanding shares | 898 | 898 | |
| Fair Price | $364 | $461 | |
Using the PEG framework with analyst consensus forward EPS growth of 23.0% plus 0.6% dividend yield, the company has a fair value of $830.82 based on NTM EPS (FY2026) of $36.07. The current PEG ratio is 1.14.
PEG < 1 = bargain, 1–1.5 = fair, > 2 = expensive.
PEG is most informative for high-growth companies — the PEG sweet spot.
| EPS Growth RateForward | 22.4% |
| Dividend Yield | +0.6% |
| Adjusted Growth (clamped 8–25%) | 23.0% |
| Fair P/E | 23.0x |
| NTM EPS (FY2026) | $36.07 |
| Fair Value | $830.82 |
| Period | EPS Est. | Growth | Analysts |
|---|---|---|---|
| FY2025 (actual) | $22.95 | — | — |
| FY2026E | $36.07 | +57.1% | 18 |
| FY2027E | $43.83 | +21.5% | 21 |
| FY2028E | $50.92 | +16.2% | 23 |
| FY2029E | $57.03 | +12.0% | 11 |
| FY2030E | $63.14 | +10.7% | 11 |
5Y Forward EPS CAGR: 22.4%
| Year | Net Income | EPS | YoY |
|---|---|---|---|
| FY2021 | $5.6B | $5.85 | — |
| FY2022 | $6.2B | $6.57 | +12.3% |
| FY2023 | $5.2B | $5.80 | -11.7% |
| FY2024 | $10.6B | $11.71 | +101.9% |
| FY2025 | $20.6B | $22.95 | +96.0% |
4Y Historical EPS CAGR: 40.7%
Using the Earnings Power Value framework with a WACC of 8.3% and normalized earnings of $15.4B, the company has a fair value of $166.28 per share. The EPV range is $134.94 – $211.35 based on WACC sensitivity (6.8% – 9.8%).
| Low | Selected | High | |
|---|---|---|---|
| Normalized Earnings | 15,405 | 15,405 | 15,405 |
| (/) WACC | 9.8% | 8.3% | 6.8% |
| Enterprise Value | 156,515 | 184,656 | 225,135 |
| (-) Net debt | 35,340 | 35,340 | 35,340 |
| Equity Value | 121,175 | 149,316 | 189,795 |
| (/) Outstanding shares | 898 | 898 | 898 |
| Fair Price | $134.94 | $166.28 | $211.35 |
Using the Two-Stage Dividend Discount Model with a Cost of Equity of 8.7% and projected dividend growth of 15.0%, the fair value is $195.01 per share. The DDM range is $128.01 – $323.05 based on sensitivity analysis across Cost of Equity and growth rate assumptions.
| Year | DPS | Payout Ratio | YoY Growth |
|---|---|---|---|
| 2025 | $6.00 | 26.1% | +15.8% |
| 2024 | $5.18 | 44.2% | +14.9% |
| 2023 | $4.51 | 77.7% | +21.1% |
| 2022 | $3.72 | 56.6% | +15.0% |
| 2021 | $3.24 | 55.3% | — |
| Year | Projected DPS | Growth | Discount Factor | Present Value |
|---|---|---|---|---|
| 2026 | $6.89 | 15.0% | 0.9202 | $6.34 |
| 2027 | $7.93 | 15.0% | 0.8468 | $6.71 |
| 2028 | $9.12 | 15.0% | 0.7793 | $7.11 |
| 2029 | $10.49 | 15.0% | 0.7171 | $7.52 |
| 2030 | $12.06 | 15.0% | 0.6599 | $7.96 |
| Terminal Value | $12.48 DPS | 3.5% | $159.37 |
Fair value under different Cost of Equity (rows) and DPS Growth Rate (columns) assumptions.
| Ke \ Growth | 13.0% | 14.0% | 15.0% | 15.0% | 15.0% |
|---|---|---|---|---|---|
| 6.7% | $297 | $310 | $323 | $323 | $323 |
| 7.7% | $224 | $234 | $244 | $244 | $244 |
| 8.7% | $180 | $187 | $195 | $195 | $195 |
| 9.7% | $150 | $156 | $162 | $162 | $162 |
| 10.7% | $128 | $133 | $139 | $139 | $139 |
Disclaimer: Sweet Value Lab provides estimated intrinsic values for informational purposes only. This is not financial advice. All models rely on assumptions that may not reflect future performance. Always do your own research before making investment decisions.