LLYELI LILLY & Co— fair value (DCF model)
A deterministic two-stage discounted-cash-flow (DCF) estimate of this company's per-share fair value, and how far it sits above or below the current share price — with the full assumptions, a growth×discount sensitivity grid and the methodology. Every figure is engine-computed from SEC filings, delayed prices and the 10-year Treasury yield, with no LLM. This is a model estimate under disclosed assumptions, not a price target, forecast or investment advice.
The model estimates $263.79 per share — 76.8% below the current price of $1,136.71.
A deterministic model estimate under the disclosed assumptions (two-stage DCF over as-reported SEC figures; CAPM discount off the 10Y Treasury). NOT a price target, forecast, or investment advice — the sensitivity grid shows how the estimate moves as assumptions change.
Free-cash-flow DCF
The model estimates $263.79 per share — 76.8% below the current price of $1,136.71.
| Base fiscal year · base amount | FY2025 · $9.0B |
| History years | 10 |
| Historical CAGR (raw) | 10.0% |
| Growth start (year 1) | 10.0% |
| Terminal growth (Gordon) | 3.0% |
| Discount rate (CAPM) | 5.0% + β 0.60 (clamped) × 5.0% = 8.0% |
| Projection years | 10 |
| Growth ↓ / Discount → | −1pp | −0.5pp | base | +0.5pp | +1pp |
|---|---|---|---|---|---|
| −5pp | $267.55 | $237.59 | $213.63 | $194.03 | $177.70 |
| −2.5pp | $298.17 | $264.47 | $237.53 | $215.49 | $197.14 |
| base | $331.87 | $294.04 | $263.79 | $239.07 | $218.48 |
| +2.5pp | $368.91 | $326.51 | $292.62 | $264.93 | $241.87 |
| +5pp | $409.57 | $362.14 | $324.24 | $293.27 | $267.50 |
Earnings (net-income) DCF
The model estimates $913.79 per share — 19.6% below the current price of $1,136.71.
| Base fiscal year · base amount | FY2025 · $20.6B |
| History years | 10 |
| Historical CAGR (raw) | 25.2% |
| Growth start (year 1) | 20.0% (clamped from 25.2% into 0–20%) |
| Terminal growth (Gordon) | 3.0% |
| Discount rate (CAPM) | 5.0% + β 0.60 (clamped) × 5.0% = 8.0% |
| Projection years | 10 |
| Growth ↓ / Discount → | −1pp | −0.5pp | base | +0.5pp | +1pp |
|---|---|---|---|---|---|
| −5pp | $943.34 | $834.09 | $746.79 | $675.46 | $616.09 |
| −2.5pp | $1,046.02 | $924.01 | $826.54 | $746.91 | $680.65 |
| base | $1,158.48 | $1,022.44 | $913.79 | $825.04 | $751.21 |
| +2.5pp | $1,158.48 | $1,022.44 | $913.79 | $825.04 | $751.21 |
| +5pp | $1,158.48 | $1,022.44 | $913.79 | $825.04 | $751.21 |
Model computed 2026-09-16 · Source: SEC XBRL filings + delayed price + 10Y Treasury yield · For reference only · Not investment advice
How the model works
- Two-stage DCF. Stage 1 projects ten explicit years of cash flow; stage 2 caps it with a Gordon terminal value. The model runs two variants — one over free cash flow, one over earnings (net income) — whenever each is computable.
- Dollar-level projection ÷ current shares. The company-level dollar series is projected and divided by the current share count once at the end. Dollar totals are split-immune, whereas a per-share history mixes pre/post-split bases.
- Linear growth decay. Stage-1 growth starts at the historical CAGR of the base series (clamped into 0%–20%; the raw CAGR is still disclosed) and decays linearly to the terminal rate.
- Gordon terminal growth = min(10-year Treasury yield, 3%). A company cannot outgrow the economy forever; the discount rate must clear the terminal rate by a minimum spread or the value is undefined.
- CAPM discount rate = 10-year Treasury + beta × equity-risk premium (5%). Beta is clamped into 0.6–2.0 (a degenerate regression beta destabilises the model); an unknown beta defaults to 1.0. Every clamp/default is disclosed.
- Honesty gates (absent, never fabricated): at least four annual points with positive first/last values to anchor a CAGR; banks, insurers and REITs are out of model scope (an FCF/earnings DCF structurally misfits their economics); and a result outside 1/8×–8× of the current price is withheld — the assumptions do not fit that business, so no number is shown.
- Sensitivity, not a single oracle number. A 5×5 grid over (growth-start offset × discount offset) shows how the estimate moves as the two key assumptions change — the honest presentation of model uncertainty.
This page is a deterministic model estimate under disclosed assumptions — not a price target, forecast or investment advice. Source: SEC XBRL filings, delayed prices and US Treasury yields; for reference only.