Eli Lilly stock report · DCF calculator
LLY DCF calculator
Value Eli Lilly on your own assumptions. It starts from the growth today's price assumes, with free cash flow, cash and shares from LLY's SEC filings. Change any of them and see what the shares would be worth.
On your assumptions
$1,185 a sharein line with today's $1,185
If free cash flow grows as set, buying at $1,185 would earn about 10.2% a year, exactly the 10.2% you asked for.
At that pace, $1,185 becomes about $1,923 in five years, counting the cash the business hands back or keeps.
Show the workings
What the value is made of
- Cash flows, years 1 to 10$352.5B
- Everything after year ten$753.7B
- Cash and short-term investments$9.1B
- All of it, over 0.94bn shares$1.12T
How much the answer moves
Value per share as the return you want and early growth change around your choice.
| Return ↓ · growth → | 13.8% | 18.8% | 23.8% | 28.8% | 33.8% |
|---|---|---|---|---|---|
| 8.2% | $1,156 | $1,420 | $1,732 | $2,098 | $2,525 |
| 9.2% | $947.51 | $1,162 | $1,416 | $1,712 | $2,058 |
| 10.2% | $795.79 | $974.36 | $1,185 | $1,431 | $1,718 |
| 11.2% | $680.91 | $832.11 | $1,010 | $1,219 | $1,461 |
| 12.2% | $591.30 | $721.19 | $874.05 | $1,053 | $1,261 |
Year by year
| Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
|---|---|---|---|---|---|---|---|---|---|---|
| Free cash flow | $21.7B | $26.9B | $33.3B | $41.2B | $51.0B | $63.2B | $78.3B | $96.9B | $120.0B | $148.6B |
| Worth today | $19.7B | $22.2B | $24.9B | $28.0B | $31.5B | $35.3B | $39.7B | $44.7B | $50.2B | $56.4B |
LLY's figures are from its SEC filings; the price is the last close. The estimate is yours: it is not a price target, and it is not advice.
How this DCF works
- Free cash flow: operating cash flow less capital spending and the stock paid to staff (which dilutes every other shareholder): $17.5B over the last twelve months, after $649M of stock pay.
- Ten years of growth: one rate for years 1 to 5 and another for 6 to 10, then a steady rate forever.
- Discounting: each year's cash is worth less today at the discount rate. The starting rate is the 10-year Treasury yield (5.2%) plus 5 points.
- To value per share: add cash and short-term investments ($9.1B) and divide by the shares outstanding. Debt is not taken off again: free cash flow is already after the interest on it.
- What the price assumes: the growth at which this model gives back today's price. The LLY report scores it against the free cash flow growth the company has delivered, slowed halfway toward the economy's growth, because ten more years at a past pace is rare.