Merck & Co. (MRK) Financial Forecast Calculator
Interactive 5-year forecast and DCF for Merck & Co.. 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 Merck & Co.’s most recent SEC filings.
Assumptions
Need this as an Excel model?
Keep iterating on the Merck & Co. 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 Merck & Co. do?+
Merck & Co. is a global healthcare company that discovers, develops, and provides innovative prescription medicines, biologic therapies, vaccines, and animal health products. It operates a highly research-intensive business model focused on oncology, cardiometabolic diseases, and infectious diseases.
What are Merck's primary revenue sources?+
Merck's primary revenue comes from its Pharmaceutical segment, heavily dominated by the oncology drug Keytruda and the HPV vaccine Gardasil, which accounts for approximately 89% of total revenue. The Animal Health segment contributes about 10% of revenue, with other revenues making up the remainder.
How does the financial model address the Keytruda loss of exclusivity?+
The financial model provides a comprehensive equity valuation and scenario planning tool to assess how Merck & Co. will navigate the impending 2028 loss of exclusivity for its flagship oncology drug Keytruda. It evaluates whether its late-stage pipeline and recent acquisitions can replace the anticipated revenue decline.
What is a key assumption for Merck's revenue growth in the financial model?+
A key assumption for Merck's revenue growth in the financial model is approximately 11.34%. This forecast extends over a horizon from FY2026 to FY2030, reflecting anticipated performance and strategic initiatives.
How does Merck & Co. manage its capital expenditures?+
Merck's capital expenditure typically ranges from 4% to 6% of revenue, amounting to approximately $4 billion annually. This spending is heavily skewed towards growth capex, particularly for building out biologic and vaccine manufacturing capacity.
Can I download an Excel financial model for Merck & Co.?+
Yes, a comprehensive Excel financial model for Merck & Co. is available for download. This model provides an equity valuation and scenario planning tool to analyze the company's future financial performance and key assumptions.
Have more financial modelling questions? Contact us
