Projected Income Statement: Eli Lilly and Company

Forecast Balance Sheet: Eli Lilly and Company

Fiscal Period: December 2020 2021 2022 2023 2024 2025 2026 2027
Net Debt 1 12,914 12,976 14,027 22,298 30,221 26,041 13,057 -9,600
Change - 0.48% 8.1% 58.96% 35.53% -13.83% -49.86% -173.52%
Announcement Date 29/01/21 03/02/22 02/02/23 06/02/24 06/02/25 - - -
1USD in Million
Estimates

Cash Flow Forecast: Eli Lilly and Company

Fiscal Period: December 2020 2021 2022 2023 2024 2025 2026 2027
CAPEX 1 1,388 1,310 1,854 3,448 5,058 5,809 6,291 6,159
Change - -5.63% 41.57% 85.92% 46.7% 14.85% 8.31% -2.11%
Free Cash Flow (FCF) 1 5,112 5,951 5,230 792.5 3,760 11,380 17,451 25,214
Change - 16.42% -12.11% -84.85% 374.46% 202.64% 53.35% 44.49%
Announcement Date 29/01/21 03/02/22 02/02/23 06/02/24 06/02/25 - - -
1USD in Million
Estimates

Forecast Financial Ratios: Eli Lilly and Company

Fiscal Period: December 2020 2021 2022 2023 2024 2025 2026 2027

Profitability

        
EBITDA Margin (%) 35% 35.33% 33.19% 25.15% 35.7% 44.87% 49.1% 50.3%
EBIT Margin (%) 29.6% 29.86% 27.85% 20.68% 31.78% 41.47% 46% 47.99%
EBT Margin (%) 29.46% 21.74% 23.85% 19.21% 28.15% 39.32% 43.36% 44.62%
Net margin (%) 25.24% 19.71% 21.88% 15.36% 23.51% 32.06% 36.95% 39.11%
FCF margin (%) 20.83% 21.01% 18.32% 2.32% 8.35% 17.86% 22.68% 28.01%
FCF / Net Income (%) 82.53% 106.61% 83.75% 15.12% 35.51% 55.71% 61.38% 71.61%

Profitability

        
ROA 14.42% 15.58% 14.62% 9.23% 14.84% 22.92% 25.8% 26.8%
ROE 175.45% 101.73% 73.22% 48.93% 84.84% 103.8% 80.26% 62.11%

Financial Health

        
Leverage (Debt/EBITDA) 1.5x 1.3x 1.48x 2.6x 1.88x 0.91x 0.35x -
Debt / Free cash flow 2.53x 2.18x 2.68x 28.14x 8.04x 2.29x 0.75x -

Capital Intensity

        
CAPEX / Current Assets (%) 5.66% 4.63% 6.5% 10.1% 11.23% 9.12% 8.18% 6.84%
CAPEX / EBITDA (%) 16.16% 13.09% 19.58% 40.16% 31.46% 20.32% 16.65% 13.6%
CAPEX / FCF (%) 27.15% 22.01% 35.45% 435.03% 134.51% 51.05% 36.05% 24.42%

Items per share

        
Cash flow per share 1 7.119 7.964 7.831 4.694 9.754 21.8 36.37 40.43
Change - 11.87% -1.67% -40.06% 107.79% 123.45% 66.85% 11.17%
Dividend per Share 1 2.96 3.4 3.92 4.52 5.2 5.893 6.632 7.392
Change - 14.86% 15.29% 15.31% 15.04% 13.34% 12.54% 11.46%
Book Value Per Share 1 5.9 9.411 11.2 11.93 15.76 29.9 51.43 79.81
Change - 59.51% 19.04% 6.45% 32.16% 89.7% 72.01% 55.19%
EPS 1 6.79 6.12 6.9 5.8 11.71 22.94 32.18 38.98
Change - -9.87% 12.75% -15.94% 101.9% 95.87% 40.29% 21.15%
Nbr of stocks (in thousands) 906,582 906,592 950,178 899,307 900,432 895,381 895,381 895,381
Announcement Date 29/01/21 03/02/22 02/02/23 06/02/24 06/02/25 - - -
1USD
Estimates
2025 *2026 *
P/E ratio 45.4x 32.4x
PBR 34.8x 20.2x
EV / Sales 15x 12.3x
Yield 0.57% 0.64%
More valuation ratios * Estimated data

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Trader
Investor
Global
Quality
ESG MSCI
A
More Ratings
Sell
Consensus
Buy
Mean consensus
BUY
Number of Analysts
30
Last Close Price
1,041.29USD
Average target price
1,110.72USD
Spread / Average Target
+6.67%
Consensus

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Equities
  3. LLY Stock
  4. Financials Eli Lilly and Company