MRK · NYQ · Healthcare
Merck & Co., Inc.
Also onShortfallConsensus DriftCrosscheck
Implied value per share
USD 147.65
Market price
USD 148.36
Implied upside
-0.5%
10-year forecast · Perpetuity growth terminal value · Mid-year discounting · Base case · Price 2026-11-02 · Accounts to 2025-12-31
Value Per Share
Same forecast, different terminal treatment. Percentages vs price.
Forecast Cashflows
Reporting currency (USD). Outflows negative.
| Line | FY26 | FY27 | FY28 | FY29 | FY30 | FY31 | FY32 | FY33 | FY34 | FY35 | CAGR |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | USD 67.2bn | USD 69.5bn | USD 71.8bn | USD 74.0bn | USD 76.3bn | USD 78.6bn | USD 80.8bn | USD 83.0bn | USD 85.2bn | USD 87.3bn | +3.0% |
| EBIT | USD 17.0bn | USD 17.6bn | USD 18.2bn | USD 18.7bn | USD 19.3bn | USD 19.9bn | USD 20.5bn | USD 21.0bn | USD 21.6bn | USD 22.1bn | +3.0% |
| NOPAT | USD 14.7bn | USD 15.2bn | USD 15.7bn | USD 16.2bn | USD 16.7bn | USD 17.2bn | USD 17.7bn | USD 18.1bn | USD 18.6bn | USD 19.1bn | +3.0% |
| Add depreciation & amortisation | USD 4.9bn | USD 5.0bn | USD 5.2bn | USD 5.4bn | USD 5.5bn | USD 5.7bn | USD 5.9bn | USD 6.0bn | USD 6.2bn | USD 6.3bn | +3.0% |
| Less capital expenditure | USD -4.3bn | USD -4.4bn | USD -4.6bn | USD -4.8bn | USD -5.0bn | USD -5.1bn | USD -5.3bn | USD -5.5bn | USD -5.7bn | USD -5.9bn | +3.6% |
| Capex, % of revenue | 6.4% | 6.4% | 6.4% | 6.5% | 6.5% | 6.6% | 6.6% | 6.6% | 6.7% | 6.7% | - |
| Less increase in working capital | USD -441.2m | USD -462.2m | USD -462.1m | USD -460.9m | USD -458.7m | USD -455.4m | USD -450.9m | USD -445.3m | USD -438.5m | USD -430.6m | -0.3% |
| Free cashflow to firm | USD 14.9bn | USD 15.3bn | USD 15.8bn | USD 16.3bn | USD 16.8bn | USD 17.3bn | USD 17.7bn | USD 18.2bn | USD 18.7bn | USD 19.1bn | +2.8% |
| Discount factor | 0.9695 | 0.9113 | 0.8566 | 0.8052 | 0.7569 | 0.7115 | 0.6688 | 0.6286 | 0.5909 | 0.5554 | - |
| Present value | USD 14.4bn | USD 14.0bn | USD 13.5bn | USD 13.1bn | USD 12.7bn | USD 12.3bn | USD 11.9bn | USD 11.4bn | USD 11.0bn | USD 10.6bn | - |
| Present Value Of The Forecast | USD 125.0bn | ||||||||||
Discount Rate
Source shown per component. All overridable above.
| Risk-free rate | 4.89% | US 10-year Treasury (^TNX), 2026-11-02 |
| Equity risk premium | 4.23% | Damodaran, January 2026 |
| Beta | 0.410 | Reported 0.120, pulled toward 1.0 (Blume) |
| Cost of equity | 6.63% | Risk-free + beta x equity risk premium |
| Cost of debt | 5.29% | Risk-free + 40bp, the spread for a AAA rating at 16.3x interest cover. Book interest / average debt was lower, at 3.1%. |
| Market capitalisation | USD 366.0bn | 88.1% of capital |
| Total debt | USD 49.3bn | 11.9% of capital, book value as a proxy |
| Tax rate | 13.7% | Effective, capped at statutory |
| WACC | 6.39% | E/V x Re + D/V x Rd x (1 - t) |
Terminal Value
Perpetuity growth is intrinsic. The exit multiple defaults to the company's current EV/EBITDA, so it answers a different question - what the shares are worth if today's rating holds and EBITDA grows as forecast.
Perpetuity growth at 2.50%
69% of EV
- Forecast FCFF, final year
- USD 19.1bn
- Capex at depreciation, working capital in reinvestment
- USD 21.9bn
- Less reinvestment at g/ROIC (12.7% of NOPAT)
- USD -2.8bn
- Capitalised
- USD 19.1bn
- ROIC (reported)
- 19.6%
- Terminal value, undiscounted
- USD 504.0bn
- Terminal value, discounted
- USD 280.0bn
- Enterprise value
- USD 404.9bn
- Less net debt
- USD 34.8bn
- Equity value
- USD 370.2bn
Exit at 14.3x EBITDA
64% of EV
- Terminal value, undiscounted
- USD 407.8bn
- Terminal value, discounted
- USD 226.5bn
- Enterprise value
- USD 351.5bn
- Less net debt
- USD 34.8bn
- Equity value
- USD 316.7bn
Spread between methods: 16%.
Sensitivity
Value per share (USD) by discount rate and long-run growth.
| Long-run growth | |||||
|---|---|---|---|---|---|
| Discount rate | 1.50% | 2.00% | 2.50% | 3.00% | 3.50% |
| 4.39% | 231.01 | 264.60 | 316.35 | 405.90 | 597.32 |
| 5.39% | 167.74 | 182.58 | 202.77 | 231.66 | 276.20 |
| 6.39% | 130.42 | 137.99 | 147.65 | 160.34 | 177.61 |
| 7.39% | 105.81 | 109.98 | 115.10 | 121.52 | 129.72 |
| 8.39% | 88.38 | 90.75 | 93.62 | 97.10 | 101.40 |
Outlined: this model. Green text: above today's price of 148.36. Shading: distance from this model's own value.
Priced In
What each input would have to be to justify the current price, one at a time.
| Input | Actual | Model | Implied | Gap |
|---|---|---|---|---|
| Revenue growth, a year | 3.1% | 3.0% | 3.0% | |
| EBIT margin | 34.0% | 25.3% | 25.4% | |
| Discount rate | - | 6.4% | 6.4% |
Live formulas, not pasted numbers - edit a driver and the workbook reprices.
Yahoo Finance and RBA data. General information, not advice. Methodology.