Lilly (Eli) (LLY) Financial Forecast Calculator
Interactive 5-year forecast and DCF for Lilly (Eli). Adjust revenue growth, gross margin, capex intensity, WACC, and terminal growth - see revenue, free cash flow, and enterprise value update in real time. Seeded from Lilly (Eli)’s most recent SEC filings.
Assumptions
Need this as an Excel model?
Keep iterating on the Lilly (Eli) forecast in Excel. The downloadable sample has every assumption you see here plus a fully integrated income statement, balance sheet, cash flow, and debt schedule - five years of SEC historicals and live formulas in a fully editable workbook.
Other Healthcare forecasts
Run the same calculator on a peer.
Frequently asked
What does Eli Lilly (LLY) do?+
Eli Lilly is a global pharmaceutical company that discovers, develops, manufactures, and markets human medicines. It primarily focuses on cardiometabolic diseases, oncology, immunology, and neuroscience, operating as an asset-heavy innovator.
What are the primary revenue drivers for Eli Lilly?+
Eli Lilly's revenue is predominantly driven by its cardiometabolic franchise, including Mounjaro, Zepbound, Jardiance, and Trulicity, which accounts for 60-65% of total revenue. Oncology, immunology, and neuroscience therapeutic areas also contribute significantly to its sales.
Why is Eli Lilly's capital expenditure currently so high?+
Eli Lilly's capital expenditure is currently 15-20% of revenue, significantly higher than its historical 5-8%. Over 80% of this spending is growth capex, specifically dedicated to new manufacturing facilities for its incretin therapies like Mounjaro and Zepbound to meet unprecedented demand.
What are the key cost assumptions in Eli Lilly's financial model?+
Key cost assumptions in Eli Lilly's financial model include COGS at approximately 22.66% of revenue, R&D at about 24.71% of revenue, and SGA at roughly 23.95% of revenue. These reflect the company's significant investment in research and development and its asset-heavy manufacturing strategy.
What is the purpose of the Eli Lilly financial model?+
The Eli Lilly financial model provides a comprehensive tool for equity valuation and scenario planning for LLY. It enables analysts to forecast the rapid scale-up of its incretin franchise, assess the margin impact of manufacturing investments, and determine a sum-of-the-parts or discounted cash flow (DCF) valuation.
Can I download an Excel financial model for Eli Lilly (LLY)?+
Yes, an Excel financial model for Eli Lilly (LLY) is available for download. This model offers a forecast horizon from FY2026 to FY2030, allowing for detailed analysis of the company's future financial performance and valuation.
Have more financial modelling questions? Contact us
