ELI LILLY AND COMPANY (LLY) valuation

1 · Enterprise-value target (what the DCF must match)

Market cap   = price × diluted shares
             = $883.96 × 899.3M
             = $794.95B

EV target    = market cap + total debt − cash & equivalents
             = $794.95B + $42.23B − $7.27B
             = $829.91B
            

2 · Starting NOPAT (base year 0)

GAAP EBIT          = $25.73B   (39.5% of revenue)
× (1 − tax rate)  = × (1 − 19.8%) = × 0.8021
= NOPAT₀            = $20.64B
            

3 · Invested capital & starting ROIC

Invested capital = total debt + book equity − cash
                 = $42.23B + $26.54B − $7.27B
                 = $61.50B

Raw ROIC₀        = NOPAT₀ / Invested capital
                 = $20.64B / $61.50B
                 = 33.6%
(no cap applied; raw value is within the 40.0% ceiling)
            

4 · Growth path construction

Source       = analyst consensus: Y1 = 25.7%, Y2 = 16.1%
Clamp        = [2.5%, 60%] (no sub-terminal or 60%+ starts)
Plateau rate = 16.1% (Y2 — held from year 2 through end of plateau)
Tier         = 5 years (rule: plateau rate < 15% → 3y, < 25% → 5y, else 7y)
Plateau      = 5 years
Fade         = linear from effective Y2 to terminal 2.5% across the remaining 5 years

Effective Y1 growth after solver bumps = 37.7%
Effective Y2 growth after solver bumps = 28.1%
Growth by year:
  Y1 = 37.7%
  Y2 = 28.1%
  Y3 = 28.1%
  Y4 = 28.1%
  Y5 = 28.1%
  Y6 = 23.0%
  Y7 = 17.9%
  Y8 = 12.8%
  Y9 = 7.6%
  Y10 = 2.5%
            

5 · Margin path construction

Starting margin (Y0) = 28.9%   (source: 3-year mean EBIT margin (latest FY deviates > 5pp))
Target margin (Y10)  = 42.3%   (solver output, normal band)
Year-t margin        = starting + (target − starting) × (t / 10)
Margin by year:
  Y1 = 30.3%
  Y2 = 31.6%
  Y3 = 33.0%
  Y4 = 34.3%
  Y5 = 35.6%
  Y6 = 37.0%
  Y7 = 38.3%
  Y8 = 39.7%
  Y9 = 41.0%
  Y10 = 42.3%
            

6 · ROIC path construction

The capex heuristic compares latest-period CapEx (—) against the Normalized CapEx (3-yr mean) of — — mean of the last three annual CapEx values. When the latest is above 1.4× that mean and CapEx is at least 5% of revenue, we treat the filer as capital-intensive and mid-investment, hold ROIC flat for a 5-year harvest phase, and only then fade to terminal ROIC. The 3-yr mean does not feed the DCF directly — it only gates this flag.

Capex-heuristic inactive (latest CapEx vs the 3-yr mean of — — below the 1.4× / 5%-of-revenue gates).
Fade from Y1: ROIC_t = ROIC₀ + (ROIC_terminal − ROIC₀) × (t / 10)
ROIC₀ = 33.6%; ROIC_terminal = 11.0%

ROIC by year:
  Y1 = 31.3%
  Y2 = 29.1%
  Y3 = 26.8%
  Y4 = 24.5%
  Y5 = 22.3%
  Y6 = 20.0%
  Y7 = 17.8%
  Y8 = 15.5%
  Y9 = 13.3%
  Y10 = 11.0%
            

7 · Solver iterations

Each row is one bisection attempt. The solver sweeps Y1 growth bumps 0pp → +20pp across the plateau ladder inside the normal margin bracket, then — if nothing reconciles — repeats the same sweep in a widened margin band ([-10%, 80%]). The first feasible attempt is the one the page uses. If no combination reconciles, the page shows the attempt whose PV sits closest to the target EV so both levers are balanced.

8 · Terminal value derivation

NOPAT_{N+1}         = NOPAT_{10} × (1 + g_terminal)
                    = $148.22B × (1 + 2.5%)
                    = $151.92B

ΔNOPAT              = NOPAT_{N+1} − NOPAT_{10}
                    = $3.71B
Reinvestment_{N+1}  = ΔNOPAT / ROIC_terminal
                    = $3.71B / 11.0%
                    = $33.69B

FCF_{N+1}           = NOPAT_{N+1} − Reinvestment_{N+1}
                    = $151.92B − $33.69B
                    = $118.24B

Terminal value (TV) = FCF_{N+1} / (WACC − g_terminal)
                    = $118.24B / (9.0% − 2.5%)
                    = $1.82T

PV(TV)              = TV / (1 + WACC)^10
                    = $1.82T / 2.367
                    = $768.37B
            

9 · Reconciliation check (DCF PV vs. the market)

This isn't a fair value — it's the inverse check. The solver built the scenario so that DCF PV reproduces the current enterprise value; if the normal bracket worked the delta below is ~0 by construction. A non-zero delta only appears when the solver fell through to the widened margin band.

Σ PV(FCF_1..10) = $61.54B
+ PV(TV)          = $768.37B
= Enterprise value = $829.91B   (≈ EV target $829.91B by construction)
− Total debt      = $42.23B
+ Cash            = $7.27B
= Equity value    = $794.95B
÷ Diluted shares  = 899.3M
= DCF PV / share  = $883.96

Market price      = $883.96
Reconciliation Δ  = +0.0%   (≈ 0 by construction — the solver anchored on this price)