Definitive Analysis
Definitive Analysis
Financial Statements
Periods / Units
Fundamentals
Valuations
Miscellaneous
Analysis Mode
Full Access
See Pricing Start Trial

Eli Lilly and Company

Intrinsic Value Analysis (Discounted Cash Flow)Industry: Drug Manufacturers - GeneralSector: Healthcare

Fair Value Summary

Current Price$1,054.29
5Y Range228.54 – 365.16
5Y Selected296.85
(-) Safety Margin72.80%
5Y Buy Price$80.74
Upside (to Buy Price)-92.34%
10Y Range278.03 – 432.84
10Y Selected355.44
(-) Safety Margin72.80%
10Y Buy Price$96.68
Upside (to Buy Price)-90.83%

Company Predictability & Safety

MetricValue
Revenue R2 (5Y)0.8569
Revenue R2 (10Y)0.7755
Net Income R2 (5Y)0.3769
Net Income R2 (10Y)0.5692
EBITDA R2 (5Y)0.4790
EBITDA R2 (10Y)0.7542
FCF R2 (5Y)0.5251
FCF R2 (10Y)0.0899
Safety Score0.2720

DA 10-Year Projection

Metric2025202620272028202920302031203220332034
% Growth13.73%12.65%11.57%10.49%9.41%8.33%7.24%6.16%5.08%4.00%
Revenue51,228.8157,710.4564,388.0171,141.8377,834.6584,315.3090,423.6395,996.51100,874.61104,909.60
EBITDA24,104.7827,154.6030,296.6033,474.4936,623.6739,673.0242,547.1845,169.4047,464.7049,363.29
D&A-2,897.99-3,264.65-3,642.39-4,024.45-4,403.06-4,769.67-5,115.21-5,430.47-5,706.42-5,934.68
EBIT21,206.7923,889.9526,654.2129,450.0332,220.6134,903.3537,431.9739,738.9341,758.2843,428.61
Pro forma Taxes-3,784.17-4,262.96-4,756.22-5,255.11-5,749.49-6,228.21-6,679.42-7,091.07-7,451.41-7,749.47
NOPAT17,422.6219,626.9921,897.9924,194.9326,471.1228,675.1430,752.5532,647.8634,306.8735,679.15
Capital Expenditures-6,181.79-6,963.93-7,769.71-8,584.69-9,392.32-10,174.34-10,911.43-11,583.91-12,172.55-12,659.46
NWC Investment-1,319.44-1,382.47-1,424.26-1,440.53-1,427.51-1,382.26-1,302.85-1,188.64-1,040.45-860.62
(+) D&A2,897.993,264.653,642.394,024.454,403.064,769.675,115.215,430.475,706.425,934.68
Free Cash Flow12,819.3814,545.2416,346.4218,194.1620,054.3521,888.2223,653.4925,305.7726,800.2928,093.75
Diluted Shares Outstanding900,588,750.00900,588,750.00900,588,750.00900,588,750.00900,588,750.00900,588,750.00900,588,750.00900,588,750.00900,588,750.00900,588,750.00

Discounting Periods

MetricDec-25Dec-26Dec-27Dec-28Dec-29Dec-30Dec-31Dec-32Dec-33Dec-34
Period Start9/30/251/1/261/1/271/1/281/1/291/1/301/1/311/1/321/1/331/1/34
Period End12/31/2512/31/2612/31/2712/31/2812/31/2912/31/3012/31/3112/31/3212/31/3312/31/34
Mid-Point11/15/257/2/267/2/277/1/287/2/297/2/307/2/317/1/327/2/337/2/34
Time (t)0.100.461.462.463.464.465.466.467.468.46
Valuation Date1/16/26

Base Case Projected Flows

WACC: 9.10%Terminal Growth: 2.39%
Metric2025202620272028202920302031203220332034TV (5y)TV (10y)
Discount Factor0.990.960.880.810.740.680.620.570.520.48
PV UFCF12,708.2413,974.1414,394.9514,685.9714,837.5614,843.8814,703.3214,418.6013,996.7213,448.68
Raw: 305,997.46
216,752.11
Raw: 428,665.92
196,462.89

Base Case Valuation

5-Year Horizon10-Year Horizon
UFCFUFCF
Enterprise Value287,352.97338,474.96
(-) Net Debt33,760.2533,760.25
Equity Value253,592.72304,714.71
(/) Shares Out900.59900.59
Fair Value$281.59$338.35
(-) Safety Margin72.80%72.80%
Buy Price$76.59$92.03
Current Price$1,054.29$1,054.29
Upside (to Buy Price)-92.74%-91.27%

Conservative Projected Flows

WACC: 10.10%Terminal Growth: 1.89%
Metric2025202620272028202920302031203220332034TV (5y)TV (10y)
Discount Factor0.990.960.870.790.720.650.590.540.490.44
PV UFCF12,696.6513,915.6114,204.4514,360.0114,376.4514,251.9413,988.7713,593.2913,075.7012,449.61
Raw: 248,870.89
170,030.79
Raw: 348,638.43
147,241.95

Conservative Valuation

5-Year Horizon10-Year Horizon
UFCFUFCF
Enterprise Value239,583.96284,154.43
(-) Net Debt33,760.2533,760.25
Equity Value205,823.71250,394.18
(/) Shares Out900.59900.59
Fair Value$228.54$278.03
(-) Safety Margin72.80%72.80%
Buy Price$62.16$75.63
Current Price$1,054.29$1,054.29
Upside (to Buy Price)-94.10%-92.83%

Aggressive Projected Flows

WACC: 8.10%Terminal Growth: 2.89%
Metric2025202620272028202920302031203220332034TV (5y)TV (10y)
Discount Factor0.990.960.890.830.760.710.650.600.560.52
PV UFCF12,719.9514,033.4614,589.7815,022.4415,317.9115,466.2015,461.4715,302.3314,992.0114,538.25
Raw: 396,016.81
290,934.82
Raw: 554,772.30
276,126.79

Aggressive Valuation

5-Year Horizon10-Year Horizon
UFCFUFCF
Enterprise Value362,618.35423,570.59
(-) Net Debt33,760.2533,760.25
Equity Value328,858.10389,810.34
(/) Shares Out900.59900.59
Fair Value$365.16$432.84
(-) Safety Margin72.80%72.80%
Buy Price$99.32$117.73
Current Price$1,054.29$1,054.29
Upside (to Buy Price)-90.58%-88.83%

Reverse DCF: Market Implied Growth

Current Price$1,054.29
WACC Used9.1%
IMPLIED REVENUE GROWTH175.07%
Metric2027202820292030203120322033203420352036
Implied Revenue163,447.97449,601.631,236,733.783,401,923.729,357,781.8725,740,753.9870,805,926.53194,768,157.78535,755,086.341,473,718,886.18
Constant Implied Growth175.07%175.07%175.07%175.07%175.07%175.07%175.07%175.07%175.07%175.07%
Implied Free Cash Flow16.3444.96123.67340.19935.782,574.087,080.5919,476.8253,575.51147,371.89
Discount Factor0.930.810.740.680.620.570.520.480.440.40
Present Value of Implied FCF15.2136.2991.50230.71581.691,466.643,697.919,323.6923,508.2159,272.20

Rolling Historical DCF (Backtest)

Valuation based on actual realized growth.
YearValuation DateActual PriceRealized Growth (5Y)Calculated Fair ValueValuation Delta
20192019-12-31$131.4315.80%$92.35-29.73%
20182018-12-31$115.7211.32%$56.61-51.08%
20172017-12-31$84.469.66%$68.01-19.48%
20162016-12-31$73.5510.99%$76.994.68%
20152015-12-31$84.267.77%$21.59-74.38%
20142014-12-31$68.995.92%$46.93-31.97%
20132013-12-31$51.003.88%$72.8942.92%
20122012-12-31$49.32-0.85%$52.526.50%
20112011-12-31$41.56-1.81%$68.0863.81%
20102010-12-31$35.04-4.87%$61.0974.35%
20092009-12-31$35.71-3.86%$38.086.65%
20082008-12-31$40.270.24%$83.65107.73%
20072007-12-31$53.392.07%$59.9312.25%
20062006-12-31$52.106.02%$51.57-1.02%
20052005-12-31$56.598.88%$9.27-83.62%
20042004-12-31$56.7510.33%$19.94-64.86%
20032003-12-31$70.339.89%$39.51-43.83%
20022002-12-31$63.508.80%$16.41-74.16%
20012001-12-31$78.548.23%$54.65-30.41%
20002000-12-31$93.066.77%$58.23-37.43%
19991999-12-31$66.505.69%$37.63-43.41%
19981998-12-31$88.885.03%$36.96-58.42%
19971997-12-31$69.635.50%$34.77-50.07%
19961996-12-31$36.509.57%$29.45-19.32%
19951995-12-31$28.1311.40%$24.34-13.48%

Monte Carlo Simulation (1,000 Iterations)

Mean Fair Value
$348.13
Median
$336.20
10th Percentile
$278.57
90th Percentile
$431.31

Fair Value Distribution

$217.57 - $271.54
78
$271.54 - $325.50
338
$325.50 - $379.47
324
$379.47 - $433.43
165
$433.43 - $487.40
62
$487.40 - $541.36
20
$541.36 - $595.33
8
$595.33 - $649.29
2
$649.29 - $703.26
0
$703.26 - $757.22
0
$757.22 - $811.19
2
$811.19 - $865.16
0
$865.16 - $919.12
0
$919.12 - $973.09
0
$973.09 - $1,027.05
0
$1,027.05 - $1,081.02
0
$1,081.02 - $1,134.98
0
$1,134.98 - $1,188.95
0
$1,188.95 - $1,242.91
0
$1,242.91 - $1,296.88
1