Projected Income Statement: Eli Lilly and Company

Forecast Balance Sheet: Eli Lilly and Company

Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028
Net Debt 1 12,976 14,027 22,298 30,221 35,235 17,383 -3,073 -32,095
Change - 8.1% 58.96% 35.53% 16.59% -50.67% -117.68% -944.42%
Announcement Date 03/02/22 02/02/23 06/02/24 06/02/25 04/02/26 - - -
1USD in Million
Estimates

Cash Flow Forecast: Eli Lilly and Company

Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028
CAPEX 1 1,310 1,854 3,448 5,058 7,841 7,861 6,590 6,476
Change - 41.57% 85.92% 46.7% 55.03% 0.26% -16.18% -1.72%
Free Cash Flow (FCF) 1 5,951 5,230 792.5 3,760 8,972 20,789 28,665 34,942
Change - -12.11% -84.85% 374.46% 138.61% 131.71% 37.88% 21.9%
Announcement Date 03/02/22 02/02/23 06/02/24 06/02/25 04/02/26 - - -
1USD in Million
Estimates

Forecast Financial Ratios: Eli Lilly and Company

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

Profitability

        
EBITDA Margin (%) 35.33% 33.19% 25.15% 35.7% 44.91% 48.57% 52.1% 53.29%
EBIT Margin (%) 29.86% 27.85% 20.68% 31.78% 41.84% 47.46% 49.12% 49.93%
EBT Margin (%) 21.74% 23.85% 19.21% 28.15% 39.48% 39.75% 46.57% 48.36%
Net margin (%) 19.71% 21.88% 15.36% 23.51% 31.67% 36.39% 38.76% 40.7%
FCF margin (%) 21.01% 18.32% 2.32% 8.35% 13.77% 24.42% 29.36% 31.63%
FCF / Net Income (%) 106.61% 83.75% 15.12% 35.51% 43.47% 67.09% 75.76% 77.71%

Profitability

        
ROA 15.58% 14.62% 9.23% 14.84% 22.77% 24.67% 26.78% 25.46%
ROE 101.73% 73.22% 48.93% 84.84% 106.69% 82.01% 62.51% 50.89%

Financial Health

        
Leverage (Debt/EBITDA) 1.3x 1.48x 2.6x 1.88x 1.2x 0.42x - -
Debt / Free cash flow 2.18x 2.68x 28.14x 8.04x 3.93x 0.84x - -

Capital Intensity

        
CAPEX / Current Assets (%) 4.63% 6.5% 10.1% 11.23% 12.03% 9.23% 6.75% 5.86%
CAPEX / EBITDA (%) 13.09% 19.58% 40.16% 31.46% 26.79% 19.01% 12.96% 11%
CAPEX / FCF (%) 22.01% 35.45% 435.03% 134.51% 87.39% 37.81% 22.99% 18.53%

Items per share

        
Cash flow per share 1 7.964 7.831 4.694 9.754 18.7 34.75 43.53 48.66
Change - -1.67% -40.06% 107.79% 91.67% 85.85% 25.28% 11.77%
Dividend per Share 1 3.4 3.92 4.52 5.2 6 6.795 7.529 8.351
Change - 15.29% 15.31% 15.04% 15.38% 13.25% 10.8% 10.93%
Book Value Per Share 1 9.411 11.2 11.93 15.76 29.57 57.09 87.11 125.6
Change - 19.04% 6.45% 32.16% 87.64% 93.04% 52.59% 44.16%
EPS 1 6.12 6.9 5.8 11.71 22.95 34.08 42.1 50.08
Change - 12.75% -15.94% 101.9% 95.99% 48.5% 23.51% 18.97%
Nbr of stocks (in thousands) 9,06,592 9,50,178 8,99,307 9,00,432 8,95,381 8,91,741 8,91,741 8,91,741
Announcement Date 03/02/22 02/02/23 06/02/24 06/02/25 04/02/26 - - -
1USD
Estimates
2026 *2027 *
P/E ratio 27.8x 22.5x
PBR 16.6x 10.9x
EV / Sales 10.1x 8.63x
Yield 0.72% 0.79%

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Trader
Investor
Global
Quality
ESG MSCI
A
Sell
Consensus
Buy
Mean consensus
BUY
Number of Analysts
31
Last Close Price
948.45USD
Average target price
1,209.14USD
Spread / Average Target
+27.49%

Quarterly revenue - Rate of surprise

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